public IEnumerable <MenuInfo> GetMenuInfoByLoginID(string loginID) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var roleQuery = from a in entityContext.MenuRoleSet join b in entityContext.UserRoleSet on a.RoleId equals b.RoleId join c in entityContext.UserSetupSet on b.UserSetupId equals c.UserSetupId where c.LoginID == loginID select a; var menuIds = roleQuery.Select(c => c.MenuId).Distinct().ToArray(); var query = from a in entityContext.MenuSet join b in entityContext.ModuleSet on a.ModuleId equals b.ModuleId join c in entityContext.MenuSet on a.ParentId equals c.MenuId into parents from pt in parents.DefaultIfEmpty() where b.Active && a.Active && menuIds.Contains(a.MenuId) select new MenuInfo() { Menu = a, Module = b, Parent = pt }; return(query.ToFullyLoaded()); } }
protected override IEnumerable <AuditTrail> GetEntities(SystemCoreContext entityContext) { //return from e in entityContext.Set<AuditTrail>() // select e; var query = (from e in entityContext.Set <AuditTrail>() select e).Take(0); var results = query; return(results); }
protected override AuditTrail GetEntity(SystemCoreContext entityContext, int id) { var query = (from e in entityContext.Set <AuditTrail>() where e.AuditTrailId == id select e); var results = query.FirstOrDefault(); return(results); }
protected override CompanySecurity GetEntity(SystemCoreContext entityContext, int id) { var query = (from e in entityContext.Set <CompanySecurity>() where e.CompanySecurityId == id select e); var results = query.FirstOrDefault(); return(results); }
protected override Database GetEntity(SystemCoreContext entityContext, int id) { var query = (from e in entityContext.Set <Database>() where e.DatabaseId == id select e); var results = query.FirstOrDefault(); return(results); }
protected override ErrorTracker GetEntity(SystemCoreContext entityContext, int id) { var query = (from e in entityContext.Set <ErrorTracker>() where e.ErrorTrackerId == id select e); var results = query.FirstOrDefault(); return(results); }
protected override UserSession GetEntity(SystemCoreContext entityContext, int id) { var query = (from e in entityContext.Set <UserSession>() where e.UserSessionId == id select e); var results = query.FirstOrDefault(); return(results); }
public UserSetup GetByLoginID(string loginID) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.UserSetupSet where a.LoginID == loginID select a; return(query.FirstOrDefault()); } }
//public IEnumerable<AuditTrail> GetByAction(AuditAction action, DateTime fromDate, DateTime toDate) //{ // using (SystemCoreContext entityContext = new SystemCoreContext()) // { // var query = from a in entityContext.AuditTrailSet // where a.RevisionStamp >= fromDate && a.RevisionStamp <= toDate && a.Actions == action // select a; // return query.ToFullyLoaded(); // } //} public IEnumerable <AuditTrail> GetAuditTrailByTab(AuditAction action) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.AuditTrailSet where a.Actions == action select a; return(query.ToFullyLoaded()); } }
public IEnumerable <AuditTrail> GetByTable(string tablename, DateTime fromDate, DateTime toDate) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.AuditTrailSet where a.RevisionStamp >= fromDate && a.RevisionStamp <= toDate && a.TableName == tablename select a; return(query.ToFullyLoaded()); } }
public IEnumerable <CompanyUser> GetCompanyUsers(string loginID) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.CompanyUserSet join b in entityContext.UserSetupSet on a.UserId equals b.UserSetupId where b.LoginID == loginID select a; return(query.ToFullyLoaded()); } }
public IEnumerable <ModuleInfo> GetModules() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.ModuleSet join d in entityContext.SolutionSet on a.SolutionId equals d.SolutionId select new ModuleInfo() { Module = a, Solution = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <RoleInfo> GetRoles() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.RoleSet join b in entityContext.SolutionSet on a.SolutionId equals b.SolutionId select new RoleInfo() { Role = a, Solution = b }; return(query.ToFullyLoaded()); } }
public IEnumerable <DatabaseInfo> GetDatabases() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.DatabaseSet join b in entityContext.SolutionSet on a.SolutionId equals b.SolutionId into parents from pt in parents.DefaultIfEmpty() select new DatabaseInfo() { Database = a, Solution = pt }; return(query.ToFullyLoaded()); } }
public IEnumerable <CompanyModuleInfo> GetCompanyModules() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.CompanyModuleSet join b in entityContext.CompanySet on a.CompanyCode equals b.Code join c in entityContext.ModuleSet on a.ModuleName equals c.Name select new CompanyModuleInfo() { CompanyModule = a, Company = b, Module = c }; return(query.ToFullyLoaded()); } }
public IEnumerable <UserSessionInfo> GetUserSessions() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.UserSessionSet join b in entityContext.UserSetupSet on a.UserId equals b.LoginID join c in entityContext.DatabaseSet on a.DatabaseId equals c.DatabaseId select new UserSessionInfo() { UserSession = a, UserSetup = b, Database = c }; return(query.ToFullyLoaded()); } }
// join b in entityContext.TeamSet on a.ParentCode equals b.Code into parents // from pt in parents.Where(c=>(a.Year==c.Year)).DefaultIfEmpty() public IEnumerable <MenuInfo> GetMenuInfo() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.MenuSet join b in entityContext.ModuleSet on a.ModuleId equals b.ModuleId join c in entityContext.MenuSet on a.ParentId equals c.MenuId into parents from pt in parents.DefaultIfEmpty() select new MenuInfo() { Menu = a, Module = b, Parent = pt }; return(query.ToFullyLoaded()); } }
public IEnumerable <MenuRoleInfo> GetMenuRoleInfo() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.MenuRoleSet join b in entityContext.MenuSet on a.MenuId equals b.MenuId join c in entityContext.RoleSet on a.RoleId equals c.RoleId join d in entityContext.SolutionSet on c.SolutionId equals d.SolutionId select new MenuRoleInfo() { MenuRole = a, Menu = b, Role = c, Solution = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <UserRoleInfo> GetUserRoleInfo() { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.UserRoleSet join b in entityContext.UserSetupSet on a.UserSetupId equals b.UserSetupId join c in entityContext.RoleSet on a.RoleId equals c.RoleId join d in entityContext.SolutionSet on c.SolutionId equals d.SolutionId select new UserRoleInfo() { UserRole = a, UserSetup = b, Role = c, Solution = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <UserRoleInfo> GetUserRoleInfo(string solutionName, string loginID, List <string> roleNames) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.UserRoleSet join b in entityContext.UserSetupSet on a.UserSetupId equals b.UserSetupId join c in entityContext.RoleSet on a.RoleId equals c.RoleId join d in entityContext.SolutionSet on c.SolutionId equals d.SolutionId where d.Name == solutionName && b.LoginID == loginID && roleNames.Contains(c.Name) select new UserRoleInfo() { UserRole = a, UserSetup = b, Role = c, Solution = d }; return(query.ToFullyLoaded()); } }
public IEnumerable <MenuRoleInfo> GetMenuRoleInfo(string loginID) { using (SystemCoreContext entityContext = new SystemCoreContext()) { var query = from a in entityContext.MenuRoleSet join b in entityContext.MenuSet on a.MenuId equals b.MenuId join c in entityContext.RoleSet on a.RoleId equals c.RoleId join d in entityContext.UserRoleSet on a.RoleId equals d.RoleId join e in entityContext.UserSetupSet on d.UserSetupId equals e.UserSetupId join f in entityContext.SolutionSet on c.SolutionId equals f.SolutionId where e.LoginID == loginID select new MenuRoleInfo() { MenuRole = a, Menu = b, Role = c, Solution = f }; return(query.ToFullyLoaded()); } }
protected override IEnumerable <Database> GetEntities(SystemCoreContext entityContext) { return(from e in entityContext.Set <Database>() select e); }
protected override Database UpdateEntity(SystemCoreContext entityContext, Database entity) { return((from e in entityContext.Set <Database>() where e.DatabaseId == entity.DatabaseId select e).FirstOrDefault()); }
protected override Database AddEntity(SystemCoreContext entityContext, Database entity) { return(entityContext.Set <Database>().Add(entity)); }
protected override Client UpdateEntity(SystemCoreContext entityContext, Client entity) { return((from e in entityContext.Set <Client>() where e.ClientId == entity.ClientId select e).FirstOrDefault()); }
protected override Client AddEntity(SystemCoreContext entityContext, Client entity) { return(entityContext.Set <Client>().Add(entity)); }
protected override UserSession UpdateEntity(SystemCoreContext entityContext, UserSession entity) { return((from e in entityContext.Set <UserSession>() where e.UserSessionId == entity.UserSessionId select e).FirstOrDefault()); }
protected override IEnumerable <UserSession> GetEntities(SystemCoreContext entityContext) { return(from e in entityContext.Set <UserSession>() select e); }
protected override AuditTrail UpdateEntity(SystemCoreContext entityContext, AuditTrail entity) { return((from e in entityContext.Set <AuditTrail>() where e.AuditTrailId == entity.AuditTrailId select e).FirstOrDefault()); }
protected override AuditTrail AddEntity(SystemCoreContext entityContext, AuditTrail entity) { return(entityContext.Set <AuditTrail>().Add(entity)); }