public bool UpdateNewsStatus(int newsId) { // News.CreatedDate = DateTime.Now; SA_News EditNews = _context.SA_News.Where(Cat => Cat.id == newsId).FirstOrDefault(); if (EditNews.status.HasValue) { if (EditNews.status.Value == 1) { EditNews.status = 2; } else { EditNews.status = 1; } } else { EditNews.status = 1; } _context.Entry(EditNews).State = EntityState.Modified; int x = _context.SaveChanges(); return(x == 0 ? false : true); }
public ActionResult SaveNews(SA_News UserNews) { for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/ProductImages"), fileName); file.SaveAs(path); UserNews.NewsImg = fileName; } } UserNews.CreatedTime = DateTime.Now; NewsDataStore Obj = new NewsDataStore(); if (UserNews.id == 0) { Obj.AddNews(UserNews); } else { Obj.EditNews(UserNews); } return(RedirectToAction("News")); }
public async Task <bool> UpdateNews(SA_News News) { _context.Entry(News).State = EntityState.Modified; // News.ModeifiedDate = DateTime.Now; int x = await _context.SaveChangesAsync(); return(x == 0 ? false : true); }
public bool AddNews(SA_News News) { // News.CreatedDate = DateTime.Now; _context.SA_News.Add(News); int x = _context.SaveChanges(); return(x == 0 ? false : true); }
public ActionResult SaveNews(SA_News UserNews) { for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/ProductImages"), fileName); file.SaveAs(path); UserNews.NewsImg = fileName; } } UserNews.status = 1; UserNews.CreatedBy = Session["User"].ToString(); UserNews.CreatedTime = UserNews.CreatedTime != null? UserNews.CreatedTime: DateTime.Now; NewsDataStore Obj = new NewsDataStore(); if (UserNews.id == 0) { Obj.AddNews(UserNews); string np = Request.Form["allProduct"].ToString(); foreach (string s in np.Split(',')) { if (s != "") { Obj.AddNewsProduct(new SA_NewsAndProductRelation { SA_NewsId = UserNews.id, SA_ProductId = Convert.ToInt16(s) }); } } } else { Obj.EditNews(UserNews); string np = Request.Form["allProduct"].ToString(); Obj.DeleteNewsProduct(UserNews.id); foreach (string s in np.Split(',')) { if (s != "") { Obj.AddNewsProduct(new SA_NewsAndProductRelation { SA_NewsId = UserNews.id, SA_ProductId = Convert.ToInt16(s) }); } } } return(RedirectToAction("News")); }
public bool DeleteNews(int NewsId) { // News.CreatedDate = DateTime.Now; SA_News EditNews = _context.SA_News.Where(News => News.id == NewsId).FirstOrDefault(); _context.Entry(EditNews).State = EntityState.Deleted; int x = _context.SaveChanges(); return(x == 0 ? false : true); }
public ActionResult EditNews(int id) { NewsDataStore Obj = new NewsDataStore(); SA_News obj = Obj.GetNewsByid(id); List <SelectListItem> productList = Obj.GetProductList(); SA_NewsViewModel objSaCatV = new SA_NewsViewModel(); objSaCatV.id = obj.id; objSaCatV.NewsName = obj.NewsName; objSaCatV.NewsDiscription = obj.NewsDiscription; objSaCatV.URL = obj.URL; objSaCatV.MetaDiscription = obj.MetaDiscription; objSaCatV.Keywords = obj.Keywords; objSaCatV.ProductList = productList; objSaCatV.Product = obj.Product.ToString(); return(View("add-News", objSaCatV)); }
public bool EditNews(SA_News News) { // News.CreatedDate = DateTime.Now; SA_News EditNews = _context.SA_News.Where(Cat => Cat.id == News.id).FirstOrDefault(); EditNews.NewsName = News.NewsName; EditNews.NewsDiscription = News.NewsDiscription; EditNews.URL = News.URL; EditNews.MetaDiscription = News.MetaDiscription; EditNews.Keywords = News.Keywords; EditNews.MetaTitle = News.MetaTitle; EditNews.Product = News.Product; EditNews.CreatedTime = News.CreatedTime; if (News.NewsImg != null) { EditNews.NewsImg = News.NewsImg; } _context.Entry(EditNews).State = EntityState.Modified; int x = _context.SaveChanges(); return(x == 0 ? false : true); }