public static bool Update(GIANGVIEN _hocVien, TAIKHOAN taiKhoan = null) { try { var hocVienCu = SelectSigleTheoKhoaKhoa(_hocVien.GiangVienId); hocVienCu.TenGiangVien = _hocVien.TenGiangVien; hocVienCu.GioiTinh = _hocVien.GioiTinh; hocVienCu.Sdt = _hocVien.Sdt; hocVienCu.Email = _hocVien.Email; hocVienCu.NgaySinh = _hocVien.NgaySinh; hocVienCu.DiaChi = _hocVien.DiaChi; hocVienCu.NgayBatDauLamViec = _hocVien.NgayBatDauLamViec; hocVienCu.GhiChu = _hocVien.GhiChu; hocVienCu.ModifiedDate = DateTime.Now; hocVienCu.ModifiedBy = GlobalSettings.UserCode; hocVienCu.ModifiedLog = GlobalSettings.SessionMyIP; Database.SubmitChanges(); if (taiKhoan != null) { TaiKhoanLogic.Update(taiKhoan); } return(true); } catch (Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Delete(int _nhanvienId) { try { using (TransactionScope ts = new TransactionScope()) { //xoa nhan vien + xoa phan quyen tai khoan + Xoa tai khoan var temp = SelectSingle(_nhanvienId); int _TaiKhoanId = temp.TaiKhoanId ?? 0; Database.NHANVIENs.DeleteOnSubmit(temp); //Database.SubmitChanges(); List <PHANQUYENTAIKHOAN> _lstpqtk = PhanQuyenTaiKhoanLogic.SelectTheoTaiKhoan(_TaiKhoanId); if (_lstpqtk != null && _lstpqtk.Count > 0) { Database.PHANQUYENTAIKHOANs.DeleteAllOnSubmit(_lstpqtk); //Database.SubmitChanges(); } TAIKHOAN _taikhoan = TaiKhoanLogic.SelectSingle(_TaiKhoanId); Database.TAIKHOANs.DeleteOnSubmit(_taikhoan); Database.SubmitChanges(); ts.Complete(); return(true); } } catch (Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Update(NHANVIEN _hocVien, TAIKHOAN taiKhoan = null) { try { var _nhanvienCu = SelectSingle(_hocVien.NhanVienId); _nhanvienCu.LOAINHANVIEN = LoaiNhanVienLogic.Select(_hocVien.LoaiNhanVienId ?? 0); _nhanvienCu.TenNhanVien = _hocVien.TenNhanVien; _nhanvienCu.Sdt = _hocVien.Sdt; _nhanvienCu.Email = _hocVien.Email; _nhanvienCu.NgaySinh = _hocVien.NgaySinh; _nhanvienCu.GioiTinh = _hocVien.GioiTinh; _nhanvienCu.DiaChi = _hocVien.DiaChi; _nhanvienCu.NgayBatDauLamViec = _hocVien.NgayBatDauLamViec; _nhanvienCu.GhiChu = _hocVien.GhiChu; _nhanvienCu.ModifiedDate = DateTime.Now; _nhanvienCu.ModifiedBy = GlobalSettings.UserCode; _nhanvienCu.ModifiedLog = GlobalSettings.SessionMyIP; Database.SubmitChanges(); if (taiKhoan != null) { TaiKhoanLogic.Update(taiKhoan); } return(true); } catch (Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Delete(int _GiangVienId) { try { using (TransactionScope ts = new TransactionScope()) { //kiem tra neu giang vien: co GIANGDAY + XEPLICHHOC thi khong cho xoa List <GIANGDAY> _lstGiangDay = GiangDayLogic.SelectTheoGiangVien(_GiangVienId); if (_lstGiangDay != null && _lstGiangDay.Count > 0) { Database.GIANGDAYs.DeleteAllOnSubmit(_lstGiangDay); Database.SubmitChanges(); } XepLichHocFilter _filter_xlh = new XepLichHocFilter(); _filter_xlh.GiaoVien_ChinhId = _GiangVienId; _filter_xlh.GiaoVien_TroGiangId = _GiangVienId; List <XEPLICHHOC> _lstXepLichHoc = XepLichHocLogic.SelectTheoGiangVien(_filter_xlh); if (_lstXepLichHoc != null && _lstXepLichHoc.Count > 0) { Database.XEPLICHHOCs.DeleteAllOnSubmit(_lstXepLichHoc); Database.SubmitChanges(); } //xoa GIANGVIEN var temp = SelectSigleTheoKhoaKhoa(_GiangVienId); Database.GIANGVIENs.DeleteOnSubmit(temp); Database.SubmitChanges(); //Xoa PHANQUYENTAIKHOAN List <PHANQUYENTAIKHOAN> _lstpqtk = PhanQuyenTaiKhoanLogic.SelectTheoTaiKhoan(temp.TaiKhoanId ?? 0); if (_lstpqtk != null && _lstpqtk.Count > 0) { Database.PHANQUYENTAIKHOANs.DeleteAllOnSubmit(_lstpqtk); Database.SubmitChanges(); } TAIKHOAN _taikhoan = TaiKhoanLogic.SelectSingle(temp.TaiKhoanId ?? 0); if (_taikhoan != null) { Database.TAIKHOANs.DeleteOnSubmit(_taikhoan); Database.SubmitChanges(); } Database.SubmitChanges(); ts.Complete(); return(true); } } catch (Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Update(HOCVIEN _hocVien, TAIKHOAN taiKhoan = null) { try { //update hoc vien var hocVienCu = SelectSingle(_hocVien.HocVienId); hocVienCu.LOAIHOCVIEN = LoaiHocVienLogic.Select(_hocVien.LoaiHocVienId ?? 0); hocVienCu.TenHocVien = _hocVien.TenHocVien; hocVienCu.GioiTinh = _hocVien.GioiTinh; hocVienCu.NgaySinh = _hocVien.NgaySinh; hocVienCu.DiaChi = _hocVien.DiaChi; hocVienCu.Sdt = _hocVien.Sdt; hocVienCu.Email = _hocVien.Email; hocVienCu.NgayTiepNhan = _hocVien.NgayTiepNhan; hocVienCu.SdtBo = _hocVien.SdtBo; hocVienCu.EmailBo = _hocVien.EmailBo; hocVienCu.SdtMe = _hocVien.SdtMe; hocVienCu.EmailMe = _hocVien.EmailMe; hocVienCu.TenNguoiTuVan = _hocVien.TenNguoiTuVan; hocVienCu.GhiChu = _hocVien.GhiChu; hocVienCu.ModifiedDate = DateTime.Now; hocVienCu.ModifiedBy = GlobalSettings.UserCode; hocVienCu.ModifiedLog = GlobalSettings.SessionMyIP; //update tai khoan TAIKHOAN _tk = TaiKhoanLogic.SelectSingle(hocVienCu.TaiKhoanId ?? 0); //_tk.TenDangNhap = taiKhoan.TenDangNhap; _tk.MatKhau = O2S_Common.EncryptAndDecrypt.MD5EncryptAndDecrypt.Encrypt(taiKhoan.MatKhau, true); if (_hocVien.LoaiHocVienId == KeySetting.LOAIHOCVIEN_CHINHTHUC)//chinh thuc { _tk.IsRemove = 0; } else { _tk.IsRemove = 1; } Database.SubmitChanges(); return(true); } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool Insert(HOCVIEN _hocVien, TAIKHOAN taiKhoan, ref int _hocVienId) { try { _hocVien.CreatedDate = DateTime.Now; _hocVien.CreatedBy = GlobalSettings.UserCode; _hocVien.CreatedLog = GlobalSettings.SessionMyIP; _hocVien.IsRemove = 0; if (_hocVien.LoaiHocVienId == KeySetting.LOAIHOCVIEN_TIEMNANG || _hocVien.LoaiHocVienId == KeySetting.LOAIHOCVIEN_CHOLOP) { taiKhoan.IsRemove = 1; } else { taiKhoan.IsRemove = 0; } taiKhoan.LOAITAIKHOAN = Logic.LoaiTaiKhoanLogic.Select(taiKhoan.LoaiTaiKhoanId ?? 0); taiKhoan.TenDangNhap = taiKhoan.TenDangNhap; taiKhoan.MatKhau = O2S_Common.EncryptAndDecrypt.MD5EncryptAndDecrypt.Encrypt(taiKhoan.MatKhau, true); Database.TAIKHOANs.InsertOnSubmit(taiKhoan); Database.HOCVIENs.InsertOnSubmit(_hocVien); Database.SubmitChanges(); _hocVien.TAIKHOAN = TaiKhoanLogic.SelectSingle(taiKhoan.TaiKhoanId); _hocVienId = _hocVien.HocVienId; _hocVien.MaHocVien = string.Format("{0}{1:D7}", "HV", _hocVienId); //add ma hoc vien Database.SubmitChanges(); TAIKHOAN _tkUpdate = TaiKhoanLogic.SelectSingle(taiKhoan.TaiKhoanId); _tkUpdate.TenDangNhap = _hocVien.MaHocVien; _tkUpdate.MatKhau = O2S_Common.EncryptAndDecrypt.MD5EncryptAndDecrypt.Encrypt(_hocVien.MaHocVien, true); Database.SubmitChanges(); return(true); } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static bool XoaPhieuGhiDanh(PHIEUGHIDANH _phieuGD) { try { using (TransactionScope ts = new TransactionScope()) { //xoa HOCPHIHOCVIEN List <HOCPHIHOCVIEN> _lstHPHV = HocPhiHocVienLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId); if (_lstHPHV != null && _lstHPHV.Count > 0) { Database.HOCPHIHOCVIENs.DeleteAllOnSubmit(_lstHPHV); //Database.SubmitChanges(); } //Xoa bang PHIEUTHU; List <PHIEUTHU> _lstPhieuThu = PhieuThuLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId); if (_lstPhieuThu != null && _lstPhieuThu.Count > 0) { Database.PHIEUTHUs.DeleteAllOnSubmit(_lstPhieuThu); // Database.SubmitChanges(); } //update=Xoa bang PHIEUGHIDANH //PHIEUGHIDANH _phieuGDUpdate = SelectSingle(_phieuGD.PhieuGhiDanhId); _phieuGD.IsRemove = _phieuGD.IsRemove; _phieuGD.LyDoXoa = _phieuGD.LyDoXoa; _phieuGD.NguoiXoa = _phieuGD.NguoiXoa; _phieuGD.ModifiedDate = DateTime.Now; _phieuGD.ModifiedBy = GlobalSettings.UserCode; _phieuGD.ModifiedLog = GlobalSettings.SessionMyIP; //Database.SubmitChanges(); //cap nhat bang HOCVIEN va bang tai khoan: kiem tra HV hoc khoa nao ko? neu=1 thi update PhieuGhiDanhFilter _filter = new PhieuGhiDanhFilter(); _filter.HocVienId = _phieuGD.HocVienId; List <PhieuGhiDanh_PlusDTO> _PGD_Kiemtra = PhieuGhiDanhLogic.Select(_filter); if (_PGD_Kiemtra == null || _PGD_Kiemtra.Count <= 1) { HOCVIEN _hocvien = HocVienLogic.SelectSingle(_phieuGD.HocVienId ?? 0); _hocvien.LOAIHOCVIEN = LoaiHocVienLogic.Select(KeySetting.LOAIHOCVIEN_TIEMNANG); Database.SubmitChanges(); TAIKHOAN _taikhoan = TaiKhoanLogic.SelectTheoTenDangNhap(_hocvien.TAIKHOAN.TenDangNhap); _taikhoan.IsRemove = 1; //Database.SubmitChanges(); } //Kiem tra lop hoc va xoa bang diem List <BANGDIEM> _bangdiem = BangDiemLogic.SelectTheoPhieuGhiDanh(_phieuGD.PhieuGhiDanhId); if (_bangdiem != null && _bangdiem.Count > 0) { Database.BANGDIEMs.DeleteAllOnSubmit(_bangdiem); //Update So luong hoc vien trong lop hoc... LOPHOC _lopHoc = LopHocLogic.SelectSingle(_phieuGD.LopHocId ?? 0); if (_lopHoc != null) { _lopHoc.SiSo = (from p in Database.BANGDIEMs where p.LopHocId == (_phieuGD.LopHocId ?? 0) && p.IsRemove != 1 select p).Count(); _lopHoc.ModifiedDate = DateTime.Now; _lopHoc.ModifiedBy = GlobalSettings.UserCode; _lopHoc.ModifiedLog = GlobalSettings.SessionMyIP; Database.SubmitChanges(); } } Database.SubmitChanges(); ts.Complete(); return(true); } } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
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 bool InsertPGDFull(PHIEUGHIDANH _phieughidanh, PHIEUTHU _phieuthu, List <HOCPHIHOCVIEN> _lsthphv, 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(); } } //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); } }