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"));
}
