public static void RegisterNewCarRent(ReservationsDTO reservationsDTO)
{
var db = new RentCDataBaseEntities();
var reservation = ConvertToEntity(reservationsDTO);
db.Reservations.Add(reservation);
db.SaveChanges();
}
public static void RegisterNewCustomer(DTO.CustomersDTO newCustomer)
{
var db = new RentCDataBaseEntities();
var customer = ConvertToEntities(newCustomer);
db.Customers.Add(customer);
db.SaveChanges();
}
public static void CreateNewStatus(DTO.ReservationStatusesDTO status)
{
var db = new RentCDataBaseEntities();
var newStatus = ConvertToEntity(status);
db.ReservationStatuses.Add(newStatus);
db.SaveChanges();
}
public static List <DTO.CarsDTO> ListCars()
{
var db = new RentCDataBaseEntities();
var cars = db.Cars.ToList();
var carsDTO = ConvertToDTO(cars);
return(carsDTO);
}
public static List <DTO.ReservationStatusesDTO> ListStatuses()
{
var db = new RentCDataBaseEntities();
var statues = db.ReservationStatuses.ToList();
var statutesDTO = ConvertToDTO(statues);
return(statutesDTO);
}
public static DTO.ReservationStatusesDTO RetrieveStatus()
{
var db = new RentCDataBaseEntities();
var status = db.ReservationStatuses.Max(p => p.ReservStatsID);
var statusDto = new DTO.ReservationStatusesDTO();
statusDto.ReservStatsID = status;
return(statusDto);
}
public static void UpdateCustomer(DTO.CustomersDTO updateCustomersDto)
{
var db = new RentCDataBaseEntities();
var updateCustomer = ConvertToEntities(updateCustomersDto);
var customer = db.Customers.Where(p => p.CostumerID == updateCustomer.CostumerID).FirstOrDefault <Customers>();
customer.Name = updateCustomer.Name;
customer.BirthDate = updateCustomer.BirthDate;
customer.Location = updateCustomer.Location;
db.SaveChanges();
}
public static void UpdateStatus(DTO.ReservationStatusesDTO status)
{
var db = new RentCDataBaseEntities();
var update = ConvertToEntity(status);
var newStatus = db.ReservationStatuses.Where(p => p.ReservStatsID == update.ReservStatsID).FirstOrDefault();
//newStatus.ReservStatsID = update.ReservStatsID;
newStatus.Name = update.Name;
newStatus.Description = update.Description;
db.SaveChanges();
}
//public static void UpdateCarRent(DTO.ReservationsDTO update)
//{
// var db = new RentCDataBaseEntities();
// var updateReservation = ConvertToEntity(update);
// var reservation = db.Reservations.Where(p => p.CarID == updateReservation.CarID
// && p.CostumerID == updateReservation.CostumerID).FirstOrDefault<Reservations>();
// //reservation.ReservationID = updateReservation.ReservationID;
// reservation.CarID = updateReservation.CarID;
// reservation.CostumerID = updateReservation.CostumerID;
// reservation.ReservStatsID = updateReservation.ReservStatsID;
// reservation.StartDate = updateReservation.StartDate;
// reservation.EndDate = updateReservation.EndDate;
// reservation.Location = updateReservation.Location;
// db.SaveChanges();
//}
public static List <DTO.ReservationsDTO> ListReservations()
{
var db = new RentCDataBaseEntities();
var reservations = db.Reservations.ToList();
var cars = Persistence.CarsRepository.ListCars();
var statuses = RentC.Persistence.ReservationStatutesRepository.ListStatuses();
var canceledReservations = statuses.FindAll(x => x.Name == "CANCELED").ToList();
var result = reservations.Where(p => !canceledReservations.Any(x => x.ReservStatsID == p.ReservStatsID)).ToList();
var reservationDTO = ConvertToDTO(result);
return(reservationDTO);
}
public static DTO.CarsDTO FindCarIdByPlate(string plate)
{
var db = new RentCDataBaseEntities();
var car = db.Cars.Where(p => p.Plate == plate).FirstOrDefault();
if (car == null)
{
return(null);
}
else
{
var carDTO = new DTO.CarsDTO();
carDTO.Plate = car.Plate;
carDTO.CarID = car.CarID;
return(carDTO);
}
}