//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(); } }