public ActionResult GetCustomers()
{
var watch = System.Diagnostics.Stopwatch.StartNew();
GlobalVars.ResultCustomers resultCustomers = new GlobalVars.ResultCustomers();
try
{
logger.Info("GetCustomers API Request.");
resultCustomers = SQLFunctionsCustomers.GetCustomers();
switch (resultCustomers.ReturnCode)
{
case 0:
logger.Info("GetCustomers API Request was executed Successfully.");
Response.StatusCode = (int)HttpStatusCode.OK;
break;
case -2:
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
logger.Fatal("GetCustomers API Request ends with a Fatal Error.");
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultCustomers, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
break;
}
}
catch (Exception e)
{
logger.Fatal("GetCustomers API Request ends with a Fatal Error.");
resultCustomers.ReturnCode = -2;
resultCustomers.Message = e.Message;
var baseException = e.GetBaseException();
resultCustomers.Exception = baseException.ToString();
logger.Fatal("Returned value:" + JsonConvert.SerializeObject(resultCustomers, Formatting.Indented));
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
}
Response.ContentType = "application/json";
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
elapsedMs = elapsedMs / 1000;
resultCustomers.ElapsedTime = elapsedMs.ToString();
logger.Debug("Returned value:" + JsonConvert.SerializeObject(resultCustomers, Formatting.Indented));
//var messaje = JsonConvert.SerializeObject(resultCustomers, Formatting.Indented);
resultCustomers.HttpStatusCode = Response.StatusCode.ToString();
var messaje = JsonConvert.SerializeObject(resultCustomers, Formatting.Indented);
logger.Info("Leaving GetCustomers API.");
//return Json(messaje);
return(Content(messaje));
}
/// <summary>
/// Get Customer by Name
/// </summary>
/// <returns></returns>
static public GlobalVars.ResultCustomers GetCustomerByName(string customerName)
{
List <GlobalVars.Customer> customers = new List <GlobalVars.Customer>();
GlobalVars.ResultCustomers resultCustomers = new GlobalVars.ResultCustomers()
{
ReturnCode = 0,
Message = "",
ReturnValue = customers,
RecordsCount = 0,
HttpStatusCode = ""
};
try
{
logger.Trace("Entering into GetCustomerByName Method ...");
using (ScanningDBContext DB = new ScanningDBContext())
{
var results = DB.Customers.Where(x => x.CustomerName == customerName);
resultCustomers.RecordsCount = results.Count();
if (results.Count() >= 1)
{
foreach (var x in results)
{
GlobalVars.Customer customer = new GlobalVars.Customer()
{
CustomerID = x.CustomerId,
CustomerName = (x.CustomerName ?? "").Trim()
};
customers.Add(customer);
}
}
}
resultCustomers.ReturnValue = customers;
resultCustomers.Message = "GetCustomerByName transaction completed successfully. Number of records found: " + resultCustomers.RecordsCount;
logger.Debug(resultCustomers.Message);
}
catch (Exception e)
{
logger.Error("Error:" + e.Message + "\n" + "Exception: " + e.InnerException);
resultCustomers.ReturnCode = -2;
resultCustomers.Message = e.Message;
var baseException = e.GetBaseException();
resultCustomers.Exception = baseException.ToString();
//return resultHosts;
}
logger.Trace("Leaving GetCustomerByName Method ...");
return(resultCustomers);
}
