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