public void AddReservation(Reserve reservation)
{
using (DB_ReservationContext context = new DB_ReservationContext())
{
context.reservationList.Add(reservation);
context.SaveChanges();
}
}
public Reserve[] GetAllReservationsOf(string LicencePLate)
{
LicencePLate = LicencePLate.Replace(" ", "").Trim();
using (DB_ReservationContext context = new DB_ReservationContext())
{
var list = context.reservationList.Where(r => r.Licence_Plate.Replace(" ", "").Trim() == LicencePLate);
return(list.ToArray());
}
}
public bool WasTheLicencePlateReserveAt(string licencePlate, DateTime time, Country country)
{
licencePlate = licencePlate.Trim().Replace(" ", "");
using (DB_ReservationContext DBcontextReservation = new DB_ReservationContext())
{
bool result;
result = DBcontextReservation.reservationList.Any(r => r.Licence_Plate.Trim().Replace(" ", "") == licencePlate && r.Start_Time <= time && r.End_Time >= time);
return(result);
}
}
public Reserve[] GetPeriodTimeReservations(ReservationRequestLetter solicitude)
{
using (DB_ReservationContext context = new DB_ReservationContext())
{
DateTime requestStart = solicitude.StartTime;
DateTime requestEnd = solicitude.EndTime;
Country country = solicitude.Country;
IQueryable <Reserve> list;
if (country == 0)
{
list = context.reservationList.Where(r => r.Start_Time >= requestStart && r.Start_Time <= requestEnd);
}
else
{
list = context.reservationList.Where(r => r.Start_Time >= requestStart && r.Start_Time <= requestEnd && r.made_in == country);
}
return(list.ToArray());
}
}
