Esempio n. 1
0
        internal virtual void btnSubmit_Click(object sender, EventArgs e)
        {
            if (IsValidData())
            {
                Address address = new Address();

                customer = new Customer();
                customer.FirstName = txtFirstName.Text;
                customer.LastName = txtLastName.Text;
                customer.Email = txtEmail.Text;
                customer.Password = txtPassword.Text;
                customer.DateOfBirth = dateDOB.Value;
                customer.Type = (Customer.Types)Enum.Parse(typeof(Customer.Types), comboType.SelectedItem.ToString());

                if(chkResponsibleParty.Checked)
                {
                    customer.PersonType = Person.PersonTypes.ResponsibleParty;
                    address.Street = txtStreet.Text;
                    address.City = txtCity.Text;
                    address.State = txtState.Text;
                    address.Zip = Int32.Parse(txtZip.Text);
                }
                else
                {
                    address = responsibleParty.Address;
                    customer.PersonType = Person.PersonTypes.Customer;
                    customer.ResponsiblePartyID = responsibleParty.CustomerID;
                }
                customer.SetAddress(address);
                this.Close();
            }
        }
Esempio n. 2
0
        public static Customer GetCustomerFromReader(SqlCeDataReader reader)
        {
            if (reader != null)
            {
                Customer customer = new Customer();
                customer.CustomerID = (long)reader["CustomerID"];
                if (!reader.IsDBNull(reader.GetOrdinal("ResponsiblePartyID")))
                {
                    customer.ResponsiblePartyID = (long)reader["ResponsiblePartyID"];

                }
                Customer.Types type;
                Enum.TryParse<Customer.Types>(reader["Type"].ToString(), out type);
                customer.Type = type;
                customer.PersonID = (long)reader["PersonID"];
                customer.FirstName = reader["FirstName"].ToString();
                customer.LastName = reader["LastName"].ToString();
                customer.DateOfBirth = DateTime.Parse(reader["DateOfBirth"].ToString());
                Person.PersonTypes personType;
                Enum.TryParse<Person.PersonTypes>(reader["PersonType"].ToString(), out personType);
                customer.PersonType = personType;
                customer.Email = reader["Email"].ToString();
                customer.Password = reader["Password"].ToString();
                customer.SetAddress(AddressDB.GetAddressFromReader(reader));

                return customer;
            }
            return null;
        }
Esempio n. 3
0
 public static long? AddCustomer(Customer customer)
 {
     if(customer.PersonType == Person.PersonTypes.ResponsibleParty)
     {
         customer.Address.AddressID = AddressDB.AddAddress(customer.Address);
     }
     customer.PersonID =  PersonDB.AddPerson(customer);
     string _query = string.Format("INSERT INTO Customer (PersonID, ResponsiblePartyID, Type) " +
         "VALUES({0}, {1}, '{2}')", customer.PersonID, customer.ResponsiblePartyID == null? 0 : customer.ResponsiblePartyID,
         customer.PersonType);
     return CaseStudyDB.ExecuteNonQuery(_query);
 }
Esempio n. 4
0
 public frmModifyCustomer(Customer customer)
 {
     if(customer != null)
     {
         _customerToModify = customer;
     }
     else
     {
         this.Close();
     }
     InitializeComponent();
     FillFormData();
 }
Esempio n. 5
0
        public static void DeleteCustomer(Customer customer)
        {
            if(customer.PersonType == Person.PersonTypes.ResponsibleParty)
            {
                AddressDB.DeleteAddress(customer.Address.AddressID);
            }

            TransactionDB.DeleteTransactionsByCustomer((long)customer.CustomerID);
            PersonDB.DeletePerson(customer.PersonID);

            string _query = string.Format("DELETE FROM Customer WHERE CustomerID = {0}", customer.CustomerID);
            CaseStudyDB.ExecuteNonQuery(_query);
        }
Esempio n. 6
0
 private void lstCustomers_SelectedIndexChanged(object sender, EventArgs e)
 {
     if(lstCustomers.SelectedIndex != -1)
     {
         if (lstProducts.SelectedIndex != -1)
         {
             numQuantity.Enabled = true;
         }
         _customer = _customers[lstCustomers.SelectedIndex];
     }
 }
Esempio n. 7
0
 public void AddDependent(Customer dependent)
 {
     if (this.PersonType == PersonTypes.ResponsibleParty && dependent.PersonType == PersonTypes.Customer)
     {
         if (_dependents == null)
         {
             _dependents = new List<Customer>();
         }
         _dependents.Add(dependent);
         dependent.ResponsibleParty = this;
         CustomerDB.ModifyCustomer(this);
     }
 }
Esempio n. 8
0
 public void RemoveDependent(Customer dependent)
 {
     if(_dependents != null)
     {
         _dependents.Remove(dependent);
         CustomerDB.ModifyCustomer(this);
     }
 }
Esempio n. 9
0
 internal virtual void comboResponsibleParty_IndexChanged(object sender, EventArgs e)
 {
     if (!chkResponsibleParty.Checked)
     {
         responsibleParty = (Customer)comboResponsibleParty.SelectedItem;
         if (responsibleParty != null)
         {
             FillAddressWithResponsibleParty();
         }
     }
 }
Esempio n. 10
0
        public static void ModifyCustomer(Customer customer)
        {
            if(customer.PersonType == Person.PersonTypes.ResponsibleParty)
            {
                AddressDB.UpdateAddress(customer.Address);
            }
            PersonDB.UpdatePerson(customer);

            string _query = string.Format("UPDATE Customer " +
                "SET ResponsiblePartyID={0}, Type='{1}' WHERE CustomerID = {2}",
                customer.ResponsiblePartyID == null ? 0 : customer.ResponsiblePartyID,
                customer.PersonType, customer.CustomerID);

            CaseStudyDB.ExecuteNonQuery(_query);
        }