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