Ejemplo n.º 1
0
        public MakeCustomer(MainScreen mainForm, int custId)
            : this(mainForm)
        {
            try
            {
                this.cust = dbcontext.customers
                            .Where(c => c.customerId == custId)
                            .FirstOrDefault();
            }
            catch (NullReferenceException)
            {
                MessageBox.Show("An appointment to modify could not be loaded");
                this.Hide();
            }

            using (var ctx = new DataLayer.ScheduleEntities())
            {
                var addressJoin = (from a in dbcontext.addresses
                                   join c in dbcontext.cities
                                   on a.cityId equals c.cityId
                                   join cn in dbcontext.countries
                                   on c.countryId equals cn.countryId
                                   where a.addressId == cust.addressId
                                   //orderby appt.start
                                   select new
                {
                    a.addressId,
                    a.address1,
                    a.address2,
                    a.phone,
                    postCode = a.postalCode,
                    cityIndex = c.cityId,
                    countryIndex = cn.countryId
                }).ToList().First();
                //`customerId`, `customerName`, `addressId`, `active`, `createDate`, `createdBy`, `lastUpdate`, `lastUpdateBy`
                textBoxName.Text              = cust.customerName;
                textBoxAddress1.Text          = addressJoin.address1;
                textBoxAddress2.Text          = addressJoin.address2;
                textBoxPostCode.Text          = addressJoin.postCode;
                comboBoxCity.SelectedIndex    = addressJoin.cityIndex - 1;
                comboBoxCountry.SelectedIndex = addressJoin.countryIndex - 1;
                textBoxPhone.Text             = addressJoin.phone;
                addr.addressId         = addressJoin.addressId;
                checkBoxActive.Checked = cust.active;
            }
        }
Ejemplo n.º 2
0
 public MakeAppointment(MainScreen mainForm)
 {
     InitializeComponent();
     this.mainForm = mainForm;
 }