public static void Insert(BANGDIEM _bangdiem) { try { _bangdiem.CreatedDate = DateTime.Now; _bangdiem.CreatedBy = GlobalSettings.UserCode; _bangdiem.CreatedLog = GlobalSettings.SessionMyIP; _bangdiem.IsRemove = 0; Database.BANGDIEMs.InsertOnSubmit(_bangdiem); Database.SubmitChanges(); int _id = _bangdiem.BangDiemId; //Insert Bang diem chi tiet List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId); foreach (var item in _khmh) { BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET(); _chitiet.BangDiemId = _id; _chitiet.MonHocId = item.MonHocId ?? 0; _chitiet.TenMonHoc = item.TenMonHoc; _chitiet.IsRemove = 0; //_chitiet.CreatedDate = DateTime.Now; //_chitiet.CreatedBy = GlobalSettings.UserCode; //_chitiet.CreatedLog = GlobalSettings.SessionMyIP; Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet); Database.SubmitChanges(); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
public static void Update(BANGDIEMCHITIET kh) { try { var khoaHocCu = Select(kh.BangDiemChiTietId); khoaHocCu.Diem = kh.Diem; Database.SubmitChanges(); } catch (System.Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool UpdateFull(BangDiemFullDTO _bdct) { bool result = false; try { using (TransactionScope ts = new TransactionScope()) { decimal _tongdiem = 0; foreach (var item in _bdct.BangDiemChiTiets) { BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET(); _chitiet.BangDiemChiTietId = (int)item.BangDiemChiTietId; _chitiet.BangDiemId = (int)item.BangDiemId; _chitiet.MonHocId = item.MonHocId; _chitiet.TenMonHoc = item.TenMonHoc; _chitiet.Diem = item.Diem; BangDiemChiTietLogic.Update(_chitiet); _tongdiem += item.Diem ?? 0; } //Cap nhat BANGDIEM + diem trung binh var _bangdiemtmp = Select(_bdct.HocVienId ?? 0, _bdct.LopHocId ?? 0); _bangdiemtmp.DiemTrungBinh = Math.Round(_tongdiem / _bdct.BangDiemChiTiets.Count, 2); _bangdiemtmp.TrangThai = 3; Database.SubmitChanges(); ts.Complete(); return(true); } } catch (Exception ex) { return(result); O2S_Common.Logging.LogSystem.Error(ex); } return(result); }
public static bool InsertPGDFull_XepLop(PHIEUGHIDANH _phieughidanh, PHIEUTHU _phieuthu, List <HOCPHIHOCVIEN> _lsthphv, BANGDIEM _bangdiem, ref int _PhieuGhiDanhId, ref int _PhieuThuId) { try { // O2S_Common.Logging.LogSystem.Error("Luu log InsertPGDFull"); using (TransactionScope ts = new TransactionScope()) { //Phieu ghi danh _phieughidanh.CoSoId = GlobalSettings.CoSoId; _phieughidanh.CreatedDate = DateTime.Now; _phieughidanh.CreatedBy = GlobalSettings.UserCode; _phieughidanh.CreatedLog = GlobalSettings.SessionMyIP; _phieughidanh.IsRemove = 0; Database.PHIEUGHIDANHs.InsertOnSubmit(_phieughidanh); Database.SubmitChanges(); _PhieuGhiDanhId = _phieughidanh.PhieuGhiDanhId; _phieughidanh.MaPhieuGhiDanh = string.Format("{0}{1:D7}", "PGD", _PhieuGhiDanhId); Database.SubmitChanges(); //insert bang PHIEUTHU if (_phieuthu != null && _phieuthu.HocVienId > 0) { _phieuthu.PhieuGhiDanhId = _PhieuGhiDanhId; _phieuthu.CreatedDate = DateTime.Now; _phieuthu.CreatedBy = GlobalSettings.UserCode; _phieuthu.CreatedLog = GlobalSettings.SessionMyIP; _phieuthu.IsRemove = 0; Database.PHIEUTHUs.InsertOnSubmit(_phieuthu); Database.SubmitChanges(); _PhieuThuId = _phieuthu.PhieuThuId; _phieuthu.MaPhieuThu = string.Format("{0}{1:D7}", "PT", _phieuthu.PhieuThuId); Database.SubmitChanges(); } //Hocphihocvien if (_lsthphv != null && _lsthphv.Count > 0) { foreach (var item in _lsthphv) { item.PhieuGhiDanhId = _PhieuGhiDanhId; item.PhieuThuId = _phieuthu.PhieuThuId; item.CreatedDate = DateTime.Now; item.CreatedBy = GlobalSettings.UserCode; item.CreatedLog = GlobalSettings.SessionMyIP; item.IsRemove = 0; Database.HOCPHIHOCVIENs.InsertOnSubmit(item); Database.SubmitChanges(); } } //insert BANGDIEM if (_bangdiem.LopHocId != 0) { _bangdiem.PhieuGhiDanhId = _PhieuGhiDanhId; _bangdiem.CreatedDate = DateTime.Now; _bangdiem.CreatedBy = GlobalSettings.UserCode; _bangdiem.CreatedLog = GlobalSettings.SessionMyIP; _bangdiem.IsRemove = 0; Database.BANGDIEMs.InsertOnSubmit(_bangdiem); Database.SubmitChanges(); int _id = _bangdiem.BangDiemId; //Insert Bang diem chi tiet List <KHOAHOC_MONHOC> _khmh = KhoaHocMonHocLogic.SelectTheoKhoaHoc(_bangdiem.KhoaHocId); foreach (var item in _khmh) { BANGDIEMCHITIET _chitiet = new BANGDIEMCHITIET(); _chitiet.BangDiemId = _id; _chitiet.MonHocId = item.MonHocId ?? 0; _chitiet.TenMonHoc = item.TenMonHoc; _chitiet.IsRemove = 0; //_chitiet.CreatedDate = DateTime.Now; //_chitiet.CreatedBy = GlobalSettings.UserCode; //_chitiet.CreatedLog = GlobalSettings.SessionMyIP; Database.BANGDIEMCHITIETs.InsertOnSubmit(_chitiet); Database.SubmitChanges(); } //Update SiSo cua LOPHOC LOPHOC _lophoc = LopHocLogic.SelectSingle(_bangdiem.LopHocId); LopHocLogic.Update(new LOPHOC() { //LopHocId = _lophoc.LopHocId, //TenLopHoc = _lophoc.TenLopHoc, //NgayBatDau = _lophoc.NgayBatDau, //NgayKetThuc = _lophoc.NgayKetThuc, //SiSoToiDa = _lophoc.SiSoToiDa, SiSo = _lophoc.SiSo + 1, //KhoaHocId = _lophoc.KhoaHocId, //IsLock = _lophoc.IsLock }); } //Update HOCVIEN = Hoc vien chinh thuc HOCVIEN _hocvien = HocVienLogic.SelectSingle(_phieughidanh.HocVienId ?? 0); _hocvien.LOAIHOCVIEN = LoaiHocVienLogic.Select(KeySetting.LOAIHOCVIEN_CHINHTHUC); //Database.SubmitChanges(); //Update TAIKHOAN = được sử dụng TAIKHOAN _taikhoan = TaiKhoanLogic.SelectTheoTenDangNhap(_hocvien.MaHocVien); _taikhoan.IsRemove = 0; Database.SubmitChanges(); ts.Complete(); return(true); } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); return(false); } }
public static void Insert(BANGDIEMCHITIET bd) { bd.IsRemove = 0; Database.BANGDIEMCHITIETs.InsertOnSubmit(bd); Database.SubmitChanges(); }