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