private void Dash_Click(object sender, EventArgs e)
{
//[CONNECTION STRINGS]
var connectionString = ConfigurationManager.ConnectionStrings["EmployeeManagement"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
//Update all relevant dgvs
con.Open();
SqlCommand HolidayData = con.CreateCommand();
HolidayData.CommandType = CommandType.Text;
HolidayData.CommandText = "select * from HolidayLeave";
HolidayData.ExecuteNonQuery();
DataTable HolidayDataTable = new DataTable();
SqlDataAdapter HolidayDataAdapter = new SqlDataAdapter(HolidayData);
HolidayDataAdapter.Fill(HolidayDataTable);
DashHolidayData.DataSource = HolidayDataTable;
con.Close();
DashHolidayData.Refresh();
con.Open();
SqlCommand Taskcmd = con.CreateCommand();
Taskcmd.CommandType = CommandType.Text;
Taskcmd.CommandText = "select * from TaskSchedule";
Taskcmd.ExecuteNonQuery();
DataTable dataTask = new DataTable();
SqlDataAdapter tasksAdapt = new SqlDataAdapter(Taskcmd);
tasksAdapt.Fill(dataTask);
DashTaskDataGrid.DataSource = dataTask;
con.Close();
DashTaskDataGrid.Refresh();
con.Open();
SqlCommand ListOfUsers = con.CreateCommand();
ListOfUsers.CommandType = CommandType.Text;
ListOfUsers.CommandText = "select * from Employees";
ListOfUsers.ExecuteNonQuery();
DataTable employeeTask = new DataTable();
SqlDataAdapter usersAdapt = new SqlDataAdapter(ListOfUsers);
usersAdapt.Fill(employeeTask);
dataGridView1.DataSource = employeeTask;
con.Close();
dataGridView1.Refresh();
Dashboard.Visible = true;
AddPanel.Visible = false;
tasksPanel.Visible = false;
ListOfUsersPanel.Visible = false;
holidayListPanel.Visible = false;
}
