public JsonResult GetImage(int id, string direction) { ImageDbEntities db = new ImageDbEntities(); IQueryable <Image> data = null; if (direction == "N") { data = (from item in db.Images where item.Id > id orderby item.Id ascending select item).Take(1); } if (direction == "P") { data = (from item in db.Images where item.Id < id orderby item.Id descending select item).Take(1); } if (direction == "") { data = from item in db.Images where item.Id == id select item; } return(Json(data.SingleOrDefault())); }
public ActionResult Index() { ImageDbEntities db = new ImageDbEntities(); IQueryable <Image> data = null; data = (from item in db.Images orderby item.Id ascending select item).Take(1); return(View(data.SingleOrDefault())); }
public ActionResult Index(int id = 0) { ImageDbEntities db = new ImageDbEntities(); IQueryable <Image> data = null; if (id == 0) { data = (from item in db.Images orderby item.Id ascending select item).Take(1); } else { data = from item in db.Images where item.Id == id select item; } return(View(data.SingleOrDefault())); }
public ActionResult Index(int id = 0) { ImageDbEntities db = new ImageDbEntities(); IQueryable <Image> data = null; int minId, maxId, prevId, nextId; minId = (from item in db.Images orderby item.Id ascending select item.Id).Min(); maxId = (from item in db.Images orderby item.Id ascending select item.Id).Max(); if (id == 0) { id = minId; } prevId = ((from item in db.Images where item.Id < id orderby item.Id descending select item.Id).Take(1)).SingleOrDefault(); if (prevId == 0) { prevId = minId; } nextId = ((from item in db.Images where item.Id > id orderby item.Id ascending select item.Id).Take(1)).SingleOrDefault(); if (nextId == 0) { nextId = maxId; } data = from item in db.Images where item.Id == id select item; ViewBag.PreviousId = prevId; ViewBag.NextId = nextId; return(View(data.SingleOrDefault())); }