public string Relatorio()
{
string retorno;
string data_inicio;
string data_fim;
int nr_itens;
int page;
string tp_acao;
string mes;
Models.Relatorio relatorio = new Relatorio();
DaoVEAnet daoRelatorio = new DaoVEAnet();
try
{
if (DateTime.Now.Month < 10)
{
mes = "0" + DateTime.Now.Month.ToString();
}
else
{
mes = DateTime.Now.Month.ToString();
}
DateTime dtAtual = DateTime.Today;
DateTime dtUltimoDiaMes = new DateTime(dtAtual.Year, dtAtual.Month, DateTime.DaysInMonth(dtAtual.Year, dtAtual.Month));
DateTime now = DateTime.Now;
data_inicio = now.ToString("yyyy") + "-" + "06" + "-" + "01";
data_fim = now.ToString("yyyy") + "-" + mes + "-" + dtUltimoDiaMes.Day.ToString();
nr_itens = 3000;
page = 1;
tp_acao = "CADASTRAR";
var client = new RestClient("https://boleto.carsystem.com/api/v1/relatorio?data_inicio=" + data_inicio.ToString() + "&data_fim=" + data_fim.ToString() + "&itens=+ " + nr_itens + "&page=1&acao=ATUALIZAR");
client.Timeout = -1;
var request = new RestRequest(Method.GET);
//EnvioParam EnvioParametros = new EnvioParam();
//EnvioParametros.data_inicio = data_inicio.ToString();
//EnvioParametros.data_fim = data_fim.ToString();
//EnvioParametros.itens = 100;
//EnvioParametros.page = 1;
//EnvioParametros.acao = tp_acao.ToString();
//var Json = JsonConvert.SerializeObject(EnvioParametros, Newtonsoft.Json.Formatting.Indented, new Newtonsoft.Json.JsonSerializerSettings { NullValueHandling = Newtonsoft.Json.NullValueHandling.Ignore });
var iParametros =
"{" +
"\"data_inicio\":\"" + data_inicio + "\"," +
"\"data_fim\":\"" + data_fim + "\"," +
"\"itens\":" + nr_itens + "," +
"\"page\":" + page + "," +
"\"acao\":\"" + tp_acao.ToString() + "\"" +
"}";
request.AddHeader("Authorization", "Basic Y2Fyc3lzdGVtOkBhcGlib2xldG8yMDIw");
request.AddHeader("Content-Type", "application/json");
request.AddHeader("Cookie", "XSRF-TOKEN=eyJpdiI6IjdwK2JNRjhlU0Y0QkRhN3dFaEdWZmc9PSIsInZhbHVlIjoiNEtXQ1pDa1pUSGd1a1wvYzJhazQ3cUF2cnpIR29NVldNY3ZDNUZ4QVV6cUl3ejVVaU04dU53aURma1Bsd2hZbjEiLCJtYWMiOiJhZmZhODFhNGVlNmI2YjI3OTYzNjY1MDI0N2M2OWMzZGQ0ZWUxM2Y4OGQwOTQ3OGIxNzc4NDcxYmU5NGM3M2Q1In0%3D; laravel_session=eyJpdiI6IktmQm55c1dXK3J2NUo1cElPMkVCS0E9PSIsInZhbHVlIjoiSFdxNDZSSXAzUkg5K1NDY3hxKzhNcVp3MW1NYUg2MngxaWpnNjQyR1prTzJGNHFvVjdBUjh5d3FwZmhkNFJvdSIsIm1hYyI6IjE5OGYwNDNkNDJhZjJkMWYwNzdhZjRjMDI5ZmRjYzNmYTFhYmQ3NzRiOTUwNjk2Y2ZmYTE5NTBmMzUyZjUyYmQifQ%3D%3D");
request.AddParameter("application/json", iParametros
//"{\"data_inicio\":\"" + data_inicio + "\",\"data_fim\":\"" + data_fim + "\",\"itens\":3000,\"page\":1,\"acao\": \"ATUALIZAR\"}"
, ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
Console.WriteLine(response.Content);
JavaScriptSerializer js = new JavaScriptSerializer();
var customerRelatorio = JsonConvert.DeserializeObject <RootobjectRelatorio>(response.Content);
if (customerRelatorio.success == true)
{
foreach (var item in customerRelatorio.relatorio)
{
int id_envio = item.id;
string cd_parcela = item.numero_parcela;
string dt_envio = item.data_envio;
int nr_tentativas = item.tentativas;
string nr_doc = item.documento;
string ds_emailEnviado = item.email_enviado;
string ds_emailCorrigido = item.email_corrigido;
string st_parcela = item.situacao_envio;
string ds_erro = item.erro_envio;
daoRelatorio.SetRelatorioEmail(id_envio, cd_parcela, dt_envio, nr_tentativas, nr_doc, ds_emailEnviado, ds_emailCorrigido, st_parcela, ds_erro);
}
retorno = customerRelatorio.success.ToString();
}
else
{
retorno = response.Content.ToString();
}
}
catch (Exception ex)
{
throw new global::System.Data.StrongTypingException("'Procure o Administrador'", ex);
}
return(retorno.ToString());
}
