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)); }
public ActionResult UpdateCustomer([FromBody] string customerJS) { var watch = System.Diagnostics.Stopwatch.StartNew(); GlobalVars.ResultGeneric result = new GlobalVars.ResultGeneric() { Message = "", ReturnCode = 0, //ReturnValue = "" }; try { if (customerJS == null) { Response.StatusCode = (int)HttpStatusCode.BadRequest; result.ReturnCode = -1; result.Message = "Missing argument customerJS"; logger.Warn("UpdateCustomer API Request ends with an Error."); logger.Warn(result.Message); } else { GlobalVars.Customer customer = JsonConvert.DeserializeObject <GlobalVars.Customer>(customerJS); logger.Info("UpdateCustomer API Request."); if (!string.IsNullOrEmpty(customer.CustomerName)) { logger.Debug("Parameter:" + JsonConvert.SerializeObject(customer, Formatting.Indented)); result = SQLFunctionsCustomers.UpdateCustomer(customer); switch (result.ReturnCode) { case 0: logger.Info("UpdateCustomer API Request was executed Successfully."); Response.StatusCode = (int)HttpStatusCode.OK; break; case -1: logger.Info("UpdateCustomer API Request ends with a warning."); Response.StatusCode = (int)HttpStatusCode.OK; break; case -2: Response.StatusCode = (int)HttpStatusCode.InternalServerError; logger.Fatal("UpdateCustomer API Request ends with a Fatal Error."); logger.Debug("Returned value:" + JsonConvert.SerializeObject(result, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; break; } } else { Response.StatusCode = (int)HttpStatusCode.BadRequest; result.ReturnCode = -1; result.Message = "CustomerName value is not valid."; logger.Warn("UpdateCustomer API Request ends with an Error."); logger.Warn(result.Message); } } } catch (Exception e) { logger.Fatal("UpdateCustomer API Request ends with a Fatal Error."); result.ReturnCode = -2; result.Message = e.Message; var baseException = e.GetBaseException(); result.Exception = baseException.ToString(); logger.Fatal("Returned value:" + JsonConvert.SerializeObject(result, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; } Response.ContentType = "application/json"; watch.Stop(); var elapsedMs = watch.ElapsedMilliseconds; elapsedMs = elapsedMs / 1000; result.ElapsedTime = elapsedMs.ToString(); result.HttpStatusCode = Response.StatusCode.ToString(); var messaje = JsonConvert.SerializeObject(result, Formatting.Indented); logger.Info("Leaving UpdateCustomer API"); //return Json(messaje); return(Content(messaje)); }
public ActionResult DeleteCustomer(int customerID) { var watch = System.Diagnostics.Stopwatch.StartNew(); GlobalVars.ResultGeneric result = new GlobalVars.ResultGeneric() { Message = "", ReturnCode = 0, //ReturnValue = "" }; try { // Customer ID is a Required Field if (customerID == 0) { Response.StatusCode = (int)HttpStatusCode.BadRequest; result.ReturnCode = -1; result.Message = "Customer ID is a required field."; logger.Warn(result.Message); } else { logger.Info("DeleteCustomer API Request. Customer ID: " + customerID); result = SQLFunctionsCustomers.DeleteCustomer(customerID); switch (result.ReturnCode) { case 0: // DeleteCustomer ends successfully logger.Info("Customer ID: " + customerID + " was Deleted Successfully."); result.Message = "Customer ID: " + customerID + " was Deleted Successfully."; Response.StatusCode = (int)HttpStatusCode.OK; break; case -1: logger.Info("DeleteCustomer API Request ends with a warning."); Response.StatusCode = (int)HttpStatusCode.OK; break; case -2: // DeleteCustomer ends with a Fatal error logger.Fatal("DeleteCustomer API Request ends with a Fatal Error."); logger.Debug("Returned value:" + JsonConvert.SerializeObject(result, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; break; } } } catch (Exception e) { logger.Fatal("DeleteCustomer API Request ends with a Fatal Error."); System.Diagnostics.Trace.WriteLineIf(true, "Error:" + e.Message + "\n" + "Exception: " + e.InnerException); result.ReturnCode = -2; result.Message = e.Message; var baseException = e.GetBaseException(); result.Exception = baseException.ToString(); logger.Fatal("Returned value:" + JsonConvert.SerializeObject(result, Formatting.Indented)); Response.StatusCode = (int)HttpStatusCode.InternalServerError; } Response.ContentType = "application/json"; watch.Stop(); var elapsedMs = watch.ElapsedMilliseconds; elapsedMs = elapsedMs / 1000; result.ElapsedTime = elapsedMs.ToString(); result.HttpStatusCode = Response.StatusCode.ToString(); var messaje = JsonConvert.SerializeObject(result, Formatting.Indented); logger.Info("Leaving DeleteCustomer API"); //return Json(messaje); return(Content(messaje)); }