public ActionResult CreateImage(int masp)
{
OImageSach data = new OImageSach();
data.TrangThai = false;
data.MaSanPham = masp;
var product = sanphamService.Get(new OSanPham {
MaSanPham = masp
});
ViewBag.Product = product;
return(View("UpdateImage", data));
}
public ActionResult CreateImage(OImageSach model)
{
try
{
imgService.Add(model);
return(RedirectToAction("Images", "QuanLySanPham", new { masp = model.MaSanPham }));
}
catch (Exception e)
{
}
ViewBag.IsEdit = true;
return(View("UpdateImage", model));
}
public void Add(OImageSach item)
{
conn.connect();
var comm = new SqlCommand("Image_SanPham_Add", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return;
}
comm.Parameters.Add(new SqlParameter("@MoTa", item.MoTa ?? (object)DBNull.Value));
comm.Parameters.Add("@DuongDan", SqlDbType.NVarChar).Value = item.DuongDan;
comm.Parameters.Add("@MaSanPham", SqlDbType.Int).Value = item.MaSanPham;
comm.Parameters.Add("@IsActive", SqlDbType.Bit).Value = item.TrangThai;
comm.ExecuteNonQuery();
}
public OImageSach Get(OImageSach item)
{
conn.connect();
var comm = new SqlCommand("Image_SanPham_Get", conn.db);
comm.CommandType = CommandType.StoredProcedure;
if (comm == null)
{
return(null);
}
comm.Parameters.Add("@IdImage", SqlDbType.Int).Value = item.MaAnh;
DataTable dt = new DataTable();
OImageSach model = new OImageSach();
dt.Load(comm.ExecuteReader());
model = Help.DAL.ConvertDataTable <OImageSach>(dt).FirstOrDefault();
return(model);
}
public ActionResult UpdateImage(OImageSach model)
{
if (ModelState.IsValid)
{
var pro = imgService.Get(new OImageSach {
MaAnh = model.MaAnh
});
if (pro != null)
{
try
{
imgService.Update(model);
return(RedirectToAction("Images", "QuanLySanPham", new { masp = model.MaSanPham }));
}
catch (Exception e)
{
}
}
}
ViewBag.IsEdit = true;
return(View(model));
}
