private void gvNoiDungChiTiet_MasterRowGetChildList(object sender, MasterRowGetChildListEventArgs e) { var dao = new DiemDanhGiaRenLuyenDAO(); var daob = new LuaChonChiTietDAO(); GridView view = sender as GridView; var tcdg = view.GetRow(e.RowHandle) as dynamic; if (tcdg != null) { var hocky = cbbHocKy.EditValue as string; var namhoc = cbbNamHoc.EditValue as string; int namhoc2 = int.Parse(namhoc.Split('-')[0].ToString()); var lst = dao.GetAllByMSSV(MSSV, namhoc2, hocky); var lstrenluyen = dao._db.ViewLuaChonChiTiets.ToList(); if (lst.Count() <= 0) { foreach (var item in lstrenluyen) { dao.AddOrUpdate(new Model.DTO.DGRenLuyen() { NamHoc = namhoc2, MaHK = hocky, MSSV = MSSV, MaLC = item.MaLC }, 0); } lst = dao.GetAllByMSSV(MSSV, namhoc2, hocky); } var lc = daob.GetAllLuaChon(tcdg.MaCT) as List <LuaChonChiTiet>; var lstsource = from a in lst.Where(x => lc.Any(y => y.MaLC == x.MaLC)) join b in lc on a.MaLC equals b.MaLC select new { MaLCView = (b.MaLC >= 10) ? "0" + b.MaLC : "00" + b.MaLC, b.MaLC, b.MoTa, DiemTT = b.DiemMin, DiemTD = b.DiemMax, DiemSV = a.DiemSVDG, DiemLTT = a.DiemLT, DiemGV = a.DiemCVHT }; e.ChildList = lstsource.ToList(); } }
private void btnOK_Click(object sender, EventArgs e) { DiemDanhGiaRenLuyenDAO dao = new DiemDanhGiaRenLuyenDAO(); int diem = (int)numDiem.Value; if (diem < this.Min) { XtraMessageBox.Show("Điểm tối thiểu phải từ " + this.Min, "Thông Báo!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (diem > this.Max) { XtraMessageBox.Show("Điểm tối đa phải thấp hơn hoặc bằng " + this.Max, "Thông Báo!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { dao.UpdateDiem(this.ID, diem, Username.ChucVu, type); this.Close(); } }