public void checkOut(int ids)
{
DateTime currDatetime = DateTime.Now;
DataLayer.Entities.Booking currentBok = dc.GetTable <DataLayer.Entities.Booking>().Where(st => st.id.Equals(ids)).First();
currentBok.checkout = currDatetime;
dc.SubmitChanges();
}
private void deleterev_Click(object sender, RoutedEventArgs e)
{
DataLayer.Entities.Booking delid = new DataLayer.Entities.Booking();
delid = (DataLayer.Entities.Booking)BookingList.SelectedItem;
if (delid != null)
{
busstest.deleteBok(delid);
}
}
public customerUI(DataLayer.Entities.Booking custid)
{
InitializeComponent();
int customerid = int.Parse(custid.customerid.ToString());
var stuff = busstest.getUserWithId(customerid);
CustomerList.DataContext = stuff;
}
private void CheckouButton_Click(object sender, RoutedEventArgs e)
{
DataLayer.Entities.Booking currentBok = new DataLayer.Entities.Booking();
currentBok = (DataLayer.Entities.Booking)BookingList.SelectedItem;
if (currentBok != null)
{
int ids = currentBok.id;
busstest.checkOut(ids);
}
}
private void moreInfo_Click(object sender, RoutedEventArgs e)
{
DataLayer.Entities.Booking custid = new DataLayer.Entities.Booking();
custid = (DataLayer.Entities.Booking)BookingList.SelectedItem;
if (custid != null)
{
customerUI custUi = new customerUI(custid);
custUi.Show();
}
else
{
MessageBox.Show("Please Select Booking Data");
}
}
private void addResv_Click(object sender, RoutedEventArgs e)
{
DataLayer.Entities.ReservationApplication selectRes = (DataLayer.Entities.ReservationApplication)ReservationList.SelectedItem;
if (selectRes != null)
{
DataLayer.Entities.Booking bookings = new DataLayer.Entities.Booking();
DateTime defualttime = new DateTime(1970, 1, 1, 00, 00, 00);
bookings.customerid = selectRes.cusId;
bookings.arriveDate = selectRes.arriveDate;
bookings.leaveDate = selectRes.leaveDate;
bookings.roomid = selectRes.roomNo;
bookings.comment = selectRes.comment;
bookings.checkin = defualttime;
bookings.checkout = defualttime;
acess.addBooking(bookings);
acess.deleteResv(selectRes);
}
}
public void addBooking(DataLayer.Entities.Booking ent)
{
dc.GetTable <DataLayer.Entities.Booking>().InsertOnSubmit(ent);
dc.SubmitChanges();
}
public void deleteBok(DataLayer.Entities.Booking delBok)
{
dc.GetTable <DataLayer.Entities.Booking>().DeleteOnSubmit(delBok);
dc.SubmitChanges();
}
