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(); } }
private void servicesComboBox_SelectedValueChanged(object sender, EventArgs e) { try { if (servicesComboBox.SelectedIndex != -1) { this.currentServiceRow = (SeniorCitizensDataSet.ServiceRow)serviceDataTable.Rows[this.servicesComboBox.SelectedIndex]; 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(); } else { this.currentServiceRow = (SeniorCitizensDataSet.ServiceRow)serviceDataTable.Rows[0]; 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(); } } catch (System.NullReferenceException ex) { //ignore } this.hourlyCheckBox.Checked = false; this.dailyCheckBox.Checked = false; this.weeklyCheckBox.Checked = false; }
private void newButton_Click(object sender, EventArgs e) { //Create copies of the initial row values. Helpful incase anything blows up within the try block. Program can revert back to original data. SeniorCitizensDataSet.EmployeeRow bakEmployeeRow = this.currentEmployeeRow; SeniorCitizensDataSet.ServiceRow bakServiceRow = this.currentServiceRow; try { //Create the new row object this.currentEmployeeRow = this.employeeDataTable.NewEmployeeRow(); //initialize the fields this.currentEmployeeRow.EmployeeID = this.currentEmployeeRow.EmployeeID + 1; this.currentEmployeeRow.EmpFirstName = string.Empty; this.currentEmployeeRow.EmpLastName = string.Empty; this.currentEmployeeRow.EmpAge = 0; this.currentEmployeeRow.EmpGender = string.Empty; this.currentEmployeeRow.EmpDateOfBirth = System.DateTime.Today; this.currentEmployeeRow.EmpPhone = "123-111-1111"; //Add the row to the data table this.employeeDataTable.AddEmployeeRow(this.currentEmployeeRow); //Use table adapter to perform the update int countNew = this.employeeTableAdapter.Update(this.employeeDataTable); this.addingNew = true; this.currentEmployeePosition = this.employeeDataTable.Count - 1; this.loadEmployee(); this.loadServices(); this.setNavButtonLastEnabledToFalse(); this.setButtonsEnabled(false); } catch (SqlException ex) { MessageBox.Show("Error: " + "\nMessage: " + ex.Message, "newButton_Click() " + ex.GetType().ToString()); //revert back to original row data if error in try block occurs this.currentEmployeeRow = bakEmployeeRow; this.currentServiceRow = bakServiceRow; } catch (Exception ex) { MessageBox.Show("Error: " + "\nMessage: " + ex.Message, "newButton_Click() " + ex.GetType().ToString()); this.currentEmployeeRow = bakEmployeeRow; this.currentServiceRow = bakServiceRow; } }