public ActionResult Edit(int id, SanPham sp)
{
var db = new MobileShopConnectionDB();
var rs = db.SingleOrDefault <MobileShopConnection.SanPham>("select HinhAnh from sanpham where MaSP=@0", id);
if (HttpContext.Request.Files.Count > 0)
{
var hpf = HttpContext.Request.Files[0];
if (hpf.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string fullPathWithFileName = "/ShopOnline/img/" + fileName + ".jpg";
hpf.SaveAs(Server.MapPath(fullPathWithFileName));
sp.HinhAnh = fileName + ".jpg";
}
else
{
sp.HinhAnh = rs.HinhAnh;
}
}
SanPhamBus.Sua(sp);
return(RedirectToAction("Index"));
}
public static SanPham LoadAvartaImg(String id)
{
var sql = new MobileShopConnectionDB();
return(sql.SingleOrDefault <SanPham>("select * from SanPham where MaSP = @0", id));
}
//edit
public static NhaSanXuat EditNSX(String id)
{
var sql = new MobileShopConnectionDB();
return(sql.SingleOrDefault <NhaSanXuat>("select * from NhaSanXuat where MaNhaSX = '" + id + "'"));
}
public static MobileShopConnection.LoaiSP ChiTiet(int id)
{
var db = new MobileShopConnectionDB();
return(db.SingleOrDefault <MobileShopConnection.LoaiSP>("select * from LoaiSP where MaLoai=@0", id));
}
//EDIT
public static LoaiSP EditLSP(String id)
{
var sql = new MobileShopConnectionDB();
return(sql.SingleOrDefault <LoaiSP>("select * from LoaiSP where MaLoaiSP = '" + id + "'"));
}
public static MobileShopConnection.SanPham ChiTiet(int id)
{
var db = new MobileShopConnectionDB();
return(db.SingleOrDefault <MobileShopConnection.SanPham>("select * from sanpham where MaSP=@0", id));
}