public ActionResult PostNews(db_NewsRooms NewsRoom, HttpPostedFileBase Image) { var FilePath = ""; if (Image != null) { var fileName = Path.GetFileName(Image.FileName); var path = Path.Combine(Server.MapPath("~/UserProfilePictures/" + fileName)); Image.SaveAs(path); FilePath = "/UserProfilePictures/" + fileName; } if (NewsRoom.NewRoomId != 0) { NewsRoom.Image = FilePath; NewsRoomService.UpdateNewRooms(NewsRoom); TempData["SuccessMessage"] = "News Updated successfully"; } else { NewsRoom.CreatedOn = DateTime.Now; NewsRoom.Image = FilePath; NewsRoom.Status = true; NewsRoomService.Create(NewsRoom); TempData["SuccessMessage"] = "News Added successfully"; } return(RedirectToAction("PostNews", "NewsRoom", new { area = "Admin" })); }
public Alumini.Core.db_NewsRooms Get(int id) { using (var context = _dbContextFactory.CreateConnection()) { db_NewsRooms News = context.db_NewsRooms.Where(x => x.NewRoomId == id && x.Status == true).FirstOrDefault(); return(News); } }
public bool Delete(int id) { using (var context = _dbContextFactory.CreateConnection()) { db_NewsRooms NewsRooms = context.db_NewsRooms.Where(x => x.Status == true && x.NewRoomId == id).FirstOrDefault(); NewsRooms.Status = false; NewsRooms.UpdatedOn = DateTime.Now; context.SaveChanges(); return(true); } }
public Alumini.Core.db_NewsRooms UpdateNewRooms(Alumini.Core.db_NewsRooms obj) { using (var context = _dbContextFactory.CreateConnection()) { db_NewsRooms News = context.db_NewsRooms.Where(x => x.NewRoomId == obj.NewRoomId && x.Status == true).FirstOrDefault(); News.Title = obj.Title; if (obj.Image != "") { News.Image = obj.Image; } News.Description = obj.Description; News.UpdatedOn = DateTime.Now; context.SaveChanges(); return(obj); } }