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