public ClientSession() { client = new Client(); session = new Session(); status = new Status(); }
private static void AddParameters(Client client, SqlCommand comm) { comm.Parameters.AddWithValue("CompanyID", client.CompanyID); comm.Parameters.AddWithValue("AddressCity", client.ClientAddressCity); comm.Parameters.AddWithValue("AddressCountry", client.ClientAddressCountry); comm.Parameters.AddWithValue("AddressLine1", client.ClientAddressLine1); comm.Parameters.AddWithValue("AddressLine2", client.ClientAddressLine2 == null ? (object)DBNull.Value : client.ClientAddressLine2); // Check for null comm.Parameters.AddWithValue("AddressPostalCode", client.ClientAddressPostalCode); comm.Parameters.AddWithValue("AddressRegion", client.ClientAddressRegion); comm.Parameters.AddWithValue("FaxPhone", client.ClientFaxPhone == null ? (object)DBNull.Value : client.ClientFaxPhone); // Check for null comm.Parameters.AddWithValue("FirstName", client.ClientFirstName); comm.Parameters.AddWithValue("HomePhone", client.ClientHomePhone); comm.Parameters.AddWithValue("LastName", client.ClientLastName); comm.Parameters.AddWithValue("WorkPhone", client.ClientWorkPhone); }
public static Client ReadClient(SqlDataReader reader) { Client client = new Client(); client.ClientID = (int)reader["ClientID"]; client.ClientAddressCity = (string)reader["ClientAddressCity"]; client.ClientAddressCountry = (string)reader["ClientAddressCountry"]; client.ClientAddressLine1 = (string)reader["ClientAddressLine1"]; client.ClientAddressLine2 = reader["ClientAddressLine2"] as string; // Allow null client.ClientAddressPostalCode = (string)reader["ClientAddressPostalCode"]; client.ClientAddressRegion = (string)reader["ClientAddressRegion"]; client.ClientFaxPhone = reader["ClientFaxPhone"] as string; // Allow null client.ClientFirstName = (string)reader["ClientFirstName"]; client.ClientHomePhone = (string)reader["ClientHomePhone"]; client.ClientLastName = (string)reader["ClientLastName"]; client.ClientWorkPhone = (string)reader["ClientWorkPhone"]; client.company = Company.ReadCompany(reader); return client; }
public static int UpdateClient(Client client, Client oldClient) { int rowsAffected = 0; // Setup Connection using (DatabaseConnection db = new DatabaseConnection("dbo.UpdateClient")) { // Set Parameters AddParameters(client, db.comm); AddOldParameters(oldClient, db.comm); // Open Connection db.conn.Open(); // Execute Command and Read Response rowsAffected = db.comm.ExecuteNonQuery(); } return rowsAffected; }
public static int AddClient(Client client) { int clientID = -1; // Setup Connection using (DatabaseConnection db = new DatabaseConnection("dbo.AddClient")) { // Set Parameters AddParameters(client, db.comm); // Open Connection db.conn.Open(); // Execute Command and Read Response clientID = Convert.ToInt32(db.comm.ExecuteScalar()); } return clientID; }