private void buttonNew_Click(object sender, EventArgs e) { if (mainGridView.SelectedRows.Count > 0 && !menu_Employee_show) { mainGridView.Width = mainGridView.Width - menu_Employee_size; panelEmployees.Width = menu_Employee_size; menu_Employee_show = !menu_Employee_show; listboxCurrentCerts.Items.Clear(); employee = new EmployeeChanges(); buttonControl.Text = "Add New!"; } else if (mainGridView.SelectedRows.Count <= 0) { MessageBox.Show("You have to select a row for too edit!"); } else if (menu_Employee_show) { mainGridView.Width = mainGridView.Width + menu_Employee_size; panelEmployees.Width = 0; menu_Employee_show = !menu_Employee_show; textBoxName.Text = ""; TextAdditInfo.Text = ""; } }
private void fillListBox() { if (mainGridView.SelectedRows.Count > 0) { con.Open(); cmd.CommandText = "select Certifications.Id, Certifications.Name, EmployeeCertification.Additional_Info, EmployeeCertification.Expiration_Date" + " from Certifications" + " join EmployeeCertification on Certifications.Id = EmployeeCertification.CertificationId" + " join Employees on Employees.Id = EmployeeCertification.EmployeeId where Employees.Id = " + mainGridView.SelectedRows[0].Cells["Id"].Value.ToString(); dr = cmd.ExecuteReader(); listboxCurrentCerts.Items.Clear(); employee = new EmployeeChanges(); while (dr.Read()) { employee.CertId.Add(dr[0].ToString()); employee.CertAdditInfo.Add(dr[2].ToString()); if (!DBNull.Value.Equals(dr[3])) { employee.CertDate.Add(Convert.ToDateTime(dr[3]).ToShortDateString()); } else { employee.CertDate.Add("NULL"); } listboxCurrentCerts.Items.Add(new KeyValuePair <string, string>(dr[0].ToString(), dr[1].ToString())); } dr.Close(); con.Close(); listboxCurrentCerts.DisplayMember = "Value"; listboxCurrentCerts.ValueMember = "Key"; } }