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(); } }
public static Address GetAddressFromReader(SqlCeDataReader reader) { Address address = new Address(); address.AddressID = (long)reader["AddressID"]; address.Street = reader["Street"].ToString(); address.City = reader["City"].ToString(); address.State = reader["State"].ToString(); address.Zip = (int)reader["Zip"]; return address; }
public static long? AddAddress(Address address) { string _query = string.Format("INSERT INTO Address(Street, City, State, Zip) " + "VALUES('{0}', '{1}', '{2}', {3})", address.Street, address.City, address.State, address.Zip); try { return (CaseStudyDB.ExecuteNonQuery(_query)); } catch (Exception ex) { MessageBox.Show(string.Format("Error Adding Address {0}", ex.Message)); return null; } }
internal static void UpdateAddress(Address address) { string _query = string.Format("UPDATE Address " + "SET Street='{0}', City='{1}', State='{2}', Zip={3} " + "WHERE AddressID = {4}", address.Street, address.City, address.State, address.Zip, address.AddressID); try { CaseStudyDB.ExecuteNonQuery(_query); } catch (Exception ex) { MessageBox.Show(string.Format("Error Adding Address {0}", ex.Message)); } }
public void SetAddress(Address address) { _address = address; }
public static List<Customer> GetCustomers() { List<Customer> customers = new List<Customer>(); XmlTextReader reader = new XmlTextReader(path); while (reader.Read()) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(reader); XmlNodeList xmlCustomers = xmlDoc.GetElementsByTagName("customer"); for (int i = 0; i < xmlCustomers.Count; i++) { long? customerID = null; long? personID = null; Customer.Types customerType = Customer.Types.Unknown; Customer.PersonTypes personType = Person.PersonTypes.Customer; string firstName = ""; string lastName = ""; DateTime? dob = null; long? addressID = null; string street = ""; string city = ""; string state = ""; int? zip = null; foreach (XmlAttribute attribute in xmlCustomers[i].Attributes) { switch (attribute.Name) { case "id": customerID = long.Parse(attribute.Value); break; case "personID": personID = long.Parse(attribute.Value); break; case "customerType": customerType = (Customer.Types)Enum.Parse(typeof(Customer.Types), attribute.Value); break; case "personType": personType = (Person.PersonTypes)Enum.Parse(typeof(Person.PersonTypes), attribute.Value); break; default: break; } } foreach(XmlNode node in xmlCustomers[i].ChildNodes) { switch (node.Name) { case "name": foreach(XmlNode childNode in node.ChildNodes) { if (childNode.Name == "firstname") { firstName = childNode.InnerText; } else { lastName = childNode.InnerText; } } break; case "dob": dob = DateTime.Parse(node.InnerText); break; case "address": XmlAttribute attribute = node.Attributes[0]; addressID = long.Parse(attribute.Value); foreach (XmlNode childNode in node.ChildNodes) { switch (childNode.Name) { case "street": street = childNode.InnerText; break; case "city": city = childNode.InnerText; break; case "state": state = childNode.InnerText; break; case "zipcode": zip = int.Parse(childNode.InnerText); break; default: break; } } break; default: break; } } Address address = new Address(addressID, street, city, state, zip); //Customer customer = new Customer(customerID, customerType, personID, firstName, lastName, dob, personType); //customer.SetAddress(address); //customers.Add(customer); } } reader.Close(); return customers; }