// Delete public bool removeQuestion(int?clarId) { int clarificationId = Convert.ToInt32(clarId); clarification clar = GetClarificationByClarId(clarificationId); List <clarificationAnswer> tempList = lisClarAns(clarificationId); var clarS = (from clars in db.clarifications where clars.clarificationId.Equals(clarificationId) select clars).FirstOrDefault(); try { foreach (clarificationAnswer ans in tempList) { db.clarificationAnswer.Remove(ans); db.SaveChanges(); } db.clarifications.Remove(clarS); db.SaveChanges(); db.clarification.Remove(clar); db.SaveChanges(); } catch { return(false); } return(true); }
public ActionResult DeleteConfirmed(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } clarification clarification = db.clarifications1.Find(id); db.clarifications1.Remove(clarification); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Details(int?id) { if (id == null) { return(RedirectToAction("Index", "Home")); } clarification clarification = db.clarifications1.Find(id); if (clarification == null) { return(HttpNotFound()); } return(View(clarification)); }
public JsonResult DeleteProblem(string id) { if (id == null) { return(Json(new { status = "failed" }, JsonRequestBehavior.AllowGet)); } int prbId = Convert.ToInt32(id); problem prob = db.problem.Find(prbId); problems prob2 = problmService.GetConnectionById(prbId); int aId = prob2.id; //because errors problems probs = db.problems.Find(aId); List <testcase> cases = problmService.getTestCasesOfProblem(prbId); foreach (var item in cases) { db.testcaseOutput.RemoveRange(db.testcaseOutput.Where(b => b.testcaseId == item.id)); } foreach (var item in cases) { int bId = item.id; testcase tst = db.testcase.Find(bId); db.testcase.Remove(tst); } db.testcases.RemoveRange(db.testcases.Where(b => b.problemId == prbId)); List <clarification> clars = clarificationService.getClarificationsOfProblem(prbId); foreach (var item in clars) { db.clarificationAnswer.RemoveRange(db.clarificationAnswer.Where(b => b.clarificationId == item.id)); } foreach (var item in clars) { int cId = item.id; clarification clr = db.clarification.Find(cId); db.clarification.Remove(clr); } db.clarifications.RemoveRange(db.clarifications.Where(b => b.problemId == prbId)); db.problem.Remove(prob); db.problems.Remove(probs); db.SaveChanges(); return(Json(new { status = "successRemove" }, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("Index", "Home")); } clarification clarification = db.clarifications1.Find(id); if (clarification == null) { return(HttpNotFound()); } account user = accountHelper.getCurrentUser(Session["User"].ToString()); int userId = user.id; ViewBag.userName = user.name; ViewBag.imagePath = user.imagePath; return(View(clarification)); }
public ActionResult Edit([Bind(Include = "id,authorId,message,posted")] clarification clarification) { if (clarification == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (ModelState.IsValid) { db.Entry(clarification).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } account user = accountHelper.getCurrentUser(Session["User"].ToString()); int userId = user.id; ViewBag.userName = user.name; ViewBag.imagePath = user.imagePath; return(View(clarification)); }
public ActionResult Create([Bind(Include = "id,authorId,message,posted")] clarification clarification) { if (clarification == null) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { db.clarifications1.Add(clarification); db.SaveChanges(); return(RedirectToAction("Index")); } account user = accountHelper.getCurrentUser(Session["User"].ToString()); int userId = user.id; ViewBag.userName = user.name; ViewBag.imagePath = user.imagePath; return(View(clarification)); }
// Put question public bool AddQuestion(string pId, int userId, string msg) { int problemId = Convert.ToInt32(pId); DateTime localDate = DateTime.Now; clarification clar = new clarification { authorId = userId, message = msg, posted = localDate }; db.clarification.Add(clar); db.SaveChanges(); clarifications clars = new clarifications { clarificationId = clar.id, problemId = problemId }; db.clarifications.Add(clars); db.SaveChanges(); return(true); }