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" }));
}
