public string addBooking(TableTypes.Booking booking) { string log = ""; BookingManipulation.bookingInstance = booking; log += AddBookingToSqlTables(booking); return(log); }
private string constructQuery(object queryObject) { TableTypes.Booking booking = (TableTypes.Booking)queryObject; string a = "insert into Booking (Customer_id ,Hotel_id,Room_id,Booking_Date,Checkin_Date,No_Of_Nights) " + "values(" + bookingInstance.Customer_id + "," + bookingInstance.Hotel_id + "," + bookingInstance.Room_id + ", '1998-03-13' , '1998-03-13' , " + bookingInstance.No_of_Nights + ");"; Console.Write(a); return(a); }