public ActionResult Delete(List <PhanQuyen> phanQuyens) { try { db.Configuration.ValidateOnSaveEnabled = false; var checkIsChecked = phanQuyens.Where(x => x.IsChecked == true).FirstOrDefault(); if (checkIsChecked == null) { this.AddNotification("Vui lòng chọn phân quyền để xóa!", NotificationType.ERROR); return(RedirectToAction("Index")); } foreach (var item in phanQuyens) { if (item.IsChecked == true) { int maQuyen = item.MaQuyen; PhanQuyen quyen = db.PhanQuyens.Where(x => x.MaQuyen == maQuyen).SingleOrDefault(); if (quyen != null) { db.PhanQuyens.Remove(quyen); db.SaveChanges(); } } } return(RedirectToAction("Index")); } catch { this.AddNotification("Không thể xóa vì quyền này đã và đang được sử dụng!", NotificationType.ERROR); return(RedirectToAction("Index")); } }
public static Boolean CapNhatLaiQuyen(String MaQuyen, String strMaAction) { var entity = new QuanLyThueXeEntities(); try { var lstQuyen = entity.PhanQuyens.Where(n => n.MaQuyen == MaQuyen); foreach (var q in lstQuyen) { entity.PhanQuyens.Remove(q); } entity.SaveChanges(); if (!string.IsNullOrEmpty(strMaAction)) { var arrMaAction = strMaAction.Split('#'); foreach (var action in arrMaAction) { var phanQuyen = new PhanQuyen(); phanQuyen.MaQuyen = MaQuyen; phanQuyen.MaAction = int.Parse(action); entity.PhanQuyens.Add(phanQuyen); } entity.SaveChanges(); } return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
private void ItemMnuSystemLogin_Click(object sender, EventArgs e) { if (!MyApp.gConnected) { frmLogin digForm = new frmLogin(); digForm.ShowDialog(); } else { if (MessageBox.Show("Có chắc chắn bỏ kết nối?", "Đăng xuất", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { MyApp.gConnected = false; frmMain.Current.ItemMnuLoginChange = "Đăng nhập"; #region "Members" UserInformation.Code = ""; UserInformation.Pass = ""; UserInformation.MaNV = ""; UserInformation.MaDV = ""; UserInformation.Name = ""; UserInformation.CheckPass = ""; UserInformation.PQ = ""; #endregion PhanQuyen.HideAll(); //ẩn tất cả các menu frmLogin digForm = new frmLogin(); digForm.ShowDialog(); } } }
private void btnOKPhanQuyen_Click(object sender, EventArgs e) { List <int> danhsachquyen = new List <int>(); for (int i = 0; i < clbPhanQuyen.ItemCount; i++) { if (clbPhanQuyen.GetItemChecked(i)) { danhsachquyen.Add((int)clbPhanQuyen.GetItemValue(i)); } } int gid = int.Parse(cbbGID.SelectedValue.ToString()); phanQuyenBUS.Xoa(new PhanQuyen(gid, -1)); bool thanhcong = false; foreach (int maquyen in danhsachquyen) { PhanQuyen phanQuyen = new PhanQuyen(gid, maquyen); thanhcong = phanQuyenBUS.CapNhat(phanQuyen); } if (thanhcong) { MessageBox.Show("Cập nhật thành công"); bangPhanQuyen = phanQuyenBUS.DanhSach(); PhanQuyenTheoGID(); isModified = true; } else { MessageBox.Show("Lỗi"); } }
public ActionResult Edit(PhanQuyen phanQuyen) { if (ModelState.IsValid) { if (phanQuyen.id != null) { if (phanQuyen.Quyen == false)//user { phanQuyen.mVanban = true; phanQuyen.mTheloaiTin = false; phanQuyen.mLoaiTin = false; phanQuyen.mTinTuc = false; phanQuyen.mTaiLieu = true; phanQuyen.mGioiThieu = false; phanQuyen.mLienHe = false; phanQuyen.mLoaivanban = true; phanQuyen.mQuantri = false; } else { phanQuyen.mVanban = true; phanQuyen.mTheloaiTin = true; phanQuyen.mLoaiTin = true; phanQuyen.mTinTuc = true; phanQuyen.mTaiLieu = true; phanQuyen.mGioiThieu = true; phanQuyen.mLienHe = true; phanQuyen.mLoaivanban = true; phanQuyen.mQuantri = true; } try { db.Entry(phanQuyen).State = EntityState.Modified; db.SaveChanges(); ViewBag.tam = 1; ViewBag.Message = "Update data success!"; } catch { ViewBag.tam = 2; ViewBag.Message = "Update data failed!"; } } else { ViewBag.tam = 2; ViewBag.Message = "The input data is empty!"; } } var user = db.users .Select(s => new { id = s.id, username = s.id + " - " + s.name }).ToList(); ViewBag.id = new SelectList(user, "id", "username", phanQuyen.id); return(View(phanQuyen)); }
private void Barbtnphanquyen_ItemClick(object sender, ItemClickEventArgs e) { PhanQuyen phanQuyen = new PhanQuyen(); phanQuyen.MdiParent = this; phanQuyen.Show(); }
public ActionResult Add(QuyenMeta model) { if (ModelState.IsValid) { try { var obj = Db.PhanQuyens.FirstOrDefault(x => x.TenQuyen == model.TenQuyen); if (obj == null) { var phanQuyen = new PhanQuyen { TenQuyen = model.TenQuyen, DanhSach = "," + string.Join(",", model.DanhSach) + "," }; Db.PhanQuyens.Add(phanQuyen); Db.SaveChanges(); TempData["notice"] = "Thêm thành công!"; return(RedirectToAction("Index")); } else { TempData["notice"] = "Tên quyền đã tồn tại!"; } } catch { TempData["notice"] = "Thêm không thành công!"; } } return(View(model)); }
public List <PhanQuyen> gltsPhanQuyen() { using (SqlConnection cnnPhanquyen = new SqlConnection(connect.Chuoiketnoi())) { List <PhanQuyen> gltsPhanQuyen = new List <PhanQuyen>(); using (SqlCommand cmdPhanquen = new SqlCommand("spSelectPhanQuyen", cnnPhanquyen)) { cmdPhanquen.CommandType = CommandType.StoredProcedure; cnnPhanquyen.Open(); SqlDataReader dar = cmdPhanquen.ExecuteReader(); if (dar.HasRows) { while (dar.Read()) { PhanQuyen phanQuyen = new PhanQuyen(); phanQuyen.PK_iPhanQuyenID = Convert.ToInt32(dar["PK_iPhanquyenID"]); phanQuyen.FK_iQuyenID = Convert.ToInt32(dar["FK_iQuyenID"]); phanQuyen.FK_iCanBoID = Convert.ToInt32(dar["FK_iCanboID"]); phanQuyen.DThoigianbatdau = Convert.ToDateTime(dar["tThoigianbatdau"]); phanQuyen.DThoigianketthuc = Convert.ToDateTime(dar["tThoigianketthuc"]); gltsPhanQuyen.Add(phanQuyen); } } return(gltsPhanQuyen); } } }
public void CapNhatPhanQuyen(string mamanhinh, string manhom, bool coquyen) { PhanQuyen pq = qlcf.PhanQuyens.Where(t => t.MaManHinh == mamanhinh && t.MaNhomNV == manhom).FirstOrDefault(); pq.CoQuyen = coquyen; qlcf.SubmitChanges(); }
public async Task <IActionResult> PutPhanQuyen(int id, PhanQuyen phanQuyen) { if (id != phanQuyen.IdPQ) { return(BadRequest()); } _context.Entry(phanQuyen).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PhanQuyenExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult AddOrEdit(PhanQuyen pq) { using (DBNoiThat db = new DBNoiThat()) { if (pq.ID == 0) { if (db.PhanQuyens.Where(p => p.Ten == pq.Ten).FirstOrDefault() != null) { return(Json(new { success = false, message = "Quyền này đã tồn tại!" }, JsonRequestBehavior.AllowGet)); } db.PhanQuyens.Add(pq); db.SaveChanges(); return(Json(new { success = true, message = "Thêm mới thành công!" }, JsonRequestBehavior.AllowGet)); } else { try { db.Entry(pq).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { success = false, message = "Cập nhật thất bại!" }, JsonRequestBehavior.AllowGet)); } } } }
protected override bool AuthorizeCore(HttpContextBase httpContext) { //Lay thong tin luu vao session objNguoiDung = (NguoiDung)HttpContext.Current.Session["useronline"]; if (objNguoiDung != null) { //Lay thong tin vai tro int vaiTroId = objNguoiDung.VaiTroId; ChucNang objChucNang = DataProvider.ShopEntities.ChucNangs.Where(p => p.TenForm.Equals(tenChucNang)).First(); if (objChucNang != null) { PhanQuyen objPhanQuyen = null; try { objPhanQuyen = DataProvider.ShopEntities.PhanQuyens.Where(p => p.VaiTroId != null && p.VaiTroId == vaiTroId && p.ChucNangId == objChucNang.Id).First <PhanQuyen>(); if (objPhanQuyen != null && objPhanQuyen.Xem.HasValue) { if (objPhanQuyen.Xem.Value) { return(true); } } } catch { } } } return(false); }
public bool Index(PhanQuyen data) { string id = data.AutoId(); data.id = id; return(Index(_default_index, data, "", id)); }
//Thêm mới public JsonResult ThemJson(int vaiTroId, int chucNangChuaCapId, bool xem, bool them, bool sua, bool xoa) { //Khai báo 1 đối tượng PhanQuyen objPhanQuyen = new PhanQuyen(); //Gán giá trị objPhanQuyen.VaiTroId = vaiTroId; objPhanQuyen.ChucNangId = chucNangChuaCapId; objPhanQuyen.Xem = xem; objPhanQuyen.Them = them; objPhanQuyen.Sua = sua; objPhanQuyen.Xoa = xoa; foreach (PhanQuyen x in DataProvider.ShopEntities.PhanQuyens.ToList()) { if (chucNangChuaCapId == x.ChucNangId && vaiTroId == x.VaiTroId) { return(Json(1, JsonRequestBehavior.DenyGet)); } } //Thực hiện thêm và lưu sự thay đổi DataProvider.ShopEntities.PhanQuyens.Add(objPhanQuyen); DataProvider.ShopEntities.SaveChanges(); return(Json("Thêm thành công", JsonRequestBehavior.AllowGet)); }
//Kiểm tra quyền: thêm, sửa, xóa public void CheckPermission(string formName) { NguoiDung objUser = null; objUser = HttpContext.Current.Session[CommonAdmin.ConstantData.USER_SESSION] as NguoiDung; if (objUser != null) { //Lấy đối tượng chức năng theo tên form ChucNang objChucNang = DataProvider.Entities.ChucNangs.Where(p => p.TenForm.Equals(formName)).First(); //Nếu tồn tại chức năng if (objChucNang != null) { //Lấy vai trò id int vaiTroId = objUser.VaiTroId.HasValue ? objUser.VaiTroId.Value : 0; int chucNangId = objChucNang.Id; //Lấy quyền của chức năng tương ứng với chức năng, vai trò PhanQuyen objQuyen = DataProvider.Entities.PhanQuyens.Where(p => p.VaiTroId == vaiTroId && p.ChucNangId == chucNangId).First(); if (objQuyen != null) { isXem = objQuyen.Xem.HasValue ? objQuyen.Xem.Value : false; isThem = objQuyen.Them.HasValue ? objQuyen.Them.Value : false; isSua = objQuyen.Sua.HasValue ? objQuyen.Sua.Value : false; isXoa = objQuyen.Xoa.HasValue ? objQuyen.Xoa.Value : false; } } } }
private void sgdmPermission_CellClick(object sender, GridCellClickEventArgs e) { if (nsd.IsAdmin) { int numberPermis = 0x0000; if (e.GridCell.GridRow["ID"].Value.ToString() != null) { if (e.GridCell.GridRow["Xem"].Value.Equals(true)) { numberPermis |= 0x0001; } if (e.GridCell.GridRow["ThemMoi"].Value.Equals(true)) { numberPermis |= 0x0002; } if (e.GridCell.GridRow["Sua"].Value.Equals(true)) { numberPermis |= 0x0004; } if (e.GridCell.GridRow["Xoa"].Value.Equals(true)) { numberPermis |= 0x0008; } } PhanQuyen pquyen = new PhanQuyen(); int idFun = Convert.ToInt32(e.GridCell.GridRow["ID"].Value.ToString()); userDB.EditPermissionForUser(infoUserNow.UserName, idFun, numberPermis); } else { MessageBox.Show("Bạn không có quyền trong chức năng phân quyền!"); } }
public int AddPQ(PhanQuyen PQ) { try { db.PhanQuyens.Add(PQ); db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Debug.WriteLine("- Entity of type \"{0}\", in state \"{1}\" has the following validation errors: ", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } catch (Exception e) { Debug.WriteLine(e.Message); throw; } return(PQ.ID); }
/// <summary> /// Get obj phân quyền đưa lên modal edit /// </summary> /// <param name="id"></param> /// <param name="vaitroid"></param> /// <returns></returns> public ActionResult GetObjToEdit(string id, string vaitroid) { try { if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(vaitroid)) { int idcn = -1; //id phân quyền int idvaitro = -1; //id vai trò int.TryParse(id, out idcn); int.TryParse(vaitroid, out idvaitro); if (idcn > 0 && idvaitro > 0) { PhanQuyen obj = DataProvider.Entities.PhanQuyens.Where(p => p.VaiTroId == idvaitro && p.ChucNangId == idcn).First(); //Tạo đối tượng trả về PhanQuyen objReturn = new PhanQuyen(); string tenvaitro = obj.VaiTro.TenVaiTro; return(Json(new { tenvaitro = obj.VaiTro.TenVaiTro, chucnangthem = obj.Them, chucnangsua = obj.Sua, chucnangxoa = obj.Xoa, chucnangbaocao = obj.BaoCao, chucnangxem = obj.Xem }, JsonRequestBehavior.AllowGet)); } } return(Json(new VaiTro(), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new JsonPostBack("Có lỗi xảy ra", false), JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Xóa quền theo list chức năng Id /// </summary> /// <param name="id"> vai trò id</param> /// <param name="itemId"> list chức năng Id</param> /// <returns></returns> public JsonResult Delete(string id, string itemId) { int vaitroId = -1; string[] lstIdChucNang; if (!string.IsNullOrEmpty(itemId)) { lstIdChucNang = itemId.Split('-'); } else { return(Json(new JsonPostBack("Xóa thành công", false), JsonRequestBehavior.AllowGet)); } try { int.TryParse(id, out vaitroId); if (vaitroId > 0) { foreach (var item in lstIdChucNang) { int Idchucnang = int.Parse(item); PhanQuyen obj = DataProvider.Entities.PhanQuyens.Where(x => x.ChucNangId == Idchucnang && x.VaiTroId == vaitroId).First(); DataProvider.Entities.PhanQuyens.Remove(obj); } DataProvider.Entities.SaveChanges(); QuanTri.SaveLog("Cấp quyền và chức năng", "Phân quyền", (int)CommonAdmin.ConstantCommon.Action.Add); return(Json(new JsonPostBack("Xóa thành công", true), JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new JsonPostBack("Xóa thất bại", false), JsonRequestBehavior.AllowGet)); } return(Json(new JsonPostBack("Xóa thất bại", false), JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult <PhanQuyen> > PostPhanQuyen(PhanQuyen phanQuyen) { _context.PhanQuyens.Add(phanQuyen); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPhanQuyen", new { id = phanQuyen.IdPQ }, phanQuyen)); }
public ActionResult SetFunc(int sMaDM, string sMaCN, string sMaNV, string sCHK) { sMaNV = sMaNV.ToLower(); sMaNV = sMaNV.Replace(",undefined", ""); sMaNV = sMaNV.Replace(",on", ""); sMaNV = sMaNV.Replace(",false", ""); sMaNV = sMaNV.Replace(",true", ""); string[] nd = sMaNV.Split(','); int len = nd.Length; if (len > 0) { for (int y = 1; y < len; y++) { int manv = int.Parse(nd[y].ToString()); var check_nvcn = from a in db.NhanVienChucNangs where a.MaNV == manv && a.MaDM == sMaDM && a.MaCN.Equals(sMaCN) select a; var check_nvcn2 = from a in db.NhanVienChucNangs where a.MaNV == manv && a.MaDM == sMaDM select a; if (check_nvcn.Count() > 0) { db.NhanVienChucNangs.RemoveRange(db.NhanVienChucNangs.Where(d => d.MaNV == manv && d.MaDM == sMaDM && d.MaCN.Equals(sMaCN))); } if (check_nvcn2.Count() > 0) { db.PhanQuyens.RemoveRange(db.PhanQuyens.Where(d => d.MaNV == manv && d.MaDM == sMaDM)); } var nvcn = from a in db.NhanVienChucNangs where a.MaNV == manv && a.MaDM == sMaDM && a.MaCN.Equals(sMaCN) select a; if (nvcn.Count() == 0 && sCHK == "true") { var checkpq = from a in db.PhanQuyens where a.MaDM == sMaDM && a.MaNV == manv select a; if (checkpq.Count() == 0) { PhanQuyen pq = new PhanQuyen(); pq.MaDM = sMaDM; pq.MaNV = manv; db.PhanQuyens.Add(pq); } NhanVienChucNang tb = new NhanVienChucNang(); tb.MaNV = manv; tb.MaDM = sMaDM; tb.MaCN = sMaCN; db.NhanVienChucNangs.Add(tb); } db.SaveChanges(); } } return(Json("1", JsonRequestBehavior.AllowGet)); }
public bool Update(PhanQuyen data) { string id = $"{data.id}"; data.id = string.Empty; return(Update(_default_index, data, id)); }
// HIen thi danh sach ChucNang private void HienThiDanhSAchChucNang(PhanQuyen pqs) { List <PhanQuyen> pqlist = pqbll.ShowListDetailsPermission(pqs); foreach (PhanQuyen pq_1 in pqlist) { } }
public ActionResult DeleteConfirmed(int id) { PhanQuyen phanQuyen = db.PhanQuyens.Find(id); db.PhanQuyens.Remove(phanQuyen); db.SaveChanges(); return(RedirectToAction("Index")); }
public bool DeleteAll(PhanQuyen phanquyen) { string query = "DELETE FROM PhanQuyen WHERE GID = @GID"; SqlParameter[] sqlParameters = new SqlParameter[1]; sqlParameters[0] = new SqlParameter("@GID", SqlDbType.Int); sqlParameters[0].Value = phanquyen.GID; return(executeDeleteQuery(query, sqlParameters)); }
public ActionResult DanhSachSanPham(string txtTuKhoa, string txtNgayBatDau, string txtNgayKetThuc, int?loaiSanPham, int?hangSanXuat, int?chuDe, string xuatXu, string txtGiaStart, string txtGiaEnd) { //Lấy VaiTroId và các quyền var vaiTroId = Int32.Parse(Session["VaiTroId"].ToString()); PhanQuyen objPhanQuyen = DataProvider.ShopEntities.PhanQuyens.Where(p => p.VaiTroId != null && p.VaiTroId == vaiTroId && p.ChucNangId == 46).First <PhanQuyen>(); //Gán các nút hiển thị ViewBag.Them = objPhanQuyen.Them == true ? "normal" : "none"; ViewBag.Sua = objPhanQuyen.Sua == true ? "normal" : "none"; ViewBag.Xoa = objPhanQuyen.Xoa == true ? "normal" : "none"; CultureInfo ci = new CultureInfo("vi-VN"); HienThiChuDe(); HienThiHangSanXuat(); HienThiLoaiSanPham(); HienThiXuatXu(); IQueryable <SanPham> lstDanhSachSP = DataProvider.ShopEntities.SanPhams; if (!string.IsNullOrEmpty(txtTuKhoa)) { lstDanhSachSP = lstDanhSachSP.Where(x => x.MaSanPham == txtTuKhoa || x.TenSanPham.ToLower().Contains(txtTuKhoa.ToLower())); } if (!string.IsNullOrEmpty(txtNgayBatDau) && !string.IsNullOrEmpty(txtNgayKetThuc)) { DateTime ngayStart = DateTime.Parse(txtNgayBatDau, ci); DateTime ngayEnd = DateTime.Parse(txtNgayKetThuc, ci); lstDanhSachSP = lstDanhSachSP.Where(x => x.NgayTao >= ngayStart && x.NgayTao <= ngayEnd); } int loaiId = 0, hangId = 0, chuDeId = 0; loaiId = (loaiSanPham.HasValue) ? loaiSanPham.Value : 0; hangId = (hangSanXuat.HasValue) ? hangSanXuat.Value : 0; chuDeId = (chuDe.HasValue) ? chuDe.Value : 0; if (loaiSanPham.HasValue) { lstDanhSachSP = lstDanhSachSP.Where(x => x.LoaiId == loaiId); } if (hangSanXuat.HasValue) { lstDanhSachSP = lstDanhSachSP.Where(x => x.HangId == hangId); } if (chuDe.HasValue) { lstDanhSachSP = lstDanhSachSP.Where(x => x.ChuDeId == chuDeId); } if (!string.IsNullOrEmpty(xuatXu)) { lstDanhSachSP = lstDanhSachSP.Where(x => x.XuatXuId == xuatXu); } if (!string.IsNullOrEmpty(txtGiaStart) && !string.IsNullOrEmpty(txtGiaEnd)) { double GiaStart = double.Parse(txtGiaStart); double GiaEnd = double.Parse(txtGiaEnd); lstDanhSachSP = lstDanhSachSP.Where(x => x.Gia >= GiaStart && x.Gia <= GiaEnd); } return(View(lstDanhSachSP.ToList())); }
public ActionResult Edit([Bind(Include = "MaPQ,LoaiQuyen")] PhanQuyen phanQuyen) { if (ModelState.IsValid) { db.Entry(phanQuyen).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(phanQuyen)); }
/// <summary> /// Kiểm tra có quyền thêm, xóa, sửa không /// </summary> /// <param name="action"></param> /// <param name="obj"></param> /// <returns></returns> public bool CheckAction(PhanQuyen obj) { switch (Action) { case ConstantCommon.Action.View: { if (obj.Xem == true) { return(true); } } break; case ConstantCommon.Action.Delete: { if (obj.Xoa == true) { return(true); } } break; case ConstantCommon.Action.Edit: { if (obj.Sua == true) { return(true); } } break; case ConstantCommon.Action.Add: { if (obj.Them == true) { return(true); } } break; case ConstantCommon.Action.Report: { if (obj.BaoCao == true) { return(true); } } break; default: return(false); } return(false); }
//[ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "MaPQ,LoaiQuyen")] PhanQuyen phanQuyen) { if (ModelState.IsValid) { db.PhanQuyens.Add(phanQuyen); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(phanQuyen)); }
private void Barbtnphanquyen_ItemClick(object sender, ItemClickEventArgs e) { PhanQuyen phanQuyen = new PhanQuyen(); if (ExistsForm(phanQuyen)) { return; } phanQuyen.MdiParent = this; phanQuyen.Show(); }