public ActionResult DeleteConfirmed(int id) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { Genre genre = db.Genres.Find(id); // Getting all the posts of the genre List <Post> lstPosts = new List <Post>(); lstPosts = db.Posts.Where(x => x.Genre.ID == id).ToList(); // Removing all the posts of that genre foreach (Post curPost in lstPosts) { Post post = db.Posts.Find(curPost.ID); List <Comment> lstComments = new List <Comment>(); lstComments = db.Comments.Where(x => x.PostID == curPost.ID).ToList(); foreach (Comment curComm in lstComments) { db.Comments.Remove(curComm); } db.Posts.Remove(post); } db.Genres.Remove(genre); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Create([Bind(Include = "ID,Name")] Genre genre) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { if (ModelState.IsValid) { // Checking if the genre already exist var isExist = db.Genres.Where(x => x.Name == genre.Name).FirstOrDefault(); if (isExist == null) { db.Genres.Add(genre); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(View(genre)); } } return(View(genre)); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Search(string username, string firstname, string lastname) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { var queryClients = new List <Client>(); foreach (var client in db.Clients) { var usernameNeeded = username != null && username.Length > 0; var firstnameNeeded = firstname != null && firstname.Length > 0; var lastnameNeeded = lastname != null && lastname.Length > 0; if ((usernameNeeded ? client.ClientName != null && client.ClientName.Contains(username) : true) && (firstnameNeeded ? client.FirstName != null && client.FirstName.Contains(firstname) : true) && (lastnameNeeded ? client.LastName != null && client.LastName.Contains(lastname) : true)) { queryClients.Add(client); } } return(View(queryClients.OrderByDescending(x => x.ClientName))); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult DeleteConfirmed(int id) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { Client client = db.Clients.Find(id); List <Post> lstPosts = new List <Post>(); // Get the posts of the user lstPosts = db.Posts.Where(x => x.ClientID == id).ToList(); // Delete user posts foreach (Post currPost in lstPosts) { List <Comment> lstComments = new List <Comment>(); lstComments = db.Comments.Where(x => x.PostID == currPost.ID).ToList(); foreach (Comment currCmt in lstComments) { db.Comments.Remove(currCmt); } db.Posts.Remove(currPost); } // Delete user comments lstPosts = db.Posts.ToList(); foreach (Post currPost in lstPosts) { if (currPost.Comments != null) { List <Comment> lstCommentsOfCurrPost = currPost.Comments.ToList(); foreach (Comment currComment in lstCommentsOfCurrPost) { if (currComment.ClientID == id) { db.Comments.Remove(currComment); } } } } db.Clients.Remove(client); db.SaveChanges(); if (((Client)Session["Client"]).ID == id) { Session.Clear(); } return(RedirectToAction("Index")); } else { return(RedirectToAction("Index", "Home")); } }
// GET: Genres public ActionResult Index() { if (AuthorizationMiddleware.AdminAuthorized(Session)) { return(View(db.Genres.ToList())); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Edit([Bind(Include = "ID,Name")] Genre genre) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { if (ModelState.IsValid) { db.Entry(genre).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(genre)); } else { return(RedirectToAction("Index", "Home")); } }
public ActionResult Edit([Bind(Include = "ID,Gender,ClientName,FirstName,LastName,Password,isAdmin")] Client client) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { if (ModelState.IsValid) { db.Entry(client).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(client)); } else { return(RedirectToAction("Index", "Home")); } }
// GET: Clients/Edit/5 public ActionResult Edit(int?id) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Client client = db.Clients.Find(id); if (client == null) { return(HttpNotFound()); } return(View(client)); } else { return(RedirectToAction("Index", "Home")); } }
// GET: Genres/Delete/5 public ActionResult Delete(int?id) { if (AuthorizationMiddleware.AdminAuthorized(Session)) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Genre genre = db.Genres.Find(id); if (genre == null) { return(HttpNotFound()); } return(View(genre)); } else { return(RedirectToAction("Index", "Home")); } }