private void LoadDataSource() // Load GridView
{
list.Clear();
dt = Utils.Util.ConvertToDataTable <PHAN_QUYEN>(m_PhanQuyenBLL.LayDanhSach());
for (int i = 0; i < dt.Rows.Count; i++)
{
PHAN_QUYEN a = new PHAN_QUYEN();
a.ID_PQ = int.Parse(dt.Rows[i]["ID_PQ"].ToString());
a.ID_Loai_ND = int.Parse(dt.Rows[i]["ID_Loai_ND"].ToString());
a.ViewKhuyenMai = bool.Parse(dt.Rows[i]["ViewKhuyenMai"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewKhuyenMai"].ToString());
a.ViewDanhMucMon = bool.Parse(dt.Rows[i]["ViewDanhMucMon"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewDanhMucMon"].ToString());
a.ViewDanhMucBan = bool.Parse(dt.Rows[i]["ViewDanhMucBan"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewDanhMucBan"].ToString());
a.ViewDanhMucKhuVuc = bool.Parse(dt.Rows[i]["ViewDanhMucKhuVuc"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewDanhMucKhuVuc"].ToString());
a.ViewDanhMucNguyenLieu = bool.Parse(dt.Rows[i]["ViewDanhMucNguyenLieu"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewDanhMucNguyenLieu"].ToString());
a.ViewDanhMucNguoiDung = bool.Parse(dt.Rows[i]["ViewDanhMucNguoiDung"] == System.DBNull.Value ? "false" : dt.Rows[i]["ViewDanhMucNguoiDung"].ToString());
a.UpdateKhuyenMai = bool.Parse(dt.Rows[i]["UpdateKhuyenMai"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateKhuyenMai"].ToString());
a.UpdateThucDon = bool.Parse(dt.Rows[i]["UpdateThucDon"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateThucDon"].ToString());
a.UpdateBan = bool.Parse(dt.Rows[i]["UpdateBan"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateBan"].ToString());
a.UpdateKhuVuc = bool.Parse(dt.Rows[i]["UpdateKhuVuc"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateKhuVuc"].ToString());
a.UpdateNguyenLieu = bool.Parse(dt.Rows[i]["UpdateNguyenLieu"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateNguyenLieu"].ToString());
a.UpdateNguoiDung = bool.Parse(dt.Rows[i]["UpdateNguoiDung"] == System.DBNull.Value ? "false" : dt.Rows[i]["UpdateNguoiDung"].ToString());
list.Add(a);
}
gridControl1.DataSource = list;
btn_Luu_Lai.Enabled = false;
m_ListUpdate.Clear();
}
private void btn_Luu_Lai_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
foreach (int id in m_ListUpdate)
{
PHAN_QUYEN _pq = new PHAN_QUYEN();
_pq.ID_PQ = int.Parse(gridView1.GetRowCellValue(id, "ID_PQ").ToString());
_pq.ID_Loai_ND = int.Parse(gridView1.GetRowCellValue(id, "ID_Loai_ND").ToString());
_pq.ViewKhuyenMai = (bool)gridView1.GetRowCellValue(id, "ViewKhuyenMai");
_pq.ViewDanhMucMon = (bool)gridView1.GetRowCellValue(id, "ViewDanhMucMon");
_pq.ViewDanhMucBan = (bool)gridView1.GetRowCellValue(id, "ViewDanhMucBan");
_pq.ViewDanhMucKhuVuc = (bool)gridView1.GetRowCellValue(id, "ViewDanhMucKhuVuc");
_pq.ViewDanhMucNguyenLieu = (bool)gridView1.GetRowCellValue(id, "ViewDanhMucNguyenLieu");
_pq.ViewDanhMucNguoiDung = (bool)gridView1.GetRowCellValue(id, "ViewDanhMucNguoiDung");
_pq.UpdateKhuyenMai = (bool)gridView1.GetRowCellValue(id, "UpdateKhuyenMai");
_pq.UpdateThucDon = (bool)gridView1.GetRowCellValue(id, "UpdateThucDon");
_pq.UpdateBan = (bool)gridView1.GetRowCellValue(id, "UpdateBan");
_pq.UpdateKhuVuc = (bool)gridView1.GetRowCellValue(id, "UpdateKhuVuc");
_pq.UpdateNguyenLieu = (bool)gridView1.GetRowCellValue(id, "UpdateNguyenLieu");
_pq.UpdateNguoiDung = (bool)gridView1.GetRowCellValue(id, "UpdateNguoiDung");
m_PhanQuyenBLL.Sua(_pq);
}
Notification.Success("Cập dữ liệu thành công.");
}
catch (Exception er)
{
Notification.Error("Có lỗi xảy ra khi cập nhật dữ liệu: " + er.Message);
}
LoadDataSource();
}
public ActionResult Edit(int id)
{
if (id <= 0)
{
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
var ctx = new SmsContext();
PHAN_QUYEN phanquyen = ctx.PHAN_QUYEN.Find(id);
if (phanquyen.ACTIVE.Equals("A"))
{
//Nguoi Dung
BindNguoiDung();
//Ma Nhom
BindNhomNguoiDung();
ViewBag.phanQuyen = phanquyen;
ctx.Dispose();
return(View(phanquyen));
}
else
{
ctx.Dispose();
ViewBag.Message = "Không tìm thấy phân quyền tương ứng.";
return(View("../Home/Error"));;
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
PHAN_QUYEN phan_quyen = await db.PHAN_QUYEN.FindAsync(id);
db.PHAN_QUYEN.Remove(phan_quyen);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void UpdatePhanQuyen(PHAN_QUYEN phanquyen)
{
var query = (from c in _dataContext.PHAN_QUYENs
where c.MaPhanQuyen == phanquyen.MaPhanQuyen
select c).Single();
query.MaChucNang = phanquyen.MaChucNang;
query.MaLoaiNhanVien = phanquyen.MaLoaiNhanVien;
_dataContext.SubmitChanges();
}
public async Task <ActionResult> Edit([Bind(Include = "MA_QUYEN,TEN_QUYEN")] PHAN_QUYEN phan_quyen)
{
if (ModelState.IsValid)
{
db.Entry(phan_quyen).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(phan_quyen));
}
public async Task <ActionResult> Create([Bind(Include = "MA_QUYEN,TEN_QUYEN")] PHAN_QUYEN phan_quyen)
{
if (ModelState.IsValid)
{
db.PHAN_QUYEN.Add(phan_quyen);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(phan_quyen));
}
// GET: /PhanQuyen/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHAN_QUYEN phan_quyen = await db.PHAN_QUYEN.FindAsync(id);
if (phan_quyen == null)
{
return(HttpNotFound());
}
return(View(phan_quyen));
}
public ActionResult AddNew(PHAN_QUYEN phanQuyen)
{
//var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
var db = new SmsContext();
var oldPermission = db.PHAN_QUYEN.FirstOrDefault(u => u.MA_NGUOI_DUNG == phanQuyen.MA_NGUOI_DUNG &&
u.ACTIVE == "A");
if (oldPermission != null)
{
oldPermission.QUYEN_ADMIN = phanQuyen.QUYEN_ADMIN;
oldPermission.QUYEN_DANH_MUC_SAN_PHAM = phanQuyen.QUYEN_DANH_MUC_SAN_PHAM;
oldPermission.QUYEN_BAN_HANG = phanQuyen.QUYEN_BAN_HANG;
oldPermission.QUYEN_THAU_NGAN = phanQuyen.QUYEN_THAU_NGAN;
oldPermission.QUYEN_QUAN_LY_KHO = phanQuyen.QUYEN_QUAN_LY_KHO;
oldPermission.MA_NHOM_NGUOI_DUNG = phanQuyen.MA_NHOM_NGUOI_DUNG;
oldPermission.ACTIVE = "A";
oldPermission.UPDATE_AT = DateTime.Now;
oldPermission.CREATE_AT = DateTime.Now;
oldPermission.UPDATE_BY = (int)Session["UserId"];
oldPermission.CREATE_BY = (int)Session["UserId"];
db.SaveChanges();
return(RedirectToAction("Index").Success("Lưu thành công."));
}
else
{
var phanquyen = db.PHAN_QUYEN.Create();
phanquyen.MA_NGUOI_DUNG = phanQuyen.MA_NGUOI_DUNG;
phanquyen.QUYEN_ADMIN = phanQuyen.QUYEN_ADMIN;
phanquyen.QUYEN_DANH_MUC_SAN_PHAM = phanQuyen.QUYEN_DANH_MUC_SAN_PHAM;
phanquyen.QUYEN_BAN_HANG = phanQuyen.QUYEN_BAN_HANG;
phanquyen.QUYEN_THAU_NGAN = phanQuyen.QUYEN_THAU_NGAN;
phanquyen.QUYEN_QUAN_LY_KHO = phanQuyen.QUYEN_QUAN_LY_KHO;
phanquyen.MA_NHOM_NGUOI_DUNG = phanQuyen.MA_NHOM_NGUOI_DUNG;
phanquyen.ACTIVE = "A";
phanquyen.UPDATE_AT = DateTime.Now;
phanquyen.CREATE_AT = DateTime.Now;
phanquyen.UPDATE_BY = (int)Session["UserId"];
phanquyen.CREATE_BY = (int)Session["UserId"];
db.PHAN_QUYEN.Add(phanquyen);
db.SaveChanges();
return(RedirectToAction("Index").Success("Lưu thành công."));
}
}
return(View());
}
public ActionResult Edit(PHAN_QUYEN phanQuyen)
{
if (ModelState.IsValid)
{
var db = new SmsContext();
var phanquyen = db.PHAN_QUYEN.Find((int)phanQuyen.ID);
phanquyen.QUYEN_ADMIN = phanQuyen.QUYEN_ADMIN;
phanquyen.QUYEN_DANH_MUC_SAN_PHAM = phanQuyen.QUYEN_DANH_MUC_SAN_PHAM;
phanquyen.QUYEN_BAN_HANG = phanQuyen.QUYEN_BAN_HANG;
phanquyen.QUYEN_THAU_NGAN = phanQuyen.QUYEN_THAU_NGAN;
phanquyen.QUYEN_QUAN_LY_KHO = phanQuyen.QUYEN_QUAN_LY_KHO;
phanquyen.MA_NHOM_NGUOI_DUNG = phanQuyen.MA_NHOM_NGUOI_DUNG;
phanquyen.ACTIVE = "A";
phanquyen.UPDATE_AT = DateTime.Now;
phanquyen.UPDATE_BY = (int)Session["UserId"];
db.SaveChanges();
return(RedirectToAction("Index").Success("Lưu thành công."));
}
return(View());
}
public void UpdatePhanQuyen(PHAN_QUYEN phanquyen)
{
_phanquyenDao.UpdatePhanQuyen(phanquyen);
}
public void InsertPhanQuyen(PHAN_QUYEN phanquyen)
{
_phanquyenDao.InsertPhanQuyen(phanquyen);
}
public void InsertPhanQuyen(PHAN_QUYEN phanquyen)
{
_dataContext.PHAN_QUYENs.InsertOnSubmit(phanquyen);
_dataContext.SubmitChanges();
}
