public static int InsertReservation(ReservationsCS sr) { //declare return variable int new_id = 0; //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("reservations_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_id", SqlDbType.Int).Value = sr.Guest_Id; cmd.Parameters.Add( "@tbl_id", SqlDbType.Int).Value = sr.Table_Id; cmd.Parameters.Add( "@user_id", SqlDbType.Int).Value = sr.User_Id; cmd.Parameters.Add( "@res_date", SqlDbType.Date).Value = sr.Res_Date; cmd.Parameters.Add( "@res_time", SqlDbType.Time).Value = sr.Res_Time; cmd.Parameters.Add( "@res_guest_cnt", SqlDbType.Int).Value = sr.Res_Guest_Cnt; cmd.Parameters.Add( "@res_spec_req", SqlDbType.VarChar).Value = sr.Res_Sp_Req; // 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 UpdateReservation(ReservationsCS 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("reservations_update", cn); // Mark the Command -> Stored Procedure cmd.CommandType = CommandType.StoredProcedure; // Add Parameters -> Stored Procedure cmd.Parameters.Add( "@res_id", SqlDbType.Int).Value = sr.Res_Id; cmd.Parameters.Add( "@guest_id", SqlDbType.Int).Value = sr.Guest_Id; cmd.Parameters.Add( "@tbl_id", SqlDbType.Int).Value = sr.Table_Id; cmd.Parameters.Add( "@user_id", SqlDbType.Int).Value = sr.User_Id; cmd.Parameters.Add( "@res_date", SqlDbType.Date).Value = sr.Res_Date; cmd.Parameters.Add( "@res_time", SqlDbType.Time).Value = sr.Res_Time; cmd.Parameters.Add( "@res_guest_cnt", SqlDbType.Int).Value = sr.Res_Guest_Cnt; cmd.Parameters.Add( "@res_spec_req", SqlDbType.VarChar).Value = sr.Res_Sp_Req; // 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); }