public ActionResult DeleteConfirmed(Guid id) { AnimalsTable animalsTable = db.AnimalsTables.Find(id); db.AnimalsTables.Remove(animalsTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AnimalId,Name,Age,Type")] AnimalsTable animalsTable) { if (ModelState.IsValid) { db.Entry(animalsTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animalsTable)); }
public ActionResult Create([Bind(Include = "AnimalId,Name,Age,Type")] AnimalsTable animalsTable) { if (ModelState.IsValid) { animalsTable.AnimalId = Guid.NewGuid(); db.AnimalsTables.Add(animalsTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animalsTable)); }
// GET: AnimalsTables/Delete/5 public ActionResult Delete(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AnimalsTable animalsTable = db.AnimalsTables.Find(id); if (animalsTable == null) { return(HttpNotFound()); } return(View(animalsTable)); }
public void BindGrid(string sortExpression = "", bool isSort = false) { using (var db = new AGRODataContext(Server.MapPath("\\"))) { IQueryable <Animals> query = db.Animals; switch (sortExpression) { case "IdA": query = GetSortExpression(query, a => a.IdA, "IdA", isSort); break; case "AName": query = GetSortExpression(query, a => a.AName, "AName", isSort); break; case "MarketPrice": query = GetSortExpression(query, a => a.MarketPrice, "MarketPrice", isSort); break; case "Count": query = GetSortExpression(query, a => a.Count, "Count", isSort); break; default: query = GetSortExpression(query, a => a.IdA, "IdA", isSort); break; } var source = query .Select(x => new { IdA = x.IdA, AName = x.AName, MarketPrice = x.MarketPrice, Count = x.Count }) .ToList(); AnimalsTable.DataSource = source; AnimalsTable.DataBind(); } }