public EmployeesResearch()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.GetEmployeesResearch();
dataGridView1.DataSource = dt;
}
public FemaleEAdmins()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.GetFemaleEAdmins();
dataGridView1.DataSource = dt;
}
public DeptMgr()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.SelectEMgr();
dataGridView1.DataSource = dt;
}
public DeptsHouston()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.GetDeptsHouston();
dataGridView1.DataSource = dt;
}
public GetSalary4000()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.GetEwithSless4000();
dataGridView1.DataSource = dt;
}
private void ViewEmployees_Load(object sender, EventArgs e)
{
controllerObj = new Controller();
DataTable dt = controllerObj.SelectAllEmp();
dataGridView1.DataSource = dt;
dataGridView1.Refresh();
}
public RetrieveProjects()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.SelectDepLoc();
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "Dlocation";
}
public AddProject()
{
InitializeComponent();
controllerObj = new Controller();
DataTable dt = controllerObj.SelectDepNum();
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "Dnumber";
}
public SalaryStats()
{
InitializeComponent();
controllerObj = new Controller();
label2.Text = "MAX: " + controllerObj.GetMaxSalary();
label3.Text = "MIN: " + controllerObj.GetMinSalary();
label4.Text = "AVG: " + controllerObj.GetAvgSalary();
}
public UpdateSalary()
{
InitializeComponent();
controllerObj = new Controller();
}
public AddDept()
{
InitializeComponent();
controllerObj = new Controller();
}
private void Welcome_Load(object sender, EventArgs e)
{
controllerObj = new Controller();
DataTable dt = controllerObj.Testt();
dataGridView1.DataSource = dt;
}
