public ActionResult DoiPass(FormCollection f)
{
if (Session["TaiKhoan"].ToString() == "admin")
{
PHANQUYEN pq = db.PHANQUYENs.First(m => m.TaiKhoan == Session["TaiKhoan"].ToString());
if (pq.PassWord == EncryptMD5.MD5Hash(f["passold"]))
{
if (f["passnew"] == f["xnpass"])
{
pq.PassWord = EncryptMD5.MD5Hash(f["passnew"]);
UpdateModel(pq);
db.SubmitChanges();
}
else
{
ViewData["Loi1"] = "Mật Khẩu không khớp vui lòng nhập lại!!!";
return(View());
}
}
else
{
ViewData["Loi2"] = "Mật Khẩu Hiện Tại Không Đúng!!!!!";
return(View());
}
return(RedirectToAction("Index", "Admin"));
}
return(RedirectToAction("Index", "Home"));
}
private void btnThem_Click(object sender, EventArgs e)
{
grdNhom.Enabled = false;
btnXoa.Enabled = false;
btnSua.Enabled = false;
txtTenNhom.Text = "";
txtMaNhom.Text = "NQ" + grdNhom.Rows.Count;
grbma.Enabled = false;
grbten.Enabled = true;
btnLuu.Enabled = true;
lstPQ = new List <PHANQUYEN>();
foreach (MANHINH item in qlns.layMH())
{
PHANQUYEN newqp = new PHANQUYEN()
{
MANQ = txtMaNhom.Text,
MAMH = item.MAMH,
COQUYEN = false,
TENMH = item.TENMH
};
lstPQ.Add(newqp);
}
gvManHinh.DataSource = lstPQ;
}
public ActionResult DeleteConfirmed(string id)
{
PHANQUYEN pHANQUYEN = db.PHANQUYENs.Find(id);
db.PHANQUYENs.Remove(pHANQUYEN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "TENQUYEN,ID_TK")] PHANQUYEN pHANQUYEN)
{
if (ModelState.IsValid)
{
db.Entry(pHANQUYEN).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_TK = new SelectList(db.TAIKHOANs, "ID_TK", "username", pHANQUYEN.ID_TK);
return(View(pHANQUYEN));
}
public JsonResult XoaPhanQuyen(string id_quyen, string id_quyenTC)
{
if (ModelState.IsValid)
{
PHANQUYEN phanquyen = db.PHANQUYENs.Find(Convert.ToInt32(id_quyen), Convert.ToInt32(id_quyenTC));
db.PHANQUYENs.Remove(phanquyen);
db.SaveChanges();
return(Json("Yes", JsonRequestBehavior.AllowGet));
}
return(Json("No", JsonRequestBehavior.AllowGet));
}
public void Delete(string quyen)
{
datacontext = new VBDQDataContext();
PHANQUYEN p = datacontext.PHANQUYENs.Where(m => m.QUYEN == quyen).FirstOrDefault();
if (p != null)
{
datacontext.PHANQUYENs.DeleteOnSubmit(p);
}
datacontext.SubmitChanges();
}
public ActionResult Create([Bind(Include = "TENQUYEN,ID_TK")] PHANQUYEN pHANQUYEN)
{
if (ModelState.IsValid)
{
db.PHANQUYENs.Add(pHANQUYEN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_TK = new SelectList(db.TAIKHOANs, "ID_TK", "username", pHANQUYEN.ID_TK);
return(View(pHANQUYEN));
}
public void updateCoQuyen(string mamh, int _maNhom, object quyen)
{
//update for LINQ
PHANQUYEN pq = new PHANQUYEN();
pq = _qllk.PHANQUYENs.Where(t => t.MaManHinh == mamh && t.MaNhomND == _maNhom).FirstOrDefault();
if (pq != null)
{
pq.CoQuyen = Convert.ToBoolean(quyen);
_qllk.SubmitChanges();
}
}
public EStatus capNhat(PhanQuyen_DTO pQuyen)
{
PHANQUYEN tim = db.PHANQUYENs.FirstOrDefault(n => n.MANHOM.Equals(pQuyen.MaNhom) && n.MAQUYEN.Equals(pQuyen.MaQuyen));
if (tim == null)
{
return(EStatus.LOI);
}
tim.COQUYEN = pQuyen.CoQuyen;
db.SubmitChanges();
return(EStatus.THANH_CONG);
}
public JsonResult CheckPhanQuyen(string id_quyen, string id_truycap)
{
PHANQUYEN phanquyen = db.PHANQUYENs.Find(Convert.ToInt32(id_quyen), Convert.ToInt32(id_truycap));
if (phanquyen == null)
{
return(Json("No", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("Yes", JsonRequestBehavior.AllowGet));
}
}
public Boolean KiemTra(string quyen)
{
PHANQUYEN x = datacontext.PHANQUYENs.Where(m => m.QUYEN == quyen).FirstOrDefault();
if (x != null)
{
return(false);
}
else
{
return(true);
}
}
// GET: Admin/PHANQUYEN/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHANQUYEN pHANQUYEN = db.PHANQUYENs.Find(id);
if (pHANQUYEN == null)
{
return(HttpNotFound());
}
return(View(pHANQUYEN));
}
// GET: Admin/PHANQUYEN/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHANQUYEN pHANQUYEN = db.PHANQUYENs.Find(id);
if (pHANQUYEN == null)
{
return(HttpNotFound());
}
ViewBag.ID_TK = new SelectList(db.TAIKHOANs, "ID_TK", "username", pHANQUYEN.ID_TK);
return(View(pHANQUYEN));
}
public void Update(PhanQuyen_DTO x)
{
datacontext = new VBDQDataContext();
PHANQUYEN p = datacontext.PHANQUYENs.Where(m => m.QUYEN == x.Quyen).FirstOrDefault();
if (p != null)
{
p.PHIEUMUA = x.PhieuMua;
p.PHIEUBAN = x.PhieuBan;
p.DICHVU = x.DichVu;
p.QUANLY = x.QuanLy;
p.THUKHO = x.ThuKho;
}
datacontext.SubmitChanges();
}
public void Insert(PhanQuyen_DTO x)
{
PHANQUYEN phanquyenmoi = new PHANQUYEN()
{
QUYEN = x.Quyen,
PHIEUMUA = x.PhieuMua,
PHIEUBAN = x.PhieuBan,
DICHVU = x.DichVu,
QUANLY = x.QuanLy,
THUKHO = x.ThuKho
};
datacontext.PHANQUYENs.InsertOnSubmit(phanquyenmoi);
datacontext.SubmitChanges();
}
public ActionResult Themmoi(PHANQUYEN Pquyen)
{
ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;
if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
{
if (ModelState.IsValid)
{
db.PHANQUYENs.Add(Pquyen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult DangKy(FormCollection f)
{
if (f["cmnd"].Length != 9 && f["cmnd"].Length != 12)
{
ViewData["L1"] = "Vui lòng nhập đúng CMND";
return(View());
}
KHACHHANG k = new KHACHHANG();
PHANQUYEN p = new PHANQUYEN();
donghoDataContext db = new donghoDataContext();
var query = from kh in db.KHACHHANGs where kh.CMND == f["cmnd"].ToString() select kh;
if (query.ToList().Count != 0)
{
ViewData["L1"] = "Tài Khoản đã tồn tại";
return(View());
}
k.CMND = f["cmnd"];
if (string.Compare(f["gioitinh"], "nam") == 0)
{
k.GioiTinh = false;
}
else
{
k.GioiTinh = true;
}
k.TenKH = f["hoten"];
k.Ngaysinh = DateTime.Parse(f["ngaysinh"]);
k.Email = f["email"];
k.TrangThai = true;
if (string.Compare(f["pass"], f["xnpass"]) != 0)
{
ViewData["L3"] = "Mật khẩu không trùng khớp";
return(View());
}
p.TrangThai = true;
p.TaiKhoan = f["cmnd"];
p.PassWord = EncryptMD5.MD5Hash(f["pass"]);
p.MaCN = 2;
db.PHANQUYENs.InsertOnSubmit(p);
db.KHACHHANGs.InsertOnSubmit(k);
db.SubmitChanges();
return(RedirectToAction("Login", "Home"));
}
public JsonResult Capnhatquyen(string tendn, int maquyen)
{
var pq = data.PHANQUYENs.Where(n => n.TENDN == tendn && n.MAQUYEN == maquyen).SingleOrDefault();
if (pq == null)
{
PHANQUYEN phanquyen = new PHANQUYEN();
phanquyen.TENDN = tendn;
phanquyen.MAQUYEN = maquyen;
data.PHANQUYENs.Add(phanquyen);
data.SaveChanges();
}
else
{
data.PHANQUYENs.Remove(pq);
data.SaveChanges();
}
var quyen = data.sp_Quyenuserksd(tendn).ToList();
var quyenuser = data.sp_Quyenusersd(tendn).ToList();
List <QuyenUser> lstQuyen = new List <QuyenUser>();
foreach (var item in quyenuser)
{
QuyenUser list = new QuyenUser(tendn, "checked", item.MAQUYEN, item.TENQUYEN);
lstQuyen.Add(list);
}
foreach (var item in quyen)
{
QuyenUser list = new QuyenUser(tendn, "", item.MAQUYEN, item.TENQUYEN);
lstQuyen.Add(list);
}
return(Json(new
{
lstQuyen,
JsonRequestBehavior.AllowGet
}));
}
public PhanQuyen_DTO Get(string quyen)
{
PHANQUYEN x = datacontext.PHANQUYENs.Where(m => m.QUYEN == quyen).FirstOrDefault();
if (x != null)
{
return(new PhanQuyen_DTO()
{
Quyen = x.QUYEN,
PhieuBan = x.PHIEUBAN.Value,
PhieuMua = x.PHIEUMUA.Value,
DichVu = x.DICHVU.Value,
QuanLy = x.QUANLY.Value,
ThuKho = x.THUKHO.Value,
});
}
else
{
return(new PhanQuyen_DTO());
}
}
public ActionResult Login(FormCollection f)
{
PHANQUYEN pq = DB.PHANQUYENs.SingleOrDefault(a => a.TaiKhoan == f["TaiKhoan"] &&
a.PassWord == EncryptMD5.MD5Hash(f["pass"]));
if (pq != null && pq.TaiKhoan == "admin")
{
Session["TaiKhoan"] = pq.TaiKhoan;
return(RedirectToAction("Index", "Admin"));
}
else if (pq != null && pq.TaiKhoan != "admin")
{
ViewBag.ThongBao = "Chúc mừng đăng nhập thành công";
Session["TaiKhoan"] = pq.TaiKhoan;
return(RedirectToAction("Index", "Home"));
}
else
{
ViewData["Loi1"] = "Tên đăng nhập hoặc mật khẩu không đúng";
}
return(View());
}
private List <PHANQUYEN> layPQ()
{
List <PHANQUYEN> lst = new List <PHANQUYEN>();
foreach (DataGridViewRow item in gvManHinh.Rows)
{
PHANQUYEN pq = new PHANQUYEN()
{
MAMH = item.Cells[1].Value.ToString(),
MANQ = txtMaNhom.Text,
};
if (item.Cells[2].Value.ToString() == "True")
{
pq.COQUYEN = true;
}
else
{
pq.COQUYEN = false;
}
lst.Add(pq);
}
return(lst);
}
public void lamMoiTaiTatCaQuyen_choNhom()
{
PHANQUYEN pq;
var nhoms = db.NHOMQUYENs;
var quyens = db.QUYENs;
foreach (NHOMQUYEN n in nhoms)
{
foreach (QUYEN q in quyens)
{
pq = db.PHANQUYENs.FirstOrDefault(t => t.MANHOM.Equals(n.MANHOM) && t.MAQUYEN.Equals(q.MAQUYEN));
if (pq == null)
{
pq = new PHANQUYEN();
pq.MANHOM = n.MANHOM;
pq.MAQUYEN = q.MAQUYEN;
pq.COQUYEN = false;
db.PHANQUYENs.InsertOnSubmit(pq);
}
}
}
db.SubmitChanges();
}
public ActionResult QuenPass(FormCollection f)
{
var query = from kh in DB.KHACHHANGs where kh.CMND == f["CMND"] && kh.Email == f["email"] select kh;
KHACHHANG k = query.SingleOrDefault();
if (k != null)
{
// phan email
StringBuilder Body = new StringBuilder();
Body.Append("<p>Cảm ơn quý khách đã sử dụng dịch của chúng tôi. Dưới đây là mật khẩu mới của bạn:</p>");
Body.Append("<p>Mật khẩu mới là: <b>1</b></p>");
MailMessage mail = new MailMessage();
mail.To.Add(k.Email);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Thay Đổi Mật Khẩu";
mail.Body = Body.ToString();// phần thân của mail ở trên
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "trungsangquan@123");// tài khoản Gmail của bạn
smtp.EnableSsl = true;
smtp.Send(mail);
PHANQUYEN pq = DB.PHANQUYENs.SingleOrDefault(m => m.TaiKhoan == k.CMND);
pq.PassWord = EncryptMD5.MD5Hash("1");
UpdateModel(pq);
DB.SubmitChanges();
return(RedirectToAction("Login"));
}
else
{
ViewData["Loi1"] = "Vui lòng Nhập đúng email đã đăng ký";
return(View());
}
}
