public Car Get(Expression <Func <Car, bool> > filter)
{
using (CareContext context = new CareContext())
{
return(context.Set <Car>().SingleOrDefault(filter));
}
}
public List <Resident> FilterResidentsByCareLevel(string careLevel)
{
List <Resident> residents = new List <Resident>();
using (var context = new CareContext()) {
/*
* residents = context.Residents.Where(e => e.CareLevel.Equals(careLevel)).ToList();
*
* oder:
*
*/
IQueryable <Resident> residentsQueryList = from resident in context.Residents
where resident.CareLevel == careLevel
select resident;
foreach (Resident res in residentsQueryList)
{
residents.Add(res);
}
if (residents.Count > 0)
{
return(residents);
}
else
{
throw new ArgumentException("Keiner der Bewohner hat dieses Care Level.");
}
}
}
public Resident FindResidentById(int residentId)
{
using (var context = new CareContext()) {
Resident resident = context.Residents.Find(residentId);
return(resident);
}
}
public void DeleteResidentWithVisitors(int residentId)
{
using (var context = new CareContext()) {
Resident res = context.Residents.Find(residentId);
context.Residents.Remove(res);
context.SaveChanges();
}
}
public void Update(Car entity)
{
using (CareContext context = new CareContext())
{
var updatedEntity = context.Entry(entity);
updatedEntity.State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(Car entity)
{
using (CareContext context = new CareContext())
{
var addedEntity = context.Entry(entity);
addedEntity.State = EntityState.Added;
context.SaveChanges();
}
}
public List <Visitor> GetVisitorListForResidentId(int residentId)
{
List <Visitor> visitorList = new List <Visitor>();
using (var context = new CareContext()) {
visitorList = context.Visitors.Where(e => e.ResidentId == residentId).ToList();
}
return(visitorList);
}
public void Delete(Car entity)
{
using (CareContext context = new CareContext())
{
var deletedEntity = context.Entry(entity);
deletedEntity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public List <Resident> FilterResidentsByAge(int minAge, int maxAge)
{
List <Resident> residents = new List <Resident>();
using (var context = new CareContext()) {
residents = context.Residents.Where(a => a.Age >= minAge && a.Age <= maxAge).ToList();
}
return(residents);
}
public List <Car> GetAll(Expression <Func <Car, bool> > filter = null)
{
using (CareContext context = new CareContext())
{
if (filter == null)
{
return(context.Set <Car>().ToList());
}
else
{
return(context.Set <Car>().Where(filter).ToList());
}
}
}
public int CountNumberOfEquipmentCategories()
{
int numberOfCats = 0;
using (var context = new CareContext()) {
var residents = context.Rooms.ToList(); // zuerst die Liste holen
var query = residents
.GroupBy(e => e.Equipment).Select(b => b).ToList(); // dann kann GroupBy darauf ausgeführt werden
numberOfCats = query.Count;
}
return(numberOfCats);
}
public List <Resident> GetResidentListForCareTakerId(int careTakerId)
{
List <Resident> residents = new List <Resident>();
using (var context = new CareContext()) {
List <ResidentCareTaker> residentCareTakers = context.ResidentCareTakers
.Where(e => e.CareTakerId == careTakerId).ToList();
foreach (ResidentCareTaker resCareTaker in residentCareTakers)
{
Resident resident = context.Residents.Find(resCareTaker.ResidentId);
residents.Add(resident);
}
return(residents);
}
}
public List <CareTaker> GetCaretTakerListForResidentId(int residentId)
{
List <CareTaker> careTakers = new List <CareTaker>();
using (var context = new CareContext()) {
List <ResidentCareTaker> residentCareTakers = context.ResidentCareTakers
.Where(e => e.ResidentId == residentId).ToList();
foreach (ResidentCareTaker resCareTaker in residentCareTakers)
{
CareTaker careTaker = context.CareTakers.Find(resCareTaker.CareTakerId);
careTakers.Add(careTaker);
}
return(careTakers);
}
}
public int CountNumberOfEquipmentCategories()
{
int numberOfCats = 0;
using (var context = new CareContext()) {
var residents = context.Rooms.ToList(); // zuerst die Liste holen
var query = residents
.GroupBy(e => e.Equipment).Select(b => b).ToList(); // dann kann GroupBy darauf ausgeführt werden
numberOfCats = query.Count;
/*var catGroups = from res in residents
* group res by res.Equipment;
*
* foreach (var group in catGroups) {
* numberOfCats++;
* }*/
}
return(numberOfCats);
}
public Resident UpdateNameResident(int residentId, string preName, string lastName)
{
Resident resident = new Resident();
using (var context = new CareContext()) {
try {
resident = context.Residents.Find(residentId);
if (!resident.Prename.Equals(preName) && !String.IsNullOrEmpty(preName))
{
resident.Prename = preName;
}
if (!resident.LastName.Equals(lastName) && !String.IsNullOrEmpty(lastName))
{
resident.LastName = lastName;
}
context.SaveChanges();
} catch (Exception e) {
Console.WriteLine(e.Message);
}
}
return(resident);
}
public List <Resident> FilterResidentByRoomEquipment(string equipment)
{
List <Resident> residents = new List <Resident>();
using (var context = new CareContext()) {
/*residents = context.Residents.Where(p => p.Room.Equipment.Equals(equipment)).ToList();
* if (residents.Count == 0) {
* throw new ArgumentException($"Keiner dieser Bewohner hat die Ausstattungskategorie {equipment}");
* }
*
* oder
*/
IQueryable <Resident> residentList = from resident in context.Residents
where resident.Room.Equipment == equipment
select resident;
foreach (Resident res in residentList)
{
residents.Add(res);
}
}
return(residents);
}
public CareController(CareContext context)
{
_context = context;
}