Beispiel #1
0
        private void OkButton_Click(object sender, EventArgs e)
        {
            DateTime timestamp = DateTime.Now;

            if (Countries.SearchBy(c => c.Name == CountryField.Text))
            {
                Country country = Countries.GetCountryBy(c => c.Name == CountryField.Text);
                if (Cities.SearchBy(c => c.Name == CityField.Text && c.Country.ID == country.ID))
                {
                    City city = Cities.GetCityBy(c => c.Name == CityField.Text && c.Country.ID == country.ID);;
                    if (Addresses.SearchBy(a => a.Address1 == Address1Field.Text && a.Address2 == Address2Field.Text && a.PostalCode == PostalCodeField.Text && a.Phone == PhoneField.Text && a.City.ID == city.ID))
                    {
                        _customer.Address = Addresses.GetAddressBy(a => a.Address1 == Address1Field.Text && a.Address2 == Address2Field.Text && a.PostalCode == PostalCodeField.Text && a.Phone == PhoneField.Text && a.City.ID == city.ID);
                    }
                    else
                    {
                        Address address = BuildAddress(timestamp);
                        address.City         = city;
                        address.City.Country = country;

                        Addresses.Insert(address);

                        _customer.Address = address;
                    }
                    _customer.CityName    = city.Name;
                    _customer.CountryName = country.Name;
                }
                else
                {
                    Address address = BuildAddress(timestamp);
                    address.City         = BuildCity(timestamp);
                    address.City.Country = country;

                    Cities.Insert(address.City);
                    Addresses.Insert(address);

                    _customer.Address  = address;
                    _customer.CityName = address.City.Name;
                }
                _customer.CountryName = country.Name;
            }
            else
            {
                Address address = BuildAddress(timestamp);
                address.City         = BuildCity(timestamp);
                address.City.Country = BuildCountry(timestamp);

                Countries.Insert(address.City.Country);
                Cities.Insert(address.City);
                Addresses.Insert(address);

                _customer.Address     = address;
                _customer.CityName    = address.City.Name;
                _customer.CountryName = address.City.Country.Name;
            }

            if (_isUpdate)
            {
                _customer.Name            = CustomerNameField.Text;
                _customer.Active          = ActiveBox.Checked;
                _customer.UpdateTimestamp = timestamp;
                _customer.UpdateBy        = Users.CurrentUser;

                Customers.Update(_customer);
            }
            else
            {
                Customer newCustomer = new Customer(Countries.GetNextID());
                newCustomer.Name            = CustomerNameField.Text;
                newCustomer.Address         = _customer.Address;
                newCustomer.Active          = ActiveBox.Checked;
                newCustomer.CreateDate      = timestamp;
                newCustomer.CreateBy        = Users.CurrentUser;
                newCustomer.UpdateTimestamp = timestamp;
                newCustomer.UpdateBy        = Users.CurrentUser;

                Customers.Insert(newCustomer);

                newCustomer.CityName    = _customer.Address.City.Name;
                newCustomer.CountryName = _customer.Address.City.Country.Name;
            }
            Close();
        }
Beispiel #2
0
        //  Load all information from the data base
        private void LoadData()
        {
            //  Get country information from the database.
            DataTable countryTable = Database.GetDataTable(new MySqlCommand("SELECT * FROM country;"));

            foreach (DataRow field in countryTable.Rows)
            {
                Country country = new Country(Convert.ToInt32(field[0]));
                country.Name            = Convert.ToString(field[1]);
                country.CreateDate      = Convert.ToDateTime(field[2]).ToLocalTime();
                country.CreateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[3]));
                country.UpdateTimestamp = Convert.ToDateTime(field[4]).ToLocalTime();
                country.UpdateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[5]));
                Countries.AllCountriesList.Add(country);
            }

            //  Get city information from the database.
            DataTable cityTable = Database.GetDataTable(new MySqlCommand("SELECT * FROM city;"));

            foreach (DataRow field in cityTable.Rows)
            {
                City city = new City(Convert.ToInt32(field[0]));
                city.Name            = Convert.ToString(field[1]);
                city.Country         = Countries.GetCountryBy(c => c.ID == Convert.ToInt32(field[2]));
                city.CreateDate      = Convert.ToDateTime(field[3]).ToLocalTime();
                city.CreateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[4]));
                city.UpdateTimestamp = Convert.ToDateTime(field[5]).ToLocalTime();
                city.UpdateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[6]));
                Cities.AllCitiesList.Add(city);
            }

            //  Get address information from the database.
            DataTable addressTable = Database.GetDataTable(new MySqlCommand("SELECT * FROM address;"));

            foreach (DataRow field in addressTable.Rows)
            {
                Address address = new Address(Convert.ToInt32(field[0]));
                address.Address1        = Convert.ToString(field[1]);
                address.Address2        = Convert.ToString(field[2]);
                address.City            = Cities.GetCityBy(c => c.ID == Convert.ToInt32(field[3]));
                address.PostalCode      = Convert.ToString(field[4]);
                address.Phone           = Convert.ToString(field[5]);
                address.CreateDate      = Convert.ToDateTime(field[6]).ToLocalTime();
                address.CreateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[7]));
                address.UpdateTimestamp = Convert.ToDateTime(field[8]).ToLocalTime();
                address.UpdateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[9]));
                Addresses.AllAddressList.Add(address);
            }

            //  Get customer information from the database.
            //  NOTE:   Whomever set up the database, has made it so that records
            //          deleted from the customer table do not delete thier rows. So as
            //          a result, the customer table will return rows that are empty.
            //          To protect against this, we will need to include a check in the
            //          SQL command.
            DataTable CustomersTable = Database.GetDataTable(new MySqlCommand(("SELECT * FROM customer WHERE customerName IS NOT NULL;")));

            foreach (DataRow field in CustomersTable.Rows)
            {
                Customer customer = new Customer(Convert.ToInt32(field[0]));
                customer.Name            = Convert.ToString(field[1]);
                customer.Address         = Addresses.GetAddressBy(a => a.ID == Convert.ToInt32(field[2]));
                customer.CityName        = customer.Address.City.Name;
                customer.CountryName     = customer.Address.City.Country.Name;
                customer.Active          = Convert.ToBoolean(field[3]);
                customer.CreateDate      = Convert.ToDateTime(field[4]).ToLocalTime();
                customer.CreateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[5]));
                customer.UpdateTimestamp = Convert.ToDateTime(field[6]).ToLocalTime();
                customer.UpdateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[7]));
                Customers.AllCustomersList.Add(customer);
            }

            //  Get appointment information from the appointment table.
            DataTable AppointmentsTable = Database.GetDataTable(new MySqlCommand("SELECT * FROM appointment;"));

            foreach (DataRow field in AppointmentsTable.Rows)
            {
                Appointment appointment = new Appointment(Convert.ToInt32(field[0]));
                int         foo         = Convert.ToInt32(field[1]);
                appointment.Customer        = Customers.GetCustomerBy(c => c.ID == Convert.ToInt32(field[1]));
                appointment.User            = Users.GetUserBy(u => u.ID == Convert.ToInt32(field[2]));
                appointment.Title           = Convert.ToString(field[3]);
                appointment.Description     = Convert.ToString(field[4]);
                appointment.Location        = Convert.ToString(field[5]);
                appointment.Contact         = appointment.Customer.Address.Phone;
                appointment.Type            = Convert.ToString(field[7]);
                appointment.URL             = Convert.ToString(field[8]);
                appointment.StartDate       = Convert.ToDateTime(field[9]).ToLocalTime();
                appointment.EndDate         = Convert.ToDateTime(field[10]).ToLocalTime();
                appointment.CreateDate      = Convert.ToDateTime(field[11]).ToLocalTime();
                appointment.CreateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[12]));
                appointment.UpdateTimestamp = Convert.ToDateTime(field[13]).ToLocalTime();
                appointment.UpdateBy        = Users.GetUserBy(u => u.Name == Convert.ToString(field[14]));
                Appointments.AllAppointmentsList.Add(appointment);
            }
        }