public static void UpdateCustomer()

in Source/Website/Data_Layer/CustomerData.cs [166:212]


        public static void UpdateCustomer(Customer customer)
        {
            var query = @"UPDATE CUSTOMERS
                            SET Email = @Email
                            ,AccountCode = @AccountCode
                            ,FirstName = @FirstName
                            ,LastName = @LastName
                            ,FirstAddress = @FirstAddress
                            ,City = @City
                            ,Country = @Country
                            ,ZipCode = @ZipCode
                            ,Website = @Website
                            ,Active = @Active
                            ,Enrrolled = @Enrrolled
                            ,PhoneNumber = @PhoneNumber
                            ,MobileNumber = @MobileNumber
                            ,FaxNumber = @FaxNumber
                        WHERE CustomerId = @CustomerId";

            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),
                new SqlParameter("@CustomerId", customer.CustomerId)
            };

            try
            {
                DataAccessHandler.ExecuteNonSelect(query, parameters);
            }
            catch (Exception e)
            {
                throw e;
            }
        }