public ActionResult PartialDanhSachSanPham() { var lstKetQua = new List <SanPhams>(); using (DauGiaEntities ctx = new DauGiaEntities()) { var lstSanPham = ctx.SanPhams.where (x => x.DaDuyet == false).ToList(); foreach (var item in lstSanPham) { var danhmuc = ctx.DanhMucs.SingleOrDefault(x => x.MaTheLoai == item.MaTheLoai.Value); var nguoiDung = ctx.NguoiDungs.SingleOrDefault(x => x.MaNguoiDung = item.MaNguoiDung.Value); var sanpham = new SanPhams() { MaSanPham = item.MaSanPham, Gia = item.Gia, Hinhanh1 = item.HinhAnh1, HinhAnh2 = item.HinhAnh2, HinhAnh3 = item.HinhAnh3, NgayBatDau = item.NgayBatDau, NgayKetThuc = item.NgayKetThuc, TenSanPham = item.TenSanPham, LoaiSanPham = item.DanhMuc, NguoiDung = nguoiDung }; lstKetQua.Add(sanpham); } lstKetQua.OrderBy(x => x.NgayBatDau).ToList(); return(partialView("DanhSachSanPham", lstKetQua)); } }
public static bool IsLogged() { if (HttpContext.Current.Session["IsLogin"] == null) { HttpContext.Current.Session["IsLogin"] = 0; } if ((int)HttpContext.Current.Session["IsLogin"] == 1) { return(true); } // kiểm tra cookie rỗng k. // nếu không rỗng tái tạo lại session và xem như đã đăng nhập if (HttpContext.Current.Response.Cookies["UserName"] != null) { string username = HttpContext.Current.Request.Cookies["UserName"].Value; using (DauGiaEntities ql = new DauGiaEntities()) { NguoiDung tk = ql.NguoiDung. Where(q => q.TaiKhoan == username). FirstOrDefault(); if (tk != null) { HttpContext.Current.Session["CurUser"] = tk; HttpContext.Current.Session["IsLogin"] = 1; return(true); } } } return(false); }
public ActionResult Login(LoginModel model) { using (DauGiaEntities ql = new DauGiaEntities()) { string encPW = StringUtils.Md5(model.Mk); NguoiDung tk = ql.NguoiDung. Where(u => u.TaiKhoan == model.TenDN && u.MatKhau == encPW) .FirstOrDefault(); if (tk == null) { ViewBag.Err = "Xin vui lòng kiểm tra lại thông tin đăng nhập!"; return(View(model)); } else { Session["IsLogin"] = 1; Session["CurUser"] = tk; if (model.Remember)// khi đã đăng nhập { Response.Cookies["UserName"].Value = tk.TenNguoiDung; Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(1); } if (tk.PhanQuyen == 1) // tài khoản thường { return(RedirectToAction("Index", "Home")); } else // He thống { return(RedirectToAction("Index", "Home")); } } } }
public ActionResult PartialDanhSachNguoiDung() { using (DauGiaEntities ctx = new DauGiaEntities()) { var lstNguoiDung = ctx.NguoiDung.ToList(); return(PartialView("DanhSachNguoiDung", lstNguoiDung)); } }
public ActionResult NamSanPhamCoNgayGanHetHan() { using (DauGiaEntities ctx = new DauGiaEntities()) { var list = ctx.SanPhams.Where(x => x.DaBan == false) .OrderBy(x => x.NgayKetThuc).Take(5).ToList(); return(PartialView("NamSanPhamCoNhieuLuoDauGiaNhat", list)); } }
public ActionResult NamSanPhamGiaCaoNhat() { using (DauGiaEntities ctx = new DauGiaEntities()) { var list = ctx.SanPhams.Where(x => x.DaBan == false) .OrderBy(n => n.Gia).Take(5).ToList(); return(PartialView("NamSanPhamGiaCaoNhat", list)); } }
public ActionResult Profile() { using (DauGiaEntities ql = new DauGiaEntities()) { NguoiDung tk = CurrentContext.CurUser(); string ten = tk.TaiKhoan; var model = ql.NguoiDung.Where(p => p.TaiKhoan == ten).FirstOrDefault(); return(View(model)); } }
// GET: SanPham/byCat public ActionResult ByCat(int?id) { if (id.HasValue == false) { return(RedirectToAction("Index", "Home")); } using (var ctx = new DauGiaEntities()) { var list = ctx.SanPhams.Where(n => n.MaTheLoai == id).ToList(); return(View(list)); } }
public ActionReSult DuyetSanPham(int id) { using (DauGiaEntities ctx = new DauGiaEntities()) { SanPham sp = ctx.SanPhams.Single(c => c.MaSanPham == id); if (sp != null) { sp.DaDuyet = true; } ctx.SaveChanges(); } return(RedirectToAction("Index", "Manager")); }
public ActionResult Register(RegisterModel model) { var response = Request["g-recaptcha-response"]; string secretKey = "6LcnAycUAAAAAAklEw73MX5LijDgWstP5fHZefSc"; var client = new WebClient(); var result = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response)); var obj = JObject.Parse(result); var status = (bool)obj.SelectToken("success"); if (ModelState.IsValid == false) { ViewBag.Error = "Xin nhập thông tin."; return(View(model)); } if (status == false) { ViewBag.Error = "ReCaptcha chưa được thực hiện."; return(View(model)); } using (DauGiaEntities ql = new DauGiaEntities()) { int n = ql.NguoiDung .Where(us => us.TaiKhoan == model.Ten) .Count(); if (n == 1) { ViewBag.Error = model.Ten + " đã có trong hệ thống"; return(View(model)); } } ViewBag.TenDangNhap = model.Ten; NguoiDung tk = new NguoiDung { TaiKhoan = model.Ten, MatKhau = StringUtils.Md5(model.MK), Email = model.Email, TenNguoiDung = model.FullName, PhanQuyen = 1,// user nguoi dung }; using (DauGiaEntities ctx = new DauGiaEntities()) { ctx.NguoiDung.Add(tk); ctx.SaveChanges(); ModelState.Clear(); } return(RedirectToAction("Login", "Account")); }
// GET: DanhMuc public ActionResult List() { try { using (DauGiaEntities ctx = new DauGiaEntities()) { var lstDanhMuc = ctx.DanhMucs.ToList(); return(PartialView("List", lstDanhMuc)); } } catch (Exception ex) { return(PartialView(null)); } }
public ActionResult NamSanPhamCoNhieuLuoDauGiaNhat() { using (DauGiaEntities ctx = new DauGiaEntities()) { var list = ctx.GiaoDiches.Where(x => x.ThangCuoc == false) .GroupBy(n => n.MaSanPham) .Select(x => new { MaSanPham = (int)x.Key, Count = x.Count() }) .OrderByDescending(x => x.MaSanPham).Take(5).ToList(); var lstSanPham = new List <SanPham>(); foreach (var item in list) { var sanpham = ctx.SanPhams.SingleOrDefault(x => x.MaSanPham == item.MaSanPham); lstSanPham.Add(sanpham); } return(PartialView("NamSanPhamCoNhieuLuoDauGiaNhat", lstSanPham)); } }
public ActionResult profilepass(Profile pr) { using (DauGiaEntities ql = new DauGiaEntities()) { string encPW = StringUtils.Md5(pr.Oldpass); NguoiDung tk = ql.NguoiDung.Where(p => p.MaNguoiDung == pr.MaTK).FirstOrDefault(); if (tk.MatKhau == encPW) { tk.MatKhau = StringUtils.Md5(pr.NewPass).ToString(); tk.Email = pr.EmailNew; tk.TenNguoiDung = pr.NameNew; ql.SaveChanges(); return(RedirectToAction("Index", "Home")); } else { ViewBag.Error = "Cập nhật thất bại!"; return(View(tk)); } } }