public ActionResult Create(SanPham sp, HinhAnh ha)
{
try
{
// TODO: Add update logic here
using (var db = new ASP_OnlineShopConnectionDB())
{
if (HttpContext.Request.Files.Count > 0)
{
if (HttpContext.Request.Files.Count != 3)
{
return(Content("<script language='javascript' type='text/javascript'>alert('Vui lòng chọn 3 hình sp!');</script>"));
}
else
{
var hpf = HttpContext.Request.Files[0];
if (hpf.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string nameImage = fileName + ".jpg";
string fullPathWithFileName = "/images/product/" + nameImage;
hpf.SaveAs(Server.MapPath(fullPathWithFileName));
sp.HinhUrl = nameImage;
}
db.Insert(sp);
var query = db.Query <SanPham>("SELECT * FROM SanPham ORDER BY MaSanPham DESC");
var id = query.First().MaSanPham;
for (int i = 0; i < 3; i++)
{
var hpf2 = HttpContext.Request.Files[i];
if (hpf2.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string nameImage = fileName + ".jpg";
string fullPathWithFileName = "/images/products/" + nameImage;
hpf2.SaveAs(Server.MapPath(fullPathWithFileName));
ha.TenHinhAnh = nameImage;
ha.MaSanPham = id;
db.Insert(ha);
}
}
}
}
//db.Update<SanPham>("SET TenSanPham=@0, GiaBan=@1, SoLuong=@2 WHERE MaSanPham=@3", sp.TenSanPham, sp.GiaBan, sp.SoLuong, id);
}
//Content("<script language='javascript' type='text/javascript'>alert('Thêm thành công!');</script>");
return(RedirectToAction("Index"));
}
catch
{
//Content("<script language='javascript' type='text/javascript'>alert('Xảy ra lỗi!');</script>");
return(View()); //đây
}
}
public static void AddToCart(int maSanPham, string maTaiKhoan)
{
using (var db = new ASP_OnlineShopConnectionDB())
{
var rs = db.Query <GioHang>("select * from GioHang where MaSanPham=@0", maSanPham);
if (rs.Count() == 0)
{
GioHang gh = new GioHang()
{
MaSanPham = maSanPham,
MaTaiKhoan = maTaiKhoan,
SoLuong = 1
};
db.Insert(gh);
}
else
{
foreach (var item in rs)
{
UpdatePlus(item.Id, item.SoLuong);
}
}
}
}
