public ActionResult DeleteConfirmed(int id)
{
ProjectQuestion projectQuestion = db.ProjectQuestions.Find(id);
db.ProjectQuestions.Remove(projectQuestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ProjectQuestionID,ProjectID,UserID,Question,Answer")] ProjectQuestion projectQuestion)
{
if (ModelState.IsValid)
{
db.Entry(projectQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(projectQuestion));
}
public ActionResult Create([Bind(Include = "ProjectID,Question")] ProjectQuestion projectQuestion)
{
if (ModelState.IsValid)
{
db.ProjectQuestions.Add(projectQuestion);
db.SaveChanges();
return(RedirectToAction("FAQ"));
}
return(View(projectQuestion));
}
public ActionResult Edit([Bind(Include = "ProjectQuestionID,Answer")] ProjectQuestion projectQuestion)
{
if (ModelState.IsValid)
{
string sqlStatement = "UPDATE ProjectQuestion SET Answer = '" + projectQuestion.Answer + "' WHERE ProjectQuestion.ProjectQuestionID = '" + projectQuestion.ProjectQuestionID + "';";
db.Database.ExecuteSqlCommand(sqlStatement);
//db.Entry(projectQuestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("FAQ"));
}
return(View(projectQuestion));
}
// GET: ProjectQuestions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProjectQuestion projectQuestion = db.ProjectQuestions.Find(id);
if (projectQuestion == null)
{
return(HttpNotFound());
}
return(View(projectQuestion));
}
