public ActionResult Create(Subpost subpost, int?id)
{
if (ModelState.IsValid)
{
var v = 1;
if (db.subposts.Any())
{
v = db.subposts.OrderByDescending(u => u.OrderNr).FirstOrDefault().OrderNr + 1;
}
var s = new Subpost
{
Title = subpost.Title,
Description = subpost.Description,
OrderNr = v,
Post = db.posts.First(u => u.IDPost == id),
IDPost = id
};
db.subposts.Add(s);
db.SaveChanges();
return(RedirectToAction("Details", "Posts", new { id = id }));
}
ViewBag.IDPost = new SelectList(db.posts, "IDPost", "Title", subpost.IDPost);
return(View(subpost));
}
public ActionResult Edit([Bind(Include = "IDSubpost,Title,Description,OrderNr,IDPost")] Subpost subpost)
{
if (ModelState.IsValid)
{
db.Entry(subpost).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", "Posts", new { id = subpost.IDPost }));
}
ViewBag.IDPost = new SelectList(db.posts, "IDPost", "Title", subpost.IDPost);
return(View(subpost));
}
// GET: Subposts/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Subpost subpost = db.subposts.Find(id);
if (subpost == null)
{
return(HttpNotFound());
}
return(View(subpost));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Subpost subpost = db.subposts.Where(x => x.IDSubpost == id).Include(i => i.Post).SingleOrDefault();
if (subpost == null)
{
return(HttpNotFound());
}
return(View(subpost));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Subpost subpost = db.subposts.Find(id);
if (subpost == null)
{
return(HttpNotFound());
}
ViewBag.IDPost = new SelectList(db.posts, "IDPost", "Title", subpost.IDPost);
return(View(subpost));
}
public ActionResult DeleteConfirmed(int id)
{
int?x = db.subposts.Find(id).IDPost;
for (int i = db.subposts.OrderByDescending(u => u.OrderNr).FirstOrDefault().OrderNr; i > db.subposts.Find(id).OrderNr; i--)
{
db.subposts.Where(o => o.OrderNr == i && o.IDPost == x).SingleOrDefault().OrderNr--;
db.Entry(db.subposts.Find(db.subposts.Where(o => o.OrderNr == i).SingleOrDefault().IDSubpost)).State = EntityState.Modified;
}
Subpost subpost = db.subposts.Find(id);
db.subposts.Remove(subpost);
db.SaveChanges();
return(RedirectToAction("Details", "Posts", new { id = x }));
}
