protected void btn_submit_Click(object sender, EventArgs e)
{
bool flag = true;
image.CenterImagePath = "";
image.CenterImageID = Convert.ToInt32(lbl_CenterImageID.Text);
if (FileUpload1.HasFile)
{
string fileExt = System.IO.Path.GetExtension(FileUpload1.FileName);
if (fileExt == ".jpg" || fileExt == ".gif" || fileExt == ".png" || fileExt == ".jpeg")
{
image.CenterImagePath = @"~/CenterImage1/" + image.CenterImageID + Class_Additionalresources.Getextention(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath(image.CenterImagePath));
flag = true;
}
else
{
flag = false;
lblMsg.Text = "Only jpg,gif and png file are allowed";
div_message.Visible = true;
img_right.Visible = false;
img_error.Visible = true;
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
if (flag)
{
image.NavigateUrl = txt_url.Text;
image.Status = chk_Status.Checked;
image.UpdateCenterImage1ByID();
if (image.OperationStatus)
{
lblMsg.Text = "Image updated Successfully";
div_message.Visible = true;
img_right.Visible = true;
img_error.Visible = false;
lblMsg.ForeColor = System.Drawing.Color.Green;
Div_Image.Visible = true;
div_update.Visible = false;
bindgrid();
}
else
{
lblMsg.Text = image.ErrorMessage;
div_message.Visible = true;
img_right.Visible = false;
img_error.Visible = true;
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
=============================================================================
public static string Getextention(string Filename)
{
string _extention;
int index;
index = Filename.IndexOf('.');
_extention = Filename.Substring(index);
return _extention;
}
=============================================================================
public void UpdateCenterImage1ByID()
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SP_UpdateCenterImage1ByID";
cmd.Parameters.AddWithValue("@CenterImageID", CenterImageID);
cmd.Parameters.AddWithValue("@CenterImagePath", CenterImagePath);
cmd.Parameters.AddWithValue("@NavigateUrl", NavigateUrl);
cmd.Parameters.AddWithValue("@Status", Status);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = Connection;
OpenConnection();
CenterImageID = Convert.ToInt32(cmd.ExecuteScalar());
if (CenterImageID == -1)
{
OperationStatus = false;
ErrorMessage = "Error : Image does not Exist.";
}
else
{
OperationStatus = true;
}
}
catch (Exception ex)
{
ErrorMessage = "Error : " + ex.Message;
OperationStatus = false;
}
finally
{
CloseConnection();
}
}
=============================================================================
CREATE PROCEDURE [dbo].[SP_UpdateCenterImage1ByID]
@CenterImageID int,
@CenterImagePath nvarchar(200),
@NavigateUrl nvarchar(max),
@Status bit
as
begin
if(@CenterImagePath = '')
update tbl_CenterImage1 set NavigateUrl=@NavigateUrl,Status = @Status
where CenterImageID = @CenterImageID
else
begin
update tbl_CenterImage1 set CenterImagePath = @CenterImagePath,NavigateUrl=@NavigateUrl,Status = @Status
where CenterImageID = @CenterImageID
end
end
=============================================================================
Sunday, 13 August 2017
Image uploading and saving its path is database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment