public WFM_Designation GetDesignationById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Designation.Where(s => s.Id == id).SingleOrDefault()); } }
public WFM_ProjectType GetProjectTypeById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectType.Where(s => s.Id == id).SingleOrDefault()); } }
public List <WFM_ProjectSector> GetProjectSectorParentList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectSector.Where(s => s.IsActive == true && s.ParentId == 0).ToList()); } }
public int GetMaxNumber() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Project.Max(p => p.Number).Value); } }
public List <WFM_Principal> GetPrincipalList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Principal.Include("WFM_Country").Where(o => o.IsActive == true).OrderBy(o => o.Name).ToList()); } }
public WFM_Organization GetOrganizationById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Organization.Where(o => o.Id == id).SingleOrDefault()); } }
public WFM_Project GetProjectById(int projectTypeId, int id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { if (projectTypeId == 0) { return(entities.WFM_Project .Include("WFM_ProjectType") .Include("WFM_ProjectType") .Include("WFM_Organization") .Include("WFM_ProjectSector") .Include("WFM_ProjectSector1") .Include("WFM_ProjectStatus") .Include("WFM_DocumentTab") .Where(p => p.Id == id) .SingleOrDefault()); } else { return(entities.WFM_Project .Include("WFM_ProjectType") .Include("WFM_ProjectType") .Include("WFM_Organization") .Include("WFM_ProjectSector") .Include("WFM_ProjectSector1") .Include("WFM_ProjectStatus") .Include("WFM_DocumentTab") .Where(p => p.ProjectTypeId == projectTypeId && p.Id == id) .SingleOrDefault()); } } }
public List <WFM_Document> GetDocumentsByProjectTypeWithFields(int projectTypeId) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Document.Include("WFM_DocumentField").Where(s => s.ProjectTypeId == projectTypeId && s.HasFields == true).ToList()); } }
public List <WFM_CommonData> GetCommonData(int type) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_CommonData.Where(o => o.Type == type).OrderBy(o => o.DisplayOrder).ToList()); } }
public static List <DataAudit> GetDataAuditByUser(Guid userId) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.DataAudits.Include("").Where(l => l.UserId == userId).OrderByDescending(o => o.UpdatedOn).ToList()); } }
public static List <LoginAudit> GetLoginAuditByUser(Guid userId) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.LoginAudits.Where(l => l.UserId == userId).OrderByDescending(o => o.DateLogged).ToList()); } }
public List <WFM_Contact> GetContactList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Contact.Where(s => s.IsActive == true).ToList()); } }
public List <WFM_ProjectStatus> GetStatusList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectStatus.ToList()); } }
public List <WFM_Designation> GetDesignationList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Designation.Where(d => d.IsActive == true).OrderBy(d => d.Name).ToList()); } }
public WFM_SourcingPartner GetSourdingPartnerById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_SourcingPartner.Where(s => s.Id == id).SingleOrDefault()); } }
public List <WFM_MethodOfIntroduction> GetMethodOfIntroductionList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_MethodOfIntroduction.Where(m => m.IsActive == true).ToList()); } }
public List <WFM_Organization> GetOrganizationList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Organization.Where(s => s.IsActive == true).ToList()); } }
public WFM_Country GetCountryById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Country.Where(s => s.Id == id).SingleOrDefault()); } }
public List <WFM_Organization> GetAllOrganizationList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Organization.ToList()); } }
public List <WFM_Country> GetCountryList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Country.Where(d => d.IsActive == true).OrderBy(d => d.Name).ToList()); } }
public List <GetDashboardData_Result> GetDashboardData() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.GetDashboardData().ToList()); } }
public List <WFM_ProjectDocument> GetProjectDocumentsByProjectType(int projectTypeId) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectDocument.Include("WFM_Document").Where(s => s.WFM_Document.ProjectTypeId == projectTypeId).ToList()); } }
public WFM_Principal GetPrincipalById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Principal.Include("WFM_Country").Where(o => o.Id == id).SingleOrDefault()); } }
public WFM_Employee GetEmployeeById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Employee.Where(s => s.Id == id).SingleOrDefault()); } }
public List <WFM_ProjectType> GetProjectTypeList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectType.ToList()); } }
public List <WFM_Employee> GetEmployeeList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_Employee.Where(d => d.IsActive == true).OrderBy(d => d.Name).ToList()); } }
public List <WFM_ProjectSector> GetSubProjectSectorsByParentId(int sectorId) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectSector.Where(s => s.ParentId == sectorId && s.IsActive == true).ToList()); } }
public List <WFM_SourcingPartner> GetSourdingPartnerList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_SourcingPartner.Where(s => s.IsActive == true).OrderBy(d => d.Name).ToList()); } }
public WFM_ProjectSector GetProjectSectorById(int?id) { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_ProjectSector.Where(s => s.IsActive == true && s.Id == id).SingleOrDefault()); } }
public List <WFM_PriorityFramework> GetPriorityFrameworkList() { using (LinkManagementEntities entities = new LinkManagementEntities()) { return(entities.WFM_PriorityFramework.Where(m => m.IsActive == true).ToList()); } }