private string EnterIntoCustomerTable(UserTypes.Customer newCustomer) { string query = "insert into customers (Customer_Id ,First_name, Last_name, Addrs, Phone_no, Email,Pass)" + "values (" + newCustomer.Custome_Id + ",'" + newCustomer.First_Name + "', '" + newCustomer.Last_name + "' , '" + newCustomer.Addr + "'" + " ," + newCustomer.Phone_Num + ",'" + newCustomer.Email + "','" + newCustomer.Pass + "' );"; return(runInsertNewSignUpQuery(query)); }
public void enterReservationIntoBookingTable(UserTypes.Customer customer, int roomNumber, TableTypes.Hotel hotel, TableTypes.Payment payment, DateManagement reserveDates) { string query = "insert into Booking (Customer_Id , Room_Id , Hotel_Id , Payment_Id , Booking_Date , Checkin_Date , No_Of_Nights)" + "VALUEs (" + customer.Custome_Id + "," + roomNumber + "," + hotel.Hotel_Id + "," + payment.PaymentID + "," + "'" + reserveDates.enteranceDate + "'" + "," + "'" + reserveDates.enteranceDate + "'" + "," + reserveDates.ReservationDuration + ")"; runHotelQuery(query); //dummy value }
public string CreateAccount(UserTypes.Customer newCustomer) { string log = ""; if (checkForDuplicate(newCustomer)) { log += EnterIntoCustomerTable(newCustomer); } else { return("customer already exists"); } return("customer " + newCustomer.First_Name + "has an account now."); }
private bool checkForDuplicate(UserTypes.Customer newCustomer) { string qurey = "Select * From Customers where email = '" + newCustomer.Email + "'"; return(runCheckDuplicateQuery(qurey)); }