public IEnumerable <Tab> GetListOfAllTab()
{
return(WorkspaceFactory.CreateReadOnly().Query <Tab>(null));
}
public IList <CarModel> GetCarModels()
{
return(WorkspaceFactory.CreateReadOnly().Query <CarModel>(null).OrderBy(x => x.ModelName).ToList());
}
public IList <ServiceType> GetServiceTypes()
{
return(WorkspaceFactory.CreateReadOnly().Query <ServiceType>(null).ToList());
}
public IList <Grant> GetGrants()
{
return(WorkspaceFactory.CreateReadOnly().Query <Grant>(x => x.Status == "Active").ToList());
}
public IList <SoleVendorSupplier> GetSoleVendorSuppliers(int SupplierTypeId)
{
return(WorkspaceFactory.CreateReadOnly().Query <SoleVendorSupplier>(x => x.SupplierType.Id == SupplierTypeId && x.Status == "Active").ToList());
}
public IList <Beneficiary> GetBeneficiaries()
{
return(WorkspaceFactory.CreateReadOnly().Query <Beneficiary>(x => x.Status == "Active").ToList());
}
public IList <ItemAccount> GetAdvanceAccount()
{
return(WorkspaceFactory.CreateReadOnly().Query <ItemAccount>(x => x.AccountName == "Account Receivable").ToList());
}
public IList <Laboratory> GetLabratories()
{
return(WorkspaceFactory.CreateReadOnly().Query <Laboratory>(null).OrderBy(x => x.LaboratoryName).ToList());
}
public IList <AppUser> GetProgramManagers()
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(x => x.EmployeePosition.PositionName == "Program Manager" || x.EmployeePosition.PositionName == "Operational Manager" || x.EmployeePosition.PositionName == "Country Director" || x.EmployeePosition.PositionName == "Deputy Country Director").ToList());
}
public IList <AppUser> GetUsers()
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(null).ToList());
}
public IList <Facility> GetFacilities()
{
return(WorkspaceFactory.CreateReadOnly().Query <Facility>(null).OrderBy(x => x.FacilityName).ToList());
}
public IList <AppUser> GetDrivers()
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(x => x.EmployeePosition.PositionName == "Driver" || x.EmployeePosition.PositionName == "Admin/HR Assisitance (Driver)").ToList());
}
public IList <AssignJob> GetAssignJobs()
{
return(WorkspaceFactory.CreateReadOnly().Query <AssignJob>(null).ToList());
}
public IList <EmployeePosition> GetEmployeePositions()
{
return(WorkspaceFactory.CreateReadOnly().Query <EmployeePosition>(null).ToList());
}
public IList <EmployeeLeave> GetEmployeeLeaves()
{
return(WorkspaceFactory.CreateReadOnly().Query <EmployeeLeave>(null).ToList());
}
public IList <EmployeePosition> GetEmployeePositions()
{
return(WorkspaceFactory.CreateReadOnly().Query <EmployeePosition>(x => x.Status == "Active").ToList());
}
public IList <EmployeeLeave> GetEmployeeLeaves(int UserId)
{
return(WorkspaceFactory.CreateReadOnly().Query <EmployeeLeave>(x => x.AppUser.Id == UserId).OrderByDescending(x => x.Id).ToList());
}
public IList <JobTitle> GetJobTitles()
{
return(WorkspaceFactory.CreateReadOnly().Query <JobTitle>(null).OrderBy(x => x.JobTitleName).ToList());
}
public IList <AppUser> GetAppUsersByEmployeePosition(int employeePosition)
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(x => x.EmployeePosition.Id == employeePosition).ToList());
}
public IList <Program> GetPrograms()
{
return(WorkspaceFactory.CreateReadOnly().Query <Program>(null).OrderBy(x => x.ProgramName).ToList());
}
public IList <ItemAccountChecklist> GetItemAccountChecklists()
{
return(WorkspaceFactory.CreateReadOnly().Query <ItemAccountChecklist>(x => x.Status == "Active").OrderBy(x => x.ChecklistName).ToList());
}
public IList <ProGrant> GetProjectGrants()
{
return(WorkspaceFactory.CreateReadOnly().Query <ProGrant>(null).ToList());
}
public IList <SoleVendorSupplier> GetSoleVendorSuppliers()
{
return(WorkspaceFactory.CreateReadOnly().Query <SoleVendorSupplier>(x => x.Status == "Active").OrderBy(x => x.SupplierName).ToList());
}
public IList <ApprovalSetting> GetApprovalSettings()
{
return(WorkspaceFactory.CreateReadOnly().Query <ApprovalSetting>(null).ToList());
}
public IList <CarRental> GetCarRentals()
{
return(WorkspaceFactory.CreateReadOnly().Query <CarRental>(x => x.Status == "Active").ToList());
}
public IList <AppUser> GetProgramManagers()
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(x => x.EmployeePosition.PositionName.Contains("Program Manager") || x.EmployeePosition.PositionName == "Vice President & Country Director, Ethiopia" || x.EmployeePosition.PositionName == "Finance Manager" || x.EmployeePosition.PositionName == "Senior Deputy Country Director" || x.EmployeePosition.PositionName == "Coordinator, Program Operations" || x.EmployeePosition.PositionName == "M&E Manager" || x.EmployeePosition.PositionName == "Head, Administration & HR").ToList());
}
public IList <Vehicle> GetVehicles()
{
return(WorkspaceFactory.CreateReadOnly().Query <Vehicle>(x => x.Status == "Active").OrderBy(x => x.AppUser).ToList());
}
public IList <AppUser> GetEmployeeList()
{
return(WorkspaceFactory.CreateReadOnly().Query <AppUser>(x => x.IsActive == true).OrderBy(x => x.FullName).ToList());
}
public IList <LeaveType> GetLeaveTypes()
{
return(WorkspaceFactory.CreateReadOnly().Query <LeaveType>(x => x.Status == "Active").ToList());
}
public IList <PocModule> GetListOfAllPocModules()
{
return(WorkspaceFactory.CreateReadOnly().Query <PocModule>(null).ToList());
}