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