public IActionResult GetAll(GeneralBodyGet GeneralBodyGet)
{
string transactionID = Guid.NewGuid().ToString();
string currentURL = this.Request.Method;
HelperRestError helperRestError = new HelperRestError();
HelperHTTPLog helperHTTPLog = new HelperHTTPLog(HelperHTTPLog.WhatToLog.All);
try
{
RestExceptionError restExceptionError = null;
RESTShippersDB rESTShippersDB = new RESTShippersDB(base.RESTConfig);
//1)Get all rows. Note: Create "select * from MyTable". DB filter must be mannually done
List <GetShippersView> rawResult = rESTShippersDB.GetAll(out restExceptionError);
if (restExceptionError != null)
{
CreatedResult errorResult = helperRestError.GetError412_PreConditionFailed(transactionID, restExceptionError.ExceptionMessage, restExceptionError.InternalMessage, "Shippers/GetAll");
return(errorResult);
}
//2)Apply filters in result set.
List <GetShippersView> filteredResult = rESTShippersDB.Filter(rawResult, GeneralBodyGet, out restExceptionError);
if (restExceptionError != null)
{
CreatedResult errorResult = helperRestError.GetError500_InternalServerError(transactionID, restExceptionError.ExceptionMessage, restExceptionError.InternalMessage, "Shippers/GetAll");
return(errorResult);
}
//3)Cut data, apply ordering
List <GetShippersView> orderedResultAndTrimed = rESTShippersDB.OrderByAndTrim(filteredResult, GeneralBodyGet, out restExceptionError);
if (restExceptionError != null)
{
CreatedResult errorResult = helperRestError.GetError500_InternalServerError(transactionID, restExceptionError.ExceptionMessage, restExceptionError.InternalMessage, "Shippers/GetAll");
return(errorResult);
}
var finalResult = orderedResultAndTrimed;
GeneralGetResponse resultContainer = new GeneralGetResponse();
resultContainer.Data = finalResult;
resultContainer.ReportHeader.TotalItensAvailable = rawResult.Count;
resultContainer.ReportHeader.TotalItensRetrieved = finalResult.Count;
resultContainer.ReportHeader.TransactionID = transactionID;
HttpResponseMessage httpResponseMessage = new HttpResponseMessage();
httpResponseMessage.StatusCode = System.Net.HttpStatusCode.OK;
CreatedResult createdResult = new CreatedResult("Shippers/GetAll", httpResponseMessage);
createdResult.Value = resultContainer;
return(createdResult);
}
catch (Exception ex)
{
CreatedResult errorResult = helperRestError.GetError500_InternalServerError(transactionID, ex.Message, "x", "Shippers/GetAll");
return(errorResult);
}
}
public IActionResult Delete(GeneralBodyPost GeneralBodyPost)
{
string transactionID = Guid.NewGuid().ToString();
string currentURL = this.Request.Method;
HelperRestError helperRestError = new HelperRestError();
HelperHTTPLog helperHTTPLog = new HelperHTTPLog(HelperHTTPLog.WhatToLog.All);
try
{
GeneralPostResponse resultContainer = new GeneralPostResponse();
resultContainer.ReportPostHeader.TransactionID = transactionID;
RestExceptionError restExceptionError = null;
RESTShippersDB rESTShippersDB = new RESTShippersDB(base.RESTConfig);
DeleteShippersView viewToDelete = rESTShippersDB.TryParse <DeleteShippersView>(GeneralBodyPost, out restExceptionError);
if (restExceptionError != null)
{
CreatedResult errorResult = helperRestError.GetError412_PreConditionFailed(transactionID, restExceptionError.ExceptionMessage, restExceptionError.InternalMessage, "Shippers/Insert");
return(errorResult);
}
rESTShippersDB.TryDelete(viewToDelete, out restExceptionError);
if (restExceptionError != null)
{
CreatedResult errorResult = helperRestError.GetError500_InternalServerError(transactionID, restExceptionError.ExceptionMessage, restExceptionError.InternalMessage, "Shippers/GetAll");
return(errorResult);
}
resultContainer.ReportPostHeader.Message = "Success";
HttpResponseMessage httpResponseMessage = new HttpResponseMessage();
httpResponseMessage.StatusCode = System.Net.HttpStatusCode.OK;
CreatedResult createdResult = new CreatedResult("Shippers/Delete", httpResponseMessage);
createdResult.Value = resultContainer;
createdResult.StatusCode = 200;
return(createdResult);
}
catch (Exception ex)
{
CreatedResult errorResult = helperRestError.GetError500_InternalServerError(transactionID, ex.Message, "x", "Shippers/Create");
return(errorResult);
}
}