public void Insert(UserRole userRole)
{
using (CRContext db = new CRContext())
{
db.UserRoles.Add(userRole);
db.SaveChanges();
}
}
public void Delete(Menu menu)
{
using (CRContext db = new CRContext())
{
db.Menus.Attach(menu);
db.Menus.Remove(menu);
db.SaveChanges();
}
}
public void Delete(User user)
{
using (CRContext db = new CRContext())
{
db.Users.Attach(user);
db.Users.Remove(user);
db.SaveChanges();
}
}
public UserRole GetDetail(UserRole userRole)
{
using (CRContext db = new CRContext())
{
return(db.UserRoles
.Where(u => u.UserRoleID.Equals(userRole.UserRoleID) ||
u.Name.Equals(userRole.Name)).FirstOrDefault());
}
}
public void Update(UserRole userRole)
{
using (CRContext db = new CRContext())
{
db.UserRoles.Attach(userRole);
db.Entry(userRole).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void Insert(User user)
{
using (CRContext db = new CRContext())
{
db.Users.Add(user);
db.UserRoles.Attach(user.UserRole);
db.Entry(user.UserRole).State = System.Data.Entity.EntityState.Unchanged;
db.SaveChanges();
}
}
public User GetDetail(User user)
{
using (CRContext db = new CRContext())
{
return(db.Users.Include("UserRole")
.Where(u => u.UserID.Equals(user.UserID) ||
u.Name.Equals(user.Name))
.FirstOrDefault());
}
}
public EF.Models.Menu GetDetail(EF.Models.Menu menu)
{
using (CRContext db = new CRContext())
{
return(db.Menus
.Include("ParentMenu")
.Where(m => m.MenuID.Equals(menu.MenuID) ||
m.Label.Equals(menu.Label))
.FirstOrDefault());
}
}
public void Insert(Menu menu)
{
using (CRContext db = new CRContext())
{
db.Menus.Add(menu);
Menu parentMenu = (menu.ParentMenu != null ? menu.ParentMenu : null);
if (parentMenu != null)
{
db.Menus.Attach(parentMenu);
db.Entry(menu.ParentMenu).State = EntityState.Unchanged;
}
db.SaveChanges();
}
}
public void Update(Menu menu)
{
using (CRContext db = new CRContext())
{
Menu parentMenu = (menu.ParentMenu != null ? menu.ParentMenu : null);
if (parentMenu != null)
{
db.Menus.Attach(menu.ParentMenu);
menu.ParentMenuID = menu.ParentMenu.ParentMenuID;
}
db.Entry(menu).State = EntityState.Modified;
db.SaveChanges();
}
}
public List <UserRole> Select(UserRole userRole = null)
{
using (CRContext db = new CRContext())
{
if (userRole == null)
{
return(db.UserRoles.ToList());
}
else
{
return(db.UserRoles
.Where(u => u.UserRoleID.Equals(userRole.UserRoleID) ||
u.Name.Equals(userRole.Name)).ToList());
}
}
}
public List <User> Select(User user = null)
{
using (CRContext db = new CRContext())
{
if (user == null)
{
return(db.Users.Include("UserRole").ToList());
}
else
{
return(db.Users.Include("UserRole")
.Where(u => u.UserID.Equals(user.UserID) ||
u.Name.Equals(user.Name))
.ToList());
}
}
}
public List <Menu> Select(Menu menu = null)
{
using (CRContext db = new CRContext())
{
if (menu == null)
{
return(db.Menus
.Include("ParentMenu")
.ToList());
}
else
{
return(db.Menus
.Include("ParentMenu")
.Where(m => m.MenuID.Equals(menu.MenuID) ||
m.Label.Equals(menu.Label))
.ToList());
}
}
}
