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