public void Khoitao() { using (var _context = new DBLapTrinhWin()) { var x = (from u in _context.TienDoes where u.IDDeAn == key select u).FirstOrDefault(); TienDoBaoCao present = new TienDoBaoCao(); present.SoBuoi = x.SoBuoi; txtSoBuoi.Text = (present.SoBuoi).ToString(); if (cbSoBuoi.Items.Count <= 0) { for (int i = 1; i <= present.SoBuoi; i++) { cbSoBuoi.Items.Add(i); } } var m = from u in _context.DeAns where u.IDDeAn == key select u; if (m.Count() != 0) { var n = m.First(); if (!(n.Diem is null)) { txtDiem.Text = n.Diem.ToString(); } if (!(n.DateStart is null || n.DateEnd is null)) { dtpDateStart.Value = DateTime.Parse(n.DateStart.Value.ToString()); dtpDateEnd.Value = DateTime.Parse(n.DateEnd.Value.ToString()); } } } }
public void TaoDTG() { using (var _context = new DBLapTrinhWin()) { int sobuoi = 0; var x = from u in _context.TienDoes where u.IDDeAn == key select u; if (x.Count() != 0) { if (x.First().SoBuoi != null) { sobuoi = (int)x.First().SoBuoi; } } var sobuoihientai = from u in _context.TienDoes where u.HoanThanh == null && u.IDDeAn == key select u; if (sobuoihientai.Count() == 1) { List <TienDoBaoCao> dtg = new List <TienDoBaoCao>(); for (int j = 0; j < sobuoi; j++) { TienDoBaoCao k = new TienDoBaoCao(); string buoi = "Buổi " + (j + 1).ToString(); k.Buoi = buoi; dtg.Add(k); } dtgTienDo.DataSource = dtg; return; } string xnd = ""; string xlink = ""; string xcheck = ""; if ((x.First().BaoCao != null)) { xnd = x.First().BaoCao; } if ((x.First().LinkTaiLieu != null)) { xlink = x.First().LinkTaiLieu; } if ((x.First().HoanThanh != null)) { xcheck = x.First().HoanThanh; } List <string> noidung = BaoCaoTienDoController.GetDanhSachNoiDungBaoCao(xnd); List <string> link = BaoCaoTienDoController.GetDanhSachLinkTaiLieu(xlink); List <bool> check = BaoCaoTienDoController.GetHoanThanh(xcheck); List <TienDoBaoCao> dtgsource = new List <TienDoBaoCao>(); for (int i = 0; i < sobuoi; i++) { TienDoBaoCao k = new TienDoBaoCao(); string buoi = "Buổi " + (i + 1).ToString(); k.Buoi = buoi; if (i < noidung.Count()) { k.NoiDung = noidung[i]; } if (i < link.Count()) { k.Link = link[i]; } if (i < check.Count()) { k.HoanThanh = check[i]; } dtgsource.Add(k); } dtgTienDo.DataSource = dtgsource; } }