public ActionResult SuaSP(ThongTinSP sp, SanPham a)
{
test2Entities data = new test2Entities();
var result1 = data.SanPhams.Where(x => x.ID.Equals(sp.ID)).FirstOrDefault();
var Result2 = data.infoProducts.Where(x => x.idProduct == sp.ID);
foreach (var item in Result2)
{
data.infoProducts.Remove(item);
}
string[] TenQuocGia = sp.NationalName.Trim().Split(' ');
var ListNational = data.NATIONALs;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = sp.ID;
data.infoProducts.Add(info);
break;
}
}
}
result1.Ten = a.Ten;
result1.SoLuong = a.SoLuong;
data.SaveChanges();
return(RedirectToAction("SanPham"));
}
public ActionResult ThemSanPham(ThongTinSP sp, SanPham b)
{
test2Entities data = new test2Entities();
SanPham a = new SanPham();
a.Ten = b.Ten;
a.SoLuong = sp.SoLuong;
data.SanPhams.Add(a);
string[] TenQuocGia = sp.NationalName.Trim().Split(' ');
var ListNational = from x in data.NATIONALs select x;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = a.ID;
data.infoProducts.Add(info);
break;
}
}
}
data.SaveChanges();
return(RedirectToAction("SanPham"));
}
public JsonResult ThemSPJson(string ten, int soluong, string nationalname, HttpPostedFileBase fileImg)
{
try
{
test2Entities data = new test2Entities();
SanPham a = new SanPham();
a.Ten = ten;
a.SoLuong = soluong;
data.SanPhams.Add(a);
string[] TenQuocGia = nationalname.Trim().Split(' ');
var ListNational = from x in data.NATIONALs select x;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = a.ID;
data.infoProducts.Add(info);
break;
}
}
}
string path = System.IO.Path.Combine(Server.MapPath("~/img/"), fileImg.FileName);
fileImg.SaveAs(path);
IMG img = new IMG();
img.IMGPath = "/Img/" + fileImg.FileName;
img.IDProduct = a.ID;
img.title = ten;
data.IMGs.Add(img);
data.SaveChanges();
return(Json(1));
}
catch (Exception ex)
{ return(Json(0)); }
}
public JsonResult SuaSanpham(int id, string Ten, int SoLuong, string NationalName, HttpPostedFileBase IMGSua)
{
try
{
test2Entities data = new test2Entities();
var result1 = data.SanPhams.Where(x => x.ID.Equals(id)).FirstOrDefault();
var Result2 = data.infoProducts.Where(x => x.idProduct == id);
foreach (var item in Result2)
{
data.infoProducts.Remove(item);
}
string[] TenQuocGia = NationalName.Trim().Split(' ');
var ListNational = data.NATIONALs;
for (int i = 0; i < TenQuocGia.Length; i++)
{
foreach (var item in ListNational)
{
if (TenQuocGia[i].ToLower().Trim() == item.NationalName.Trim().ToLower())
{
infoProduct info = new infoProduct();
info.NationalID = item.NationalID;
info.idProduct = id;
data.infoProducts.Add(info);
break;
}
}
}
result1.Ten = Ten;
result1.SoLuong = SoLuong;
if (IMGSua != null)
{
var result = data.IMGs.Where(x => x.IDProduct == id).FirstOrDefault();
string imgPath = result.IMGPath.Trim();
imgPath = imgPath.Substring(5);
string path = System.IO.Path.Combine(Server.MapPath("~/Img/"), imgPath);
System.IO.File.Delete(path);
data.IMGs.Remove(result);
string path1 = System.IO.Path.Combine(Server.MapPath("~/Img/"), IMGSua.FileName);
IMGSua.SaveAs(path1);
IMG img = new IMG();
img.IMGPath = "/Img/" + IMGSua.FileName;
img.IDProduct = id;
img.title = Ten;
data.IMGs.Add(img);
}
data.SaveChanges();
return(Json("sửa thành công"));
}
catch (Exception ex)
{
return(Json(0));
}
}