public void UpdateBooking(Booking B)
{
using (var db = new HotelCaliforniaEntities())
{
db.Bookings.AddOrUpdate(B);
db.SaveChanges();
}
}
public void BookARoom(Booking B)
{
using (var db = new HotelCaliforniaEntities())
{
db.Bookings.Add(B);
db.SaveChanges();
}
}
public void AddCustomer(Customer C)
{
using (var Data = new HotelCaliforniaEntities())
{
Data.Customers.Add(C);
Data.SaveChanges();
}
}
public void DeleteCustomer(Customer C)
{
using (var db = new HotelCaliforniaEntities())
{
var Item = db.Customers.SingleOrDefault(x => x.CustomerID == C.CustomerID);
db.Customers.Remove(Item);
db.SaveChanges();
}
}
public void DeleteBooking(Booking B)
{
using (var db = new HotelCaliforniaEntities())
{
var Item = db.Bookings.SingleOrDefault(x => x.BookingID == B.BookingID);
db.Bookings.Remove(Item);
var Invoice = db.Invoices.SingleOrDefault(x => x.BookingID == B.BookingID);
if (Invoice == null)
{
db.SaveChanges();
}
else
{
db.Invoices.Remove(Invoice);
db.SaveChanges();
}
}
}
public void ChangeCustomer(Customer C)
{
using (var Data = new HotelCaliforniaEntities())
{
var Item = Data.Customers.First(a => a.CustomerID == C.CustomerID);
Item.FirstName = C.FirstName;
Item.LastName = C.LastName;
Item.PersonID = C.PersonID;
Data.SaveChanges();
}
}
public void CreateInvoice(Booking B)
{
var Get = new GetData();
Room R = Get.GetRoom(int.Parse(B.RoomID.ToString()));
decimal Price = decimal.Parse(((B.DateEnd - B.DateStart).TotalDays * R.Price).ToString());
var I = new Invoice();
I.BookingID = B.BookingID;
I.Complete = 0;
I.BookedDate = DateTime.Now;
I.TotalPrice = Price;
using (var db = new HotelCaliforniaEntities())
{
db.Invoices.Add(I);
db.SaveChanges();
}
}
