How to edit an uploaded image on the server

protected void ibtnUploadImage_Click(object sender, ImageClickEventArgs e)
{
if (this.fuUploadImage.HasFile)
{
this.fuUploadImage.PostedFile.SaveAs(this.imagePath + this.fuUploadImage.FileName);
this.imageProduct.Src = "ProductImage/" + this.fuUploadImage.FileName;
}
}

protected void lbtnJewellery_Click(object sender, EventArgs e)
{
LinkButton lbtn = (LinkButton)sender;
DataSet ds = this.GetJewelleryBySerialNumber(lbtn.CommandArgument);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
this.lblSerialNumber.Text = Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]);
this.lblCategory.Text = Convert.ToString(ds.Tables[0].Rows[0]["Category"]);
this.lblConsignmentName.Text = !string.IsNullOrWhiteSpace(Convert.ToString(ds.Tables[0].Rows[0]["ConsignmentName"])) ? Convert.ToString(ds.Tables[0].Rows[0]["ConsignmentName"]) : "N/A";
this.imageProductPopup.Src = "ProductImage/" + JewelleryHelper.GetImageFromBinaryData(ds.Tables[0].Rows[0]["Image"], Convert.ToString(ds.Tables[0].Rows[0]["SerialNumber"]), this.imagePath);
this.lblDescription.Text = Convert.ToString(ds.Tables[0].Rows[0]["Description"]);
this.lblCostPrice.Text = Convert.ToString(ds.Tables[0].Rows[0]["CostPrice"]);
this.lblSellingPrice.Text = Convert.ToString(ds.Tables[0].Rows[0]["SellingPrice"]);
ScriptManager.RegisterStartupScript(this, this.GetType(), "JewelleryInfo", "loadPopup();", true);
}
}

protected void btnUploadJewelry_Click(object sender, EventArgs e)
{
int flag = this.UpdateJewelry();
if (flag > 0)
{
JewelleryHelper.DeleteFileIfExists(Server.MapPath(this.imageProduct.Src));
////JewelleryHelper.DeleteTemporaryInternetFiles();
this.BindJewellery();
this.divUpdateJewellary.Visible = false;
this.lblInfo.Visible = false;
////Alert message after jewellery added successfully.
ScriptManager.RegisterStartupScript(this, this.GetType(), "AddJewellery", "alert('Jewelry has been updated successfully.');", true);
}
else
{
this.lblInfo.Text = flag == 0 ? "Not any rows has been updated." : "An error occured while updating jewelry.";
this.lblInfo.Visible = true;
this.lblInfo.ForeColor = System.Drawing.Color.Red;
}
}

private DataSet GetJewelleryBySerialNumber(string serialNumber)
{
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spGetJeweleryBySerialNumberForPopup", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = serialNumber;
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
con.Close();
return ds;
}
}
}

private int UpdateJewelry()
{
int flag = 0;
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spUpdateJewelleryBySerialNumber", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = this.txtSerialNumber.Text;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = this.ddlCategory.SelectedValue;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = this.txtdesc.Text;
if (!string.IsNullOrEmpty(this.imageProduct.Src))
{
byte[] binaryImage = JewelleryHelper.ConvertImageInBinaryData(S

private int UpdateJewelry()
{
int flag = 0;
using (SqlConnection con = new SqlConnection(JewelleryHelper.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("spUpdateJewelleryBySerialNumber", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SerialNumber", SqlDbType.NVarChar).Value = this.txtSerialNumber.Text;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = this.ddlCategory.SelectedValue;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = this.txtdesc.Text;
if (!string.IsNullOrEmpty(this.imageProduct.Src))
{
byte[] binaryImage = JewelleryHelper.ConvertImageInBinaryData(Server.MapPath(this.imageProduct.Src));
if (binaryImage != null)
{
cmd.Parameters.Add("@Image", SqlDbType.Image).Value = binaryImage;
}
}
cmd.Parameters.Add("@CostPrice", SqlDbType.VarChar).Value = JewelleryHelper.GetEncodedCostPrice(this.txtCostPrice.Text);
double costPrice;
if (double.TryParse(this.txtCostPrice.Text, out costPrice))
{
cmd.Parameters.Add("@SellingPrice", SqlDbType.Float).Value = JewelleryHelper.GetSellingPrice(costPrice);
}
if (!string.IsNullOrEmpty(this.txtSoldPrice.Text))
{
cmd.Parameters.Add("@SoldPrice", SqlDbType.Float).Value = double.Parse(this.txtSoldPrice.Text);
}

if (!string.IsNullOrEmpty(this.txtsolddate.Text))
{
cmd.Parameters.Add("@SoldDate", SqlDbType.DateTime).Value = Convert.ToDateTime(this.txtsolddate.Text);
}

cmd.Parameters.Add("@CustomerName", SqlDbType.VarChar).Value = this.txtCustomer.Text;
cmd.Parameters.Add("@AffectedRows", SqlDbType.Int);
cmd.Parameters["@AffectedRows"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();

flag = (int)cmd.Parameters["@AffectedRows"].Value;
}
}

return flag;
}
}