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