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