public ActionResult Details(int?id) { tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); Session["title"] = ViewBag.shoptitle; Session["icon"] = hea.shortcuticon; var CT_SP = (db.tbl_Products.First(sp => sp.ID == id)); int loai = int.Parse(CT_SP.IDLoaiSP.ToString()); ViewBag.TenLoai = (from s in db.tbl_Products from l in db.tbl_product_types where s.ID == id && s.IDLoaiSP == l.ID && s.Status == true select l); ViewBag.SP_cungloai = (from s in db.tbl_Products where s.ID == id && s.IDLoaiSP == loai && s.Status == true select s).Skip(0).Take(4).ToList(); ViewBag.SP_khac = (from s in db.tbl_Products where s.ID == id && s.IDLoaiSP != loai && s.Status == true select s).Skip(0).Take(4).ToList(); //CT_SP.LuotXem += 1; //UpdateModel(CT_SP); //db.SubmitChanges(); ViewBag.Title = CT_SP.title; ViewBag.keyword = CT_SP.keyword; ViewBag.description = CT_SP.description; return(View(CT_SP)); }
public ActionResult ProductType(string id, int?page, string sorting) { tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); Session["title"] = ViewBag.shoptitle; Session["icon"] = hea.shortcuticon; int pageSize = 20; int pageNum = (page ?? 1); var laysp = from g in db.tbl_Products from h in db.tbl_product_types where h.alias.Equals(id) && g.IDLoaiSP == h.ID && g.Status == true && h.Status == true select g; Session["loai"] = id; tbl_product_type loai = db.tbl_product_types.SingleOrDefault(n => n.alias.Equals(id)); Session["tenloai"] = loai.TenLoaiSP; ViewBag.TenLoai = (from l in db.tbl_product_types where l.alias.Equals(id) select l); ViewBag.TenSapXep = "Sắp xếp: A đến Z"; ViewBag.NameSortParm = "Name_desc"; ViewBag.NameSortParmasc = "Name_asc"; ViewBag.DateSortParm = "Date_desc"; ViewBag.PriceSortParm = "Price_desc"; ViewBag.PriceSortPasc = "Price"; if (sorting == "Name_desc") { ViewBag.TenSapXep = "Sắp xếp: Z đến A"; return(View(laysp.OrderByDescending(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Name_asc") { ViewBag.TenSapXep = "Sắp xếp: A đến Z"; return(View(laysp.OrderBy(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Date_desc") { ViewBag.TenSapXep = "Sản phẩm mới"; return(View(laysp.OrderByDescending(n => n.NgayCapNhat).ToPagedList(pageNum, pageSize))); } if (sorting == "Price_desc") { ViewBag.TenSapXep = "Sắp xếp Giá: Cao Đến Thấp"; return(View(laysp.OrderByDescending(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } if (sorting == "Price") { ViewBag.TenSapXep = "Sắp xếp Giá: Thấp đến Cao"; return(View(laysp.OrderBy(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } return(View(laysp.ToPagedList(pageNum, pageSize))); }
public ActionResult Search(string txttimkiem, string sorting, int?page) { tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); Session["icon"] = hea.shortcuticon; int pageNum = (page ?? 1); int pageSize = 20; string tukhoa = txttimkiem; if (String.IsNullOrEmpty(tukhoa)) { tukhoa = ""; } ViewBag.tukhoa = tukhoa; Session["timkiem"] = txttimkiem; List <tbl_Product> sp = db.tbl_Products.Where(n => n.TenSP.Contains(tukhoa)).ToList(); ViewBag.TenSapXep = "Sắp xếp: A đến Z"; ViewBag.NameSortParm = "Name_desc"; ViewBag.NameSortParmasc = "Name_asc"; ViewBag.DateSortParm = "Date_desc"; ViewBag.PriceSortParm = "Price_desc"; ViewBag.PriceSortPasc = "Price"; if (sorting == "Name_desc") { ViewBag.TenSapXep = "Sắp xếp: Z đến A"; return(View(sp.OrderByDescending(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Name_asc") { ViewBag.TenSapXep = "Sắp xếp: A đến Z"; return(View(sp.OrderBy(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Date_desc") { ViewBag.TenSapXep = "Sản phẩm mới"; return(View(sp.OrderByDescending(n => n.NgayCapNhat).ToPagedList(pageNum, pageSize))); } if (sorting == "Price_desc") { ViewBag.TenSapXep = "Sắp xếp Giá: Cao Đến Thấp"; return(View(sp.OrderByDescending(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } if (sorting == "Price") { ViewBag.TenSapXep = "Sắp xếp Giá: Thấp đến Cao"; return(View(sp.OrderBy(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } return(View(sp.OrderBy(n => n.TenSP).ToPagedList(pageNum, pageSize))); }
public ActionResult hienthica3(int?page, string sorting) { tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); Session["icon"] = hea.shortcuticon; int pageSize = 20; int pageNum = (page ?? 1); var laysp = from g in db.tbl_Products where g.SachMoiMoiNgay == true && g.Status == true orderby g.NgayCapNhat descending select g; ViewBag.TenSapXep = "Sắp xếp: A đến Z"; ViewBag.NameSortParm = "Name_desc"; ViewBag.NameSortParmasc = "Name_asc"; ViewBag.DateSortParm = "Date_desc"; ViewBag.PriceSortParm = "Price_desc"; ViewBag.PriceSortPasc = "Price"; if (sorting == "Name_desc") { ViewBag.TenSapXep = "Sắp xếp: Z đến A"; return(View(laysp.OrderByDescending(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Name_asc") { ViewBag.TenSapXep = "Sắp xếp: A đến Z"; return(View(laysp.OrderBy(n => n.TenSP).ToPagedList(pageNum, pageSize))); } if (sorting == "Date_desc") { ViewBag.TenSapXep = "Sản phẩm mới"; return(View(laysp.OrderByDescending(n => n.NgayCapNhat).ToPagedList(pageNum, pageSize))); } if (sorting == "Price_desc") { ViewBag.TenSapXep = "Sắp xếp Giá: Cao Đến Thấp"; return(View(laysp.OrderByDescending(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } if (sorting == "Price") { ViewBag.TenSapXep = "Sắp xếp Giá: Thấp đến Cao"; return(View(laysp.OrderBy(n => n.GiaHienTai).ToPagedList(pageNum, pageSize))); } return(View(laysp.ToPagedList(pageNum, pageSize))); }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { // Your logic here... tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); tbl_shop shop = db.tbl_shops.SingleOrDefault(n => n.id == 1); Session["icon"] = hea.shortcuticon; Session["title"] = shop.title; Session.Timeout = 40; ViewBag.Title = shop.title; ViewBag.icon = hea.shortcuticon; ViewBag.keyword = shop.keyword; ViewBag.shoptitle = shop.title; ViewBag.description = shop.description; base.OnActionExecuting(filterContext); }
public ActionResult headerEdit(FormCollection form, HttpPostedFileBase fileUpload, HttpPostedFileBase fileUpload2) { tbl_header tic = getHeader(); var tittle = form["tittle"]; var phone1 = form["phone1"]; var phone2 = form["phone2"]; tic.phone1 = phone1; tic.phone2 = phone2; if (form["chkClearImg"] != null) { tic.image = ""; } else if (fileUpload != null) { var fileName = Path.GetFileName(DateTime.Now.Millisecond + fileUpload.FileName); var path = Path.Combine(Server.MapPath(URLHelper.URL_IMAGE_PATH), fileName); if (!System.IO.File.Exists(path)) { fileUpload.SaveAs(path); } tic.image = fileName; } if (form["chkClearImgIcon"] != null) { tic.shortcuticon = ""; } else if (fileUpload2 != null) { var fileName = Path.GetFileName(DateTime.Now.Millisecond + fileUpload2.FileName); var path = Path.Combine(Server.MapPath(URLHelper.URL_IMAGE_PATH), fileName); if (!System.IO.File.Exists(path)) { fileUpload2.SaveAs(path); } tic.shortcuticon = fileName; } UpdateModel(tic); data.SubmitChanges(); return(RedirectToAction("Index", "Admin")); }
protected override void OnActionExecuting(ActionExecutingContext filterContext) { Session.Timeout = 720; // Your logic here... tbl_header hea = db.tbl_headers.SingleOrDefault(n => n.id == 1); tbl_shop shop = db.tbl_shops.SingleOrDefault(n => n.id == 1); Session["icon"] = hea.shortcuticon; Session["title"] = shop.title; ViewBag.logo = hea.image; ViewBag.Title = shop.title; ViewBag.icon = hea.shortcuticon; ViewBag.keyword = shop.keyword; ViewBag.shoptitle = shop.title; ViewBag.description = shop.description; ViewBag.CurrentNumberFormat = new System.Globalization.CultureInfo("de-DE", false).NumberFormat; ViewBag.phone = shop.phoneshop; base.OnActionExecuting(filterContext); }