public ActionResult DeleteConfirmed(int id)
{
QuestionRoom questionRoom = db.QuestionRooms.Find(id);
db.QuestionRooms.Remove(questionRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "QuestionRoomID,Title,Creator")] QuestionRoom questionRoom)
{
if (ModelState.IsValid)
{
db.Entry(questionRoom).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(questionRoom));
}
public ActionResult Create([Bind(Include = "QuestionRoomID,Title,Creator")] QuestionRoom questionRoom)
{
if (ModelState.IsValid)
{
db.QuestionRooms.Add(questionRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(questionRoom));
}
public override void OnActionExecuting(ActionExecutingContext filterContext)//the fillter is activated after sending a comment to! -> comment increses the priority as well!!
{
MyDB db = new MyDB();
UsersController usersController = new UsersController();
//
//getting the Qroom/Post id and the current user
//
var contentid = filterContext.Controller.ValueProvider.GetValue("Id").AttemptedValue;
string userId = filterContext.HttpContext.Session["UserName"].ToString();
User user = db.Users.Where(d => d.UserName == userId).ToList().ElementAt(0);
//
//getting the controller in order to know if the user enterd a post or a Qroom
//
var controller = filterContext.Controller;
//
if (controller.GetType() == typeof(QuestionRoomsController)) // in case of QutionRoom
{
QuestionRoom questionRoom = db.QuestionRooms.Find(Int32.Parse(contentid));
foreach (RoomToCategory c in questionRoom.Categories)
{
//
//in case the catgory is alrady in the intrests list
//
if (user.Interests.Where(d => d.CategoryName == c.CategoryName).Count() > 0)
{
usersController.categoryWasViewd(c.CategoryName, userId.ToString());
}
else
{// in case the user viewed this category for the first time in a sertion preiod of time
usersController.newCategoryWasViewd(c.CategoryName, userId.ToString());
}
}
}
else //in case of post
{
Post post = db.Posts.Find(Int32.Parse(contentid));
foreach (PostToCategory c in post.Categories)
{
//
//in case the catgory is alrady in the intrests list
//
if (user.Interests.Where(d => d.CategoryName == c.CategoryName).Count() > 0)
{
usersController.categoryWasViewd(c.CategoryName, userId.ToString());
}
else
{// in case the user viewed this category for the first time in a sertion preiod of time
usersController.newCategoryWasViewd(c.CategoryName, userId.ToString());
}
}
}
}
// GET: QuestionRooms/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuestionRoom questionRoom = db.QuestionRooms.Find(id);
if (questionRoom == null)
{
return(HttpNotFound());
}
return(View(questionRoom));
}
public ActionResult Create([Bind(Include = "Title,CreatorName")] QuestionRoom questionRoom, string[] selectedOptions)
{
if (ModelState.IsValid && selectedOptions != null)
{
questionRoom.QuestionRoomID = db.QuestionRooms.Count();
for (int i = 0; i < selectedOptions.Length; i++)
{//MtM of category-room relationship
db.RoomToCategories.Add(new RoomToCategory(questionRoom.QuestionRoomID, selectedOptions[i]));
}
questionRoom.DatePublished = DateTime.Today;
db.QuestionRooms.Add(questionRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(questionRoom));
}
public ActionResult DeleteQR([Bind(Include = "QuestionRoomID")] QuestionRoom qr)
{
MyDB db = new MyDB();
if (qr.QuestionRoomID == 0)
{
return(Redirect("/QuestionRooms/Index"));
}
foreach (var item in db.QustionRoomComments.Where(d => d.RoomID == qr.QuestionRoomID).ToList())
{
db.QustionRoomComments.Remove(item);
}
QuestionRoom qR = db.QuestionRooms.Find(qr.QuestionRoomID);
db.QuestionRooms.Remove(qR);
db.SaveChanges();
return(Redirect("/QuestionRooms/Index"));
}
