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