in Source/Website/Data_Layer/CustomerData.cs [105:164]
public static void AddCustomer(Customer customer)
{
var query = @"INSERT INTO CUSTOMERS
(Email
,AccountCode
,FirstName
,LastName
,FirstAddress
,City
,Country
,ZipCode
,Website
,Active
,Enrrolled
,PhoneNumber
,MobileNumber
,FaxNumber)
VALUES
(@Email
,@AccountCode
,@FirstName
,@LastName
,@FirstAddress
,@City
,@Country
,@ZipCode
,@Website
,@Active
,@Enrrolled
,@PhoneNumber
,@MobileNumber
,@FaxNumber)";
var parameters = new SqlParameter[]
{
new SqlParameter("@Email", customer.Email),
new SqlParameter("@AccountCode", customer.AccountCode),
new SqlParameter("@FirstName", customer.FirstName),
new SqlParameter("@LastName", customer.LastName),
new SqlParameter("@FirstAddress", customer.FirstAddress),
new SqlParameter("@City", customer.City),
new SqlParameter("@Country", customer.Country),
new SqlParameter("@ZipCode", customer.ZipCode),
new SqlParameter("@Website", customer.Website),
new SqlParameter("@Active", (bool) customer.Active),
new SqlParameter("@Enrrolled", (int) customer.Enrrolled),
new SqlParameter("@PhoneNumber", customer.PhoneNumber),
new SqlParameter("@MobileNumber", customer.MobileNumber),
new SqlParameter("@FaxNumber", customer.FaxNumber)
};
try
{
DataAccessHandler.ExecuteNonSelect(query, parameters);
}
catch (Exception e)
{
throw e;
}
}