private void btnCreate_Click(object sender, EventArgs e)
{
List <DayOfWeek> dayOfWeeks = new List <DayOfWeek>();
foreach (var item in lbDaysInWeek.SelectedItems)
{
dayOfWeeks.Add(ConvertToDayOfWeek(item.ToString().Trim()));
}
int totalDays = curClass.TongSoBuoi.Value;
DateTime startDate = cboStartDate.DateTime;
int cnt = 0;
List <DateTime> targetDateTimes = new List <DateTime>();
while (cnt < totalDays)
{
if (dayOfWeeks.Contains(startDate.DayOfWeek))
{
targetDateTimes.Add(startDate);
cnt++;
}
startDate = startDate.AddDays(1);
}
//Console.WriteLine("TOTAL DATE: " + totalDays);
int maCaHoc = int.Parse(cboCaHoc.SelectedValue.ToString());
int stt = 1;
List <HocSinh> listHs = db.BienLaiThuHocPhis.Where(bl => bl.MaLopHoc == curClassId).Select(bl => bl.HocSinh).Distinct().ToList();
foreach (var curDate in targetDateTimes)
{
BuoiHoc newBh = new BuoiHoc()
{
MaLopHoc = curClassId,
MaCaHoc = maCaHoc,
NgayHoc = curDate,
SoThuTu = stt
};
db.BuoiHocs.Add(newBh);
stt++;
}
db.SaveChanges();
Console.WriteLine("So buoi hoc: " + db.BuoiHocs.Where(bh => bh.MaLopHoc == curClassId).ToList().Count);
foreach (var bh in db.BuoiHocs.Where(bh => bh.MaLopHoc == curClassId).ToList())
{
foreach (var hs in listHs)
{
DiemDanh dd = new DiemDanh()
{
MaBuoiHoc = bh.Ma,
MaHocSinh = hs.Ma,
DaDiemDanh = false
};
db.DiemDanhs.Add(dd);
}
}
db.SaveChanges();
ShowLearnDate();
}
private void dgvContent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex >= dgvContent.RowCount)
{
return;
}
if (dgvContent.Columns[e.ColumnIndex].Name == "DiemDanh")
{
//Console.WriteLine("Hoc sinh: " + dgvContent.Rows[e.RowIndex].Cells[2].Value.ToString());
int maHocSinh = int.Parse(dgvContent.Rows[e.RowIndex].Cells[2].Value.ToString());
DiemDanh diemDanh = db.DiemDanhs.Where(dd => dd.MaBuoiHoc == _maBuoiHoc && dd.MaHocSinh == maHocSinh).FirstOrDefault();
diemDanh.DaDiemDanh = !diemDanh.DaDiemDanh;
db.SaveChanges();
BoundDataSource();
}
}
