private void FetchEmployeeSalaryButton_Click(object sender, EventArgs e)
{
try
{
SqlEmployeesRepository employees = new SqlEmployeesRepository(connectionString);
Employees ee = employees.FetchEmployeeSalary(Convert.ToInt32(EmployeeIdTextBox.Text));
List <Employees> list = new List <Employees>();
list.Add(ee);
dataGridView1.DataSource = list;
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
DataGridViewColumn columnOne = dataGridView1.Columns[0];
columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewColumn columnTwo = dataGridView1.Columns[2];
columnTwo.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewColumn columnThree = dataGridView1.Columns[3];
columnThree.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}catch (Exception ex)
{
MessageBox.Show("Incorrect Input. Parameter takes an integer.");
}
}
private void UpdateEmployeeRoleButton_Click(object sender, EventArgs e)
{
try
{
EmployeesData ed = new EmployeesData();
SqlEmployeesRepository employees = new SqlEmployeesRepository(connectionString);
employees.UpdateEmployeeRole(Convert.ToInt32(EmployeeIdText.Text), EmailTextbox.Text, NameTextbox.Text, EmployeeRoleText.Text, Convert.ToInt32(SalaryTextbox.Text));
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void CreateEmployeeButton_Click(object sender, EventArgs e)
{
try
{
SqlEmployeesRepository employees = new SqlEmployeesRepository(connectionString);
Employees createEmployees = employees.CreateEmployee(EmailTextbox.Text, NameTextbox.Text, RoleTextbox.Text, Convert.ToInt32(SalaryTextbox.Text));
list.Add(createEmployees);
EmployeesData ed = new EmployeesData();
ed.dataGridView1.DataSource = list;
}
catch (Exception ex)
{
MessageBox.Show("There cannot be any empty or incorrectly entered parameters. Check submission.");
}
}
private void RetrieveEmployeesButton_Click(object sender, EventArgs e)
{
SqlEmployeesRepository employees = new SqlEmployeesRepository(connectionString);
IReadOnlyList <Employees> employeeList = employees.RetrieveEmployees();
dataGridView1.DataSource = employeeList;
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
DataGridViewColumn columnOne = dataGridView1.Columns[0];
columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewColumn columnTwo = dataGridView1.Columns[2];
columnTwo.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewColumn columnThree = dataGridView1.Columns[3];
columnThree.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
