public static Contractor Create(int id)
{
Contractor contractor = null;
using (IDataReader reader = DBContractor.Get(id))
{
if(reader.Read())
{
contractor = new Contractor(id);
contractor.Name = reader["Name"].ToString();
contractor.Phone = reader["Phone"].ToString();
contractor.Movile = reader["Movile"].ToString();
contractor.StatusCode = reader["Status"].ToString();
}
}
if (contractor == null)
return Contractor.Empty;
using (IDataReader reader = DBContractor.GetAllSpecialties(id))
{
while (reader.Read())
{
contractor.Specialties.Add(reader["SpecialtyId"].ToString());
}
}
using (IDataReader reader = DBContractor.GetBankAccounts(id))
{
while (reader.Read())
{
ContractorBankAccount bankAccount = new ContractorBankAccount(Convert.ToInt32(reader["ContractorAccountId"]));
bankAccount.AccountNumber = reader["Account"].ToString();
bankAccount.Bank = reader["Bank"].ToString();
contractor.BankAccounts.Add(bankAccount);
}
}
return contractor;
}
public static ContractorBankAccount Create(int contractorId, int contractorBankAccountId)
{
ContractorBankAccount bankAccount = new ContractorBankAccount(contractorId);
using (IDataReader reader = DBContractor.GetBankAccount(contractorId, contractorBankAccountId))
{
if (reader.Read())
{
bankAccount.Bank = (string)reader["Bank"];
bankAccount.AccountNumber = (string)reader["Account"];
}
}
return bankAccount;
}
private void Save()
{
Contractor contractor = new Contractor(_contractorId);
ContractorBankAccount bankAccount = null;
contractor.Name = this.txtName.Text;
contractor.Phone = this.txtPhone.Text;
contractor.Movile = this.txtMovile.Text;
contractor.StatusCode = this.ddlStatus.SelectedValue;
foreach (ListItem item in this.lstSpecialties.Items)
{
if (item.Selected)
{
contractor.Specialties.Add(item.Value);
}
}
bankAccount = new ContractorBankAccount(BankAccountId1);
bankAccount.Bank = txtBank1.Text;
bankAccount.AccountNumber = txtBankAccount1.Text;
contractor.BankAccounts.Add(bankAccount);
bankAccount = new ContractorBankAccount(BankAccountId2);
bankAccount.Bank = txtBank2.Text;
bankAccount.AccountNumber = txtBankAccount2.Text;
contractor.BankAccounts.Add(bankAccount);
bankAccount = new ContractorBankAccount(BankAccountId3);
bankAccount.Bank = txtBank3.Text;
bankAccount.AccountNumber = txtBankAccount3.Text;
contractor.BankAccounts.Add(bankAccount);
contractor.Save();
}