public static void AddCustomer()

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