public async Task CreateBaiLam(BaiLam baiLam) { await _context.BaiLamContext.AddAsync(baiLam); await _context.SaveChangesAsync(); }
public async Task DeleteBaiLam(BaiLam baiLam) { _context.BaiLamContext.Remove(baiLam); await _context.SaveChangesAsync(); }
public void Update(BaiLam baiLam) { _baiLamRepository.Update(baiLam); }
public BaiLam Add(BaiLam baiLam) { return(_baiLamRepository.Add(baiLam)); }
/// <summary> /// chấm tthi /// </summary> protected virtual void LoadGrid() { var stt = 1; _tbError = GetTable(); var tbbailam = LoadData.Load(207, _idkythi); var tabledapan = LoadData.Load(7, _idkythi); if (tabledapan.Rows.Count == 0) { lock (LockTotal) { OnCloseDialog(); } Invoke( (Action)(() => MessageBox.Show(@"Chưa Import đáp án của mã đề", @"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning))); lock (LockTotal) { OnCloseDialog(); } return; } if (tbbailam.Rows.Count > 0) { foreach (DataRow dataRow in tbbailam.Rows) { double diem = 0; var listbailam = dataRow["KetQua"].ToString(); var tbdapan = SearchData.Timkiemmade2(dataRow["MaDe"].ToString(), _idkythi); if (listbailam.Length != tbdapan.Rows.Count) { _tbError.Rows.Add(stt++, dataRow["MaSV"].ToString(), dataRow["MaDe"].ToString(), dataRow["KetQua"].ToString() ); continue; } for (var i = 0; i < tbdapan.Rows.Count; i++) { var a = listbailam[i].ToString(); var s = tbdapan.Rows[i]["Dapan"].ToString(); var c = tbdapan.Rows[i]["ThangDiem"].ToString(); if (a == s) { diem = diem + double.Parse(c); } } var d = Math.Round(diem, 1); var hs = new BaiLam { IdKyThi = _idkythi, MaSV = int.Parse(dataRow["MaSV"].ToString()), DiemThi = d }; _listUpdate.Add(hs); dataRow["DiemThi"] = d; } Invoke((Action)(() => dgv_DanhSach.DataSource = tbbailam)); lock (LockTotal) { OnCloseDialog(); } } else { lock (LockTotal) { OnCloseDialog(); } Invoke( (Action)(() => MessageBox.Show(@"Chưa Import bài làm của sinh viên", @"Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning))); } }
public List <BaiLam> ParseBaiLam(Range xlRange, List <DeThi> lsDethi) { if (xlRange == null) { return(null);; } List <BaiLam> lsBaiLam = new List <BaiLam>(); int rowCount = xlRange.Rows.Count; int colCount = xlRange.Columns.Count; int indexColData = 0; int lengthSBD = 6; //nếu tăng lên n thì khai thêm la n int lengthMade = 3; bool checkParseData = false; //check data for (int i = 1; i <= rowCount; i++) { BaiLam baiLam = null; //get row and col for starting parseData if (!checkParseData) { for (int j = 1; j <= colCount; j++) { if (xlRange.Cells[i, j] != null) { object value = xlRange.Cells[i, j].Value2; if (value != null) { if (value.ToString().Trim().Replace(" ", "").Equals("Filename", StringComparison.CurrentCultureIgnoreCase)) { checkParseData = true; indexColData = j; totalProcess = totalProcess + 20; SetProgressValue(); break; } } } } } else { var page = xlRange.Cells[i, indexColData].Value2; if (!string.IsNullOrEmpty(FuncUtils.GetStringValue(page))) { baiLam = new BaiLam(); baiLam.rowIndex = i; //parse SBD var sbdUse = new StringBuilder(); for (int j = indexColData + 1; j <= indexColData + lengthSBD; j++) { object value = xlRange.Cells[i, j].Value2; //if (value != null){ //không có sbd vẫn làm tiếp sbdUse.Append(FuncUtils.GetStringValue(value)); //} } if (!string.IsNullOrEmpty(sbdUse.ToString())) { baiLam.SBD = sbdUse.ToString(); //parse made var made = new StringBuilder(); for (int j = (indexColData + lengthSBD + 1); j <= (indexColData + lengthSBD + lengthMade); j++) { object value = xlRange.Cells[i, j].Value2; //if (value != null) //mã đề thiếu vẫn làm //{ made.Append(FuncUtils.GetStringValue(value)); //} } baiLam.MaDe = made.ToString(); //parse bai lam var startIndex = indexColData + lengthSBD + lengthMade; var cauIndex = 0; var lsDapAn = new List <DapAn>(); for (int j = startIndex + 1; j <= colCount; j++) { object value = xlRange.Cells[i, j].Value2; /*if (value != null) * {*/ cauIndex++; lsDapAn.Add(new DapAn() { Cau = cauIndex, Result = FuncUtils.GetStringValue(value), colIndex = j, rowIndex = i }); /*}*/ } var maxObject = lsDapAn.OrderByDescending(item => item.colIndex).First(); baiLam.columnIndexResult = maxObject.colIndex + 1; //lấy index cột cuối cùng baiLam.DapAns = lsDapAn; } } } if (baiLam != null && !string.IsNullOrEmpty(baiLam.SBD) && !string.IsNullOrEmpty(baiLam.MaDe)) { lsBaiLam.Add(baiLam); } } if (!checkParseData) { throw new NotSupportedException("File bài làm lỗi"); } totalProcess = totalProcess + 20; SetProgressValue(); CalculateDiem(lsBaiLam, lsDethi); totalProcess = totalProcess + 10; SetProgressValue(); return(lsBaiLam); }
public frmHocSinh(frmLogin frmlogin, HocSinh hs) { this.frmlogin = frmlogin; this.hs = qlttn.HocSinhQL.Where(hs1 => hs1.maHS == hs.maHS).FirstOrDefault(); InitializeComponent(); btGanNhat = qlttn.BuoiThiQL.Where(bt => bt.KyThi.LoaiKT == "ThiThiet" && bt.BaiLams.Where(bl => bl.maHS == hs.maHS && bl.DiemSo == -1).Count() > 0 && (bt.NgayGioThi > DateTime.Now || (DateTime.Now >= bt.NgayGioThi && DateTime.Now <= bt.NgayGioThi + bt.DeThi.ThoiGianLamBai))) .OrderBy(bt => bt.NgayGioThi) .FirstOrDefault(); if (btGanNhat != null) { ktGanNhat = btGanNhat.KyThi; bl = btGanNhat.BaiLams.Where(bl => bl.maHS == hs.maHS).FirstOrDefault(); SetUpThi(); } else { MessageBox.Show("Sắp tới chưa có kỳ thi nào diễn ra, hãy tận hưởng đi nhé", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); ShowChildControl(tabControl1.TabPages[0], false); tabControl1.SelectedIndex = 1; } btnNopBai.Click += BtnNopBai_Click; this.FormClosing += (s, e) => { frmlogin.Show(); }; tabControl1.SelectedIndexChanged += (s, e) => { if (tabControl1.SelectedIndex == 1) { loadThongTinHocSinh(); loadCbKyThis(); loadDgvDaThi(); loadDgvLichThi(); } else if (tabControl1.SelectedIndex == 2) { loadCbKyThiThu(); loadDgvKyThiThu(); } }; txtHoTenHS.Validating += Txt_Validating; txtNgaySinh.Validating += Txt_Validating; txtMatKhauCu.Validating += Txt_Validating; txtMatKhauMoi.Validating += Txt_Validating; txtNgaySinh.Validating += (s, e) => { try { epMain.SetError(txtNgaySinh, ""); var ns = DateTime.Parse(txtNgaySinh.Text); } catch (Exception exec) { epMain.SetError(txtNgaySinh, "Hãy nhập đúng ngày sinh"); txtNgaySinh.Focus(); return; } }; btnCapNhat.Click += BtnCapNhat_Click; cbKyThiThu.SelectedIndexChanged += CbKyThiThu_SelectedIndexChanged; Load += FrmHocSinh_Load; }