public List <K_Resident.Simple> ListResidentsCurrent(DateTime?today)
{
if (today is null)
{
today = DateTime.Now.Date;
}
using (KModel km = new KModel())
{
var query = from res in km.K_Resident
join type in km.K_ResidentType on res.K_ResidentID equals type.K_ResidentID
where res.K_ResidentStatus == 1 &&
res.K_ResidentArrivalDate < today &&
res.K_ResidentDepartureDate >= today &&
type.K_ResidentTypeActive == 1 &&
(type.K_ResidentType1 == (int)GlobalEnums.ResidentType.Undecided ||
type.K_ResidentType1 == (int)GlobalEnums.ResidentType.Guest ||
type.K_ResidentType1 == (int)GlobalEnums.ResidentType.ShortTerm ||
type.K_ResidentType1 == (int)GlobalEnums.ResidentType.LongTerm)
orderby res.K_ResidentFirstName
select new Simple()
{
FirstName = res.K_ResidentFirstName, LastName = res.K_ResidentLastName, CPR = res.K_ResidentCPR, ID = res.K_ResidentID
};
return(query.ToList <K_Resident.Simple>());
}
}
/// <summary>
/// List all residents who have not been cancelled (status == 1)
/// Ordered by FirstName
/// </summary>
/// <returns></returns>
public List <K_Resident.Simple> ListResidentsAll()
{
using (KModel km = new KModel())
{
var query = from res in km.K_Resident
where res.K_ResidentStatus == 1
orderby res.K_ResidentFirstName
select new Simple()
{
FirstName = res.K_ResidentFirstName, LastName = res.K_ResidentLastName, CPR = res.K_ResidentCPR, ID = res.K_ResidentID
};
return(query.ToList <K_Resident.Simple>());
}
}
public List <K_Resident.Simple> ListResidentsAppartment()
{
using (KModel km = new KModel())
{
var query = from res in km.K_Resident
join type in km.K_ResidentType on res.K_ResidentID equals type.K_ResidentID
where res.K_ResidentStatus == 1 &&
type.K_ResidentTypeActive == 1 &&
(type.K_ResidentType1 == (int)GlobalEnums.ResidentType.Appartement)
orderby res.K_ResidentFirstName
select new Simple()
{
FirstName = res.K_ResidentFirstName, LastName = res.K_ResidentLastName, CPR = res.K_ResidentCPR, ID = res.K_ResidentID
};
return(query.ToList <K_Resident.Simple>());
}
}
public List <K_Resident.Simple> ListResidentsArrivals(DateTime?today)
{
if (today is null)
{
today = DateTime.Now.Date;
}
using (KModel km = new KModel())
{
var query = from res in km.K_Resident
where res.K_ResidentStatus == 1 &&
res.K_ResidentArrivalDate == today
orderby res.K_ResidentFirstName
select new Simple()
{
FirstName = res.K_ResidentFirstName, LastName = res.K_ResidentLastName, CPR = res.K_ResidentCPR, ID = res.K_ResidentID
};
return(query.ToList <K_Resident.Simple>());
}
}
