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