public int UpdateNews(NewsboardEntity news) { NewsBoard orgCheck = new NewsBoard(); int retVal = 0; string response = string.Empty; using (var db = new DbContext(CONNECTION_NAME)) { try { orgCheck = db.Set <NewsBoard>().Where(s => s.NewsBoardId == news.NewsBoardId).FirstOrDefault <NewsBoard>(); if (orgCheck != null) { //orgCheck.NewsBoardId = news.NewsBoardId; orgCheck.Title = news.Title; orgCheck.Description = news.Description; orgCheck.Image = news.Image; orgCheck.CreatedBy = news.CreatedBy; orgCheck.CreatedDate = DateTime.Now; } db.SaveChanges(); retVal = 1; } catch (Exception ex) { retVal = -1; } } return(retVal); }
public JsonResult GetNewsById(int id) { NewsboardEntity AccDetails = null; try { var objDtl = new NewBoardComponent(); AccDetails = objDtl.GetNewsById(id); } catch (Exception ex) { return(null); } return(Json(AccDetails, JsonRequestBehavior.AllowGet)); }
public string AddNews(NewsboardEntity news) { string strResponse = string.Empty; var orgcomponent = new NewBoardComponent(); UserSessionInfo objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo; int _userID = objSessioninfo.UserId; news.CreatedBy = _userID; string imagename = string.Empty; if (Request.Files.Count > 0) { var file = Request.Files[0]; var fileName = "/uploadimages/Images/" + file.FileName; imagename = file.FileName; var imagepath = Server.MapPath(fileName); file.SaveAs(imagepath); } if (imagename == "") { news.Image = "newsDefault.jpg"; } else { news.Image = imagename; } int r = orgcomponent.AddNews(news); if (r > 0) { strResponse = "News Added successfully"; } else if (r == 0) { strResponse = "News already exists"; } else if (r < 0) { strResponse = "Error occured in Adding News"; } return(strResponse); }
public int AddNews(NewsboardEntity news) { NewsBoard orgCheck = new NewsBoard(); int retVal = 0; string response = string.Empty; UserSessionInfo info = new UserSessionInfo(); int accid = info.AccountId; using (var db = new DbContext(CONNECTION_NAME)) { try { orgCheck = db.Set <NewsBoard>().Where(s => s.NewsBoardId == news.NewsBoardId).FirstOrDefault <NewsBoard>(); if (orgCheck != null) { return(retVal); } NewsBoard OrgCheck = new NewsBoard(); //OrgCheck.NewsBoardId = news.NewsBoardId; OrgCheck.Title = news.Title; OrgCheck.Description = news.Description; OrgCheck.Image = news.Image; OrgCheck.CreatedBy = news.CreatedBy; OrgCheck.CreatedDate = DateTime.Now; OrgCheck.AccountId = accid; db.Set <NewsBoard>().Add(OrgCheck); db.SaveChanges(); retVal = 1; } catch (Exception ex) { retVal = -1; } } return(retVal); }
public int UpdateNews(NewsboardEntity news) { var newsboarddac = new NewBoardDAC(); return(newsboarddac.UpdateNews(news)); }
public int AddNews(NewsboardEntity news) { var newsboarddac = new NewBoardDAC(); return(newsboarddac.AddNews(news)); }