private void paintCells2(int i, Classes_SM2 s)
{
for (int j = 5; j < 18; j++)
{
dataGridView.Rows[i].Cells[j].Style.BackColor = Color.Red;
}
if (s.C08_09 == 0)
{
dataGridView.Rows[i].Cells[5].Style.BackColor = Color.LawnGreen;
}
if (s.C09_10 == 0)
{
dataGridView.Rows[i].Cells[6].Style.BackColor = Color.LawnGreen;
}
if (s.C10_11 == 0)
{
dataGridView.Rows[i].Cells[7].Style.BackColor = Color.LawnGreen;
}
if (s.C11_12 == 0)
{
dataGridView.Rows[i].Cells[8].Style.BackColor = Color.LawnGreen;
}
if (s.C12_13 == 0)
{
dataGridView.Rows[i].Cells[9].Style.BackColor = Color.LawnGreen;
}
if (s.C13_14 == 0)
{
dataGridView.Rows[i].Cells[10].Style.BackColor = Color.LawnGreen;
}
if (s.C14_15 == 0)
{
dataGridView.Rows[i].Cells[11].Style.BackColor = Color.LawnGreen;
}
if (s.C15_16 == 0)
{
dataGridView.Rows[i].Cells[12].Style.BackColor = Color.LawnGreen;
}
if (s.C16_17 == 0)
{
dataGridView.Rows[i].Cells[13].Style.BackColor = Color.LawnGreen;
}
if (s.C17_18 == 0)
{
dataGridView.Rows[i].Cells[14].Style.BackColor = Color.LawnGreen;
}
if (s.C18_19 == 0)
{
dataGridView.Rows[i].Cells[15].Style.BackColor = Color.LawnGreen;
}
if (s.C19_20 == 0)
{
dataGridView.Rows[i].Cells[16].Style.BackColor = Color.LawnGreen;
}
if (s.C20_21 == 0)
{
dataGridView.Rows[i].Cells[17].Style.BackColor = Color.LawnGreen;
}
i++;
}
//save to file
private void save_btn_Click(object sender, EventArgs e)
{
//SAVE FILE
using (SaveFileDialog save = new SaveFileDialog()
{
Filter = "Csv|*.csv", ValidateNames = true
})
{
if (save.ShowDialog() == DialogResult.OK)
{
var csv = new StringBuilder();
Classes_SM2 req = new Classes_SM2();
using (var sw = new StreamWriter(save.FileName))
{
var writer = new CsvWriter(sw);
writer.WriteHeader(typeof(Classes_SM2));
for (int i = 0; i < dataGridView.RowCount - 1; i++)
{
req.date = dataGridView.Rows[i].Cells[0].Value.ToString();
req.day = dataGridView.Rows[i].Cells[1].Value.ToString();
req.Class_Id = dataGridView.Rows[i].Cells[2].Value.ToString();
req.Type = dataGridView.Rows[i].Cells[3].Value.ToString();
req.Capacity = Convert.ToInt32(dataGridView.Rows[i].Cells[4].Value);
if (dataGridView.Rows[i].Cells[5].Style.BackColor == Color.LawnGreen)
{
req.C08_09 = 0;
}
if (dataGridView.Rows[i].Cells[6].Style.BackColor == Color.LawnGreen)
{
req.C09_10 = 0;
}
if (dataGridView.Rows[i].Cells[7].Style.BackColor == Color.LawnGreen)
{
req.C10_11 = 0;
}
if (dataGridView.Rows[i].Cells[8].Style.BackColor == Color.LawnGreen)
{
req.C11_12 = 0;
}
if (dataGridView.Rows[i].Cells[9].Style.BackColor == Color.LawnGreen)
{
req.C12_13 = 0;
}
if (dataGridView.Rows[i].Cells[10].Style.BackColor == Color.LawnGreen)
{
req.C13_14 = 0;
}
if (dataGridView.Rows[i].Cells[11].Style.BackColor == Color.LawnGreen)
{
req.C14_15 = 0;
}
if (dataGridView.Rows[i].Cells[12].Style.BackColor == Color.LawnGreen)
{
req.C15_16 = 0;
}
if (dataGridView.Rows[i].Cells[13].Style.BackColor == Color.LawnGreen)
{
req.C16_17 = 0;
}
if (dataGridView.Rows[i].Cells[14].Style.BackColor == Color.LawnGreen)
{
req.C17_18 = 0;
}
if (dataGridView.Rows[i].Cells[15].Style.BackColor == Color.LawnGreen)
{
req.C18_19 = 0;
}
if (dataGridView.Rows[i].Cells[16].Style.BackColor == Color.LawnGreen)
{
req.C19_20 = 0;
}
if (dataGridView.Rows[i].Cells[17].Style.BackColor == Color.LawnGreen)
{
req.C20_21 = 0;
}
writer.WriteRecord(req);
}
}
MessageBox.Show("Saved", "mes", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private int classCapacity(string className)
{
Classes_SM2 ss = context.Classes_SM2.First(s => s.Class_Id == className);
return(Convert.ToInt32(ss.Capacity));
}
