public IEnumerable <RPT_Role> GetList(List <RPT_UserRole> RoleCode) { using (ReportEntities db = new ReportEntities()) { int count = RoleCode.Count(); if (count == 0) { var Role = db.RPT_Role.ToList(); return(Role); } else { List <RPT_Role> Role = db.RPT_Role.ToList(); List <RPT_Role> Roledate = db.RPT_Role.ToList(); foreach (RPT_UserRole i in RoleCode) { foreach (RPT_Role j in Role) { if (i.RoleCode.Equals(j.RoleCode)) { Roledate.Remove(j); } } } return(Roledate); } } }
public RPT_Company GetData(int id) { using (ReportEntities db = new ReportEntities()) { return(db.RPT_Company.FirstOrDefault(p => p.ID == id)); } }
public RPT_Company GetData(string systemId) { using (ReportEntities db = new ReportEntities()) { return(db.RPT_Company.FirstOrDefault(p => p.SystemID == systemId)); } }
public List <RPT_Company> GetList() { using (ReportEntities db = new ReportEntities()) { return(db.RPT_Company.ToList()); } }
public int Update(string Account, string RoList, string CreateUser = "") { if (Account.Equals("")) { return(0); } using (ReportEntities db = new ReportEntities()) { var items = db.RPT_UserRole.Where(p => p.UserAccount == Account); if (items == null) { return(0); } foreach (var v in items) { db.RPT_UserRole.Remove(v); } string UserName = ""; if (CreateUser != "") { UserName = db.RPT_User.Where(p => p.UserAccount == Account).FirstOrDefault().UserName; } if (RoList.Equals("")) { return(0); } string[] sArray = RoList.Split(';'); RptRoleOP op = new RptRoleOP(); List <RPT_Role> RoleLst = op.GetList().ToList(); Hashtable data = new Hashtable(); foreach (string i in sArray) { foreach (RPT_Role j in RoleLst) { if (i.Equals(j.RoleCode)) { data[i] = j.RoleName; } } } foreach (string i in sArray) { if (!i.Equals("")) { RPT_UserRole UserRole = new RPT_UserRole() { UserAccount = Account, UserName = UserName, RoleName = data[i].ToString(), RoleCode = i, CreateUser = CreateUser, CreateTime = DateTime.Now }; db.RPT_UserRole.Add(UserRole); } } return(db.SaveChanges()); } }
public RPT_Role GetDataByCode(string RoleCode) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == RoleCode); return(item); } }
public RPT_Role GetData(int id) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.FirstOrDefault(p => p.ID == id); return(item); } }
public List <RPT_Menu> GetAllMenu() { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Menu.OrderBy(p => p.ID); return(item.ToList()); } }
public IEnumerable <RPT_Role> GetList(string txtSearch = "") { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.Where(p => txtSearch == "" || p.RoleName.Contains(txtSearch) || p.RoleDesc.Contains(txtSearch)).ToList(); return(item); } }
public bool Exists(string RoleCode) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == RoleCode); return(item != null); } }
public IEnumerable <RPT_Menu> GetList() { using (ReportEntities db = new ReportEntities()) { var data = db.RPT_Menu.ToList(); return(data); } }
public int Create(RPT_Company data) { using (ReportEntities db = new ReportEntities()) { db.RPT_Company.Add(data); return(db.SaveChanges()); } }
public IEnumerable <RPT_UserRole> GetListByUser(string UserAccount) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_UserRole.Where(p => p.UserAccount == UserAccount).ToList(); return(item); } }
public IEnumerable <RPT_Role> GetList(string txtSearch, int PageNumber, int PageSize, out int total) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.Where(p => txtSearch == "" || p.RoleName.Contains(txtSearch) || p.RoleDesc.Contains(txtSearch)); total = item.Count(); var data = item.OrderBy(p => p.RoleCode).Skip((PageNumber - 1) * PageSize).Take(PageSize); return(data.ToList()); } }
public IEnumerable <RPT_Company> GetList(string txtSearch, int pageNumber, int pageSize, out int total) { using (ReportEntities db = new ReportEntities()) { var data = db.RPT_Company.Where(p => txtSearch == "" || p.CompanyCode.Contains(txtSearch) || p.CompanyName.Contains(txtSearch) || p.CompanyAddress.Contains(txtSearch)); total = data.Count(); data = data.OrderBy(p => p.ID).Skip((pageNumber - 1) * pageSize).Take(pageSize); return(data.ToList()); } }
public int Delete(int id) { using (ReportEntities db = new ReportEntities()) { var exsit = db.RPT_Company.FirstOrDefault(p => p.ID == id); if (exsit != null) { db.RPT_Company.Remove(exsit); } return(db.SaveChanges()); } }
public int Create(RPT_Role data, List <RPT_UserRolePriv> list) { using (ReportEntities db = new ReportEntities()) { db.RPT_Role.Add(data); foreach (RPT_UserRolePriv userRole in list) { db.RPT_UserRolePriv.Add(userRole); } return(db.SaveChanges()); } }
public int Update(RPT_Company data) { using (ReportEntities db = new ReportEntities()) { var exsit = db.RPT_Company.FirstOrDefault(p => p.CompanyCode == data.SystemID); if (exsit != null) { int id = exsit.ID; exsit.CopyFrom(data); exsit.ID = id; } return(db.SaveChanges()); } }
public int Update(RPT_Menu data) { using (ReportEntities db = new ReportEntities()) { var exsit = db.RPT_Menu.FirstOrDefault(p => p.MenuID == data.MenuID); if (exsit != null) { int id = exsit.ID; exsit.CopyFrom(data); exsit.ID = id; } return(db.SaveChanges()); } }
public List <SelectListItem> GetExistsMenu(string RoleCode) { using (ReportEntities db = new ReportEntities()) { var item = from menu in db.RPT_Menu join role in db.RPT_UserRolePriv on menu.MenuID equals role.MenuID where role.UserRoleCode == RoleCode select new SelectListItem { Value = menu.MenuID, Text = menu.MenuName }; return(item.ToList()); } }
public int Delete(int id) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.FirstOrDefault(p => p.ID == id); db.RPT_UserRolePriv.Where(p => p.UserRoleCode == item.RoleCode).ToList().ForEach(k => { db.RPT_UserRolePriv.Remove(k); }); if (item != null) { db.RPT_Role.Remove(item); } return(db.SaveChanges()); } }
public int Update(RPT_Role data, List <RPT_UserRolePriv> list) { using (ReportEntities db = new ReportEntities()) { var item = db.RPT_Role.FirstOrDefault(p => p.RoleCode == data.RoleCode); if (item != null) { item.RoleName = data.RoleName; item.IsActive = data.IsActive; item.RoleDesc = data.RoleDesc; } var items = db.RPT_UserRolePriv.Where(p => p.UserRoleCode == data.RoleCode); foreach (var v in items) { db.RPT_UserRolePriv.Remove(v); } foreach (RPT_UserRolePriv userRole in list) { db.RPT_UserRolePriv.Add(userRole); } return(db.SaveChanges()); } }