public int Insert(CSF_Roles entity)
{
try
{
MyContext.CSF_Roles.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public int Insert(CSF_Functions entity)
{
try
{
entity.CreateDate = System.DateTime.Now;
entity.ParentID = entity.ParentID != null ? entity.ParentID : 0;
MyContext.CSF_Functions.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public bool EditModules(CSF_Modules entity)
{
try
{
var module = MyContext.CSF_Modules.Find(entity.ID);
module.Name = entity.Name;
module.Description = entity.Description;
MyContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public int Insert(CSF_Users entity)
{
try
{
entity.RegisterDate = System.DateTime.Now;
entity.Password = Encryptor.MD5Hash(entity.Password);
entity.Status = 1;
MyContext.CSF_Users.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public bool Update(CSF_Partials entity)
{
try
{
CSF_Partials obj = MyContext.CSF_Partials.Find(entity.ID);
obj.Name = entity.Name;
obj.Key = entity.Key;
obj.ModuleID = entity.ModuleID;
obj.Controller = entity.Controller;
MyContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(false);
}
}
public int Insert(CSF_Pages entity)
{
try
{
entity.CreateDate = DateTime.Now;
entity.IsActive = entity.IsActive == null ? false : entity.IsActive;
entity.IsAdmin = entity.IsAdmin == null ? false : entity.IsAdmin;
entity.IsHost = entity.IsHost == null ? false : entity.IsHost;
entity.IsBlank = entity.IsBlank == null ? false : entity.IsBlank;
MyContext.CSF_Pages.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public bool Update(CMS_Categories entity)
{
try
{
CMS_Categories obj = MyContext.CMS_Categories.Find(entity.ID);
obj.NAME = entity.NAME;
obj.DESCRIPTION = entity.DESCRIPTION;
obj.PICTURE = entity.PICTURE;
obj.PUBLISH = entity.PUBLISH;
obj.KEY = entity.KEY;
obj.ORDERS = entity.ORDERS;
MyContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(false);
}
}
public JsonResult CopyPageSetup(string pagenguon, string pagedich)
{
try
{
int IDPageNguon = Convert.ToInt32(pagenguon);
int IDPageDich = Convert.ToInt32(pagedich);
CSF_MVCEntities MyContext = new CSF_MVCEntities();
MyContext.CSF_Pages_CopyPage(IDPageNguon, IDPageDich);//delete ban ghi cu
var listPageNguon = MyContext.CSF_PagePartial.Where(x => x.PageID == IDPageNguon).ToList();
CSF_PagePartial objPP;
foreach (var item in listPageNguon.Where(x => x.IsBox == true))
{
int idItem = item.ID;
objPP = new CSF_PagePartial();
objPP = item;
objPP.PageID = IDPageDich;
MyContext.CSF_PagePartial.Add(objPP);
MyContext.SaveChanges();
var newID = objPP.ID;
foreach (var itemC in listPageNguon.Where(x => x.BoxParent == idItem))
{
objPP = new CSF_PagePartial();
objPP = itemC;
objPP.PageID = IDPageDich;
objPP.BoxParent = newID;
MyContext.CSF_PagePartial.Add(objPP);
MyContext.SaveChanges();
}
}
return(Json(new { state = true, message = "Copy pageSetup thành công" }, JsonRequestBehavior.AllowGet));
//return Json(new { state = false, message = "Lỗi copy pageSetup" }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
}
}
public bool Delete(int id)
{
try
{
var obj = MyContext.CSF_Logs.Find(id);
MyContext.CSF_Logs.Remove(obj);
MyContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
return(false);
}
}
public int Insert(int UserID, int RoleID)
{
try
{
CSF_UserRole entity = new CSF_UserRole();
entity.UserID = UserID;
entity.RoleID = RoleID;
MyContext.CSF_UserRole.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
public JsonResult DeletePagePartial(string id)
{
try
{
CSF_MVCEntities ett = new CSF_MVCEntities();
int ID = Convert.ToInt32(id);
var pagePartial = ett.CSF_PagePartial.Find(ID);
if (pagePartial != null)
{
ett.CSF_PagePartial.Remove(pagePartial);
ett.SaveChanges();
return(Json(new { state = true, message = "Xóa thành công" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = false, message = "Lỗi xóa dữ liệu" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GuiDuyet(string newsid)
{
try
{
CSF_MVCEntities entity = new CSF_MVCEntities();
int NEWSID = Convert.ToInt32(newsid);
var news = entity.CMS_News.Find(NEWSID);
if (news != null && (news.ID_NEWS_STATUS == 1 || news.ID_NEWS_STATUS == 3 || news.ID_NEWS_STATUS == 6))
{
news.ID_NEWS_STATUS = 2;
entity.Entry(news).State = EntityState.Modified;
entity.SaveChanges();
}
SetAlert("Gửi duyệt thành công", AlertType.Success);
return(Json(new { state = true, message = "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = false, message = ex }, JsonRequestBehavior.AllowGet));
}
}
public int Insert(CMS_News entity)
{
try
{
entity.CREATEDATE = System.DateTime.Now;
entity.NUMBEROFVIEW = 0;
entity.ISFOCUS = 0;
MyContext.CMS_News.Add(entity);
MyContext.SaveChanges();
return(entity.ID);
}
catch (Exception ex)
{
Logs.WriteLog(ex);
throw;
}
}
