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