public static int InsertGuest(GuestCS sr)
{
int new_id = 0;
//declare return variable
//connection object -> ConfigurationManager namespace
//access to web.config -> connection strings & key values
SqlConnection cn = new SqlConnection(
ConfigurationManager.ConnectionStrings["SE256_CorwinConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("guests_insert", cn);
// Mark the Command -> Stored Procedure
cmd.CommandType = CommandType.StoredProcedure;
// Add Parameters -> Stored Procedure
cmd.Parameters.Add(
"@new_id", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(
"@guest_email", SqlDbType.VarChar).Value = sr.Guest_Email;
cmd.Parameters.Add(
"@guest_first", SqlDbType.VarChar).Value = sr.Guest_First;
cmd.Parameters.Add(
"@guest_last", SqlDbType.VarChar).Value = sr.Guest_Last;
cmd.Parameters.Add(
"@guest_salt", SqlDbType.VarChar).Value = sr.Guest_Salt;
cmd.Parameters.Add(
"@guest_pwd", SqlDbType.VarChar).Value = sr.Guest_Pwd;
cmd.Parameters.Add(
"@guest_phone", SqlDbType.VarChar).Value = sr.Guest_Phone;
// Open database connection -> execute command
try
{
cn.Open();
//execute -> stored procedure
cmd.ExecuteNonQuery();
new_id = Convert.ToInt32(cmd.Parameters["@new_id"].Value);
}
catch (Exception exc)
{
//error -> notify user
exc.ToString();
}
finally
{
cn.Close();
}
return(new_id);
}
public static bool UpdateGuest(GuestCS sr)
{
//declare return variable
bool blnSuccess = false;
//connection object -> ConfigurationManager namespace
//access web.config setting -> connection strings & key values
SqlConnection cn = new SqlConnection(
ConfigurationManager.ConnectionStrings["SE256_CorwinConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("guests_update", cn);
// Mark the Command -> Stored Procedure
cmd.CommandType = CommandType.StoredProcedure;
// Add Parameters -> Stored Procedure
cmd.Parameters.Add(
"@guest_id", SqlDbType.Int).Value = sr.Guest_ID;
cmd.Parameters.Add(
"@guest_email", SqlDbType.VarChar).Value = sr.Guest_Email;
cmd.Parameters.Add(
"@guest_first", SqlDbType.VarChar).Value = sr.Guest_First;
cmd.Parameters.Add(
"@guest_last", SqlDbType.VarChar).Value = sr.Guest_Last;
cmd.Parameters.Add(
"@guest_salt", SqlDbType.VarChar).Value = sr.Guest_Salt;
cmd.Parameters.Add(
"@guest_pwd", SqlDbType.VarChar).Value = sr.Guest_Pwd;
cmd.Parameters.Add(
"@guest_phone", SqlDbType.VarChar).Value = sr.Guest_Phone;
// Open database connection -> execute command
try
{
cn.Open();
cmd.ExecuteNonQuery();
blnSuccess = true;
}
catch (Exception exc)
{
//error -> notify user
exc.ToString();
blnSuccess = false;
}
finally
{
cn.Close();
}
return(blnSuccess);
}
