public static int CheckCustomer(GuestResponseModel responseModel) { // checks if customer exist. if true return the CustomerCode else return 0 int hasIt = 0; try { con.Close(); SqlCommand cmd = SelectIt(responseModel); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); bool i = reader.HasRows; if (i) { reader.Read(); hasIt = reader.GetInt32(4); Console.WriteLine(hasIt); } con.Close(); Console.WriteLine(i); } catch (Exception e) { ErrorViewModel x = new ErrorViewModel(); x.Message = e.Message; Console.WriteLine(e.Message); } return(hasIt); }
public ViewResult RsvpForm(GuestResponseModel guestResponse) { string c = guestResponse.RSVpType; if (c == ("none") | c == ("null")) { ViewBag.Error = "Please select your room type"; return(View()); } else { ViewBag.Greeting = "Good Evening, " + guestResponse.Name + "\n Your Reservation was completed We will call you to confirm. \nThank you"; int res = DbActions.CustomerRVSP(guestResponse); if (res > 0) { ViewData["Message"] = "Reservation Successfully"; } else { ViewData["Message"] = "Something Went Wrong"; } return(View("Index")); } //TODO: SubscribeUser(model.Email); // TODO: Email response to the party organizer }
public static int CustomerRVSP(GuestResponseModel responseModel) { int code = DbChecks.CheckCustomer(responseModel); if (code == 0) { //create new customer DateTime dateTime = DateTime.Now; int CustomerCode = DbChecks.CheckCode(); SqlConnection con = new SqlConnection(ConnectionString.ConnStr()); string query = "INSERT INTO Customers (Name, Email, PhoneNumber, CustomerCode, NumberOfRSVP, Date_Created)" + " values ('" + responseModel.Name + "','" + responseModel.Email + "','" + responseModel.Phone + "','" + CustomerCode + "','" + 0 + "','" + dateTime + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); AddRVSP(responseModel, CustomerCode); return(i); } else { return(AddRVSP(responseModel, code)); } }
public static SqlCommand SelectIt(GuestResponseModel responseModel) { string query = "select * from Customers where Name = '" + responseModel.Name + "' and Email = '" + responseModel.Email + "'"; SqlCommand cmd = new SqlCommand(query, con); return(cmd); }
public IActionResult RsvpForm(GuestResponseModel model) { if (ModelState.IsValid) { Repository.AddResponse(model); return(View("Thanks", model)); } else { return(View()); } }
public static int AddRVSP(GuestResponseModel responseModel, int CustomerCode) { //create new customer DateTime dateTime = DateTime.Now; long r = new DateTimeOffset(dateTime).ToUnixTimeMilliseconds(); string RsvpCode = "RSVP_" + r; SqlConnection con = new SqlConnection(ConnectionString.ConnStr()); string query = "INSERT INTO Reservarions (RoomType, RoomCount, Kids, ArriveDate, LeaveDate, CustomerCode, RsvpCode, Date_Created)" + " values ('" + responseModel.RSVpType + "','" + responseModel.Number + "','" + responseModel.NumberKids + "','" + responseModel.GetDateTimeIn + "','" + responseModel.GetDateTimeOut + "','" + CustomerCode + "','" + RsvpCode + "','" + dateTime + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); return(i); }
public static int UpdateRSVPCount(GuestResponseModel guestResponseModel, int CustomerCode) { //Updates the number of times a customer have done Reservation int RsvpCode = 0; try { con.Close(); SqlCommand cmd1 = SelectIt(guestResponseModel); con.Open(); SqlDataReader reader1 = cmd1.ExecuteReader(); bool i = reader1.HasRows; if (i) { RsvpCode = reader1.GetInt32(5); } con.Close(); RsvpCode++; string query = "UPDATE Customers SET NumberOfRSVP=" + RsvpCode + " where CustomerCode = '" + CustomerCode + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception e) { ErrorViewModel x = new ErrorViewModel(); x.Message = e.Message; Console.WriteLine(e.Message); } return(CustomerCode); }
public static void AddResponse(GuestResponseModel response) { responses.Add(response); }