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