public void Update(FileUploadUpdate model)
{
this.DataProvider.ExecuteNonQuery(
"User_Files_Update",
inputParamMapper : delegate(SqlParameterCollection paramCol)
{
paramCol.AddWithValue("@Id", model.Id);
paramCol.AddWithValue("@Description", model.Description);
}
);
}
protected void btnUpdate_Command(object sender, CommandEventArgs e)
{
if (FileUploadUpdate.HasFile)
{
string fileExt = Path.GetExtension(FileUploadUpdate.FileName.ToLower());
string ext = "";
if (fileExt == ".jpg")
{
ext = ".jpg";
}
else if (fileExt == ".jpeg")
{
ext = ".jpeg";
}
else if (fileExt == ".png")
{
ext = ".png";
}
else if (fileExt == ".gif")
{
ext = ".gif";
}
else
{
lblAdvertisementResult.ForeColor = Color.Red;
lblAdvertisementResult.Text = "Image File (*.jpg, *.jpeg, *.png, *.gif)";
}
if (ext != "")
{
string ImageName = DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "update Advertisement set Image='" + ImageName + ext + "'";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
lblAdvertisementResult.ForeColor = Color.Green;
lblAdvertisementResult.Text = "Sucessfully Update.";
GridView1.DataBind();
FileUploadUpdate.SaveAs(Server.MapPath("../images/Advertisement/Temp/" + ImageName + ext));
System.Drawing.Image obj;
Bitmap newimage;
obj = System.Drawing.Image.FromFile(Server.MapPath("../images/Advertisement/Temp/" + ImageName + ext));
ImageFormat imgformat = obj.RawFormat;
newimage = new Bitmap(obj, 263, 270);
newimage.Save(Server.MapPath("../images/Advertisement/" + ImageName + ext), imgformat);
}
}
else
{
lblAdvertisementResult.ForeColor = Color.Red;
lblAdvertisementResult.Text = "Image File Upload.";
}
}
public IActionResult Update([FromBody] FileUploadUpdate model)
{
try
{
if (ModelState.IsValid)
{
model.ModifiedBy = "a7295eb3-eaee-4093-90ca-e4586b170420";
_fileService.Update(model);
SuccessResponse resp = new SuccessResponse();
return(Ok(resp));
}
else
{
return(BadRequest(ModelState));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
