public ActionResult GetFieldsByJobID(int jobID)
{
var watch = System.Diagnostics.Stopwatch.StartNew();
GlobalVars.ResultFields resultFields = new GlobalVars.ResultFields();
try
{
logger.Info("GetFieldsByJobID API Request. Job ID: " + jobID);
if (jobID == 0)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
resultFields.ReturnCode = -1;
resultFields.Message = "Missing argument Job ID";
logger.Warn("GetJobsByProjectID API Request ends with an Error.");
logger.Warn(resultFields.Message);
}
else
{
resultFields = SQLFunctionsFields.GetFieldsByJobID(jobID);
switch (resultFields.ReturnCode)
{
case 0:
logger.Info("GetFieldsByJobID API Request was executed Successfully.");
Response.StatusCode = (int)HttpStatusCode.OK;
break;
case -2:
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
logger.Fatal("GetFieldsByJobID API Request ends with a Fatal Error.");
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultFields, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
break;
}
}
}
catch (Exception e)
{
logger.Fatal("GetFieldsByJobID API Request ends with a Fatal Error.");
resultFields.ReturnCode = -2;
resultFields.Message = e.Message;
var baseException = e.GetBaseException();
resultFields.Exception = baseException.ToString();
logger.Fatal("Returned value:" + JsonConvert.SerializeObject(resultFields, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
}
Response.ContentType = "application/json";
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
elapsedMs = elapsedMs / 1000;
resultFields.ElapsedTime = elapsedMs.ToString();
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultFields, Formatting.Indented));
resultFields.HttpStatusCode = Response.StatusCode.ToString();
var messaje = JsonConvert.SerializeObject(resultFields, Formatting.Indented);
logger.Info("Leaving GetFieldsByJobID API.");
//return Json(messaje);
return(Content(messaje));
}
/// <summary>
/// Get List of Fields for a given Job ID and FieldName
/// </summary>
/// <returns></returns>
static public GlobalVars.ResultFields GetFieldsByNameAndJobID(string fieldName, int jobID)
{
List <GlobalVars.Field> fields = new List <GlobalVars.Field>();
GlobalVars.ResultFields resultFields = new GlobalVars.ResultFields()
{
ReturnCode = 0,
Message = "",
ReturnValue = fields,
RecordsCount = 0,
HttpStatusCode = ""
};
try
{
logger.Trace("Entering into GetFieldsByNameAndJobID Method ...");
using (ScanningDBContext DB = new ScanningDBContext())
{
var results = DB.JobsFields.Where(x => x.JobId == jobID & x.CpfieldName == fieldName);
resultFields.RecordsCount = results.Count();
if (results.Count() >= 1)
{
foreach (var x in results)
{
GlobalVars.Field field = new GlobalVars.Field()
{
JobID = x.JobId,
FieldID = x.FieldId,
CPFieldName = (x.CpfieldName ?? "").Trim(),
VFRFieldName = (x.VfrfieldName ?? "").Trim(),
ExcludeFromKeystrokesCount = Convert.ToBoolean(x.KeyStrokeExcludeFlag)
};
fields.Add(field);
}
}
}
resultFields.ReturnValue = fields;
resultFields.Message = "GetFieldsByNameAndJobID transaction completed successfully. Number of records found: " + resultFields.RecordsCount;
logger.Debug(resultFields.Message);
}
catch (Exception e)
{
logger.Error("Error:" + e.Message + "\n" + "Exception: " + e.InnerException);
resultFields.ReturnCode = -2;
resultFields.Message = e.Message;
var baseException = e.GetBaseException();
resultFields.Exception = baseException.ToString();
//return resultHosts;
}
logger.Trace("Leaving GetFieldsByNameAndJobID Method ...");
return(resultFields);
}
