public bool Create(SanphamModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "sp_item_create",
"@masanpham", model.masanpham,
"@tensanpham", model.tensanpham,
"@mau", model.mau,
"@dongia", model.dongia,
"@content", model.content,
"@manhasanxuat", model.manhasanxuat,
"@maloai", model.maloai);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update(SanphamModel model)
{
string msgError = "";
try
{
var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "suasanpham",
"@MASP", model.MASP,
"@MACODE", model.MACODE,
"@TENSP", model.TENSP,
"@GIA", model.GIA,
"@MAGIAMGIA", model.MAGIAMGIA,
"@HINH", model.HINH,
"@SOLUONGTON", model.SOLUONGTON,
"@NGAYNHAP", model.NGAYNHAP,
"@MOTA", model.MOTA,
"@ANHIEN", model.ANHIEN,
"@MALOAI", model.MALOAI
);
if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError))
{
throw new Exception(Convert.ToString(result) + msgError);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult SeachWithname(string name)
{
SanphamModel list = new SanphamModel();
IQueryable <SPHAM> kq = list.Searchwithname(name);
var js = (from p in kq orderby p.MASP descending select new { p.MASP, p.TENSP, p.ANHDAIDIEN, p.GIA }).Take(5);
return(Json(js, JsonRequestBehavior.AllowGet));
}
public ActionResult themsp()
{
SanphamModel sp = new SanphamModel();
ViewBag.HANGSX = new SelectList(sp.Gethangsanxuat(), "HANGSX", "TENHANG ");
ViewBag.LOAISP = new SelectList(sp.Getloaisp(), "MALOAI", "TENLOAI");
return(View());
}
protected void rptSanpham_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
SanphamModel sanpham = e.Item.DataItem as SanphamModel;
if (sanpham != null)
{
Image imgSanpham = e.Item.FindControl("imgSanpham") as Image;
if (imgSanpham != null)
{
imgSanpham.ImageUrl = string.Format("~/{0}", sanpham.sHinhanh);
}
Literal ltrGiaDangApdung = e.Item.FindControl("ltrGiaDangApdung") as Literal;
SanphamController brlSanpham = new SanphamController();
if (ltrGiaDangApdung != null)
{
decimal giaDangApdung = brlSanpham.GetGiaDangApdungByFKSanphamID(sanpham.PK_iSanphamID);
ltrGiaDangApdung.Text = giaDangApdung < 0 ? "Liên hệ" : giaDangApdung.ToString("C0");
}
Literal ltrLoaiSanpham = e.Item.FindControl("ltrLoaiSanpham") as Literal;
if (ltrLoaiSanpham != null)
{
int loaiSanphamID = sanpham.FK_iLoaiSanphamID;
if (loaiSanphamID > 0)
{
List <LoaiSanphamModel> glstLoaisanpham = brlSanpham.LoaiSanphamGetbyPK(loaiSanphamID);
if (glstLoaisanpham.Count > 0)
{
ltrLoaiSanpham.Text = glstLoaisanpham[0].sTenLoaiSanpham;
}
}
}
Literal ltrKhuyenmaiDangApdung = e.Item.FindControl("ltrKhuyenmaiDangApdung") as Literal;
if (ltrKhuyenmaiDangApdung != null)
{
int khuyenmaiDangapdung = Convert.ToInt32(brlSanpham.GetKhuyenmaiDangApdungByFKSanphamID(sanpham.PK_iSanphamID) * 100);
ltrKhuyenmaiDangApdung.Text = khuyenmaiDangapdung < 0 ? string.Empty : string.Format("{0}%", khuyenmaiDangapdung);
}
HyperLink hrefDieuChinhgia = e.Item.FindControl("hrefDieuChinhgia") as HyperLink;
if (hrefDieuChinhgia != null)
{
hrefDieuChinhgia.NavigateUrl = string.Format("~/DieuchinhGia.aspx?gsp={0}", sanpham.PK_iSanphamID);
}
HyperLink hrefDieuChinhKhuyenmai = e.Item.FindControl("hrefDieuChinhKhuyenmai") as HyperLink;
if (hrefDieuChinhKhuyenmai != null)
{
hrefDieuChinhKhuyenmai.NavigateUrl = string.Format("~/DieuchinhKhuyenmai.aspx?kmsp={0}", sanpham.PK_iSanphamID);
}
HyperLink hrefCongthuc = e.Item.FindControl("hrefCongthuc") as HyperLink;
if (hrefCongthuc != null)
{
hrefCongthuc.NavigateUrl = string.Format("~/Congthuc.aspx?ctsp={0}", sanpham.PK_iSanphamID);
}
} //sanpham
} //ItemType
}
public ActionResult Addvendsearchpt(string ten, string loai, string hangsx, int?max, int?min, int?page, string typeview)
{
ViewBag.Theoten = ten;
ViewBag.Theoloai = loai;
ViewBag.Theohang = hangsx;
ViewBag.Giamax = max;
ViewBag.Giamin = min;
ViewBag.type = typeview;
SanphamModel list = new SanphamModel();
IQueryable <SPHAM> sp = list.Searchaddvend(ten, loai, hangsx, max, min);
return(Phantrang(sp, page));
}
public ActionResult Addsanpham([Bind(Include = "TENSP,LOAISP,HANGSX,GIA,MOTA,SOLUONG,ISNEW")] SPHAM sanpham, HttpPostedFileBase an)
{
SanphamModel spm = new SanphamModel();
if (ModelState.IsValid)
{
string masp = spm.themsp(sanpham);
UploadAnh(an, masp + "1"); //waring masp+1 not get picture up to list
}
ViewBag.HANGSX = new SelectList(spm.Gethangsanxuat(), "HANGSX", "TENHANG ");
ViewBag.LOAISP = new SelectList(spm.Getloaisp(), "MALOAI", "TENLOAI");
return(View("themsp", sanpham));
}
public SanphamModel UpdateSP([FromBody] SanphamModel model)
{
if (model.HINH != null)
{
var arrData = model.HINH.Split(';');
if (arrData.Length == 3)
{
var savePath = $@"{arrData[0]}";
model.HINH = $"{savePath}";
SaveFileFromBase64String(savePath, arrData[2]);
}
}
_SanphamBusiness.Update(model);
return(model);
}
public bool Updatetinhtrangdh(string madh, int?tt)
{
if (tt == null)
{
return(false);
}
try {
Shopbanhang db = new Shopbanhang();
DONHANG dh = db.DONHANGs.Find(madh);
if (dh.TINHTRANGDH == 4 || dh.TINHTRANGDH == 3)
{
return(false);
}
if (dh.TINHTRANGDH == 1)
{
if (tt == 2 || tt == 3)
{
foreach (var item in db.CTDONHANGs)
{
SanphamModel sp = new SanphamModel();
sp.UpdateSoluong(item.MASP, item.SOLUONG, false);
}
}
}
if (dh.TINHTRANGDH == 2)
{
if (tt == 4)
{
foreach (var item in db.CTDONHANGs)
{
SanphamModel sp = new SanphamModel();
sp.UpdateSoluong(item.MASP, item.SOLUONG, false);
}
}
if (tt == 1)
{
return(false);
}
}
string query = "update DONHANG set TINHTRANGDH = " + tt + " where MADONHANG ='" + madh + "'";
db.Database.ExecuteSqlCommand(query);
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Sanphammoinhat(int?skip)
{
SanphamModel sp = new SanphamModel();
int skipnum = (skip ?? 0);
IQueryable <SPHAM> splist = sp.SPMoiNhap();
splist = splist.OrderBy(r => r.MASP).Skip(skipnum).Take(8);
if (splist.Any())
{
return(PartialView("_ProductTabLoadMorePartial", splist));
}
else
{
return(null);
}
}
public JsonResult sanpham()
{
SanphamModel sanpham = new SanphamModel();
var model = sanpham.Getsp();
return(this.Json(
new
{
data = (from obj in db.SPHAMs select new { MASP = obj.MASP, TENSP = obj.TENSP,
LOAISP = obj.LOAISP,
HANGSX = obj.HANGSX,
GIA = obj.GIA,
SOLUONG = obj.SOLUONG,
MOTA = obj.MOTA,
ANHDAIDIEN = obj.ANHDAIDIEN })
}
, JsonRequestBehavior.AllowGet
));
}
public bool Update(SanphamModel model)
{
return(_res.Update(model));
}
public bool Create(SanphamModel model)
{
return(_res.Create(model));
}
public SanphamModel Update([FromBody] SanphamModel model)
{
_itemBusiness.Update(model);
return(model);
}
public SanphamModel CreateItem([FromBody] SanphamModel model)
{
_itemBusiness.Create(model);
return(model);
}