public ActionResult GetReports() { // The following section is just a test for the reporting //GlobalVars.ResultGeneric rg = new GlobalVars.ResultGeneric(); // rg = SQLFunctionsReports.OverallBatchStatusReport(reportID); var watch = System.Diagnostics.Stopwatch.StartNew(); GlobalVars.ResultReports resultReport = new GlobalVars.ResultReports(); try { logger.Info("GetReports API Request."); resultReport = SQLFunctionsReports.GetReports(); switch (resultReport.ReturnCode) { case 0: logger.Info("GetReports API Request was executed Successfully."); Response.StatusCode = (int)HttpStatusCode.OK; break; case -2: Response.StatusCode = (int)HttpStatusCode.InternalServerError; logger.Fatal("GetReports API Request ends with a Fatal Error."); logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultReport, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; break; } } catch (Exception e) { logger.Fatal("GetReports API Request ends with a Fatal Error."); resultReport.ReturnCode = -2; resultReport.Message = e.Message; var baseException = e.GetBaseException(); resultReport.Exception = baseException.ToString(); logger.Fatal("Returned value:" + JsonConvert.SerializeObject(resultReport, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; } Response.ContentType = "application/json"; watch.Stop(); var elapsedMs = watch.ElapsedMilliseconds; elapsedMs = elapsedMs / 1000; resultReport.ElapsedTime = elapsedMs.ToString(); logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultReport, Formatting.Indented)); //var messaje = JsonConvert.SerializeObject(resultCustomers, Formatting.Indented); resultReport.HttpStatusCode = Response.StatusCode.ToString(); var messaje = JsonConvert.SerializeObject(resultReport, Formatting.Indented); logger.Info("Leaving GetReports API."); //return Json(messaje); return(Content(messaje)); }
public ActionResult GetReportsByCustomerName(string customerName) { var watch = System.Diagnostics.Stopwatch.StartNew(); GlobalVars.ResultReports resultReports = new GlobalVars.ResultReports(); try { logger.Info("GetReportsByCustomerName API Request."); if (string.IsNullOrEmpty(customerName)) { Response.StatusCode = (int)HttpStatusCode.BadRequest; resultReports.ReturnCode = -1; resultReports.Message = "Missing argument customerName"; logger.Warn("GetReportsByCustomerName API Request ends with an Error."); logger.Warn(resultReports.Message); } else { resultReports = SQLFunctionsReports.GetReportsByCustomerName(customerName); switch (resultReports.ReturnCode) { case 0: logger.Info("GetReportsByCustomerName API Request was executed Successfully."); Response.StatusCode = (int)HttpStatusCode.OK; break; case -2: Response.StatusCode = (int)HttpStatusCode.InternalServerError; logger.Fatal("GetReportsByCustomerName API Request ends with a Fatal Error."); logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultReports, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; break; } } } catch (Exception e) { logger.Fatal("GetReportsByCustomerName API Request ends with a Fatal Error."); resultReports.ReturnCode = -2; resultReports.Message = e.Message; var baseException = e.GetBaseException(); resultReports.Exception = baseException.ToString(); logger.Fatal("Returned value:" + JsonConvert.SerializeObject(resultReports, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; } Response.ContentType = "application/json"; watch.Stop(); var elapsedMs = watch.ElapsedMilliseconds; elapsedMs = elapsedMs / 1000; resultReports.ElapsedTime = elapsedMs.ToString(); logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultReports, Formatting.Indented)); //var messaje = JsonConvert.SerializeObject(resultCustomers, Formatting.Indented); resultReports.HttpStatusCode = Response.StatusCode.ToString(); var messaje = JsonConvert.SerializeObject(resultReports, Formatting.Indented); logger.Info("Leaving GetReportsByCustomerName API."); //return Json(messaje); return(Content(messaje)); }