// add staff button private void button1_Click(object sender, EventArgs e) { try { // selcted item name var name = ValidateClass.CheckEmptyString(comboBox1.SelectedItem.ToString()); // selected item name var id = Getquery.GetDepartmentId(name); var firstName = ValidateClass.CheckEmptyString(textBox1.Text); var lastName = ValidateClass.CheckEmptyString(textBox2.Text); var telPhone = int.Parse(ValidateClass.CheckEmptyString(textBox4.Text)); var email = ValidateClass.CheckEmptyString(textBox6.Text); var salary = int.Parse(textBox5.Text); //todays date DateTime dateTime = DateTime.UtcNow; var hireDate = dateTime.ToString("dd/MM/yyyy"); DateTime date = DateTime.Parse(hireDate); // add employee Getquery.AddEmployee(firstName, lastName, email, telPhone, date, salary, id); MessageBox.Show("New employee Added"); // empty textbox textBox1.Text = ""; textBox2.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; } catch (Exception) { MessageBox.Show("Invalid Operation"); } }
private void button1_Click(object sender, EventArgs e) { var deptName = ValidateClass.CheckEmptyString(textBox1.Text); processQuery.UpdatDepartment(DeptClass.DepartmentId, deptName); MessageBox.Show("Department Updated "); }
// update button private void button1_Click(object sender, EventArgs e) { try { // selected department name var name = comboBox1.SelectedItem.ToString(); var id = Getprocess.GetDepartmentId(name); var firstName = ValidateClass.CheckEmptyString(textBox1.Text); var lastName = ValidateClass.CheckEmptyString(textBox2.Text); var telPhone = int.Parse(ValidateClass.CheckEmptyString(textBox5.Text)); var email = ValidateClass.CheckEmptyString(textBox3.Text); var salary = int.Parse(textBox4.Text); // todays date DateTime dateTime = DateTime.UtcNow; var hireDate = dateTime.ToString("dd/MM/yyyy"); DateTime date = DateTime.Parse(hireDate); // update employee Getprocess.EmployeeUpdate(firstName, lastName, email, telPhone, date, salary, id, EmployeId); MessageBox.Show("Employee Edited"); } catch (Exception) { MessageBox.Show("Invalid operation "); } }
// add department button private void button1_Click(object sender, EventArgs e) { var textValue = ValidateClass.CheckEmptyString(textBox1.Text); Getquery.AddDepartment(textValue); MessageBox.Show("Department Added"); textBox1.Text = ""; }