public long UpdateMenu(TblMenuContent entity)
{
var news = da.TblMenuContent.Find(entity.ID);
if (news != null)
{
try
{
// set data
news.Menu_Content = entity.Menu_Content;
news.Status = entity.Status;
news.del_flg = Constant.DeleteFlag.NON_DELETE;
da.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
else
{
return(0);
}
return(entity.ID);
}
// GET: ManageMenuContent
#region REGISTER/ UPDATE
public ActionResult MenuContentEdit(long menuId = 0)
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
TblMenuContent model = new TblMenuContent();
CommonService comService = new CommonService();
ManageMenuDa dataAccess = new ManageMenuDa();
model.Status = Constant.Status.ACTIVE;
if (menuId > 0)
{
TblMenuContent infor = new TblMenuContent();
infor = dataAccess.getInfoMenuContent(menuId);
model = infor != null ? infor : model;
model.Menu_Content = HttpUtility.HtmlDecode(model.Menu_Content);
}
return(View(model));
}
public List <TblMenuContent> SearchMenuList(DataTableModel dt, TblMenuContent model, out int total_row)
{
var listMenu = da.TblMenuContent.Where(i => i.del_flg == model.del_flg).ToList();
total_row = listMenu.Count();
return(listMenu);
}
public List <TblMenuContent> SearchMenuList(DataTableModel dt, TblMenuContent model, out int total_row)
{
ManageMenuDa dataAccess = new ManageMenuDa();
List <TblMenuContent> results = dataAccess.SearchMenuList(dt, model, out total_row);
return(results);
}
public long UpdateMenu(TblMenuContent model)
{
long res = 0;
// Declare new DataAccess object
ManageMenuDa dataAccess = new ManageMenuDa();
using (var transaction = new TransactionScope())
{
try
{
res = dataAccess.UpdateMenu(model);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
transaction.Dispose();
}
}
return(res);
}
public long InsertMenu(TblMenuContent entity)
{
entity.del_flg = Constant.DeleteFlag.NON_DELETE;
da.TblMenuContent.Add(entity);
da.SaveChanges();
return(entity.ID);
}
public ActionResult Contact(int MenuCd = MenuCode.Contact)
{
ManageMenuDa dataAccess = new ManageMenuDa();
TblMenuContent model = new TblMenuContent();
model = dataAccess.getMenuContentDisplay(MenuCd);
return(View(model));
}
public ActionResult Edit(TblMenuContent model)
{
try
{
using (MenuService service = new MenuService())
{
if (ModelState.IsValid)
{
bool isNew = false;
if (model.ID == 0)
{
isNew = true;
service.InsertMenu(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
else
{
isNew = false;
service.UpdateMenu(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
}
catch (Exception ex)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest;
System.Web.HttpContext.Current.Session["ERROR"] = ex;
return(new EmptyResult());
}
}
public ActionResult List(DataTableModel dt, TblMenuContent condition)
{
if (ModelState.IsValid)
{
using (MenuService service = new MenuService())
{
int total_row = 0;
var dataList = service.SearchMenuList(dt, condition, out total_row);
int order = 1;
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.ID,
order++,
MenuCode.Items[i.MenuCd].ToString(),
i.Status == true? "Hiển thị" : "Ẩn",
i.del_flg
})
});
SaveRestoreData(condition);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
public ActionResult MenuList()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
TblMenuContent model = new TblMenuContent();
CommonService comService = new CommonService();
ManageMenuDa dataAccess = new ManageMenuDa();
var tmpCondition = GetRestoreData() as TblMenuContent;
if (tmpCondition != null)
{
model = tmpCondition;
}
return(View(model));
}
public TblMenuContent getMenuContentDisplay(long Id)
{
TblMenuContent product = da.TblMenuContent.Where(s => s.ID == Id && s.Status == true && s.del_flg == Constant.DeleteFlag.NON_DELETE).SingleOrDefault();
return(product);
}
public TblMenuContent getInfoMenuContent(long Id)
{
TblMenuContent product = da.TblMenuContent.Where(s => s.ID == Id).SingleOrDefault();
return(product);
}
