public ActionResult Edit([Bind(Include = "Topic_Seq,Topic_Name,Description")] Question_Topic question_Topic)
{
if (ModelState.IsValid)
{
if (AreThereDuplicatesTopics(question_Topic.Topic_Name))
{
if (db.Question_Topic.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).Select(Y => Y.Topic_Name).Single() == question_Topic.Topic_Name)
{
db.Entry(question_Topic).State = EntityState.Modified;
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
string name = db.Question_Topic.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).Select(Y => Y.Topic_Name).Single();
Person_Session_Action_Log psal = new Person_Session_Action_Log();
psal.Action_DateTime = DateTime.Now;
psal.Action_ID = 11;
psal.Session_ID = db.Person_Session_Log.Select(Y => Y.Session_ID).Max();
psal.Action_Performed = "Question topic: " + name;
psal.Crud_Operation = "Edit";
db.Person_Session_Action_Log.Add(psal);
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
ViewBag.Topic = question_Topic.Topic_Seq;
return(View("Edit_Some_More"));
}
else
{
ModelState.AddModelError("Topic_Name", "This topic already exists. Please choose another topic name.");
ViewBag.Topic_Name = question_Topic.Topic_Name;
ViewBag.Description = question_Topic.Description;
return(View("Edit"));
}
}
else
{
db.Entry(question_Topic).State = EntityState.Modified;
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
string name = db.Question_Topic.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).Select(Y => Y.Topic_Name).Single();
Person_Session_Action_Log psal = new Person_Session_Action_Log();
psal.Action_DateTime = DateTime.Now;
psal.Action_ID = 11;
psal.Session_ID = db.Person_Session_Log.Select(Y => Y.Session_ID).Max();
psal.Crud_Operation = "Edit";
psal.Action_Performed = "Question topic: " + name;
db.Person_Session_Action_Log.Add(psal);
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
ViewBag.Topic = question_Topic.Topic_Seq;
return(View("Edit_Some_More"));
}
}
return(View(question_Topic));
}
public ActionResult DeleteConfirmed(int id)
{
Question_Topic question_Topic = db.Question_Topic.Find(id);
int _Count = 0;
_Count = db.Questionnaires.Where(X => X.Topic_Seq == id).Count();
if (_Count != 0)
{
ViewBag.Error = "This topic cannot be deleted as it is being used in a questionnaire";
Question_Topic q_Topic = db.Question_Topic.Find(id);
return(View(q_Topic));
}
else
{
// -------------------------------Action Log ----------------------------------------//
string name = db.Question_Topic.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).Select(Y => Y.Topic_Name).Single();
Person_Session_Action_Log psal = new Person_Session_Action_Log();
psal.Action_DateTime = DateTime.Now;
psal.Action_ID = 11;
psal.Session_ID = db.Person_Session_Log.Select(Y => Y.Session_ID).Max();
psal.Crud_Operation = "Delete";
psal.Action_Performed = "Question topic: " + name;
db.Person_Session_Action_Log.Add(psal);
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
List <Question_Bank> question_Bank = db.Question_Bank.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).ToList();
@ViewBag.DeleteCompleteMessage = "Question topic '" + question_Topic.Topic_Name + "' successfully deleted.";
db.Question_Bank.RemoveRange(question_Bank);
db.Question_Topic.Remove(question_Topic);
db.SaveChanges();
ViewBag.DeleteComplete = "Yes";
return(View("Index", db.Question_Topic.ToList()));
}
}
public ActionResult Create([Bind(Include = "Topic_Seq,Topic_Name,Description")] Question_Topic question_Topic)
{
if (ModelState.IsValid)
{
if (AreThereDuplicatesTopics(question_Topic.Topic_Name))
{
ModelState.AddModelError("Topic_Name", "This topic already exists. Please choose another topic name.");
ViewBag.Topic_Name = question_Topic.Topic_Name;
ViewBag.Description = question_Topic.Description;
return(View("Create"));
}
else
{
db.Question_Topic.Add(question_Topic);
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
string name = db.Question_Topic.Where(X => X.Topic_Seq == question_Topic.Topic_Seq).Select(Y => Y.Topic_Name).Single();
Person_Session_Action_Log psal = new Person_Session_Action_Log();
psal.Action_DateTime = DateTime.Now;
psal.Action_ID = 11;
psal.Session_ID = db.Person_Session_Log.Select(Y => Y.Session_ID).Max();
psal.Action_Performed = "Question topic: " + name;
psal.Crud_Operation = "Create";
db.Person_Session_Action_Log.Add(psal);
db.SaveChanges();
// -------------------------------Action Log ----------------------------------------//
string NewTopic = "YES";
return(RedirectToAction("Add_Question_To_New_Topic", "Question_Bank", new { question_Topic.Topic_Seq, NewTopic, question_Topic.Topic_Name, question_Topic.Description }));
}
}
return(View(question_Topic));
}
