//function that sets the form to the information of the selected primary key
private void BindData(int resID)
{
//if the class if doesn't equal -1, set the page up as an update
if (resID != -1)
{
//make the button say update
btnAddUpdate.Text = "Update";
//instantiate a new class of the form type, passing in the routeData primary key
se256_Dobachesky.Reservation aReservation = new se256_Dobachesky.Reservation(resID);
//get the guest id of this reservation then instantiate an instance of the guest class via overloaded constructor with it
int guest_id = aReservation.guest_id;
se256_Dobachesky.Guest aGuest = new se256_Dobachesky.Guest(guest_id);
//if the data exists, fill the form with it's information
if (aReservation != null)
{
txtEmail.Text = aGuest.guest_email.ToString();
txtFirstName.Text = aGuest.guest_first.ToString();
txtLastName.Text = aGuest.guest_last.ToString();
txtPhone.Text = aGuest.guest_phone.ToString();
ddlTables.SelectedValue = aReservation.tbl_id.ToString();
ddlUsers.SelectedValue = aReservation.user_id.ToString();
txtResDate.Text = aReservation.res_date;
txtResTime.Text = aReservation.res_time;
ddlGuestCount.SelectedValue = aReservation.res_guest_cnt.ToString();
txtSpecReq.Text = aReservation.res_spec_req;
}
}
//if the class does equal -1, set the form up as an add
else
{
btnAddUpdate.Text = "Add";
}
}
protected void btnAddUpdate_Click(object sender, EventArgs e)
{
//instantiate a new class for both reservations and guests
se256_Dobachesky.Reservation aReservation;
se256_Dobachesky.Guest aGuest;
//if the routedata information exists, finish the classes by passing in the primary key ids
if (RouteData.Values["resID"] != null)
{
aReservation = new se256_Dobachesky.Reservation(Convert.ToInt32(RouteData.Values["resID"].ToString()));
aGuest = new se256_Dobachesky.Guest(aReservation.guest_id);
}
//if the routedata information does not exist, finish the classes with a blank class
else
{
aReservation = new se256_Dobachesky.Reservation();
aGuest = new se256_Dobachesky.Guest();
}
//set the object's properties to be equal to the information on the form
aGuest.guest_email = txtEmail.Text.ToString();
aGuest.guest_first = txtFirstName.Text.ToString();
aGuest.guest_last = txtLastName.Text.ToString();
aGuest.guest_phone = txtPhone.Text.ToString();
aReservation.tbl_id = Convert.ToInt32(ddlTables.SelectedValue.Trim());
aReservation.user_id = Convert.ToInt32(ddlUsers.SelectedValue.Trim().ToString());
aReservation.res_date = String.Format("{0:MM/dd/yyyy}", Convert.ToDateTime(txtResDate.Text.Trim()));
aReservation.res_time = String.Format("{0:HH:mm:ss}", Convert.ToDateTime(txtResTime.Text.Trim()));
aReservation.res_guest_cnt = Convert.ToInt32(ddlGuestCount.SelectedValue.Trim());
aReservation.res_spec_req = txtSpecReq.Text.Trim();
//if the primary key exists go forward with the update
if (aReservation.res_id > 0)
{
//run the update method, and if it fails display an error message in a label
if (se256_Dobachesky.Reservation.UpdateReservation(aReservation) && se256_Dobachesky.Guest.UpdateGuest(aGuest))
{
Response.Redirect("/Admin/Res-Management");
}
else
{
lblMessage.Text = "Reservation update failed!";
}
}
//if the primary key does not exist it is because the record does not exist yet, go forward with the add
else
{
//run the insert method, and if it fails display an error message in a label
if (se256_Dobachesky.Reservation.InsertReservation(aReservation) && se256_Dobachesky.Guest.InsertGuest(aGuest))
{
Response.Redirect("/Admin/Res-Management");
}
else
{
lblMessage.Text = "Reservation insert failed!";
}
}
}
public static bool UpdateReservation(se256_Dobachesky.Reservation aReservation)
{
//start out with the boolean value at false
bool blnSuccess = false;
//create sql connection object that gets connection string from web.config
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SE256_CS"].ConnectionString);
//create sql command as stored procedure
SqlCommand cmd = new SqlCommand("reservations_update", conn);
//set the command as a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
//add the parameters to be used in the update method
cmd.Parameters.Add("@res_id", SqlDbType.Int).Value = aReservation.res_id;
cmd.Parameters.Add("@guest_id", SqlDbType.Int).Value = aReservation.guest_id;
cmd.Parameters.Add("@tbl_id", SqlDbType.Int).Value = aReservation.tbl_id;
cmd.Parameters.Add("@user_id", SqlDbType.Int).Value = aReservation.user_id;
cmd.Parameters.Add("@res_date", SqlDbType.DateTime).Value = aReservation.res_date;
cmd.Parameters.Add("@res_time", SqlDbType.Time).Value = aReservation.res_time;
cmd.Parameters.Add("@res_guest_cnt", SqlDbType.Int).Value = aReservation.res_guest_cnt;
cmd.Parameters.Add("@res_spec_req", SqlDbType.VarChar).Value = aReservation.res_spec_req;
//try to open the connection and run the command, then set the boolean value to true
try
{
conn.Open();
cmd.ExecuteNonQuery();
blnSuccess = true;
}
//prepare the error as a string and set boolean value to false
catch (Exception e)
{
e.ToString();
blnSuccess = false;
}
//close the connection
finally
{
conn.Close();
}
//return the boolean containing information as to of if the operation was a success or not
return(blnSuccess);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
//pass the datetime, email, and guest count to the CheckReservation method of the Reservation Class
string checkReservation = se256_Dobachesky.Reservation.CheckReservation(txtResDate.Text.Trim().ToString(), txtResTime.Text.Trim().ToString(), Convert.ToInt32(ddlGuestCount.SelectedValue.Trim().ToString()));
//set checkReservation to 0 if the method did not return anything
if (checkReservation == "")
{
checkReservation = "0";
}
//go forward if the checkReservation method returned an available table
if (Convert.ToInt32(checkReservation.ToString()) > 0)
{
//instantiate a new class for both reservations and guests
se256_Dobachesky.Reservation aReservation = new se256_Dobachesky.Reservation();
se256_Dobachesky.Guest aGuest = new se256_Dobachesky.Guest(txtEmail.Text.ToString());
//set the object's properties to be equal to the information on the form
aGuest.guest_email = txtEmail.Text.Trim().ToString();
aGuest.guest_first = txtFirstName.Text.Trim().ToString();
aGuest.guest_last = txtLastName.Text.Trim().ToString();
aGuest.guest_phone = txtPhone.Text.Trim().ToString();
aReservation.tbl_id = Convert.ToInt32(checkReservation.ToString());
aReservation.user_id = Convert.ToInt32(ddlUsers.SelectedValue.Trim().ToString());
aReservation.res_date = String.Format("{0:MM/dd/yyyy}", Convert.ToDateTime(txtResDate.Text.Trim()));
aReservation.res_time = String.Format("{0:HH:mm:ss}", Convert.ToDateTime(txtResTime.Text.Trim()));
aReservation.res_guest_cnt = Convert.ToInt32(ddlGuestCount.SelectedValue.Trim());
aReservation.res_spec_req = txtSpecReq.Text.Trim();
//if the primary key exists go forward with the update
if (aGuest.guest_id > 0)
{
//run the update method, and if it fails display an error message in a label
if (se256_Dobachesky.Guest.UpdateGuest(aGuest))
{
aReservation.guest_id = Convert.ToInt32(aGuest.guest_id);
lblMessage.Text = "";
}
else
{
lblMessage.Text = "Error updating guest!";
}
}
//if the primary key does not exist it is because the record does not exist yet, go forward with the add
else
{
//run the insert method, and if it fails display an error message in a label
if (se256_Dobachesky.Guest.InsertGuest(aGuest))
{
se256_Dobachesky.Guest aGuest2 = new se256_Dobachesky.Guest(txtEmail.Text.ToString());
aReservation.guest_id = Convert.ToInt32(aGuest2.guest_id);
lblMessage.Text = "";
}
else
{
lblMessage.Text = "Error adding guest!";
}
}
//run the update method, and if it fails display an error message in a label
if (se256_Dobachesky.Reservation.InsertReservation(aReservation))
{
lblMessage.Text = "";
Response.Redirect("/Reservations");
}
else
{
lblMessage.Text = "Error adding reservation!";
}
}
else
{
lblMessage.Text = "All qualified tables are filled for this time slot!";
}
}