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));
}
}
}
