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