public static int AddCompany(Company company) { int companyID = -1; // Setup Connection using (DatabaseConnection db = new DatabaseConnection("dbo.AddCompany")) { // Set Parameters AddParameters(company, db.comm); // Open Connection db.conn.Open(); // Execute Command and Read Response companyID = Convert.ToInt32(db.comm.ExecuteScalar()); } return companyID; }
private static void AddParameters(Company company, SqlCommand comm) { comm.Parameters.AddWithValue("BillingAddressCity", company.CompanyBillingAddressCity); comm.Parameters.AddWithValue("BillingAddressCountry", company.CompanyBillingAddressCountry); comm.Parameters.AddWithValue("BillingAddressLine1", company.CompanyBillingAddressLine1); comm.Parameters.AddWithValue("BillingAddressLine2", company.CompanyBillingAddressLine2 == null ? (object)DBNull.Value : company.CompanyBillingAddressLine2); // Check for null comm.Parameters.AddWithValue("BillingAddressPostalCode", company.CompanyBillingAddressPostalCode); comm.Parameters.AddWithValue("BillingAddressRegion", company.CompanyBillingAddressRegion); comm.Parameters.AddWithValue("BillingName", company.CompanyBillingName); }
public static int UpdateCompany(Company company, Company oldCompany) { int rowsAffected = 0; // Setup Connection using (DatabaseConnection db = new DatabaseConnection("dbo.UpdateCompany")) { // Set Parameters AddParameters(company, db.comm); AddOldParameters(oldCompany, db.comm); // Open Connection db.conn.Open(); // Execute Command and Read Response rowsAffected = db.comm.ExecuteNonQuery(); } return rowsAffected; }
public static Company ReadCompany(SqlDataReader reader) { Company company = new Company(); company.CompanyID = (int)reader["CompanyID"]; company.CompanyBillingAddressCity = (string)reader["CompanyBillingAddressCity"]; company.CompanyBillingAddressCountry = (string)reader["CompanyBillingAddressCountry"]; company.CompanyBillingAddressPostalCode = (string)reader["CompanyBillingAddressPostalCode"]; company.CompanyBillingAddressLine1 = (string)reader["CompanyBillingAddressLine1"]; company.CompanyBillingAddressLine2 = reader["CompanyBillingAddressLine2"] as string; // Allow null company.CompanyBillingAddressRegion = (string)reader["CompanyBillingAddressRegion"]; company.CompanyBillingName = (string)reader["CompanyBillingName"]; return company; }
public Invoice() { company = new Company(); }
public Client() { company = new Company(); }