public ActionResult Create(long T_ID)
{
long TrigId = T_ID;
var validq = db.Questions_tbl.Where(a => a.Available == true && a.TableType == "Quality");
ViewBag.Sq = validq.Select(q => q.question).ToArray();
ViewBag.count = validq.Count();
ViewBag.SqID = validq.Select(i => i.Q_ID).ToArray();
//ViewBag.Status = db.Answers_tbl.Select(s => s.Status).ToArray();
var mymodel = new List <Answers_tbl>();
for (var i = 0; i < @ViewBag.count; i++)
{
mymodel.Add(new Answers_tbl());
mymodel[i].q_ID = ViewBag.SqID[i];
mymodel[i].triggerID = TrigId;
ViewBag.AnsType = validq.Select(n => n.AnsType).ToArray();
}
Triggers_tbl t = db.Triggers_tbl.Find(T_ID);
ViewBag.line = t.line;
ViewBag.shift = t.shift;
ViewBag.day = t.daydate;
ViewBag.id = t.TriggerID;
return(View(mymodel));
}
public ActionResult Create([Bind(Include = "TriggerID,line,shift,daydate,usernum")] Triggers_tbl trigger)
{
long T_ID;
if (ModelState.IsValid)
{
if (db.Triggers_tbl.Any(t => t.line == trigger.line && t.shift == trigger.shift && DbFunctions.TruncateTime(t.daydate) == DbFunctions.TruncateTime(trigger.daydate)))
{
Triggers_tbl tabl = db.Triggers_tbl.Where(t => t.line == trigger.line && t.shift == trigger.shift && DbFunctions.TruncateTime(t.daydate) == DbFunctions.TruncateTime(trigger.daydate)).FirstOrDefault();
T_ID = tabl.TriggerID;
}
else
{
db.Triggers_tbl.Add(trigger);
db.SaveChanges();
T_ID = trigger.TriggerID;
}
if (db.Summary_tbl.Any(s => s.TrigID == T_ID))
{
return(RedirectToAction("Index", new { TID = T_ID }));
}
else
{
return(RedirectToAction("Create", "SafetyAns", new { T_ID = T_ID }));
}
}
return(View(trigger));
}
// GET: /Operator/Create
public ActionResult Create()
{
string username = Session["Username"].ToString();
User_Line user = db.User_Line.Where(u => u.User_num == username).FirstOrDefault();
Triggers_tbl tr = new Triggers_tbl();
tr.line = Convert.ToInt16(user.Line);
tr.usernum = user.ID;
return(View(tr));
}
public ActionResult Index([Bind(Include = "A_ID,q_ID,states,action,done,triggerID,TableType")] List <Answers_tbl> Actions_tbl, long TID)
{
if (ModelState.IsValid)
{
foreach (var table in Actions_tbl)
{
if (table.done)
{
table.DoneDate = DateTime.Now;
table.DoneTrigger = TID;
}
db.Entry(table).State = EntityState.Modified;
db.SaveChanges();
}
long id = TID;
Triggers_tbl trg = db.Triggers_tbl.Find(id);
Summary_tbl summ;
BeforeAfter AB = new BeforeAfter();
List <Answers_tbl> BeforeList = AB.Before_tr(trg.line, Actions_tbl[0].TableType, trg.shift, DateTime.Now);
List <Answers_tbl> AfterList = AB.After_tr(trg.line, Actions_tbl[0].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.message = "Not Saved";
return(View(Actions_tbl));
}
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([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));
}
QSEntities1 db = new QSEntities1(); // context database connection
//
// GET: /Operator/
public ActionResult Index(long TID)
{
Triggers_tbl tr = db.Triggers_tbl.Find(TID);
int LINE = tr.line;
var answers = db.Answers_tbl.Include(q => q.Triggers_tbl);
var actions = answers.Where(a => a.Triggers_tbl.line == LINE && a.done == false);
ViewBag.ids = TID;
ViewBag.idq = TID;
string shift = tr.shift;
DateTime date = tr.daydate;
ViewBag.line = LINE;
ViewBag.shift = shift;
ViewBag.day = date;
return(View(actions.ToList()));
}
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());
}
public ActionResult Create([Bind(Include = "A_ID,q_ID,states,action,triggerID")] List <Answers_tbl> Quality_ans_tbls)
{
if (ModelState.IsValid)
{
foreach (var table in Quality_ans_tbls)
{
table.TableType = "Quality";
table.done = !table.states;
if (table.states)
{
string entireString = table.action;
if (entireString == null)
{
entireString = "";
db.Answers_tbl.Add(table);
db.SaveChanges();
}
foreach (var myString in entireString.Split(new string[] { "\n", "\r\n" }, StringSplitOptions.RemoveEmptyEntries))
{
var record = table;
record.action = myString;
db.Answers_tbl.Add(record);
db.SaveChanges();
}
}
else
{
table.action = null;
db.Answers_tbl.Add(table);
db.SaveChanges();
}
}
long id = Quality_ans_tbls[0].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, "Quality", trg.shift, DateTime.Now);
List <Answers_tbl> AfterList = AB.After_tr(trg.line, "Quality", 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.QualityBefore = BeforeList.Any();
summ.QualityAfter = AfterList.Any();
db.Entry(summ).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { T_ID = id }));
}
else
{
summ = new Summary_tbl();
summ.TrigID = id;
summ.Inserted = DateTime.Now;
summ.QualityBefore = BeforeList.Any();
summ.QualityAfter = AfterList.Any();
db.Summary_tbl.Add(summ);
db.SaveChanges();
return(RedirectToAction("Index", "Operator", new { TID = id }));
}
}
var validq = db.Questions_tbl.Where(a => a.Available == true).Select(q => q.question);
ViewBag.Sq = validq.ToArray();
ViewBag.count = validq.Count();
return(View(Quality_ans_tbls));
}
