private void UpdateAutoReservations(object state)
{
//Get json from rest api
var IpToMacActiveUsers = new Dictionary <string, string>();
var macToUser = new Dictionary <string, string>();
foreach (var ipMac in IpToMacActiveUsers)
{
var activeUser = macToUser[ipMac.Value];
var userIpAddress = ipMac.Key;
var desk = new Desk();
using (var db = new FlexSeatingContext())
{
desk = db.Desk.Where(x => x.IpAddress == userIpAddress).FirstOrDefault();
}
if (desk.Reservations.Count == 0)
{
desk.Reservations.Add(new Reservations()
{
Date = DateTime.Now,
UserId = activeUser,
DeskId = desk.Id,
Desk = desk
});
}
}
}
public Floor GetFloor(int floorId)
{
using (var dbContext = new FlexSeatingContext())
{
return(dbContext.Floor.Where(x => x.Id == floorId).FirstOrDefault());
}
}
public Building GetBuilding(int buildingId)
{
using (var dbContext = new FlexSeatingContext())
{
return(dbContext.Building.Include(x => x.Floor).Where(x => x.Id == buildingId).FirstOrDefault());
}
}
public List <Building> GetBuildings(DateTime now)
{
using (var dbContext = new FlexSeatingContext())
{
var date = new DateTime(now.Year, now.Month, now.Day);
var todayReservations = dbContext.Reservations.Where(x => x.Date == date).ToList();
var buildings = dbContext.Building
.Include(x => x.Floor)
.ThenInclude(y => y.Desk)
.ToList();
foreach (var b in buildings)
{
foreach (var f in b.Floor)
{
f.Desk = f.Desk.OrderBy(x => x.Name).ToList();
foreach (var d in f.Desk)
{
foreach (var r in todayReservations)
{
if (r.DeskId == d.Id)
{
d.Reservations.Add(r);
}
}
}
}
}
return(buildings);
}
}
public void CancelReservation(int reservationId, string user)
{
using (var dbContext = new FlexSeatingContext())
{
var res = dbContext.Reservations.Where(x => x.Id == reservationId).FirstOrDefault();
if (res != null && user == res.UserId)
{
dbContext.Reservations.Remove(res);
}
dbContext.SaveChanges();
}
}
public void ReserveDesk(int deskId, string user, DateTime date)
{
using (var dbContext = new FlexSeatingContext())
{
var num = dbContext.Reservations.Where(x => (x.Date == date && x.UserId == user)).Count();
if (num == 0)
{
var res = new Reservations()
{
DeskId = deskId,
UserId = user,
Date = date
};
dbContext.Reservations.Add(res);
dbContext.SaveChanges();
}
}
}
