/// <summary>
/// Removes a reservation. Asks for approval.
/// </summary>
/// <param name="reservation"></param>
private void Remove(Data.Reservation reservation)
{
if (MessageBoxResult.Yes == MessageBox.Show(Properties.Resources.ConfirmationRemoveReservation, Properties.Resources.ConfirmationRemoveReservationCaption, MessageBoxButton.YesNo, MessageBoxImage.Exclamation, MessageBoxResult.No))
{
Reservations.Remove(reservation);
_reservationRepo.DeleteReservation(reservation);
MessageHandler.InvokeSuccessMessage(Properties.Resources.InformationRemoveReservation, Properties.Resources.InformationReservationRemoved);
}
}
public void DeleteReservation(Data.Reservation reservation)
{
if (!_context.Reservations.Local.Any(i => i.ID == reservation.ID))
{
_context.Reservations.Attach(reservation);
}
_context.Reservations.Remove(reservation);
_context.SaveChanges();
}
public Data.Reservation UpdateReservation(Data.Reservation reservation)
{
if (!_context.Reservations.Local.Any(res => res.ID == reservation.ID))
{
_context.Reservations.Attach(reservation);
}
_context.Entry(reservation).State = EntityState.Modified;
_context.SaveChanges();
return(reservation);
}
public static ReservationGetDto FromModel(Data.Reservation reservation)
{
return(new ReservationGetDto
{
Reference = reservation.Reference,
EventDate = reservation.EventDate,
VenueCode = reservation.VenueCode,
WhenMade = reservation.WhenMade,
StaffId = reservation.StaffId
});
}
public static ReservationGetDto FromModel(Data.Reservation reservation)
{
return(new ReservationGetDto
{
Reference = reservation.Reference,
EventDate = reservation.EventDate,
VenueCode = reservation.VenueCode,
VenueName = reservation.Availability.Venue.Name,
VenueCapacity = reservation.Availability.Venue.Capacity,
VenueCostPerHour = reservation.Availability.CostPerHour,
WhenMade = reservation.WhenMade,
StaffId = reservation.StaffId
});
}
/// <summary>
/// Adds or Edit a new reservation
/// </summary>
private void Save()
{
try
{
Data.Reservation reservation;
if (!IsNewReservation)
{
reservation = _reservationRepo.GetReservationById(ManipulatedReservation.ID);
}
else
{
reservation = new Data.Reservation();
}
reservation.Table = _tableRepo.GetTableById(SelectedTable.Id);
reservation.AmountPeople = ManipulatedReservation.AmountPeople;
reservation.LastName = ManipulatedReservation.LastName;
reservation.PhoneNumber = ManipulatedReservation.PhoneNumber;
reservation.StartTime = ManipulatedReservation.StartTime;
if (IsNewReservation)
{
Reservations.Add(reservation);
_reservationRepo.AddReservation(reservation);
Cancel();
MessageHandler.InvokeSuccessMessage(Properties.Resources.Reservations, Properties.Resources.InfoReservationAdded);
}
else
{
Reservations.Add(reservation);
_reservationRepo.UpdateReservation(reservation);
Cancel();
MessageHandler.InvokeSuccessMessage(Properties.Resources.Reservations, Properties.Resources.InfoReservationAdded);
}
}
catch (ArgumentException e)
{
ErrorHandler.ThrowError(0, e.Message);
}
catch (Exception e)
{
ErrorHandler.ThrowError(0, e.Message);
}
}
public void SetReservation(Data.Reservation reservation)
{
try
{
ManipulatedReservation = new Business.Reservation()
{
ID = reservation.ID, LastName = reservation.LastName, AmountPeople = reservation.AmountPeople, PhoneNumber = reservation.PhoneNumber, StartTime = reservation.StartTime, Table = new Business.Table()
{
Id = reservation.Table.Id, Capacity = reservation.Table.Capacity, IsOccupied = reservation.Table.IsOccupied, Name = reservation.Table.Name
}
};
SelectedTable = reservation.Table;
}
catch (Exception ex)
{
ErrorHandler.ThrowError(0, ex.Message);
}
}
public bool bilpay(Data.Reservation dr)
{
bool stat = false;
koneksi kon = new koneksi();
try
{
kon.openConnection();
string query = "update tb_reservation set pembayaran='" + dr.Pembayaran + "',kembalian=@kembalian-'" + dr.Pembayaran + "', keterangan='" + dr.Keterangan + "' where no_reservation='" + dr.No_reservasi + "' ";
kon.ExecuteQueries(query);
stat = true;
kon.closeConnection();
}
catch (Exception ex)
{
}
return(stat);
}
public bool deletereservation(Data.Reservation dre)
{
bool stat = false;
koneksi kon = new koneksi();
try
{
kon.openConnection();
string query = "delete from tb_reservation where no_reservation='" + dre.No_reservasi + "'";
kon.ExecuteQueries(query);
stat = true;
kon.closeConnection();
}
catch (Exception ex)
{
}
return(stat);
}
public bool editreservation(Data.Reservation drv)
{
bool stat = false;
koneksi kon = new koneksi();
try
{
kon.openConnection();
string query = "update tb_reservation set client_id='" + drv.Client_id + "',room_type='" + drv.Room_type + "',room_price='" + drv.Room_price + "', no_room='" + drv.No_room + "',booking_date='" + drv.Booking_date + "', date_in='" + drv.Date_in + "',date_out='" + drv.Date_out + "', cara_bayar='" + drv.Carabayar + "' where no_reservation='" + drv.No_reservasi + "'";
kon.ExecuteQueries(query);
stat = true;
kon.closeConnection();
}
catch (Exception ex)
{
}
return(stat);
}
public bool reservationclient(Data.Reservation drv)
{
bool stat = false;
koneksi kon = new koneksi();
try
{
kon.openConnection();
string query = "insert into tb_reservation values('" + drv.No_reservasi + "', '" + drv.Client_id + "', '" + drv.Room_type + "', '" + drv.Room_price + "', '" + drv.No_room + "', '" + drv.Booking_date + "', '" + drv.Date_in + "', '" + drv.Date_out + "', null, null, '" + drv.Room_price + "' * '" + drv.No_room + "','" + drv.Carabayar + "', null, null, 'Belum Lunas')";
kon.ExecuteQueries(query);
stat = true;
kon.closeConnection();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(stat);
}
public bool searchreservid(Data.Reservation dr)
{
bool stat = false;
koneksi kon = new koneksi();
try
{
kon.openConnection();
string query = "select * from tb_reservation where no_reservation='" + dr.No_reservasi + "'";
//kon.ExecuteQueries("select * from tb_reservation where no_reservation='" + dr.No_reservasi + "'");
kon.ExecuteQueries(query);
stat = true;
kon.closeConnection();
}
catch (Exception ex)
{
}
return(stat);
}
/// <summary>
/// Requests the editing of a reservation. This will open the ReservationAddEditViewModel
/// </summary>
/// <param name="reservation"><inheritdoc cref="SelectedReservation"/></param>
private void Edit(Data.Reservation reservation)
{
EditRequested?.Invoke(reservation);
}
public Data.Reservation GetReservationById(int id)
{
Data.Reservation reservation = _context.Reservations.FirstOrDefault(x => x.ID == id);
return(reservation);
}
public Data.Reservation AddReservation(Data.Reservation reservation)
{
_context.Reservations.Add(reservation);
_context.SaveChanges();
return(reservation);
}
private void _reservationsViewModel_EditRequested(Data.Reservation reservation)
{
_reservationAddEditViewModel.IsNewReservation = false;
_reservationAddEditViewModel.SetReservation(reservation);
CurrentViewModel = _reservationAddEditViewModel;
}
