public ActionResult Create([Bind(Include = "MaSP,HinhAnh,QuyCachDongGoi,XuatXu,MaLoai")] tb_SanPham tb_sanpham) { if (ModelState.IsValid) { tb_sanpham.TrangThai = true; db.tb_SanPham.Add(tb_sanpham); db.SaveChanges(); // db.tb_NhatKy.Add(new tb_NhatKy { NguoiDung = (string)Session["username"], DoiTuong = "Sản phẩm", ThaoTac = DateTime.Now.ToString("dd/MM/yyy hh:mm:ss") + " - Thêm sản phẩm\"" + tb_sanpham.tb_SanPhamTrans.FirstOrDefault().TenSanPhamTrans+ "\"", MaDoiTuong = tb_sanpham.MaSP}); } tb_SanPhamTrans tb_spVi = new tb_SanPhamTrans(); tb_spVi.NgonNgu = "vi"; tb_spVi.MaSP = tb_sanpham.MaSP; tb_spVi.TenSanPhamTrans = Request.Form["tenSPVn"]; tb_spVi.UuDienTrans = Request.Form["uuDiemVn"]; tb_spVi.DacDiemTrans = Request.Form["dacDiemVn"]; tb_spVi.ThanhPhanChinhTrans = Request.Form["tpChinhVn"]; tb_spVi.LuuYTrans = Request.Form["luuYVn"]; tb_spVi.CachDungTrans = Request.Form["cachDungVn"]; db.tb_SanPhamTrans.Add(tb_spVi); db.SaveChanges(); tb_SanPhamTrans tb_SpEn = new tb_SanPhamTrans(); tb_SpEn.NgonNgu = "en"; tb_SpEn.MaSP = tb_sanpham.MaSP; tb_SpEn.TenSanPhamTrans = Request.Form["tenSPEn"]; tb_SpEn.UuDienTrans = Request.Form["uuDiemEn"]; tb_SpEn.DacDiemTrans = Request.Form["dacDiemEn"]; tb_SpEn.ThanhPhanChinhTrans = Request.Form["tpChinhEn"]; tb_SpEn.LuuYTrans = Request.Form["luuYEn"]; tb_SpEn.CachDungTrans = Request.Form["cachDungEn"]; db.tb_SanPhamTrans.Add(tb_SpEn); db.SaveChanges(); ViewBag.MaLoai = new SelectList(db.tb_LoaiSP, "MaLoaiSP", "TenLoaiSP", tb_sanpham.MaLoai); return(RedirectToAction("Index")); }
public ActionResult getListProductsByCategory(int?id, int?page) { List <Object> list = new List <object>(); string lang = Request.RequestContext.RouteData.Values["lang"] as string ?? "vi"; var current = db.tb_LoaiSP.Where(x => x.MaLoaiSP == id).FirstOrDefault(); // ViewBag.LoaiCurrent = db.tb_LoaiSPTrans.Where(x => x.NgonNgu == lang && x.MaLoaiSP == id).FirstOrDefault(); if (current != null) { var listLSP = current.tb_LoaiSP1; int limit = 8; int page1 = page ?? 1; var listID = new List <int>(); listID.Add(current.MaLoaiSP); listID.AddRange(listLSP.Select(x => x.MaLoaiSP).ToList()); //var numberPage = listID.Count / limit; // ViewBag.NumberPage = numberPage + 1; var listSPFull = db.tb_SanPham.Where(x => listID.Contains(x.MaLoai)).ToList(); var listSP = listSPFull.OrderByDescending(x => x.MaSP).Skip((page1 - 1) * limit).Take(limit).ToList(); var numberPage = listSPFull.Count % limit > 0 ? listSPFull.Count / limit + 1 : listSPFull.Count / limit; string strlistsp = ""; for (int i = 0; i < listSP.Count(); i++) { tb_SanPhamTrans spTran = listSP[i].tb_SanPhamTrans.FirstOrDefault(y => y.NgonNgu == lang); if (spTran != null && string.IsNullOrWhiteSpace(spTran.TenSanPhamTrans)) { lang = lang == "en" ? "vi" : "en"; spTran = listSP[i].tb_SanPhamTrans.FirstOrDefault(y => y.NgonNgu == lang); } if (spTran == null || (spTran != null && string.IsNullOrWhiteSpace(spTran.TenSanPhamTrans))) { continue; } //RegexOptions options = RegexOptions.None; //Regex regex = new Regex("[ ]{2,}", options); //spTran.UuDienTrans = regex.Replace(spTran.UuDienTrans, "<br/>"); string uudiem = spTran.UuDienTrans.Length > 150 ? spTran.UuDienTrans.Substring(0, 147) + "..." : spTran.UuDienTrans; strlistsp += "<div class=\"col-lg-3 col-md-3 col-sm-4 col-xs-12 item-product\" data-id='product" + listSP[i].MaSP + "'><div class=\"product-image\">" + "<img src=\"" + listSP[i].HinhAnh + "\" alt=\"Avatar\" class=\"image\"></div>" + "<a class=\"name-product\" href=\"" + Url.RouteUrl("SanPhamDetails", new { id = listSP[i].MaSP, title = UrlEncode.ToFriendlyUrl(spTran.TenSanPhamTrans) }) + "\">" + spTran.TenSanPhamTrans + "</a></div>"; strlistsp += "<div class='product-uudiem' id='product" + listSP[i].MaSP + "'>" + "<div class='uu-diem'>" + "<div class='tieu-de'>" + "<h4><b>" + spTran.TenSanPhamTrans + "</b></h4>" + "</div>" + "<div class='noi-dung'>" + "<p>" + uudiem.Replace("\r\n", "<br/>") + "</p>" + "</div>" + "<div class='doc-them'>" + "<a class='btn btn-custom' href='" + Url.RouteUrl("SanPhamDetails", new { id = listSP[i].MaSP, title = UrlEncode.ToFriendlyUrl(spTran.TenSanPhamTrans) }) + "'>" + GlobalRes.ReadMore + "</a>" + "</div>" + "</div>" + "</div>"; } string pagination = ""; for (int i = 1; i <= numberPage; i++) { pagination += "<li "; if (i == page1) { pagination += "class='active'>"; } else { pagination += "onclick='chuyenTrang(" + i + ")'>"; } pagination += "<a href='javascript:;'>" + i + "</a></li>"; } list.Add(new { pagination = pagination }); list.Add(new { listproduct = strlistsp }); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "MaSP,HinhAnh,TenSanPham,UuDiem,DacDiem,ThanhPhanChinh,LuuY,QuyCachDongGoi,XuatXu,CachDung,GiaThanh,TrangThai,MaLoai")] tb_SanPham tb_sanpham) { if (ModelState.IsValid) { db.Entry(tb_sanpham).State = EntityState.Modified; db.tb_NhatKy.Add(new tb_NhatKy { NguoiDung = (string)Session["username"], DoiTuong = "Sản phẩm", ThaoTac = DateTime.Now.ToString("dd/MM/yyy hh:mm:ss") + " - Sửa sản phẩm\"" + "\"", MaDoiTuong = tb_sanpham.MaSP }); db.SaveChanges(); } bool add = false; tb_SanPhamTrans tb_spVi = db.tb_SanPhamTrans.FirstOrDefault(x => x.NgonNgu == "vi" && x.MaSP == tb_sanpham.MaSP); if (tb_spVi == null) { tb_spVi = new tb_SanPhamTrans(); add = true; } tb_spVi.NgonNgu = "vi"; tb_spVi.MaSP = tb_sanpham.MaSP; tb_spVi.TenSanPhamTrans = Request.Params["tenSPVn"]; tb_spVi.UuDienTrans = Request.Params["uuDiemVn"]; tb_spVi.DacDiemTrans = Request.Params["dacDiemVn"]; tb_spVi.ThanhPhanChinhTrans = Request.Params["tpChinhVn"]; tb_spVi.LuuYTrans = Request.Params["luuYVn"]; tb_spVi.CachDungTrans = Request.Params["cachDungVn"]; if (add) { db.tb_SanPhamTrans.Add(tb_spVi); } else { db.Entry(tb_spVi).State = EntityState.Modified; } tb_SanPhamTrans tb_SpEn = db.tb_SanPhamTrans.FirstOrDefault(x => x.NgonNgu == "en" && x.MaSP == tb_sanpham.MaSP); add = false; if (tb_SpEn == null) { tb_SpEn = new tb_SanPhamTrans(); add = true; } tb_SpEn.NgonNgu = "en"; tb_SpEn.MaSP = tb_sanpham.MaSP; tb_SpEn.TenSanPhamTrans = Request.Params["tenSPEn"]; tb_SpEn.UuDienTrans = Request.Params["uuDiemEn"]; tb_SpEn.DacDiemTrans = Request.Params["dacDiemEn"]; tb_SpEn.ThanhPhanChinhTrans = Request.Params["tpChinhEn"]; tb_SpEn.LuuYTrans = Request.Params["luuYEn"]; tb_SpEn.CachDungTrans = Request.Params["cachDungEn"]; db.tb_SanPhamTrans.Add(tb_SpEn); if (add) { db.tb_SanPhamTrans.Add(tb_SpEn); } else { db.Entry(tb_SpEn).State = EntityState.Modified; } if (db.SaveChanges() > 0) { return(RedirectToAction("Index")); } ViewBag.SpVi = tb_spVi; ViewBag.SpEn = tb_SpEn; ViewBag.MaLoai = new SelectList(db.tb_LoaiSP, "MaLoaiSP", "TenLoaiSP", tb_sanpham.MaLoai); return(View(tb_sanpham)); }