Example #1
0
        public void UpdateCustomer(CustomerDataObjects customer)
        {
            List <CustomerDataObjects> CustomerList = new List <CustomerDataObjects>();

            try
            {
                conn.Open();
                using (SqlCommand comm = new SqlCommand("SPCustAddUpdate", conn))
                {
                    comm.CommandType = CommandType.StoredProcedure;
                    comm.Parameters.AddWithValue("@Customer_ID", customer.Customer_ID);
                    comm.Parameters.AddWithValue("@FirstName", customer.FirstName);
                    comm.Parameters.AddWithValue("@LastName", customer.LastName);
                    comm.Parameters.AddWithValue("@Address", customer.Address);
                    comm.Parameters.AddWithValue("@Customer_Type", customer.Customer_Type);
                    comm.ExecuteNonQuery();
                }
            }
            catch (Exception ec)
            {
                MessageBox.Show(ec.Message);
            }
            finally
            {
                conn.Close();
            }
        }
Example #2
0
        //Return all customers
        public List <CustomerDataObjects> GetCustomers()
        {
            List <CustomerDataObjects> CustomerList = new List <CustomerDataObjects>();

            // string st = "Select Customer_ID,FirstName,LastName,Address,Customer_Type from Customer";
            try
            {
                conn.Open();
                using (SqlCommand comm = new SqlCommand("SPCustSelect", conn))
                {
                    comm.CommandType = CommandType.StoredProcedure;
                    using (SqlDataReader reader = comm.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            var Customer = new CustomerDataObjects();
                            Customer.Customer_ID   = (int)reader["Customer_ID"];
                            Customer.FirstName     = reader["FirstName"].ToString();
                            Customer.LastName      = reader["LastName"].ToString();
                            Customer.Address       = reader["Address"].ToString();
                            Customer.Customer_Type = reader["Customer_Type"].ToString();
                            CustomerList.Add(Customer);
                        }
                    }
                }
            }
            catch (Exception ec)
            {
                MessageBox.Show(ec.Message);
            }
            finally
            {
                conn.Close();
            }
            return(CustomerList);
        }