/// <summary>
/// Event to be triggered when a value is selected in order to perform it searches
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void searchComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
//var test = CUDOperations.getAllEmp();
if (searchComboBox.SelectedIndex == 0)
{
dataGridView1.DataSource = ResEmp.GetAllEmpAndDept();
}
else if (searchComboBox.SelectedIndex == 1)
{
dataGridView1.DataSource = ResEmp.GetAllEmpAndDeptGroupedByDept();
}
else if (searchComboBox.SelectedIndex == 2)
{
dataGridView1.DataSource = ResEmp.GetEmployeeBySalaryAbove150000();
}
else if (searchComboBox.SelectedIndex == 3)
{
dataGridView1.DataSource = ResEmp.GetAllDeptNotAssignedAnEmp();
}
else if (searchComboBox.SelectedIndex == 4)
{
dataGridView1.DataSource = ResEmp.GetAllEmpAndDeptAssignedAndNotAssigned();
}
else if (searchComboBox.SelectedIndex == 5)
{
dataGridView1.DataSource = ResEmp.GetAllEmp();
}
}
/// <summary>
/// Event to be triggered when Update a Department
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateDept_Click(object sender, EventArgs e)
{
try
{
ResDept.UpdateDept(
new Department
{
DepartmentId = DeptID,
DepartmentName = textBox10.Text
}
);
dataGridView2.DataSource = ResDept.GetAllDept();
dataGridView1.DataSource = ResEmp.GetAllEmp();
comboBox1.Items.Clear();
var comboDept = ResDept.GetAllDeptToCombo();
foreach (var item in comboDept)
{
comboBox1.Items.Add(item);
}
textBox10.Clear();
}
catch (Exception)
{
MessageBox.Show("Department could not be Updated");
}
}
/// <summary>
/// On Form Load, Methods to Perform
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CompanyForm_Load(object sender, EventArgs e)
{
var comboDept = ResDept.GetAllDeptToCombo();
var dept = ResDept.GetAllDept();
var emp = ResEmp.GetAllEmp();
dataGridView1.DataSource = emp;
dataGridView2.DataSource = dept;
foreach (var item in comboDept)
{
comboBox1.Items.Add(item);
}
searchComboBox.Items.Add("");
}
/// <summary>
/// Event to be triggered when Deleting an Employee
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDeleteEmp_Click(object sender, EventArgs e)
{
try
{
ResEmp.DeleteEmp(EmpID);
dataGridView1.DataSource = ResEmp.GetAllEmp();
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox6.Clear();
}
catch (Exception)
{
MessageBox.Show("Employee details could not be Deleted");
}
}
/// <summary>
/// Event to be triggered when Add an Employee
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddEmp_Click(object sender, EventArgs e)
{
try
{
decimal.TryParse(textBox6.Text, out decimal d);
if (decimal.TryParse(textBox6.Text, out decimal _))
{
ResEmp.AddEmp(new Employee
{
FirstName = textBox1.Text,
LastName = textBox2.Text,
Email = textBox3.Text,
PhoneNumber = textBox4.Text,
HireDate = dateTimePicker1.Value,
Salary = d
},
comboBox1.Text
);
dataGridView1.DataSource = ResEmp.GetAllEmp();
}
else
{
MessageBox.Show("Enter Valid Input");
}
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox6.Clear();
}
catch (Exception)
{
MessageBox.Show("Fill up Relevant Fields. New Employee details could not be Added");
}
}
