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);
}
}
