public List <UserDetail> GetUserList(int roleId) { List <UserDetail> list = null; using (LegaSysEntities db = new LegaSysEntities()) { list = db.LegaSys_UserDetails.Where(x => (x.IsActive && x.Master_Role_ID < roleId) || x.Master_Role_ID == 2).AsEnumerable().Select(y => new UserDetail { UserDetailID = y.UserDetailID, Fullname = $"{y.Firstname} {y.Lastname}" }).ToList(); } return(list); }
public List <LegaSys_Master_Technologies> GetAllTechnologyByDomainId(int id) { try { using (LegaSysEntities db = new LegaSysEntities()) { var tech = db.LegaSys_Master_Technologies.AsEnumerable().Where(x => x.Master_DomainID == id).Select(x => new LegaSys_Master_Technologies { TechnologyID = x.TechnologyID, Name = x.Name }).ToList(); return(tech); } } catch (Exception) { throw; } }
// Get All client details public List <ClientDetail> GetAllClient() { List <ClientDetail> lstClient = null; //declare the object to return try { using (LegaSysEntities db = new LegaSysEntities()) { lstClient = db.LegaSys_ClientDetails.Where(s => s.IsActive == true).Select(s => new ClientDetail() { ClientDetailID = s.ClientDetailID, ClientName = s.ClientName, Address = s.Address, Country = s.Country, CoClient = s.CoClient, //CoClient2 = s.CoClient2, //CoClient3 = s.CoClient3, //CoClient4 = s.CoClient4, EmailID = s.EmailID, //EmailID2 = s.EmailID2, //EmailID3 = s.EmailID3, //EmailID4 = s.EmailID4, //Created_By = s.Created_By, //Updated_By = s.Updated_By, IsActive = (bool)s.IsActive }).ToList(); } } catch (Exception) { throw; } return(lstClient); }
public UOWLocations(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWDomains(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWProjects(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWClient(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWResources(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWTask(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWShifts(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWTechnologies(IDbFactory dbFactory) { db = dbFactory.Init(); }
public LegaSysEntities Init() { return(dbContext ?? (dbContext = new LegaSysEntities())); }
public UOWRoles(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWUsers(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWExceptionLogger(IDbFactory dbFactory) { db = dbFactory.Init(); }
public UOWLeaves(IDbFactory dbFactory) { db = dbFactory.Init(); }