public ResultStatus Edit(SBH_TM_NEWS news)
{
try
{
SBH_TM_NEWS newsNew = _ctx.SBH_TM_NEWS.Find(news.ID);
newsNew.TITLE = news.TITLE;
newsNew.DESCRIPTION = news.DESCRIPTION;
newsNew.CATEGORY_ID = news.CATEGORY_ID;
newsNew.FILE_IMAGE1 = news.FILE_IMAGE1;
newsNew.FILE_IMAGE2 = news.FILE_IMAGE2;
newsNew.FILE_IMAGE3 = news.FILE_IMAGE3;
newsNew.FILE_IMAGE4 = news.FILE_IMAGE4;
newsNew.TEMPLATE = news.TEMPLATE;
newsNew.LAST_MODIFIED_TIME = news.LAST_MODIFIED_TIME;
newsNew.LAST_MODIFIED_BY = news.LAST_MODIFIED_BY;
_ctx.Entry(newsNew).State = System.Data.Entity.EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public ActionResult Detail(int id)
{
SBH_TM_NEWS NEWSView = new SBH_TM_NEWS();
SBH_TM_NEWS NEWSRes = new SBH_TM_NEWS();
NEWSView.ID = id;
NEWSRes = repo.Retrieve(id);
return(PartialView(NEWSRes));
}
public ActionResult Edit(int id)
{
SBH_TM_NEWS NEWSView = new SBH_TM_NEWS();
SBH_TM_NEWS NEWSRes = new SBH_TM_NEWS();
//ViewBag.GetClassButtonList = Dropdown.GetClassButtonList();
ViewBag.GetTemplateList = Dropdown.GetTemplateList();
ViewBag.GetCategoryList = repo.GetCategoryList();
NEWSView.ID = id;
NEWSRes = repo.Retrieve(id);
return(PartialView(NEWSRes));
}
public ResultStatus Add(SBH_TM_NEWS news)
{
try
{
_ctx.SBH_TM_NEWS.Add(news);
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public ActionResult ActionCreate(SBH_TM_NEWS NEWSView, HttpPostedFileBase postedFile)
{
string a = Request.Form["storeImage"];
try
{
string encodedString = Server.HtmlEncode(NEWSView.DESCRIPTION);
NEWSView.DESCRIPTION = encodedString;
string physicalPath = "";
if (postedFile != null)
{
string ImageName = System.IO.Path.GetFileName(postedFile.FileName); //file2 to store path and url
physicalPath = Server.MapPath("~" + Common.GetPathFolderImg() + ImageName);
NEWSView.FILE_IMAGE1 = Common.GetPathFolderImg() + ImageName;
}
NEWSView.CREATED_BY = Session["UserId"].ToString();
NEWSView.CREATED_TIME = DateTime.Now;
rs = repo.Add(NEWSView);
if (rs.IsSuccess)
{
if (physicalPath != "")
{
postedFile.SaveAs(physicalPath);
}
rs.SetSuccessStatus("Data has been created successfully");
TempData["msgSuccess"] = rs.MessageText;
}
else
{
rs.SetErrorStatus("Data failed to created");
TempData["msgError"] = rs.MessageText;
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
rs.SetErrorStatus("Data failed to created");
TempData["msgError"] = rs.MessageText;
}
return(RedirectToAction("Index"));
}
public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime)
{
try
{
SBH_TM_NEWS news = _ctx.SBH_TM_NEWS.Find(id);
news.LAST_MODIFIED_TIME = modifiedTime;
news.LAST_MODIFIED_BY = modifiedBy;
news.ROW_STATUS = eStat.fg.NotActive;
_ctx.Entry(news).State = EntityState.Modified;
_ctx.SaveChanges();
rs.SetSuccessStatus();
}
catch (Exception ex)
{
rs.SetErrorStatus(ex.Message);
}
return(rs);
}
public SelectList GetNewsList()
{
SelectList selectList = null;
int categoryId = _ctx.SBH_TM_CATEGORY.Where(x => x.CATEGORY_NAME.ToUpper() == "EVENT").FirstOrDefault().ID;
if (categoryId > 0)
{
List <SBH_TM_NEWS> newsList = _ctx.SBH_TM_NEWS.Where(x => x.ROW_STATUS == (int)EnumList.RowStatus.Active && x.CATEGORY_ID == categoryId).ToList();
SBH_TM_NEWS news = new SBH_TM_NEWS {
ID = 0, TITLE = "Select Event :"
};
newsList.Add(news);
var newsListSelection = newsList.OrderBy(x => x.ID);
selectList = new SelectList(newsListSelection, "ID", "TITLE");
}
return(selectList);
}
