// // GET: /Contact/ public ActionResult Index() { var db = new WebBangDiaEntities(); ViewBag.MaYC = new SelectList(db.YeuCaus, "MaYC", "TenYeuCau"); var lienhe = (from lh in db.LienHes orderby lh.MaLH descending select lh).Take(8).ToList(); string chuoi=""; for (int i = 0; i < lienhe.Count; i++) { //var tk=db.TaiKhoans.Where(tk=>tk.MaTK==lienhe[i].MaTK).Select(tk=>tk.TenTK); if (lienhe[i].An == null || lienhe[i].An == true) { string tentk = lienhe[i].TaiKhoan.HoTen; chuoi += "<div class=\"contentlh\">"; chuoi += "<div class=\"dmcontent\">"; chuoi += "<div class=\"dmcontentleft\">"; chuoi += "<img src=\"/Images/LienHe/anhtk.jpg\"/><br/>"; chuoi += "<span>" + tentk + "</span>"; chuoi += "</div>"; chuoi += "<div class=\"dmcontentright\">"; chuoi += "<div>"; chuoi += "<h2>" + lienhe[i].TieuDe + "</h2>"; chuoi += "</div>"; chuoi += "<p>" + lienhe[i].NoiDung + "</p>"; chuoi += "</div>"; chuoi += "</div>"; chuoi += "</div>"; } } ViewBag.lienhe = chuoi; return View(); }
public ActionResult All(int idDm, int? page) { var db = new WebBangDiaEntities(); const int pageSize = 12; int pageNum = page ?? 1; var id = int.Parse(Session["Home"].ToString()); if (id == 1) { var list = db.BangDias.Where(sp => sp.An != true & sp.DanhMuc.MaDM == idDm).OrderBy(p => p.TenBD); return View(list.ToPagedList(pageNum, pageSize)); } if (id == 2) { var list = db.BangDias.Where(sp => sp.An != true & sp.DanhMuc.MaDM == idDm).OrderBy(p => p.Gia); return View(list.ToPagedList(pageNum, pageSize)); } if (id == 3) { var list = db.BangDias.Where(sp => sp.An != true & sp.DanhMuc.MaDM == idDm).OrderByDescending(p => p.Gia); return View(list.ToPagedList(pageNum, pageSize)); } else { var list = db.BangDias.Where(sp => sp.An != true & sp.DanhMuc.MaDM == idDm).OrderByDescending(p => p.NgayCapNhat); return View(list.ToPagedList(pageNum, pageSize)); } }
public ActionResult Search(FormCollection form, int? page) { Session["search"] = form["txtText"]; string keyword = form["txtText"]; var dbEntities = new WebBangDiaEntities(); const int pageSize = 9; int pageNum = page ?? 1; var listProduct = dbEntities.BangDias.Where(sp => sp.An != true & sp.TenBD.Contains(keyword)).OrderByDescending(sp => sp.TenBD); return View(listProduct.ToPagedList(pageNum, pageSize)); }
public ActionResult Filter(FormCollection form, int? page) { var dbEntities = new WebBangDiaEntities(); const int pageSize = 9; int pageNum = page ?? 1; Session["Gia"] = Convert.ToInt32(form["dropdownGia"]); Session["Xem"] = Convert.ToInt32(form["dropdownXem"]); Session["TheLoai"] = Convert.ToInt32(form["dropdownTheLoai"]); Session["Hsx"] = Convert.ToInt32(form["dropdownHsx"]); var idG = Convert.ToInt32(Session["Gia"].ToString()); var idX = Convert.ToInt32(Session["Xem"].ToString()); var idT = Convert.ToInt32(Session["TheLoai"].ToString()); var idH = Convert.ToInt32(Session["Hsx"].ToString()); if ((idG == 4 || idG == 5) && (idX == 0 || idX == 1)) { if (idG == 4 && idX == 0) { var listProduct = dbEntities.BangDias.Where(sp => sp.An != true & sp.MaDM == idT & sp.MaHSX == idH) .OrderBy(sp => sp.Gia) .ThenByDescending(sp => sp.LuotView); return View(listProduct.ToPagedList(pageNum, pageSize)); } else if (idG == 5 && idX == 0) { var listProduct = dbEntities.BangDias.Where(sp => sp.An != true & sp.MaDM == idT & sp.MaHSX == idH) .OrderByDescending(sp => sp.Gia) .ThenByDescending(sp => sp.LuotView); return View(listProduct.ToPagedList(pageNum, pageSize)); } else if (idG == 4 && idX == 1) { var listProduct = dbEntities.BangDias.Where(sp => sp.An != true & sp.MaDM == idT & sp.MaHSX == idH) .OrderBy(sp => sp.Gia) .ThenBy(sp => sp.LuotView); return View(listProduct.ToPagedList(pageNum, pageSize)); } else if (idG == 5 && idX == 1) { var listProduct = dbEntities.BangDias.Where(sp => sp.An != true & sp.MaDM == idT & sp.MaHSX == idH) .OrderBy(sp => sp.Gia) .ThenBy(sp => sp.LuotView); return View(listProduct.ToPagedList(pageNum, pageSize)); } } else { double ctG = CanTrenGia(idG); double cdG = CanDuoiGia(idG); double ctX = CanTrenXem(idX); double cdX = CanDuoiXem(idX); var listProduct2 = dbEntities.BangDias.Where( sp => sp.An != true & sp.MaDM == idT & sp.MaHSX == idH & sp.Gia > cdG & sp.Gia <= ctG & sp.LuotView > cdX & sp.LuotView <= ctX).OrderByDescending(sp => sp.Gia); return View(listProduct2.ToPagedList(pageNum, pageSize)); } var list = db.BangDias.Where(sp => sp.An != true).OrderByDescending(p => p.Gia); return View(list.ToPagedList(pageNum, pageSize)); }