public static int AddStatus(Status status)
{
int statusID = -1;
// Setup Connection
using (DatabaseConnection db = new DatabaseConnection("dbo.AddStatus"))
{
// Set Parameters
AddParameters(status, db.comm);
// Open Connection
db.conn.Open();
// Execute Command and Read Response
statusID = Convert.ToInt32(db.comm.ExecuteScalar());
}
return statusID;
}
public ClientSession()
{
client = new Client();
session = new Session();
status = new Status();
}
public static Status ReadStatus(SqlDataReader reader)
{
Status status = new Status();
status.StatusID = (int)reader["StatusID"];
status.StatusName = (string)reader["StatusName"];
return status;
}
private static void AddParameters(Status status, SqlCommand comm)
{
comm.Parameters.AddWithValue("StatusName", status.StatusName);
}
public static int RemoveStatus(Status oldStatus)
{
int rowsAffected = 0;
// Setup Connection
using (DatabaseConnection db = new DatabaseConnection("dbo.RemoveStatus"))
{
// Set Parameters
AddOldParameters(oldStatus, db.comm);
// Open Connection
db.conn.Open();
// Execute Command and Read Response
rowsAffected = db.comm.ExecuteNonQuery();
}
return rowsAffected;
}
