public List <Organisation> GetOrganisations()
{
var organisations = _context.Set <Organisation>()
.ToList();
return(organisations);
}
public List <OrganisationManager> getDeletedOrganisationManagers(bool deleted)
{
var orgmagr = _context.Set <OrganisationManager>()
.Where(x => x.isDeleted == deleted)
.ToList();
return(orgmagr);
}
public Department GetTop1Department(string dep, int orgId, bool del)
{
var department = _context.Set <Department>()
.Where(x => x.DepartmentName == dep && x.OrganisationID == orgId && x.isDeleted == del)
.ToList();
return(department.LastOrDefault());
}
public DepartmentManager GetSpecificDepartmentManager(int depid, int empId, bool del)
{
var depMan = _context.Set <DepartmentManager>()
.Where(x => x.DepartmentID == depid && x.ManagerID == empId && x.isDeleted == del)
.ToList();
return(depMan.LastOrDefault());
}
public UserAddress GetUserAddress(int userID)
{
var userAdd = _context.Set <UserAddress>()
.Where(x => x.UserID == userID)
.Include(c => c.EmplonomyUser)
.Include(c => c.AddressType)
.Include(c => c.City)
.Include(c => c.Town)
.Include(c => c.Province)
.Include(c => c.Country)
.FirstOrDefault();
return(userAdd);
}
public int CountAddressTypes()
{
return(_context.Set <AddressType>().Count());
}
public int CountSendSmsStatuss()
{
return(_context.Set <SendSmsStatus>().Count());
}
public List <T> FindMany(Expression <Func <T, bool> > predicate)
{
List <T> entities = _context.Set <T>().Where(predicate).ToList();
return(entities);
}
public int CountProvisioned()
{
return(_context.Set <Provisioned>().Count());
}
public EmplonomyUser GetCompleteUserByEmail(string email)
{
var user = _context.Set <EmplonomyUser>()
.Where(x => x.EmailAddress == email && x.isDeleted == false)
.Include(d => d.Department)
.Include(p => p.PasswordQsBank)
.Include(sp => sp.SurveyResponses)
.Include(ua => ua.UserAddresses)
.Include(dm => dm.DepartmentManagers)
.Include(om => om.OrganisationManagers)
.FirstOrDefault();
return(user);
}
public int CountRoles()
{
return(_context.Set <Role>().Count());
}
public int CountShortMessages()
{
return(_context.Set <ShortMessage>().Count());
}
public int CountLocations()
{
return(_context.Set <Location>().Count());
}
public int CountPasswordQsBanks()
{
return(_context.Set <PasswordQsBank>().Count());
}