public ActionResult GetVFRInfoByJobID(int jobID)
{
var watch = System.Diagnostics.Stopwatch.StartNew();
GlobalVars.ResultsVFR resultVFR = new GlobalVars.ResultsVFR();
try
{
logger.Info("GetVFRInfoByJobID API Request. Job ID: " + jobID);
if (jobID == 0)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
resultVFR.ReturnCode = -1;
resultVFR.Message = "Missing argument Job ID";
logger.Warn("GetJobsByProjectID API Request ends with an Error.");
logger.Warn(resultVFR.Message);
}
else
{
resultVFR = SQLFunctionsVFR.GetVFRInfoByJobID(jobID);
switch (resultVFR.ReturnCode)
{
case 0:
logger.Info("GetVFRInfoByJobID API Request was executed Successfully.");
Response.StatusCode = (int)HttpStatusCode.OK;
break;
case -2:
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
logger.Fatal("GetVFRInfoByJobID API Request ends with a Fatal Error.");
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultVFR, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
break;
}
}
}
catch (Exception e)
{
logger.Fatal("GetVFRInfoByJobID API Request ends with a Fatal Error.");
resultVFR.ReturnCode = -2;
resultVFR.Message = e.Message;
var baseException = e.GetBaseException();
resultVFR.Exception = baseException.ToString();
logger.Fatal("Returned value:" + JsonConvert.SerializeObject(resultVFR, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
}
Response.ContentType = "application/json";
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
elapsedMs = elapsedMs / 1000;
resultVFR.ElapsedTime = elapsedMs.ToString();
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultVFR, Formatting.Indented));
resultVFR.HttpStatusCode = Response.StatusCode.ToString();
var messaje = JsonConvert.SerializeObject(resultVFR, Formatting.Indented);
logger.Info("Leaving GetVFRInfoByJobID API.");
//return Json(messaje);
return(Content(messaje));
}
/// <summary>
/// Get VFR Server Information
/// </summary>
/// <returns></returns>
static public GlobalVars.ResultsVFR GetVFRInfoByJobID(int jobID)
{
GlobalVars.VFR vfr = new GlobalVars.VFR();
GlobalVars.ResultsVFR resultVFR = new GlobalVars.ResultsVFR()
{
ReturnCode = 0,
Message = "",
ReturnValue = vfr,
RecordsCount = 0,
HttpStatusCode = ""
};
try
{
logger.Trace("Entering into GetVFRInfoByJobID Method ...");
using (ScanningDBContext DB = new ScanningDBContext())
{
var results = DB.Vfr.FirstOrDefault(x => x.JobId == jobID);
if (results != null)
{
resultVFR.RecordsCount = 1;
vfr.CADIUrl = results.Cadiurl;
vfr.CaptureTemplate = results.CaptureTemplate;
vfr.InstanceName = results.InstanceName;
vfr.JobID = results.JobId;
vfr.SettingID = results.SettingId;
vfr.Password = results.Password;
vfr.UserName = results.UserName;
vfr.RepositoryName = results.RepositoryName;
vfr.QueryField = results.QueryField;
}
else
{
//There is no record in the database
}
}
resultVFR.ReturnValue = vfr;
resultVFR.Message = "GetVFRInfoByJobID transaction completed successfully. Number of records found: " + resultVFR.RecordsCount;
logger.Debug(resultVFR.Message);
}
catch (Exception e)
{
logger.Error("Error:" + e.Message + "\n" + "Exception: " + e.InnerException);
resultVFR.ReturnCode = -2;
resultVFR.Message = e.Message;
var baseException = e.GetBaseException();
resultVFR.Exception = baseException.ToString();
}
logger.Trace("Leaving GetVFRInfoByJobID Method ...");
return(resultVFR);
}
