public string SaveBanner(utblBanner model) { var parBannerID = new SqlParameter("@BannerID", model.BannerID); var parBannerTitle = new SqlParameter("@BannerTitle", model.BannerTitle); var parDesc = new SqlParameter("@BannerDesc", model.BannerDescription); var parThumb = new SqlParameter("@BannerThumb", model.BannerThumb); var parPath = new SqlParameter("@BannerPath", model.BannerPath); var parTransDate = new SqlParameter("@TransDate", model.TransDate); var parUserID = new SqlParameter("@UserID", model.UserID); return(db.Database.SqlQuery <string>("udspBannerSave @BannerID, @BannerTitle,@BannerDesc, @BannerThumb, @BannerPath, @TransDate, @UserID", parBannerID, parBannerTitle, parDesc, parThumb, parPath, parTransDate, parUserID).FirstOrDefault()); }
//[AntiXSRFFilter] public ActionResult Edit(BannerSaveModel model, string sessionXSRFToken) { utblBanner banner = new utblBanner(); banner = objBanner.GetBannerByID(model.Banner.BannerID); string PrvPath = banner.BannerPath; if (ModelState.IsValid) { string name = ""; if (model.PhotoStrs.PhotoNormal != null) { //if (!IsBase64(model.PhotoStrs.PhotoNormal)) //{ // ModelState.AddModelError("PhotoStrs.PhotoNormal", "Invalid Photo"); // return View(model); //} Random rand = new Random(); name = "Banner_" + 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)); } else { DeleteFile(PrvPath); } model.Banner.BannerPath = "/Uploads/Banner/" + normal_result; model.Banner.BannerThumb = model.PhotoStrs.PhotoThumb; } model.Banner.TransDate = DateTime.Now; model.Banner.UserID = User.Identity.Name; //model.Banner.IPAddress = IPAddressGetter.GetIPAddress(); string result = objBanner.SaveBanner(model.Banner); if (result.Contains("Success")) { objSite.AddAuditLog("utblBanners", "Banner Updated", IPAddressGetter.GetIPAddress(), User.Identity.Name, model.Banner.BannerID); TempData["ErrMsg"] = result; return(RedirectToAction("index", "banner", new { Area = "Admin" })); } TempData["ErrMsg"] = result; DeleteFile(name); } return(View(model)); }
public string DeleteBanner(long id) { try { utblBanner model = db.utblBanners.Find(id); string bannerpath = model.BannerPath; db.utblBanners.Remove(model); db.SaveChanges(); return(bannerpath); } catch (Exception) { return("Error: Server error, try again later"); } }
public ActionResult Delete(long id) { utblBanner banner = new utblBanner(); banner = objBanner.GetBannerByID(id); string PrvPath = banner.BannerPath; string result = objBanner.DeleteBanner(id); if (!result.ToLower().Contains("error")) { objSite.AddAuditLog("utblBanners", "Banner Removed", IPAddressGetter.GetIPAddress(), User.Identity.Name, id); DeleteFile(PrvPath); TempData["ErrMsg"] = "Success: Data Removed Succesfully !"; } else { TempData["ErrMsg"] = result; } return(RedirectToAction("index", "banner", new { Area = "Admin" })); }