public string DeleteImage(long id)
{
try
{
utblImage model = db.utblImages.Find(id);
db.utblImages.Remove(model);
db.SaveChanges();
return("Image Removed");
}
catch (Exception)
{
return("Error: Server error, try again later");
}
}
public string SaveImage(utblImage model)
{
var parImageID = new SqlParameter("@ImageID", model.ImageID);
var parImageTitle = new SqlParameter("@ImageTitle", model.ImageTitle);
var parImageAlbumID = new SqlParameter("@ImageAlbumID", model.ImageAlbumID);
var parImageFilePathThumb = new SqlParameter("@ImageFilePathThumb", model.ImageFilePathThumb);
var parImageFilePathNormal = new SqlParameter("@ImageFilePathNormal", model.ImageFilePathNormal);
var parIsAlbumCover = new SqlParameter("@IsAlbumCover", model.IsAlbumCover);
var parTransDate = new SqlParameter("@TransDate", model.TransDate);
var parUserID = new SqlParameter("@UserID", model.UserID);
return(db.Database.SqlQuery <string>("udspImageSave @ImageID,@ImageTitle, @ImageAlbumID, @ImageFilePathThumb,@ImageFilePathNormal,@IsAlbumCover, @TransDate, @UserID",
parImageID, parImageTitle, parImageAlbumID, parImageFilePathThumb, parImageFilePathNormal, parIsAlbumCover, parTransDate, parUserID).FirstOrDefault());
}
//[AntiXSRFFilter]
public ActionResult Delete(long id, long AlbumID)
{
utblImage model = new utblImage();
model = objImg.GetImageByID(id);
string PrvPath = model.ImageFilePathNormal;
string result = objImg.DeleteImage(id);
if (!result.ToLower().Contains("error"))
{
objSite.AddAuditLog("utblImages", "Image Removed", IPAddressGetter.GetIPAddress(), User.Identity.Name, id);
DeleteFile(PrvPath);
TempData["ErrMsg"] = "Success: Data Removed Succesfully !";
}
else
{
TempData["ErrMsg"] = result;
}
return(RedirectToAction("index", "image", new { Area = "Admin", AlbumID = AlbumID }));
}
public ActionResult Edit(ImageSaveModel model)
{
utblImage img = new utblImage();
img = objImg.GetImageByID(model.Images.ImageID);
string PrvPath = img.ImageFilePathNormal;
if (ModelState.IsValid)
{
string name = "";
if (model.PhotoStrs.PhotoNormal != null)
{
Random rand = new Random();
name = "Images_" + DateTime.Now.ToString("yyyyMMdd") + "_" + rand.Next(50) + ".jpg";
string normal_result = SaveImage(model.PhotoStrs.PhotoNormal, name);
if (normal_result.Contains("Error"))
{
TempData["ErrMsg"] = normal_result;
return(View(model));
}
model.Images.ImageFilePathNormal = "/Uploads/Images/" + normal_result;
model.Images.ImageFilePathThumb = model.PhotoStrs.PhotoThumb;
}
model.Images.TransDate = DateTime.Now;
model.Images.UserID = User.Identity.Name;
string result = objImg.SaveImage(model.Images);
if (result.Contains("Success"))
{
DeleteFile(PrvPath);
objSite.AddAuditLog("utblImages", "Image Updated", IPAddressGetter.GetIPAddress(), User.Identity.Name);
TempData["ErrMsg"] = result;
return(RedirectToAction("index", "image", new { Area = "Admin", AlbumID = model.Images.ImageAlbumID }));
}
TempData["ErrMsg"] = result;
//return RedirectToAction("index", "image", new { Area = "Admin", AlbumID = model.Images.ImageAlbumID });
}
return(View(model));
}
