public Shop_New AddNews(Shop_New SN) { try { using (shoponlineDataContext context = DbUtils.Create()) { context.Shop_News.InsertOnSubmit(SN); context.SubmitChanges(); return SN; } } catch (Exception) { return null; } }
public Shop_New UpdateShopNews(Shop_New s_News) { try { using (shoponlineDataContext context = DbUtils.Create()) { Shop_New NewsObj = context.Shop_News.Where(u => u.NewsId.Equals(s_News.NewsId)).SingleOrDefault(); if (NewsObj != null) { NewsObj.News_HeadLine = s_News.News_HeadLine; NewsObj.News_Detail = s_News.News_Detail; context.SubmitChanges(); return NewsObj; } } } catch (Exception) { } return null; }
public ActionResult AddNews(string txtNewsHeadLine, string txtNewsDetail, string hidNewsId) { try { if (!String.IsNullOrWhiteSpace(hidNewsId)) { ViewData[Constants.MENU_PARENT] = Constants.MENU_MANAGE_NEWS; ViewData[Constants.MENU] = Constants.MANAGE_NEWS; } else { ViewData[Constants.MENU_PARENT] = Constants.MENU_MANAGE_NEWS; ViewData[Constants.MENU] = Constants.ADD_NEWS; } ViewBag.TitleDes = "Free shop advertisement"; ViewData["txtNewsHeadLine"] = txtNewsHeadLine; ViewData["txtNewsDetail"] = txtNewsDetail; ViewData["hidNewsId"] = hidNewsId; Boolean isValid = true; if (string.IsNullOrWhiteSpace(txtNewsHeadLine)) { ViewData[Constants.OPERATIONALMESSAGE] = Utils.getErrorMessage("Input Field Required", "Please Enter News HeadLine"); isValid = false; } if (string.IsNullOrWhiteSpace(txtNewsDetail)) { ViewData[Constants.OPERATIONALMESSAGE] = Utils.getErrorMessage("Input Field Required", "Please Enter News Detail"); isValid = false; } if (isValid == true) { Shop_New SN = new Shop_New(); SN.User_Id = new ShopOnline.Filters.UserSession().getUserSession().UserId; SN.News_HeadLine = txtNewsHeadLine; SN.News_Detail = txtNewsDetail; if (!string.IsNullOrWhiteSpace(hidNewsId)) { SN.NewsId = Convert.ToInt64(new SecurityManager().DecodeString(hidNewsId)); } if (SN.NewsId > 0) { new Shop_New().UpdateShopNews(SN); return RedirectToRoute(new RouteValueDictionary(new { controller = "ShopNews", action = "ManageShopNews", RecUpdateOperation = "1" })); } else { SN.Created_On = DateTime.UtcNow; Shop_New shop_news = new Shop_New().AddNews(SN); if (shop_news != null) { return RedirectToRoute(new RouteValueDictionary(new { controller = "ShopNews", action = "AddNewsForm", RecSaveOperation = "1" })); } else { ViewData[Constants.OPERATIONALMESSAGE] = Utils.getErrorMessage("Input field required", "Sorry record could not be saved"); } } } } catch (Exception ex) { } return View("AddNews"); }
public ActionResult AddNewsForm(string RecSaveOperation, string hidNewsId) { try { if (!String.IsNullOrWhiteSpace(hidNewsId)) { ViewData[Constants.MENU_PARENT] = Constants.MENU_MANAGE_NEWS; ViewData[Constants.MENU] = Constants.MANAGE_NEWS; string News_Id = new SecurityManager().DecodeString(hidNewsId); Shop_New SN = new Shop_New().GetShopNews(Convert.ToInt64(News_Id)); ViewData["txtNewsHeadLine"] = SN.News_HeadLine; ViewData["txtNewsDetail"] = SN.News_Detail; ViewData["hidNewsId"] = hidNewsId; } else { ViewData[Constants.MENU_PARENT] = Constants.MENU_MANAGE_NEWS; ViewData[Constants.MENU] = Constants.ADD_NEWS; ViewBag.TitleDes = "Free shop advertisement"; if (!String.IsNullOrEmpty(RecSaveOperation)) { ViewData[Constants.OPERATIONALMESSAGE] = Utils.getSuccessMessage("Success", "Record saved successfully."); } } } catch(Exception ex) { } return View("AddNews"); }
//public ActionResult EditShopNews(string NewsId) //{ // ViewData[Constants.MENU_PARENT] = Constants.MENU_MANAGE_NEWS; // ViewData[Constants.MENU] = Constants.MANAGE_NEWS; // ViewBag.TitleDes = "Free shop advertisement"; // string News_Id = new SecurityManager().DecodeString(NewsId); // ViewData.Model = new Shop_New().GetShopNews(Convert.ToInt64(News_Id)); // return View("EditNews"); //} public ActionResult DeleteNews(string NewsId) { try { if (!string.IsNullOrEmpty(NewsId)) { string News_Id = new SecurityManager().DecodeString(NewsId); Boolean retItem = new Shop_New().DeleteNews(Convert.ToInt64(News_Id)); if (retItem == true) { return RedirectToRoute(new RouteValueDictionary(new { controller = "ShopNews", action = "ManageShopNews", RecDelOperation = "1" })); } else { return RedirectToRoute(new RouteValueDictionary(new { controller = "ShopNews", action = "ManageShopNews", RecDelErrorOperation = "1" })); } } } catch (Exception) { } return RedirectToRoute(new RouteValueDictionary(new { controller = "ShopNews", action = "ManageShopNews" })); }