public List <ReservationBE> ListReservation() { try { HotelEntities hotel = new HotelEntities(); //var data = hotel.Reservation.ToList(); var data = (from r in hotel.Reservation join c in hotel.Customer on r.CustomerId equals c.id join u in hotel.Room on r.RoomId equals u.id join h in hotel.Hotel on r.HotelId equals h.id orderby r.id descending select new ReservationBE { Id = r.id, CustomerId = r.CustomerId, CustomerName = c.Name + " " + c.SurName, HotelId = r.HotelId, HotelName = h.Name, RoomId = u.id, RoomName = u.TypeRoom, AdmissionDate = r.AdmissionDate, DepartureDate = r.DepartureDate, }).ToList(); return(data); } catch (Exception e) { throw new Exception("Error en ListReservation: " + e.Message); } }
public Confirm Update(Room room) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); var query = (from r in hotel.Room where r.id == room.id select r).FirstOrDefault(); query.NumberRoom = room.NumberRoom; query.Price = room.Price; query.TypeRoom = room.TypeRoom; hotel.SaveChanges(); confirm.Status = "OK"; confirm.Clase = "UpdateRoom"; } catch (Exception e) { confirm.Status = e.Message; confirm.Clase = "UpdateRoom"; //throw new Exception(e.Message); } return(confirm); }
public Confirm CreateReservation(ReservationBE reservationBE) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); Reservation reservation = new Reservation(); reservation.AdmissionDate = reservationBE.AdmissionDate; reservation.DepartureDate = reservationBE.DepartureDate; reservation.CustomerId = reservationBE.CustomerId; reservation.RoomId = reservationBE.RoomId; reservation.HotelId = reservationBE.HotelId; hotel.Reservation.Add(reservation); hotel.SaveChanges(); SendMessage sendMessage = new SendMessage(); sendMessage.Send(reservationBE); confirm.Clase = "CreateReservation"; confirm.Status = "OK"; } catch (Exception e) { confirm.Clase = "CreateReservation"; confirm.Status = e.Message; //throw new Exception(e.Message); } return(confirm); }
public Confirm DeleteReservation(int reservationId) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); var remove = (from r in hotel.Reservation where r.id == reservationId select r).First(); if (remove != null) { hotel.Reservation.Remove(remove); hotel.SaveChanges(); } confirm.Clase = "DeleteReservation"; confirm.Status = "OK"; } catch (Exception e) { confirm.Clase = "DeleteReservation"; confirm.Status = e.Message; //throw new Exception(e.Message); } return(confirm); }
public Confirm UpdateReservation(ReservationBE reservationBE, int reservationId) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); var query = (from r in hotel.Reservation where r.id == reservationId select r).FirstOrDefault(); query.CustomerId = reservationBE.CustomerId; query.HotelId = reservationBE.HotelId; query.RoomId = reservationBE.RoomId; query.AdmissionDate = reservationBE.AdmissionDate; query.DepartureDate = reservationBE.DepartureDate; hotel.SaveChanges(); confirm.Clase = "UpdateReservation"; confirm.Status = "OK"; } catch (Exception e) { confirm.Clase = "UpdateReservation"; confirm.Status = e.Message; throw new Exception(e.Message); } return(confirm); }
public Confirm UpdateCustomer(Customer customer) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); Customer custome = new Customer(); var query = (from c in hotel.Customer where c.id == customer.id select c).FirstOrDefault(); query.Name = customer.Name; query.SurName = customer.SurName; query.DocumentType = customer.DocumentType; query.DocumentNumber = customer.DocumentNumber; query.Phone = customer.Phone; hotel.SaveChanges(); confirm.Clase = "UpdateCustomer"; confirm.Status = "OK"; } catch (Exception e) { confirm.Clase = "UpdateCustomer"; confirm.Status = e.Message; //throw new Exception(e.Message); } return(confirm); }
public Confirm CreateCustomer(CustomerBE customerBE) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); Customer customer = new Customer(); customer.Name = customerBE.Name; customer.SurName = customerBE.SurName; customer.DocumentType = customerBE.DocumentType; customer.DocumentNumber = customerBE.DocumentNumber; customer.Phone = customerBE.Phone; hotel.Customer.Add(customer); hotel.SaveChanges(); confirm.Clase = "CreateCustomer"; confirm.Status = "OK"; } catch (Exception e) { confirm.Clase = "CreateCustomer"; confirm.Status = e.Message; //throw new Exception(e.Message); } return(confirm); }
public List <Room> GetAll() { try { HotelEntities hotel = new HotelEntities(); var data = hotel.Room.ToList(); return(data); }catch (Exception e) { throw new Exception(e.Message); } }
public List <Hotel> ListHotel() { try { HotelEntities hotel = new HotelEntities(); var data = hotel.Hotel.ToList(); return(data); } catch (Exception e) { throw new Exception("Error en ListReservation: " + e.Message); } }
public List <Room> Find(string type) { try { HotelEntities hotel = new HotelEntities(); var data = (from r in hotel.Room where r.TypeRoom.Contains(type) select r).ToList(); return(data); }catch (Exception e) { throw new Exception(e.Message); } throw new NotImplementedException(); }
public void DeleteCustomer(int customerId) { try { HotelEntities hotel = new HotelEntities(); var remove = (from c in hotel.Customer where c.id == customerId select c).First(); if (remove != null) { hotel.Customer.Remove(remove); hotel.SaveChanges(); } } catch (Exception e) { throw new Exception(e.Message); } }
public List <Room> ListRoom(int HotelID, int CustomerID) { try { HotelEntities hotel = new HotelEntities(); var data = (from r in hotel.Room join e in hotel.Reservation on r.id equals e.RoomId where e.HotelId == HotelID && e.CustomerId == CustomerID select r).ToList(); var query = hotel.Room.ToList().Except(data).ToList(); return(query); } catch (Exception e) { throw new Exception(e.Message); } }
public Confirm Create(Room room) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); hotel.Room.Add(room); hotel.SaveChanges(); confirm.Status = "OK"; confirm.Clase = "CreateRoom"; } catch (Exception e) { confirm.Status = e.Message; confirm.Clase = "CreateRoom"; //throw new Exception(e.Message); } return(confirm); }
public Confirm Delete(int idRoom) { Confirm confirm = new Confirm(); try { HotelEntities hotel = new HotelEntities(); var query = (from r in hotel.Room where r.id == idRoom select r).FirstOrDefault(); hotel.Room.Remove(query); hotel.SaveChanges(); confirm.Status = "OK"; confirm.Clase = "DeleteRoom"; } catch (Exception e) { confirm.Status = e.Message; confirm.Clase = "DeleteRoom"; //throw new Exception(e.Message); } return(confirm); }
public List <CustomerBE> ListCustomer() { HotelEntities hotelEntities = new HotelEntities(); try { //var data = hotelEntities.Customer.ToList(); var data = (from c in hotelEntities.Customer select new CustomerBE { Id = c.id, Name = c.Name, SurName = c.SurName, DocumentType = c.DocumentType, DocumentNumber = c.DocumentNumber, Phone = c.Phone, FullName = c.Name + " " + c.SurName, }).ToList(); return(data); } catch (Exception e) { throw new Exception(e.Message); } }