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