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());
}
}
