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