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