//GET: /Operator/AddAction
public ActionResult AddAction(bool RL, long TID)
{
long IID = TID;
var model = new Answers_tbl();
if (RL)
{
model.TableType = "Safety";
ViewBag.q_ID = new SelectList(db.Questions_tbl.Where(x => x.TableType == "Safety"), "Q_Id", "question");
}
else
{
model.TableType = "Quality";
ViewBag.q_ID = new SelectList(db.Questions_tbl.Where(x => x.TableType == "Quality"), "Q_Id", "question");
}
model.states = true;
model.triggerID = IID;
model.done = false;
ViewBag.ids = TID;
ViewBag.idq = TID;
ViewBag.q_ID = new SelectList(db.Questions_tbl, "Q_Id", "question");
return(View(model));
}
public ActionResult EditAction([Bind(Include = "A_ID,q_ID,states,action,triggerID,TableType,done,DoneDate")] Answers_tbl ans_tbl)
{
if (ModelState.IsValid)
{
if (ans_tbl.done)
{
ans_tbl.DoneDate = DateTime.Now;
}
if (!ans_tbl.states)
{
ans_tbl.action = null;
ans_tbl.done = true;
}
db.Entry(ans_tbl).State = EntityState.Modified;
db.SaveChanges();
long id = ans_tbl.triggerID;
Triggers_tbl trg = db.Triggers_tbl.Find(id);
Summary_tbl summ;
BeforeAfter AB = new BeforeAfter();
List <Answers_tbl> BeforeList = AB.Before_tr(trg.line, ans_tbl.TableType, trg.shift, DateTime.Now);
List <Answers_tbl> AfterList = AB.After_tr(trg.line, ans_tbl.TableType, trg.shift, DateTime.Now);
if (db.Summary_tbl.Any(s => s.TrigID == id))
{
summ = db.Summary_tbl.Where(s => s.TrigID == id).FirstOrDefault();
summ.LastEdited = DateTime.Now;
summ.SafetyBefore = BeforeList.Any();
summ.SafetyAfter = AfterList.Any();
db.Entry(summ).State = EntityState.Modified;
db.SaveChanges();
}
else
{
summ = new Summary_tbl();
summ.TrigID = id;
summ.Inserted = DateTime.Now;
summ.SafetyBefore = BeforeList.Any();
summ.SafetyAfter = AfterList.Any();
db.Summary_tbl.Add(summ);
db.SaveChanges();
}
return(RedirectToAction("Index", new { TID = id }));
}
ViewBag.SqID = new SelectList(db.Questions_tbl, "q_Id", "question", ans_tbl.q_ID);
ViewBag.TriggerID = new SelectList(db.Triggers_tbl, "triggerID", "shift", ans_tbl.triggerID);
return(View(ans_tbl));
}
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Answers_tbl Quality_ans_tbl = db.Answers_tbl.Find(id);
if (Quality_ans_tbl == null)
{
return(HttpNotFound());
}
ViewBag.SqID = new SelectList(db.Questions_tbl, "q_Id", "Question", Quality_ans_tbl.q_ID);
ViewBag.TriggerID = new SelectList(db.Triggers_tbl, "triggerID", "shift", Quality_ans_tbl.triggerID);
return(View(Quality_ans_tbl));
}
public void addQuestion(string Question,string[] answers)
{
using (db = new CollegeERPDBEntities())
{
Questionaire_tbl qstn = new Questionaire_tbl { Question = Question };
db.Questionaire_tbl.Add(qstn);
db.SaveChanges();
foreach (string ans in answers)
{
Answers_tbl anss = new Answers_tbl { Q_ID = qstn.Q_ID, Answer = ans };
db.Answers_tbl.Add(anss);
db.SaveChanges();
}
}
}
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Answers_tbl Quality_ans_tbl = db.Answers_tbl.Find(id);
long triggerId = Quality_ans_tbl.triggerID;
if (Quality_ans_tbl == null)
{
return(HttpNotFound());
}
db.Answers_tbl.Remove(Quality_ans_tbl);
db.SaveChanges();
return(RedirectToAction("Index", new { T_ID = triggerId }));
}
public ActionResult Edit([Bind(Include = "A_ID,q_ID,states,action,triggerID")] Answers_tbl Quality_ans_tbl)
{
if (ModelState.IsValid)
{
Quality_ans_tbl.TableType = "Quality";
if (!Quality_ans_tbl.states)
{
Quality_ans_tbl.action = null;
Quality_ans_tbl.done = true;
}
db.Entry(Quality_ans_tbl).State = EntityState.Modified;
db.SaveChanges();
long id = Quality_ans_tbl.triggerID;
Triggers_tbl t = db.Triggers_tbl.Find(id);
return(RedirectToAction("Index", new { T_ID = id }));
}
ViewBag.SqID = new SelectList(db.Questions_tbl, "q_Id", "question", Quality_ans_tbl.q_ID);
ViewBag.TriggerID = new SelectList(db.Triggers_tbl, "triggerID", "shift", Quality_ans_tbl.triggerID);
return(View(Quality_ans_tbl));
}
public ActionResult AddAction([Bind(Include = "q_ID,states,action,done,triggerID,TableType")] Answers_tbl answer)
{
if (ModelState.IsValid)
{
db.Answers_tbl.Add(answer);
db.SaveChanges();
long id = answer.triggerID;
Triggers_tbl trg = db.Triggers_tbl.Find(id);
Summary_tbl summ;
BeforeAfter AB = new BeforeAfter();
List <Answers_tbl> BeforeList = AB.Before_tr(trg.line, answer.TableType, trg.shift, DateTime.Now);
List <Answers_tbl> AfterList = AB.After_tr(trg.line, answer.TableType, trg.shift, DateTime.Now);
if (db.Summary_tbl.Any(s => s.TrigID == id))
{
summ = db.Summary_tbl.Where(s => s.TrigID == id).FirstOrDefault();
summ.LastEdited = DateTime.Now;
summ.SafetyBefore = BeforeList.Any();
summ.SafetyAfter = AfterList.Any();
db.Entry(summ).State = EntityState.Modified;
db.SaveChanges();
}
else
{
summ = new Summary_tbl();
summ.TrigID = id;
summ.Inserted = DateTime.Now;
summ.SafetyBefore = BeforeList.Any();
summ.SafetyAfter = AfterList.Any();
db.Summary_tbl.Add(summ);
db.SaveChanges();
}
return(RedirectToAction("Index", new { TID = id }));
}
return(View());
}
