private void DuyetPhanCapChucNang(HT_CNANG htCNang, ref List <HT_CNANG> lstHtCnang) { if (htCNang.ID_CNANG_CHA != null) { lstHtCnang.Add(htCNang); bool chkExist = false; foreach (HT_CNANG item in lstHtCnang) { if (item.ID == htCNang.ID_CNANG_CHA) { chkExist = true; break; } } HT_CNANG htCNangCha = new DS_HT_CNANG().GetById(htCNang.ID_CNANG_CHA.Value); if (!chkExist) { lstHtCnang.Add(htCNangCha); } if (htCNangCha.ID_CNANG_CHA != null) { DuyetPhanCapChucNang(htCNangCha, ref lstHtCnang); } } }
public bool Sua(HT_CNANG obj) { bool kq = true; Entities entities = ContextFactory.GetInstance(); EntityKey key = null; object original = null; try { key = entities.CreateEntityKey(ENTITY_SET_NAME, obj); if (entities.TryGetObjectByKey(key, out original)) { entities.ApplyCurrentValues(key.EntitySetName, obj); } entities.SaveChanges(); kq = true; } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { entities = null; } return(kq); }
public bool XoaListTheoID(List <int> listID) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { using (TransactionScope trans = new TransactionScope()) { foreach (int id in listID) { HT_CNANG obj = new HT_CNANG(); obj = entities.HT_CNANG.FirstOrDefault(e => e.ID == id); entities.DeleteObject(obj); entities.SaveChanges(); } trans.Complete(); } } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { entities = null; } return(kq); }
public bool HuyDuyetListTheoID(List <int> listID) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { using (TransactionScope trans = new TransactionScope()) { foreach (int id in listID) { HT_CNANG obj = new HT_CNANG(); obj = entities.HT_CNANG.FirstOrDefault(e => e.ID == id); obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.THOAI_DUYET.layGiaTri(); entities.SaveChanges(); } trans.Complete(); } } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { entities = null; } return(kq); }
private void Luu() { //Mouse.OverrideCursor = Cursors.Wait; try { string maTranPheDuyet = getObject(); DataRowView dr = (DataRowView)grDanhSach.SelectedItem; string maChucNang = dr["MA"].ToString(); HT_CNANG htCNang = new HT_CNANG(); htCNang.MA_CNANG = maChucNang; htCNang.MA_TRAN_PHE_DUYET = maTranPheDuyet; ApplicationConstant.ResponseStatus ret = ApplicationConstant.ResponseStatus.KHONG_THANH_CONG; string responseMessage = ""; ret = qtht.MaTranPheDuyet(ref htCNang, ref responseMessage); if (ret == ApplicationConstant.ResponseStatus.THANH_CONG) { LMessage.ShowMessage("Thiết lập ma trận phê duyệt thành công cho chức năng được chọn", LMessage.MessageBoxType.Information); } else { LMessage.ShowMessage(responseMessage, LMessage.MessageBoxType.Warning); } } catch (System.Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } //Mouse.OverrideCursor = Cursors.Arrow; }
private void InsertParrentTNKT(int idCNang, string maDoiTuong, int idDoiTuong, string loaiDoiTuong, string nguoiCapNhat) { try { Entities entities = ContextFactory.GetInstance(); HT_TNGUYEN_KTHAC obj = new HT_TNGUYEN_KTHAC(); string taiNguyenMenu = BusinessConstant.LoaiTaiNguyen.MENU.layGiaTri(); HT_CNANG cn = entities.HT_CNANG.FirstOrDefault(e => e.ID == idCNang); obj.GTRI_TNGUYEN = cn.ID.ToString(); obj.ID_TNGUYEN = cn.ID; obj.MA_TNGUYEN = cn.MA_CNANG; obj.ID_TNGUYEN_CHA = cn.ID_CNANG_CHA; if (cn.ID_CNANG_CHA != null) { obj.MA_TNGUYEN_CHA = entities.HT_CNANG.FirstOrDefault(e => e.ID == cn.ID_CNANG_CHA).MA_CNANG; } obj.TEN_TNGUYEN = cn.TEN_CNANG; obj.ID_DTUONG = idDoiTuong; obj.ID_TNGUYEN_LOAI = entities.HT_TNGUYEN_LOAI.FirstOrDefault(e => e.MA_TNGUYEN_LOAI.Equals(taiNguyenMenu)).ID; obj.MA_DTUONG = maDoiTuong; obj.MA_DTUONG_LOAI = loaiDoiTuong; obj.KIEU_DLIEU = "String"; obj.MA_DVI_QLY = entities.DM_DON_VI.First().MA_DVI; obj.MA_DVI_TAO = obj.MA_DVI_QLY; obj.MA_TNGUYEN_LOAI = BusinessConstant.LoaiTaiNguyen.MENU.layGiaTri(); obj.NGAY_CNHAT = DateTime.Today.ToString("yyyyMMdd"); obj.NGAY_NHAP = DateTime.Today.ToString("yyyyMMdd"); obj.NGUOI_CNHAT = nguoiCapNhat; obj.NGUOI_NHAP = nguoiCapNhat; obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri(); entities.HT_TNGUYEN_KTHAC.AddObject(obj); entities.SaveChanges(); if (cn.ID_CNANG_CHA != null) { InsertParrentTNKT(cn.ID_CNANG_CHA.Value, maDoiTuong, idDoiTuong, loaiDoiTuong, nguoiCapNhat); } } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } }
public ApplicationConstant.ResponseStatus LuuMaTranPheDuyet( ref THONG_TIN_CHUNG objThongTinChung, ref HT_CNANG htCNang, ref ApplicationConstant.QuanTriHeThongResponseMessage responseMessage, ref BS_ResponseDetail bsRetDetail) { bool kq = true; try { using (TransactionScope trans = new TransactionScope()) { DS_HT_CNANG dsHtCNang = new DS_HT_CNANG(); HT_CNANG obj = dsHtCNang.GetByMa(htCNang.MA_CNANG); obj.MA_TRAN_PHE_DUYET = htCNang.MA_TRAN_PHE_DUYET; kq = dsHtCNang.Sua(obj); if (kq) { trans.Complete(); responseMessage = ApplicationConstant.QuanTriHeThongResponseMessage.M_ResponseMessage_QuanTriHeThong_ThanhCong; bsRetDetail.Result = ApplicationConstant.OperationStatus.Successful.layNgonNgu(); bsRetDetail.Detail = responseMessage.layGiaTri(); htCNang = obj; return(ApplicationConstant.ResponseStatus.THANH_CONG); } else { responseMessage = ApplicationConstant.QuanTriHeThongResponseMessage.M_ResponseMessage_QuanTriHeThong_KhongThanhCong; bsRetDetail.Result = ApplicationConstant.OperationStatus.Failed.layNgonNgu(); bsRetDetail.Detail = responseMessage.layGiaTri(); return(ApplicationConstant.ResponseStatus.KHONG_THANH_CONG); } } } catch (Exception ex) { responseMessage = ApplicationConstant.QuanTriHeThongResponseMessage.M_ResponseMessage_QuanTriHeThong_KhongThanhCong; bsRetDetail.Result = ApplicationConstant.OperationStatus.Failed.layNgonNgu(); bsRetDetail.Detail = responseMessage.layGiaTri(); LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } }
public bool Xoa(HT_CNANG obj) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { entities.DeleteObject(obj); entities.SaveChanges(); } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { entities = null; } return(kq); }
public HT_CNANG GetByMa(string ma) { HT_CNANG kq = null; Entities entities = ContextFactory.GetInstance(); try { kq = entities.HT_CNANG.FirstOrDefault(e => e.MA_CNANG.Equals(ma)); return(kq); } catch (System.Exception ex) { kq = null; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } finally { entities = null; } return(kq); }
public ApplicationConstant.ResponseStatus MaTranPheDuyet(DatabaseConstant.Action action, ref THONG_TIN_CHUNG objThongTinChung, ref List <BS_ResponseDetail> lstResponseDetail, ref HT_CNANG obj, ref ApplicationConstant.QuanTriHeThongResponseMessage responseMessage) { ApplicationConstant.ResponseStatus responseStatus = new ApplicationConstant.ResponseStatus(); BS_ResponseDetail responseDetail = new BS_ResponseDetail(); switch (action) { case DatabaseConstant.Action.LUU: //Luu responseStatus = new BS_QuanTriHeThong_Action().MaTranPheDuyet_Luu(ref objThongTinChung, ref obj, ref responseMessage, ref responseDetail); break; default: responseStatus = ApplicationConstant.ResponseStatus.KHONG_THANH_CONG; responseMessage = ApplicationConstant.QuanTriHeThongResponseMessage.M_ResponseMessage_QuanTriHeThong_KhongThanhCong; break; } lstResponseDetail.Add(responseDetail); return(responseStatus); }
public bool luuPhanQuyen(string maDoiTuong, string loaiDoiTuong, ArrayList lstPhanQuyen, string nguoiCapNhat) { try { using (TransactionScope trans = new TransactionScope()) { Entities entities = ContextFactory.GetInstance(); List <string> lstMaCNang = new List <string>(); string taiNguyenMenu = BusinessConstant.LoaiTaiNguyen.MENU.layGiaTri(); foreach (List <string> lst in lstPhanQuyen) { // Xóa hết phân quyền cũ foreach (string tn in lst) { HT_TNGUYEN_KTHAC tnkt = entities.HT_TNGUYEN_KTHAC.FirstOrDefault(e => e.MA_DTUONG.Equals(maDoiTuong) && e.MA_DTUONG_LOAI.Equals(loaiDoiTuong) && e.MA_TNGUYEN.Equals(tn) && e.MA_TNGUYEN_LOAI.Equals(taiNguyenMenu)); if (tnkt != null) { entities.HT_TNGUYEN_KTHAC.DeleteObject(tnkt); entities.SaveChanges(); } if (lst.IndexOf(tn) > 0) { if (!lstMaCNang.Contains(tn)) { lstMaCNang.Add(tn); } // ID của tính năng được gán vào tham số Capacity khi khởi tạo list phía client int idTinhNang = Convert.ToInt32(lst.First()); HT_CNANG_TNANG cntn = entities.HT_CNANG_TNANG.FirstOrDefault(e => e.MA_CNANG.Equals(tn) && e.ID_TNANG == idTinhNang); // ID của tính năng được lưu trong trường GTRI_TNGUYEN HT_CNANG_PQUYEN cnpq = entities.HT_CNANG_PQUYEN.FirstOrDefault(e => e.MA_DTUONG.Equals(maDoiTuong) && e.MA_DTUONG_LOAI.Equals(loaiDoiTuong) && e.ID_CNANG_TNANG == cntn.ID); if (cnpq != null) { entities.HT_CNANG_PQUYEN.DeleteObject(cnpq); entities.SaveChanges(); } } } foreach (string tn in lst) { if (lst.IndexOf(tn) > 0) { HT_CNANG_PQUYEN obj = new HT_CNANG_PQUYEN(); // ID của tính năng được gán vào tham số Capacity khi khởi tạo list phía client int idTinhNang = Convert.ToInt32(lst.First()); HT_CNANG_TNANG cntn = entities.HT_CNANG_TNANG.FirstOrDefault(e => e.MA_CNANG.Equals(tn) && e.ID_TNANG == idTinhNang); obj.ID_CNANG_TNANG = cntn.ID; if (loaiDoiTuong.Equals(BusinessConstant.LoaiDoiTuong.NGUOI_SDUNG.layGiaTri())) { obj.ID_DTUONG = entities.HT_NSD.FirstOrDefault(e => e.MA_NSD.Equals(maDoiTuong)).ID; } if (loaiDoiTuong.Equals(BusinessConstant.LoaiDoiTuong.NHOM_NGUOI_SDUNG.layGiaTri())) { obj.ID_DTUONG = entities.HT_NHNSD.FirstOrDefault(e => e.MA_NHNSD.Equals(maDoiTuong)).ID; } obj.MA_DTUONG = maDoiTuong; obj.MA_DTUONG_LOAI = loaiDoiTuong; obj.MA_DVI_QLY = entities.HT_NSD.FirstOrDefault(e => e.MA_DANG_NHAP.ToLower().Equals(nguoiCapNhat.ToLower())).MA_DVI_QLY; obj.MA_DVI_TAO = obj.MA_DVI_QLY; obj.NGAY_CNHAT = DateTime.Today.ToString("yyyyMMdd"); obj.NGAY_NHAP = DateTime.Today.ToString("yyyyMMdd"); obj.NGUOI_CNHAT = nguoiCapNhat; obj.NGUOI_NHAP = nguoiCapNhat; obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri(); entities.HT_CNANG_PQUYEN.AddObject(obj); entities.SaveChanges(); } } } // Tạo quyền mới foreach (string maCNang in lstMaCNang) { HT_TNGUYEN_KTHAC obj = new HT_TNGUYEN_KTHAC(); HT_CNANG cn = entities.HT_CNANG.FirstOrDefault(e => e.MA_CNANG.Equals(maCNang)); obj.GTRI_TNGUYEN = cn.ID.ToString(); obj.ID_TNGUYEN = cn.ID; obj.MA_TNGUYEN = cn.MA_CNANG; obj.ID_TNGUYEN_CHA = cn.ID_CNANG_CHA; if (cn.ID_CNANG_CHA != null) { obj.MA_TNGUYEN_CHA = entities.HT_CNANG.FirstOrDefault(e => e.ID == cn.ID_CNANG_CHA).MA_CNANG; } obj.TEN_TNGUYEN = cn.TEN_CNANG; if (loaiDoiTuong.Equals(BusinessConstant.LoaiDoiTuong.NGUOI_SDUNG.layGiaTri())) { obj.ID_DTUONG = entities.HT_NSD.FirstOrDefault(e => e.MA_NSD.Equals(maDoiTuong)).ID; } if (loaiDoiTuong.Equals(BusinessConstant.LoaiDoiTuong.NHOM_NGUOI_SDUNG.layGiaTri())) { obj.ID_DTUONG = entities.HT_NHNSD.FirstOrDefault(e => e.MA_NHNSD.Equals(maDoiTuong)).ID; } obj.ID_TNGUYEN_LOAI = entities.HT_TNGUYEN_LOAI.FirstOrDefault(e => e.MA_TNGUYEN_LOAI.Equals(taiNguyenMenu)).ID; obj.MA_DTUONG = maDoiTuong; obj.MA_DTUONG_LOAI = loaiDoiTuong; obj.KIEU_DLIEU = "String"; obj.MA_DVI_QLY = entities.DM_DON_VI.First().MA_DVI; obj.MA_DVI_TAO = obj.MA_DVI_QLY; obj.MA_TNGUYEN_LOAI = BusinessConstant.LoaiTaiNguyen.MENU.layGiaTri(); obj.NGAY_CNHAT = DateTime.Today.ToString("yyyyMMdd"); obj.NGAY_NHAP = DateTime.Today.ToString("yyyyMMdd"); obj.NGUOI_CNHAT = nguoiCapNhat; obj.NGUOI_NHAP = nguoiCapNhat; obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.DA_DUYET.layGiaTri(); entities.HT_TNGUYEN_KTHAC.AddObject(obj); entities.SaveChanges(); if (cn.ID_CNANG_CHA != null) { InsertParrentTNKT(cn.ID_CNANG_CHA.Value, maDoiTuong, obj.ID_DTUONG, loaiDoiTuong, nguoiCapNhat); } } trans.Complete(); return(true); } } catch (Exception ex) { LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } }
public ApplicationConstant.ResponseStatus MaTranPheDuyet_Luu(ref THONG_TIN_CHUNG objThongTinChung, ref HT_CNANG obj, ref ApplicationConstant.QuanTriHeThongResponseMessage responseMessage, ref BS_ResponseDetail bsRetDetail) { //Xử lý nghiệp vụ return(new BS_ChucNang_Detail().LuuMaTranPheDuyet(ref objThongTinChung, ref obj, ref responseMessage, ref bsRetDetail)); }