public ActionResult PhanQuyen(int?MaLTV, IEnumerable <LoaiThanhVien_Quyen> lstPhanQuyen)
{
//Trường hợp : Nếu đã đã tiến hành phân quyền rồi nhưng muốn phân quyền lại
//Bước 1: Xóa những quyền cũa thuộc loại TV đó
var lstDaPhanQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == MaLTV);
if (lstDaPhanQuyen.Count() != 0)
{
db.LoaiThanhVien_Quyen.RemoveRange(lstDaPhanQuyen);
db.SaveChanges();
}
if (lstPhanQuyen != null)
{
//Kiểm tra list danh sách quyền được check
foreach (var item in lstPhanQuyen)
{
item.MaLoaiTV = int.Parse(MaLTV.ToString());
//Nếu được check thì insert dữ liệu vào bảng phân quyền
db.LoaiThanhVien_Quyen.Add(item);
}
db.SaveChanges();
}
ViewBag.ThongBao = "Thành công !";
//Lấy ra danh sách quyền để load ra check box
ViewBag.MaQuyen = db.Quyens;
ViewBag.LoaiTVQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == MaLTV);
LoaiThanhVien ltv = db.LoaiThanhViens.SingleOrDefault(n => n.MaLoaiTV == MaLTV);
return(View(ltv));
}
public ActionResult XoaMember(LoaiThanhVien model)
{
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
model.UuDai = 0;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult PhanQuyen(int id)
{
ViewBag.lstPhanQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == id);
ViewBag.lstQuyen = db.Quyens.Where(n => n.MaQuyen != "QuanTri").ToList();
LoaiThanhVien LTV = db.LoaiThanhViens.Single(n => n.MaLoaiTV == id);
return(View(LTV));
}
public ActionResult ThemMember(LoaiThanhVien loaiTV)
{
if (ModelState.IsValid)
{
db.LoaiThanhViens.Add(loaiTV);
loaiTV.UuDai = 1;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SuaDMLoaiTV(int?MaLoaiThanhVien)
{
// ViewBag.MaLoaiThanhVien = new SelectList(db.LoaiThanhViens.ToList().OrderBy(n => n.TenLoaiThanhVien), "MaLoaiThanhVien", "TenLoaiThanhVien");
LoaiThanhVien tv = db.LoaiThanhViens.Find(MaLoaiThanhVien);
if (tv == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(tv));
}
public ActionResult SuaDMLoaiTV(LoaiThanhVien ltv)
{
//Thêm vào cơ sở dữ liệu
if (ModelState.IsValid)
{
db.Entry(ltv).State = EntityState.Modified;
db.SaveChanges();
Logging log = new Logging();
log.SaveLog(ltv.TenLoaiThanhVien + "-" + db.HanhDongs.Where(n => n.MaAction == 2).FirstOrDefault().TenAction, 2, int.Parse(Session["MaThanhVien"].ToString()));
return(RedirectToAction("XemDMLoaiTV", "DanhMuc"));
}
return(View(ltv));
}
public ActionResult PhanQuyen(int id)
{
LoaiThanhVien ltv = _ltvService.LayTheoMa(id);
if (ltv != null)
{
ViewBag.DanhSachQuyen = _qService.LayTatCa();
ViewBag.DanhSachPhanQuyen = _ltv_qService.LayDanhSachQuyenTheoLoaiThanhVien(id);
return(View(ltv));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult XoaMember(int?id)
{
//Lấy quyền cần chỉnh sửa dựa vào id
if (id == null)
{
Response.StatusCode = 404;
return(null);
}
LoaiThanhVien q = db.LoaiThanhViens.SingleOrDefault(n => n.MaLoaiTV == id);
if (q == null)
{
return(HttpNotFound());
}
return(View(q));
}
public ActionResult PhanQuyen(int?id)
{
if (id == null)
{
Response.StatusCode = 404;
return(null);
}
LoaiThanhVien ltv = db.LoaiThanhVien.SingleOrDefault(n => n.MaLoaiTV == id);
if (ltv == null)
{
return(HttpNotFound());
}
ViewBag.Quyen = db.Quyen;
ViewBag.LoaiTVQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == id);
return(View(ltv));
}
public ActionResult XoaDMLoaiTV(int MaLoaiThanhVien)
{
LoaiThanhVien ltv1 = db.LoaiThanhViens.Find(MaLoaiThanhVien);
if (ltv1 == null)
{
Response.StatusCode = 404;
return(null);
}
Logging log = new Logging();
log.SaveLog(ltv1.TenLoaiThanhVien + "-" + db.HanhDongs.Where(n => n.MaAction == 3).FirstOrDefault().TenAction, 3, int.Parse(Session["MaThanhVien"].ToString()));
db.LoaiThanhViens.Remove(ltv1);
db.SaveChanges();
return(RedirectToAction("XemDMLoaiTV", "DanhMuc"));
}
public ActionResult PhanQuyen(int?id)
{
//Lấy mã loại tv dựa vào id
if (id == null)
{
Response.StatusCode = 404;
return(null);
}
LoaiThanhVien ltv = db.LoaiThanhViens.SingleOrDefault(n => n.MaLoaiTV == id);
if (ltv == null)
{
return(HttpNotFound());
}
//Lấy ra danh sách quyền để load ra check box
ViewBag.MaQuyen = db.Quyens;
ViewBag.LoaiTVQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == id);
return(View(ltv));
}
public static int GetIdCuoi()
{
int id = 0;
DataTable tb = DataProvider.instanse.Executequerry("select * from LoaiThanhVien");
if (tb == null)
{
return(0);
}
else
{
foreach (DataRow item in tb.Rows)
{
LoaiThanhVien tv = new LoaiThanhVien(item);
id = tv.Id_LoaiTV;
}
}
return(id);
}
public ActionResult PhanQuyen(int?id)
{
//Lấy MaLoaiTV cần chỉnh sửa dựa vào id
if (id == null)
{
Response.StatusCode = 404;
return(null);
}
LoaiThanhVien ltv = db.LoaiThanhViens.SingleOrDefault(n => n.MaLoaiTV == id);
if (ltv == null)
{
return(HttpNotFound());
}
//Lay ra ds quyen (de load ra checkbox)
ViewBag.MaQuyen = db.Quyens;
//lay ra ds quyen cua loai thanh vien
ViewBag.LoaiTVQuyen = db.LoaiThanhVien_Quyen.Where(n => n.MaLoaiTV == id && n.Quyen.TrangThai == true);
return(View(ltv));
}
public ActionResult ThemDMLoaiTV(LoaiThanhVien ltv)
{
if (ModelState.IsValid)
{
var count = db.LoaiThanhViens.Count(n => n.TenLoaiThanhVien == ltv.TenLoaiThanhVien);
if (count == 0)
{
db.LoaiThanhViens.Add(ltv);
db.SaveChanges();
Logging log = new Logging();
log.SaveLog(ltv.TenLoaiThanhVien + "-" + db.HanhDongs.Where(n => n.MaAction == 1).FirstOrDefault().TenAction, 1, int.Parse(Session["MaThanhVien"].ToString()));
return(Redirect("../DanhMuc/XemDMLoaiTV"));
}
else
{
ViewBag.Message = 0;
}
}
return(View(ltv));
}
public IActionResult Index(int?page)
{
if (HttpContext.Session.Get("TaiKhoan") == null)
{
return(RedirectToAction("Index", "Home"));
}
ThanhVienTb kt = HttpContext.Session.Get <ThanhVienTb>("TaiKhoan");
if (kt.MaLoaiTv != 1 && kt.MaLoaiTv != 2)
{
return(RedirectToAction("Index", "Home"));
}
var result = db.DonDatHang.OrderByDescending(o => o.NgayDat);
if (page == 1 || page == null)
{
foreach (var item in result)
{
int KM = 0;
var kh = db.KhachHang.SingleOrDefault(s => s.MaKh == item.MaKh);
var tv = db.ThanhVienTb.SingleOrDefault(s => s.MaThanhVien == kh.MaThanhVien);
if (tv != null)
{
LoaiThanhVien ltv = db.LoaiThanhVien.SingleOrDefault(s => s.MaLoaiTv == tv.MaLoaiTv);
KM = (int)ltv.UuDai;
}
DonDatHang ddh = db.DonDatHang.SingleOrDefault(s => s.MaDdh == item.MaDdh);
ddh.UuDai = KM;
}
db.SaveChanges();
}
int pagenum = (page ?? 1);
int pagesize = 20;
return(View(result.ToPagedList(pagenum, pagesize)));
}
public ActionResult PhanQuyen(int id, IEnumerable <LoaiThanhVien_Quyen> listPhanQuyen)
{
LoaiThanhVien ltv = _ltvService.LayTheoMa(id);
if (ltv != null)
{
ViewBag.DanhSachQuyen = _qService.LayTatCa();
ViewBag.DanhSachPhanQuyen = _ltv_qService.LayDanhSachQuyenTheoLoaiThanhVien(id);
// Phân Quyền
var listDaPhanQuyen = _ltv_qService.LayDanhSachQuyenTheoLoaiThanhVien(id);
if (listDaPhanQuyen != null)
{
_ltv_qService.XoaNhieu(listDaPhanQuyen);
_ltv_qService.luu();
}
if (listPhanQuyen.Count() > 0)
{
foreach (var item in listPhanQuyen)
{
if (item.MaQuyen != null)
{
_ltv_qService.ThemMoi(item);
}
}
_ltv_qService.luu();
ViewBag.Message = "Phân quyền thành công!";
}
return(View(ltv));
}
else
{
return(RedirectToAction("Index"));
}
}
public void ThemMoi(LoaiThanhVien item)
{
_LoaiThanhVienRepository.Add(item);
}
public void CapNhat(LoaiThanhVien item)
{
_LoaiThanhVienRepository.Update(item);
}
