public async void ListAnnouncementReport(
EStatusCode expectedStatus,
ListAnnouncementReport query
)
{
var announcement = EntitiesFactory.NewAnnouncement(dateSale: DateTime.Now).Save();
var result = await QueriesHandler.Handle(query);
Assert.Equal(expectedStatus, result.Status);
if (expectedStatus == EStatusCode.Success)
{
Assert.NotEmpty(result.Data);
var announcementResult = result.Data.FirstOrDefault(a => a.Id == announcement.Id);
Assert.NotNull(announcementResult);
Assert.Equal(announcement.PriceSale - announcement.PricePurchase, announcementResult.Profit);
Assert.Equal(announcement.Vehicle.Model.Brand.Name, announcementResult.VehicleBrandName);
Assert.Equal(announcement.Vehicle.Model.Name, announcementResult.VehicleModelName);
}
}
public async Task <IViewModel[]> ExecuteAsync(QueriesHandler queriesHandler)
{
var result = null as IEnumerable <Movie>;
using (HttpClient client = new HttpClient())
using (HttpResponseMessage res = await client.GetAsync("http://copafilmes.azurewebsites.net/api/filmes"))
using (HttpContent content = res.Content)
{
string data = await content.ReadAsStringAsync();
if (data != null)
{
result = JsonConvert.DeserializeObject <IEnumerable <Movie> >(data);
}
}
return(result.ToArray());
}
// POST api/<controller>
public async Task <HttpResponseMessage> Post([FromBody] QueryInfo query)
{
try
{
Resultado objetoConsulta = new Resultado();
objetoConsulta.ip = new System.Net.WebClient().DownloadString("https://api.ipify.org");
//GetIPAddresss().ToString();
if (String.IsNullOrEmpty(query.SQL))
{
objetoConsulta.erro.codigo = "0";
objetoConsulta.erro.mensagem = "A query não pode estar vazia";
return(Request.CreateResponse(HttpStatusCode.OK, objetoConsulta));
}
QueriesHandler qh = new QueriesHandler();
var resultadoConsulta = await qh.Query(query.SQL, query?.ConnectionName);
objetoConsulta.resultado = resultadoConsulta;
return(Request.CreateResponse(HttpStatusCode.OK, objetoConsulta));
}
catch (Exception ex)
{
Resultado objetoConsulta = new Resultado();
objetoConsulta.ip = new System.Net.WebClient().DownloadString("https://api.ipify.org");
objetoConsulta.erro.mensagem = ex.Message;
var arrayErro = ex.Message.Split(':');
if (arrayErro.Length > 1)
{
objetoConsulta.erro.codigo = ex.Message.Split(':')[0];
objetoConsulta.erro.mensagem = ex.Message.Split(':')[1].Trim();
}
return(Request.CreateResponse(HttpStatusCode.OK, objetoConsulta));
}
}
public MoviesController(CommandsHandler commandsHandler, QueriesHandler queriesHandler)
{
_commandsHandler = commandsHandler;
_queriesHandler = queriesHandler;
}
