public static bool insert(MMenuAccessVM model)
{
bool result = false;
using (AppEntities db = new AppEntities())
{
foreach (var item in model.listMenuId)
{
var data = new m_menu_access()
{
m_role_id = model.role.id,
created_by = 2,
is_active = true,
created_date = DateTime.Now,
m_menu_id = item
};
db.m_menu_access.Add(data);
}
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public void EditMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
m_menu_access menu_access = new m_menu_access();
menu_access.m_role_id = menuAccess.mRoleId;
menu_access.is_delete = menuAccess.isDelete;
var menu_is_already_exist = (from p in db.m_menu_access
where p.m_role_id.Equals(menu_access.m_role_id) && !p.is_delete
select p).ToList();
foreach (var menu_id in menuAccess.selectedMenus)
{
if (!menu_is_already_exist.Any(x => x.m_menu_id.Equals(int.Parse(menu_id))))
{
menu_access.m_menu_id = int.Parse(menu_id);
menu_access.is_delete = false;
menu_access.created_by = menuAccess.createdBy;
menu_access.created_date = menuAccess.createdDate;
db.m_menu_access.Add(menu_access);
db.SaveChanges();
}
else
{
menu_access = menu_is_already_exist.Where(x => x.m_menu_id.Equals(int.Parse(menu_id))).SingleOrDefault();
menu_access.is_delete = true;
menu_access.updated_by = menuAccess.updateBy;
menu_access.updated_date = menuAccess.updatedDate;
db.Entry(menu_access).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
public void CreateMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
m_menu_access menu_access = new m_menu_access();
menu_access.m_role_id = menuAccess.mRoleId;
menu_access.is_delete = false;
menu_access.created_by = menuAccess.createdBy;
menu_access.created_date = DateTime.Now;
foreach (var menu_id in menuAccess.selectedMenus)
{
menu_access.m_menu_id = int.Parse(menu_id);
db.m_menu_access.Add(menu_access);
db.SaveChanges();
}
}
}
public void DeleteMenuAccess(MenuAccessViewModel menuAccess)
{
using (MarcommEntities db = new MarcommEntities())
{
var menu_is_already_exist = (from p in db.m_menu_access
where p.m_role_id.Equals(menuAccess.mRoleId) && !p.is_delete
select p).ToList();
foreach (var menu in menu_is_already_exist)
{
m_menu_access menu_access = menu;
menu_access.is_delete = true;
menu_access.updated_by = menuAccess.updateBy;
menu_access.updated_date = DateTime.Now;
db.Entry(menu_access).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public static bool update(MMenuAccessVM model)
{
bool result = false;
using (AppEntities db = new AppEntities())
{
var dataMenu = db.m_menu_access.Where(x => x.m_role_id == model.role.id);
db.m_menu_access.RemoveRange(dataMenu);
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
//memasukan idMenu Baru
foreach (var item in model.listMenuId)
{
m_menu_access data = new m_menu_access()
{
m_role_id = model.role.id,
m_menu_id = item,
created_by = 2,
created_date = DateTime.Now,
is_active = true
};
db.m_menu_access.Add(data);
}
try
{
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
}
return(result);
}
public static Responses Update(M_MenuAccessViewModel entity)
{
Responses result = new Responses();
try
{
using (var db = new MarcomContext())
{
if (entity.Id != 0)
{
m_menu_access mAccess = db.m_menu_access.Where(o => o.id == entity.Id).FirstOrDefault();
if (mAccess != null)
{
mAccess.m_menu_id = entity.MMenuId;
mAccess.m_role_id = entity.MRoleId;
mAccess.is_delete = entity.IsDelete;
mAccess.created_by = "csk";
mAccess.created_date = DateTime.Now;
db.SaveChanges();
}
}
else
{
m_menu_access mAccess = new m_menu_access();
mAccess.m_menu_id = entity.MMenuId;
mAccess.m_role_id = entity.MRoleId;
mAccess.is_delete = false;
mAccess.created_by = "csk";
mAccess.created_date = DateTime.Now;
db.m_menu_access.Add(mAccess);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Success = false;
}
return(result);
}
