public async Task <IActionResult> PutBreeds(int id, Breeds breeds) { if (id != breeds.BreedId) { return(BadRequest()); } _context.Entry(breeds).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BreedsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult Edit(Itemadder it) { if (Session["swi"] == null) { return(RedirectToAction("Index", "Home")); } if (Session["swi"] != null && Session["isadmin"] == "no") { return(RedirectToAction("Index", "Customers")); } ViewBag.message = ""; if (it.pv != null) { if (it.pv.Contains("") || it.pv.Contains(null)) { return(RedirectToAction("Index")); } try { List <int> ignore = new List <int>(); int id = 0; var e = from a in pdb.Properites select a; foreach (var a in e) { id = a.P_Id; } Categories cat = new Categories(it.cat_name); cat.Cat_Id = it.cat_id; db.Entry(cat).State = EntityState.Modified; db.SaveChanges(); bool exist = false; for (int i = 0; i < it.pv.Count; i++) { string x = it.pv[i]; var q1 = from a in pdb.Properites where a.P_Name.ToLower() == x.ToLower() select a; foreach (var b in q1) { exist = true; //Cat_pro cap = new Cat_pro(); //cap.Cat_Id = it.cat_id; //cap.P_Id = b.P_Id; //catpro.catpro.Add(cap); ignore.Add(b.P_Id); } if (exist == false) { Properites p = new Properites(it.pv[i]); id++; p.P_Id = id; ignore.Add(p.P_Id); Cat_pro cap = new Cat_pro(); cap.Cat_Id = it.cat_id; cap.P_Id = p.P_Id; catpro.catpro.Add(cap); pdb.Properites.Add(p); } } var ee = from a in catpro.catpro where a.Cat_Id == it.cat_id select a; foreach (var t in ee) { if (ignore.Contains(t.P_Id)) { } else { Properites d2 = (from a in pdb.Properites where a.P_Name.ToLower() == "model" select a).First(); Properites d3 = (from a in pdb.Properites where a.P_Name.ToLower() == "date" select a).First(); Properites d4 = (from a in pdb.Properites where a.P_Name.ToLower() == "image" select a).First(); if (t.P_Id != d2.P_Id && t.P_Id != d3.P_Id && t.P_Id != d4.P_Id) { catpro.catpro.Remove(t); } } } /* Categories cat = new Categories(it.cat_name); * cat.Cat_Id = it.cat_id; * db.Entry(cat).State = EntityState.Modified; * db.SaveChanges();*/ pdb.SaveChanges(); catpro.SaveChanges(); db.SaveChanges(); return(RedirectToAction("Index")); } catch { ViewBag.message = "INVALID ENTER"; return(View(it)); } } else { it.p = new List <Properites>(); it.pv = new List <string>(); it.ind = new List <int>(); int counter = 0; it.item_name = it.cat_name; var q6 = from s in catpro.catpro where s.Cat_Id == it.cat_id select s; foreach (var d in q6) { Properites ty = (from a in pdb.Properites where a.P_Id == d.P_Id select a).First(); if (ty.P_Name.ToLower() != "date" && ty.P_Name.ToLower() != "model" && ty.P_Name.ToLower() != "image") { counter++; it.ind.Add(d.P_Id); } } int y = 0; var q5 = from s in pdb.Properites select s; foreach (var a in q5) { if (it.ind.Contains(a.P_Id)) { it.p.Add(a); it.pv.Add(a.P_Name); } } ViewBag.number = counter; return(View(it)); } }