private static Customer CreateCustomerFromRow(DataRow row)
{
string firstName;
if (row.IsNull("first_name"))
{
return(null);
}
firstName = row["first_name"].ToString();
string lastName;
if (row.IsNull("last_name"))
{
return(null);
}
lastName = row["last_name"].ToString();
string suite = "";
if (!row.IsNull("suite_number"))
{
suite = row["suite_number"].ToString();
}
string street = "";
if (!row.IsNull("street_number"))
{
street = row["street_number"].ToString();
}
string house = "";
if (!row.IsNull("house_number"))
{
house = row["house_number"].ToString();
}
string city = "";
if (!row.IsNull("city"))
{
city = row["city"].ToString();
}
string province = "";
if (!row.IsNull("province"))
{
province = row["province"].ToString();
}
string postalCode = "";
if (!row.IsNull("postalcode"))
{
postalCode = row["postalcode"].ToString();
}
string email = "";
if (!row.IsNull("email"))
{
email = row["email"].ToString();
}
string phone = "";
if (!row.IsNull("phone_number"))
{
phone = row["phone_number"].ToString();
}
DateTime creationDate;
if (row.IsNull("creation_date"))
{
return(null);
}
creationDate = (DateTime)row["creation_date"];
string creditCard = "";
if (!row.IsNull("credit_card"))
{
creditCard = row["credit_card"].ToString();
}
Customer.AccountType account = Customer.AccountType.Limited;
switch (row["account_type"].ToString())
{
case "Disabled":
account = Customer.AccountType.Disabled;
break;
case "Limited":
account = Customer.AccountType.Limited;
break;
case "Bronze":
account = Customer.AccountType.Bronze;
break;
case "Silver":
account = Customer.AccountType.Silver;
break;
case "Gold":
account = Customer.AccountType.Gold;
break;
default:
return(null);
}
UserName name = new UserName(firstName, lastName);
Address address = new Address(suite, street, house, city, province, postalCode);
ContactInformation newContact = new ContactInformation(email, phone);
Credentials credentials = new Credentials(row["username"].ToString(), row["passhash"].ToString());
Customer customer = new Customer(name, address, newContact, account)
{
CreationDate = creationDate,
CreditCard = creditCard,
Id = (int)row["cid"],
Rating = (int)row["rating"],
Credentials = credentials,
};
return(customer);
}
private static Employee CreateEmployeeFromRow(DataRow row)
{
string firstName;
if (row.IsNull("first_name"))
{
return(null);
}
firstName = row["first_name"].ToString();
string lastName;
if (row.IsNull("last_name"))
{
return(null);
}
lastName = row["last_name"].ToString();
string suite = "";
if (!row.IsNull("suite_number"))
{
suite = row["suite_number"].ToString();
}
string street = "";
if (!row.IsNull("street_number"))
{
street = row["street_number"].ToString();
}
string house = "";
if (!row.IsNull("house_number"))
{
house = row["house_number"].ToString();
}
string city = "";
if (!row.IsNull("city"))
{
city = row["city"].ToString();
}
string province = "";
if (!row.IsNull("province"))
{
province = row["province"].ToString();
}
string postalCode = "";
if (!row.IsNull("postalcode"))
{
postalCode = row["postalcode"].ToString();
}
string phone = "";
if (!row.IsNull("phone_number"))
{
phone = row["phone_number"].ToString();
}
Employee.Position position;
if (row.IsNull("position"))
{
return(null);
}
position = Employee.Position.Employee;
if (row["position"].ToString() == "manager")
{
position = Employee.Position.Manager;
}
float wage;
if (row.IsNull("wage"))
{
return(null);
}
wage = float.Parse(row["wage"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
DateTime startDate;
if (row.IsNull("start"))
{
return(null);
}
startDate = (DateTime)row["start"];
string sin = "";
if (row.IsNull("social_insurance_num"))
{
sin = row["social_insurance_num"].ToString();
}
UserName name = new UserName(firstName, lastName);
Address address = new Address(suite, street, house, city, province, postalCode);
ContactInformation contactInfo = new ContactInformation("", phone);
Credentials credentials = new Credentials(row["username"].ToString(), row["passhash"].ToString());
Employee employee = new Employee(name, address, contactInfo, wage, startDate, sin, position)
{
Id = (int)row["eid"],
Credentials = credentials
};
return(employee);
}
