public bool ChangeStatus(Menu menu, bool status) { try { using (LCDBEntities model = new LCDBEntities()) { var _menu = model.Menus.FirstOrDefault(o => o.ID == menu.ID); if (_menu == null) { throw new MenuNotFoundException("Menu not found with this id"); } _menu.IsActive = status; model.SaveChanges(); } return(true); } catch (Exception ex) { if (ex is MenuNotFoundException) { throw ex; } return(false); } }
public List <MenuClass> GetMenus(int roleId, int languageId) { try { using (var model = new LCDBEntities()) { var r = (from mr in model.MenusRoles.AsQueryable() join m in model.Menus.AsQueryable() on mr.MenuID equals m.ID join l in model.TranslateMenus.AsQueryable() on m.ID equals l.MenuID where mr.RoleID == roleId && l.LanguageID == languageId select new MenuClass { ID = m.ID, Name = m.Name, Description = m.Description, Tittle = l.Title, EventName = m.EventName, IsActive = m.IsActive, OrderNumber = m.OrderNumber, ParentID = m.ParentID }).ToList(); return(r); } } catch (Exception ex) { Debug.WriteLine(ex.Message); return(new List <MenuClass>()); } }
public bool EditCatalog(int id, string name, int?parentId) { try { using (var model = new LCDBEntities()) { var catalog = model.Catalogs.FirstOrDefault(c => c.ID == id); if (catalog == null) { throw new CatalogNotFoundException("Catalog with this id not found in database"); } catalog.Name = name; catalog.ParentID = parentId; model.SaveChanges(); return(true); } } catch (Exception ex) { if (ex is CatalogNotFoundException) { throw ex; } return(false); } }
public bool EditMenu(Menu menu) { try { using (LCDBEntities model = new LCDBEntities()) { var _menu = model.Menus.FirstOrDefault(m => m.ID == menu.ID); if (_menu == null) { throw new MenuNotFoundException("Menu not found with this id"); } _menu.IsActive = menu.IsActive; _menu.Name = menu.Name; _menu.Description = menu.Description; _menu.ParentID = menu.ParentID; _menu.EventName = menu.EventName; _menu.OrderNumber = menu.OrderNumber; model.SaveChanges(); } return(true); } catch (Exception ex) { if (ex is MenuNotFoundException) { throw ex; } return(false); } }
public bool AddMenu(Menu menu) { try { using (LCDBEntities model = new LCDBEntities()) { Menu _menu = new Menu(); _menu.ID = menu.ID; _menu.Name = menu.Name; _menu.Description = menu.Description; _menu.ParentID = menu.ParentID; _menu.EventName = menu.EventName; _menu.OrderNumber = menu.OrderNumber; _menu.IsActive = menu.IsActive; model.Menus.Add(_menu); model.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool SetStatusAsActive(int id, bool isActive) { try { using (var model = new LCDBEntities()) { var catalog = model.Catalogs.FirstOrDefault(c => c.ID == id); if (catalog == null) { throw new CatalogNotFoundException("Catalog with this id not found in database"); } catalog.IsActive = isActive; model.SaveChanges(); return(true); } } catch (Exception ex) { if (ex is CatalogNotFoundException) { throw ex; } return(false); } }
public List <ICatalog> GetCatalogsByParentId(int?parentID) { try { using (var model = new LCDBEntities()) { var catalogs = model.Catalogs.Where(c => c.ParentID == parentID); if (catalogs == null) { return(new List <ICatalog>()); } var result = catalogs.Select(c => new CatalogClass { Id = c.ID, IsActive = c.IsActive, Name = c.Name, ParentId = c.ParentID }).ToList <ICatalog>(); return(result); } } catch (Exception) { return(new List <ICatalog>()); } }
public List <RoleClass> GetRoles() { using (LCDBEntities model = new LCDBEntities()) { return(model.Roles.Select(i => new RoleClass { ID = i.ID, Name = i.Name, Description = i.Description }).ToList()); } }
public bool AddUser(UserClass user) { try { using (LCDBEntities model = new LCDBEntities()) { using (TransactionScope t = new TransactionScope()) { try { if (model.Users.Any(i => i.PersonalNumber.Equals(user.PersonalNumber))) { throw new Exception("This user already exists..."); } User u = new User(); u.PersonalNumber = user.PersonalNumber; u.FirstName = user.FirstName; u.LastName = user.LastName; u.EMail = user.EMail; u.Password = user.Password; u.BirthDate = user.BirthDate; u.NationalityID = user.NationalityID; u.Avatar = user.Avatar; u.Address1 = user.Address1; u.Address2 = user.Address2; u.PhoneNumber = user.PhoneNumber; u.GenderId = user.GenderId; model.Users.Add(u); UserRole ur = new UserRole(); ur.RoleID = user.RoleId; ur.UserID = u.ID; ur.IsActive = true; model.UserRoles.Add(ur); model.SaveChanges(); t.Complete(); return(true); } catch (Exception ex) { t.Dispose(); throw new Exception(ex.Message); } } } } catch (Exception ex) { return(false); } }
public bool BlockUnblock(int userId, int roleId) { try { LCDBEntities model = new LCDBEntities(); if (!model.UserRoles.Any(i => i.UserID == userId && i.RoleID == roleId)) { throw new Exception("role not found..."); } UserRole u = model.UserRoles.Where(i => i.UserID == userId && i.RoleID == roleId).First(); u.IsActive = !u.IsActive; model.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public UserClass FindUser(string pn) { try { LCDBEntities model = new LCDBEntities(); if (!model.Users.Any(i => i.PersonalNumber.Equals(pn))) { throw new Exception("User not found..."); } var result = model.Users.Where(i => i.PersonalNumber.Equals(pn)).Select(i => new UserClass { Id = i.ID, FirstName = i.FirstName, LastName = i.LastName, EMail = i.EMail, BirthDate = i.BirthDate, NationalityID = i.NationalityID, Avatar = i.Avatar, Address1 = i.Address1, Address2 = i.Address2, PhoneNumber = i.PhoneNumber, GenderId = i.GenderId, Roles = i.UserRoles.Select(k => new RoleClass { ID = k.ID, Name = k.Role.Name, Description = k.Role.Description }).ToList() }).First(); return(result); } catch (Exception ex) { return(null); } }
public bool ChangeMenuIndex(Menu menu, int ordernNUmber) { try { using (LCDBEntities model = new LCDBEntities()) { var _menu = model.Menus.FirstOrDefault(o => o.ID == menu.ID); if (_menu == null) { throw new MenuNotFoundException("Menu not found with this id"); } var menuItem = model.Menus.FirstOrDefault(o => o.OrderNumber == ordernNUmber); if (menuItem != null) { //model.Menus.Skip(ordernNUmber).Select(o => { o.OrderNumber++; return true; }); //for (int i = ordernNUmber; i < model.Menus.Count(); i++) //{ // model.Menus.ToList()[i].OrderNumber++; //} model.Menus.Skip(ordernNUmber).ToList().ForEach(o => { o.OrderNumber = o.OrderNumber++; }); menu.OrderNumber = ordernNUmber; } return(true); } } catch (Exception ex) { if (ex is MenuNotFoundException) { throw ex; } return(false); } }
public bool UpdateRole(RoleClass role) { try { LCDBEntities model = new LCDBEntities(); if (!model.Roles.Any(i => i.Name.Equals(role.Name))) { throw new Exception("This role not found..."); } Role r = model.Roles.Where(i => i.Name.Equals(role.Name)).First(); r.Name = role.Name; r.Description = role.Description; model.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool AddNewCatalog(ICatalog catalog) { try { using (var model = new LCDBEntities()) { var newCatalog = new Catalog() { Name = catalog.Name, ParentID = catalog.ParentId, IsActive = catalog.IsActive }; model.Catalogs.Add(newCatalog); model.SaveChanges(); } return(true); } catch (Exception) { return(false); } }
public bool AddRole(RoleClass role) { try { LCDBEntities model = new LCDBEntities(); if (model.Roles.Any(i => i.Name.Equals(role.Name))) { throw new Exception("This Role already exists..."); } Role r = new Role(); r.Name = role.Name; r.Description = role.Description; model.Roles.Add(r); model.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool AssignNewRole(int userId, int roleId) { try { LCDBEntities model = new LCDBEntities(); if (model.UserRoles.Any(i => i.UserID == userId && i.RoleID == roleId)) { throw new Exception("The Role is already assigned for this User..."); } UserRole ur = new UserRole(); ur.UserID = userId; ur.RoleID = roleId; ur.IsActive = true; model.UserRoles.Add(ur); model.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public bool UpdateUser(UserClass user) { try { using (LCDBEntities model = new LCDBEntities()) { using (TransactionScope t = new TransactionScope()) { try { if (!model.Users.Any(i => i.PersonalNumber.Equals(user.PersonalNumber))) { throw new Exception("This user not found..."); } User u = model.Users.Where(i => i.PersonalNumber.Equals(user.PersonalNumber)).First(); u.FirstName = user.FirstName; u.LastName = user.LastName; u.BirthDate = user.BirthDate; u.NationalityID = user.NationalityID; u.Avatar = user.Avatar; u.Address1 = user.Address1; u.Address2 = user.Address2; u.PhoneNumber = user.PhoneNumber; u.GenderId = user.GenderId; if (!model.UserRoles.Any(i => i.UserID == u.ID)) { throw new Exception("role not found..."); } UserRole ur = model.UserRoles.Where(i => i.UserID == u.ID).First(); ur.RoleID = user.RoleId; model.SaveChanges(); t.Complete(); return(true); } catch (Exception ex) { t.Dispose(); throw new Exception(ex.Message); } } } } catch (Exception ex) { return(false); } try { LCDBEntities model = new LCDBEntities(); model.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }