private void LoadGrid()
{
ViewRepository repository = new ViewRepository();
var gridItems = repository.GetNotWorking().Where(e => e.Month == GlobalValues.Instance.CurrentMonth).ToList();
dataGridView1.DataSource = gridItems;
dataGridView1.Columns[2].Visible = false;
dataGridView1.Columns[8].Visible = false;
dataGridView1.Columns[7].Visible = fiveweek;
for (int i = 0; i < gridItems.Count; i++)
{
if (gridItems[i].Week1 == 0)
{
dataGridView1.Rows[i].Cells[3].Style.BackColor = Color.Red;
}
if (gridItems[i].Week2 == 0)
{
dataGridView1.Rows[i].Cells[4].Style.BackColor = Color.Red;
}
if (gridItems[i].Week3 == 0)
{
dataGridView1.Rows[i].Cells[5].Style.BackColor = Color.Red;
}
if (gridItems[i].Week4 == 0)
{
dataGridView1.Rows[i].Cells[6].Style.BackColor = Color.Red;
}
if (gridItems[i].Week5 == 0)
{
dataGridView1.Rows[i].Cells[7].Style.BackColor = Color.Red;
}
}
}
