public JsonResult IsCreateSessionAcquisition(int IDTable, string OpenSessionDateTime) { string s = User.Identity.Name; try { switch (IDTable) { case 0: { DataAcquisitionSession dataacquisitionsession = db.DataAcquisitionSessions.Find(DateTime.Parse(OpenSessionDateTime)); return(Json((dataacquisitionsession == null) ? "No" : "Yes", JsonRequestBehavior.AllowGet)); } break; case 1: { LinearSession dataacquisitionsession = db.LinearSessions.Find(DateTime.Parse(OpenSessionDateTime)); return(Json((dataacquisitionsession == null) ? "No" : "Yes", JsonRequestBehavior.AllowGet)); } break; case 2: { CastingSession dataacquisitionsession = db.CastingSessions.Find(DateTime.Parse(OpenSessionDateTime)); return(Json((dataacquisitionsession == null) ? "No" : "Yes", JsonRequestBehavior.AllowGet)); } break; case 3: { AlarmsSession dataacquisitionsession = db.AlarmsSessions.Find(DateTime.Parse(OpenSessionDateTime)); return(Json((dataacquisitionsession == null) ? "No" : "Yes", JsonRequestBehavior.AllowGet)); } break; case 4: { GeneralDoubleBeltSession dataacquisitionsession = db.GeneralDoubleBeltSessions.Find(DateTime.Parse(OpenSessionDateTime)); return(Json((dataacquisitionsession == null) ? "No" : "Yes", JsonRequestBehavior.AllowGet)); } break; default: throw new SystemException(); } } catch (SystemException e) { } return(Json("Error", JsonRequestBehavior.AllowGet)); }
public JsonResult CreateSessionAcquisition(int IDTable, int OpenSessionCode, string OpenSessionDateTime) { try { if (ModelState.IsValid) { switch (IDTable) { case 0: { DataAcquisitionSession dataacquisitionsession = new DataAcquisitionSession(); dataacquisitionsession.OpenSessionCode = OpenSessionCode; dataacquisitionsession.CloseSessionDateTime = dataacquisitionsession.OpenSessionDateTime = DateTime.Parse(OpenSessionDateTime); dataacquisitionsession.CloseSessionCode = -1; db.DataAcquisitionSessions.Add(dataacquisitionsession); } break; case 1: { LinearSession dataacquisitionsession = new LinearSession(); dataacquisitionsession.OpenSessionCode = OpenSessionCode; dataacquisitionsession.CloseSessionDateTime = dataacquisitionsession.OpenSessionDateTime = DateTime.Parse(OpenSessionDateTime); dataacquisitionsession.CloseSessionCode = -1; db.LinearSessions.Add(dataacquisitionsession); } break; case 2: { CastingSession dataacquisitionsession = new CastingSession(); dataacquisitionsession.OpenSessionCode = OpenSessionCode; dataacquisitionsession.CloseSessionDateTime = dataacquisitionsession.OpenSessionDateTime = DateTime.Parse(OpenSessionDateTime); dataacquisitionsession.CloseSessionCode = -1; db.CastingSessions.Add(dataacquisitionsession); } break; case 3: { AlarmsSession dataacquisitionsession = new AlarmsSession(); dataacquisitionsession.OpenSessionCode = OpenSessionCode; dataacquisitionsession.CloseSessionDateTime = dataacquisitionsession.OpenSessionDateTime = DateTime.Parse(OpenSessionDateTime); dataacquisitionsession.CloseSessionCode = -1; db.AlarmsSessions.Add(dataacquisitionsession); } break; case 4: { GeneralDoubleBeltSession dataacquisitionsession = new GeneralDoubleBeltSession(); dataacquisitionsession.OpenSessionCode = OpenSessionCode; dataacquisitionsession.CloseSessionDateTime = dataacquisitionsession.OpenSessionDateTime = DateTime.Parse(OpenSessionDateTime); dataacquisitionsession.CloseSessionCode = -1; db.GeneralDoubleBeltSessions.Add(dataacquisitionsession); } break; default: throw new SystemException(); } db.SaveChanges(); return(Json("Ok", JsonRequestBehavior.AllowGet)); } } catch (SystemException) { } return(Json("Error", JsonRequestBehavior.AllowGet)); }
public JsonResult CloseSessionAcquisition(int IDTable, string OpenSessionDateTime, int CloseSessionCode, string CloseSessionDateTime) { try { switch (IDTable) { case 0: { DataAcquisitionSession dataacquisitionsession = db.DataAcquisitionSessions.Find(DateTime.Parse(OpenSessionDateTime)); if (dataacquisitionsession == null) { throw new SystemException(); } dataacquisitionsession.CloseSessionCode = CloseSessionCode; dataacquisitionsession.CloseSessionDateTime = DateTime.Parse(CloseSessionDateTime); db.Entry(dataacquisitionsession).State = EntityState.Modified; db.SaveChanges(); } break; case 1: { LinearSession dataacquisitionsession = db.LinearSessions.Find(DateTime.Parse(OpenSessionDateTime)); if (dataacquisitionsession == null) { throw new SystemException(); } dataacquisitionsession.CloseSessionCode = CloseSessionCode; dataacquisitionsession.CloseSessionDateTime = DateTime.Parse(CloseSessionDateTime); db.Entry(dataacquisitionsession).State = EntityState.Modified; db.SaveChanges(); } break; case 2: { CastingSession dataacquisitionsession = db.CastingSessions.Find(DateTime.Parse(OpenSessionDateTime)); if (dataacquisitionsession == null) { throw new SystemException(); } dataacquisitionsession.CloseSessionCode = CloseSessionCode; dataacquisitionsession.CloseSessionDateTime = DateTime.Parse(CloseSessionDateTime); db.Entry(dataacquisitionsession).State = EntityState.Modified; db.SaveChanges(); } break; case 3: { AlarmsSession dataacquisitionsession = db.AlarmsSessions.Find(DateTime.Parse(OpenSessionDateTime)); if (dataacquisitionsession == null) { throw new SystemException(); } dataacquisitionsession.CloseSessionCode = CloseSessionCode; dataacquisitionsession.CloseSessionDateTime = DateTime.Parse(CloseSessionDateTime); db.Entry(dataacquisitionsession).State = EntityState.Modified; db.SaveChanges(); } break; case 4: { GeneralDoubleBeltSession dataacquisitionsession = db.GeneralDoubleBeltSessions.Find(DateTime.Parse(OpenSessionDateTime)); if (dataacquisitionsession == null) { throw new SystemException(); } dataacquisitionsession.CloseSessionCode = CloseSessionCode; dataacquisitionsession.CloseSessionDateTime = DateTime.Parse(CloseSessionDateTime); db.Entry(dataacquisitionsession).State = EntityState.Modified; db.SaveChanges(); } break; default: throw new SystemException(); } return(Json("Ok", JsonRequestBehavior.AllowGet)); } catch (SystemException) { } return(Json("Error", JsonRequestBehavior.AllowGet)); }