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