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