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