//delete selected room from database
public void deleteRoom()
{
using (var context = new MotelEntities())
{
//select the row you want to delete
var contact = (from s in context.Rooms
where s.RoomID == RoomID
select s).SingleOrDefault();
//run remove command
context.Rooms.Remove(contact);
//save the changes
context.SaveChanges();
}
}
//update the booking in the database
public void updateBooking()
{
using (var context = new MotelEntities())
{
var query = from s in context.Bookings
where s.BookingID == BookingID
select s;
var room = query.FirstOrDefault();
room.BookingFrom = BookingFrom;
room.BookingTo = BookingTo;
context.SaveChanges();
}
}
//add booking to the database
public void addBooking()
{
using (var context = new MotelEntities())
{
var BookingZ = new Booking();
//assign fields from database to variables
BookingZ.RoomIDFK = GuestID;
BookingZ.BookingFrom = BookingFrom;
BookingZ.BookingTo = BookingTo;
BookingZ.RoomCost = 100 + (numSingleBeds * 20) + (numDoubleBeds * 40);
//Add to entity set of context
context.Bookings.Add(BookingZ);
context.SaveChanges();
}
}
public IEnumerable viewBillings()
{
//Extract all fields from databases and assign to correct names
using (var context = new MotelEntities())
{
var alldata = from g in context.Billings where g.GuestIDFK == GuestID
select new
{
g.BillingID,
g.GuestIDFK,
g.BarCharge,
g.WiFiCharge,
g.TelephoneCharge,
g.RoomCharge,
};
return(alldata.ToList());
}
}
//add room from form in database
public void addRooms()
{
using (var context = new MotelEntities())
{
var Roomz = new Room();
Roomz.NumSingleBeds = NumSingleBeds;
Roomz.NumDoubleBeds = NumDoubleBeds;
Roomz.ExtraFeatures = ExtraFeatures;
Roomz.TariffSinglePerson = TariffSinglePerson;
Roomz.Tariff2People = Tariff2People;
Roomz.TariffExtraPerson = TariffExtraPerson;
//Add to entity set of context
context.Rooms.Add(Roomz);
context.SaveChanges();
}
}
//Update rooms in database from from
public void updateRooms()
{
using (var context = new MotelEntities())
{
var query = from s in context.Rooms
where s.RoomID == RoomID
select s;
var room = query.FirstOrDefault();
room.NumSingleBeds = NumSingleBeds;
room.NumDoubleBeds = NumDoubleBeds;
room.ExtraFeatures = ExtraFeatures;
room.TariffSinglePerson = 15;
room.Tariff2People = 25;
room.TariffExtraPerson = 5;
context.SaveChanges();
}
}
//Add billing to database
public void addBilling()
{
using (var context = new MotelEntities())
{
//assign variables to fields from database
var BillingZ = new Billing();
BillingZ.GuestIDFK = GuestID;
BillingZ.BarCharge = BarCharge;
BillingZ.WiFiCharge = WiFiCharge;
BillingZ.TelephoneCharge = TelephoneCharge;
BillingZ.RoomCharge = RoomCost;
//Add to entity set of context
context.Billings.Add(BillingZ);
context.SaveChanges();
}
}
public IEnumerable viewBookings()
{
//Our standard Using statement passing all the data to context
using (var context = new MotelEntities())
{
//What ever we want our code to do we do it in here
//Pass our fields across to a variable
var alldata = from g in context.Bookings where g.RoomIDFK == GuestID
select new
{
g.BookingID,
g.RoomIDFK,
g.BookingFrom,
g.BookingTo,
g.RoomCost
};
return(alldata.ToList());
}
}
public IEnumerable viewRooms()
{
//Our standard Using statement passing all the data to context
using (var context = new MotelEntities())
{
//Whatever we want our code to do we do it in here
//Pass our fields across to a variable
var alldata = from g in context.Rooms
select new
{
g.NumSingleBeds,
g.NumDoubleBeds,
g.ExtraFeatures,
g.TariffSinglePerson,
g.Tariff2People,
g.TariffExtraPerson,
g.RoomID
};
return(alldata.ToList());
}
}
public IEnumerable viewGuests()
{
//Our standard Using statement passing all the data to context
using (var context = new MotelEntities())
{
//Extract all fields from databases and assign to correct names
var alldata = from g in context.Guests where g.BookingIDFK == BookingID
select new
{
g.GuestID,
g.BookingIDFK,
g.Name,
g.Address,
g.NumberOfGuests,
g.RoomBooked,
g.CheckIn,
g.CheckOut,
g.BookingDate
};
return(alldata.ToList());
}
}
//Update currently existing guest in database
public void updateGuest()
{
//assign variables to fields from database
using (var context = new MotelEntities())
{
var query = from s in context.Guests
where s.GuestID == GuestID
select s;
var guest = query.FirstOrDefault();
guest.Name = Name;
guest.Address = Address;
guest.NumberOfGuests = NumberOfGuests;
guest.RoomBooked = RoomBooked;
guest.Address = Address;
guest.CheckIn = CheckIn;
guest.CheckOut = CheckOut;
guest.BookingDate = BookingDate;
context.SaveChanges();
}
}
//Add Guest to database
public void addGuest()
{
using (var context = new MotelEntities())
{
//assign variables to fields from database
var GuestZ = new Guest();
GuestZ.BookingIDFK = BookingIDFK;
GuestZ.Name = Name;
GuestZ.Address = Address;
GuestZ.NumberOfGuests = NumberOfGuests;
GuestZ.RoomBooked = RoomBooked;
GuestZ.CheckIn = CheckIn;
GuestZ.CheckOut = CheckOut;
GuestZ.BookingDate = BookingDate;
//Add to entity set of context
context.Guests.Add(GuestZ);
context.SaveChanges();
}
}
