Exemple #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            this.loadClient();

            if (clientComboBox.Items.Count > 0)
            {
                this.employeeTableAdapter = new SeniorCitizensDataSetTableAdapters.EmployeeTableAdapter();
                this.employeeTableAdapter.ClearBeforeFill = true;
                this.employeeDataTable = new SeniorCitizensDataSet.EmployeeDataTable();

                this.employeeTableAdapter.Fill(employeeDataTable);
                this.currentEmployeePosition = 0;
                this.currentEmployeeRow      =
                    (SeniorCitizensDataSet.EmployeeRow)employeeDataTable.Rows[currentEmployeePosition];

                this.serviceTableAdapter = new SeniorCitizensDataSetTableAdapters.ServiceTableAdapter();
                this.serviceTableAdapter.ClearBeforeFill = true;
                this.serviceDataTable = new SeniorCitizensDataSet.ServiceDataTable();

                this.serviceTableAdapter.Fill(serviceDataTable);
                this.currentServicePosition = 0;
                this.currentServiceRow      =
                    (SeniorCitizensDataSet.ServiceRow)serviceDataTable.Rows[currentServicePosition];

                this.loadEmployee();
                this.loadServices();
                this.setNavButtonEnabledToFalse();
            }
        }
Exemple #2
0
        private void loadServices()
        {
            SeniorCitizensDataSetTableAdapters.ServiceTableAdapter serviceTableAdapter =
                new SeniorCitizensDataSetTableAdapters.ServiceTableAdapter();
            serviceTableAdapter.ClearBeforeFill = true;

            SeniorCitizensDataSet.ServiceDataTable serviceDataTable =
                new SeniorCitizensDataSet.ServiceDataTable();

            try
            {
                serviceTableAdapter.Fill(serviceDataTable);
                servicesComboBox.DataSource    = serviceDataTable;
                servicesComboBox.ValueMember   = "ServiceID";
                servicesComboBox.DisplayMember = "ServiceID";
            }
            catch (System.NullReferenceException ex)
            {
                //ignore
            }
            catch (SqlException ex)
            {
                MessageBox.Show("Error: " +
                                "\nMessage: " + ex.Message,
                                "loadServices() " + ex.GetType().ToString());
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " +
                                "\nMessage: " + ex.Message,
                                "loadServices() " + ex.GetType().ToString());
            }

            this.serviceDescriptionTextBox.Text = this.currentServiceRow.ServiceDescription;
            this.serviceRateHourlyTextBox.Text  = this.currentServiceRow.ServiceRateHourly.ToString();
            this.serviceRateDailyTextBox.Text   = this.currentServiceRow.ServiceRateDaily.ToString();
            this.serviceRateWeeklyTextBox.Text  = this.currentServiceRow.ServiceRateWeekly.ToString();
        }