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 BarItemVisibility KiemTraChucNang_Form(string _machucnang) { BarItemVisibility result = BarItemVisibility.Never; try { if (GlobalSettings.UserCode == KeyTrongPhanMem.AdminUser_key) { result = BarItemVisibility.Always; } else { PHANQUYENTAIKHOAN _phanquyen = PhanQuyenTaiKhoanLogic.SelectTheoMaChucNang(_machucnang); if (_phanquyen != null) { result = BarItemVisibility.Always; } } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } return(result); }
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 Delete(int _hocvienId) //xoa hoc vien { try { using (TransactionScope ts = new TransactionScope()) { //Xoa LICHSUTUVAN List <LICHSUTUVAN> _lstTuVan = LichSuTuVanLogic.SelectTheoHocVien(_hocvienId); if (_lstTuVan != null && _lstTuVan.Count > 0) { Database.LICHSUTUVANs.DeleteAllOnSubmit(_lstTuVan); } //Xoa PHIEUGHIDANH List <PHIEUGHIDANH> _lstPhieuGD = PhieuGhiDanhLogic.SelectTheoHocVien(_hocvienId); if (_lstPhieuGD != null && _lstPhieuGD.Count > 0) { Database.PHIEUGHIDANHs.DeleteAllOnSubmit(_lstPhieuGD); } //XOA HOCVIENs var temp = SelectSingle(_hocvienId); //int _loaihocvien = temp.LoaiHocVienId ?? 0; int _TaiKhoanId = temp.TaiKhoanId ?? 0; Database.HOCVIENs.DeleteOnSubmit(temp); //Xoa tai khoan //Xoa phan quyen tai khoan List <PHANQUYENTAIKHOAN> _lstPhanQuyen = PhanQuyenTaiKhoanLogic.SelectTheoTaiKhoan(_TaiKhoanId); Database.PHANQUYENTAIKHOANs.DeleteAllOnSubmit(_lstPhanQuyen); var temp_TK = (from p in Database.TAIKHOANs where p.TaiKhoanId == _TaiKhoanId select p).Single(); Database.TAIKHOANs.DeleteOnSubmit(temp_TK); Database.SubmitChanges(); ts.Complete(); return(true); } } catch (System.Exception ex) { return(false); O2S_Common.Logging.LogSystem.Error(ex); } }
public static void Delete(int _TaiKhoanId) { try { //Xoa phan quyen tai khoan List <PHANQUYENTAIKHOAN> _lstPhanQuyen = PhanQuyenTaiKhoanLogic.SelectTheoTaiKhoan(_TaiKhoanId); Database.PHANQUYENTAIKHOANs.DeleteAllOnSubmit(_lstPhanQuyen); var temp = (from p in Database.TAIKHOANs where p.TaiKhoanId == _TaiKhoanId select p).Single(); Database.TAIKHOANs.DeleteOnSubmit(temp); Database.SubmitChanges(); } catch (System.Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } }
private void LoadPhanQuyenTheoTaiKhoan(int _taikhoanId) { try { gridControlChucNang.DataSource = null; gridControlBaoCao.DataSource = null; this.lstPQ_TK_ChucNang = new List <PhanQuyenTaiKhoan_PlusDTO>(); this.lstPQ_TK_BaoCao = new List <PhanQuyenTaiKhoan_PlusDTO>(); List <PhanQuyenTaiKhoan_PlusDTO> _lstPQ_TK_All = PhanQuyenTaiKhoanLogic.SelectKieuPhanQuyen(_taikhoanId); this.lstPQ_TK_ChucNang = _lstPQ_TK_All.Where(o => o.LoaiChucNangId != 3).ToList(); gridControlChucNang.DataSource = this.lstPQ_TK_ChucNang; this.lstPQ_TK_BaoCao = _lstPQ_TK_All.Where(o => o.LoaiChucNangId == 3).ToList(); gridControlBaoCao.DataSource = this.lstPQ_TK_BaoCao; } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(ex); } }
public static bool KiemTraChucNang_Nut(string _machucnang, ButtonEnum _button) { bool result = false; try { if (GlobalSettings.UserCode == KeyTrongPhanMem.AdminUser_key) { result = true; } else { PHANQUYENTAIKHOAN _phanquyen = PhanQuyenTaiKhoanLogic.SelectTheoMaChucNang(_machucnang); if (_phanquyen != null) { switch (_button) { case ButtonEnum.Them: { result = _phanquyen.Them == 1 ? true : false; break; } case ButtonEnum.Sua: { result = _phanquyen.Sua == 1 ? true : false; break; } case ButtonEnum.Xoa: { result = _phanquyen.Xoa == 1 ? true : false; break; } case ButtonEnum.In: { result = _phanquyen.InAn == 1 ? true : false; break; } case ButtonEnum.XuatFile: { result = _phanquyen.XuatFile == 1 ? true : false; break; } default: { break; } } } } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Error(ex); } return(result); }
private void btnLuuThongTin_Click(object sender, EventArgs e) { try { if (this.TaiKhoan_Select != null) { //Update TAIKHOAN: passs this.TaiKhoan_Select.MatKhau = txtMatKhau.Text; //Update PHANQUYENTAIKHOAN List <PHANQUYENTAIKHOAN> _lstPQ_TK_All = new List <PHANQUYENTAIKHOAN>(); foreach (var _item in this.lstPQ_TK_ChucNang) { if (_item.IsCheck) { PHANQUYENTAIKHOAN _phanquyen = new PHANQUYENTAIKHOAN { TaiKhoanId = this.TaiKhoan_Select.TaiKhoanId, ChucNangId = _item.ChucNangId, Them = _item.Them == true ? 1 : 0, Sua = _item.Sua == true ? 1 : 0, Xoa = _item.Xoa == true ? 1 : 0, InAn = _item.InAn == true ? 1 : 0, XuatFile = _item.XuatFile == true ? 1 : 0, }; _lstPQ_TK_All.Add(_phanquyen); } } foreach (var _item in this.lstPQ_TK_BaoCao) { if (_item.IsCheck) { PHANQUYENTAIKHOAN _phanquyen = new PHANQUYENTAIKHOAN { TaiKhoanId = this.TaiKhoan_Select.TaiKhoanId, ChucNangId = _item.ChucNangId, Them = _item.Them == true ? 1 : 0, Sua = _item.Sua == true ? 1 : 0, Xoa = _item.Xoa == true ? 1 : 0, InAn = _item.InAn == true ? 1 : 0, XuatFile = _item.XuatFile == true ? 1 : 0, }; _lstPQ_TK_All.Add(_phanquyen); } } if (TaiKhoanLogic.Update(this.TaiKhoan_Select) && PhanQuyenTaiKhoanLogic.DeleteAndInsert(_lstPQ_TK_All, this.TaiKhoan_Select.TaiKhoanId)) { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THANH_CONG); frmthongbao.Show(); } else { O2S_Common.Utilities.ThongBao.frmThongBao frmthongbao = new O2S_Common.Utilities.ThongBao.frmThongBao(Base.ThongBaoLable.CAP_NHAT_THAT_BAI); frmthongbao.Show(); } } } catch (Exception ex) { O2S_Common.Logging.LogSystem.Warn(ex); } }