public HttpResponseMessage RetornaFinalizaPagamentoTray(HttpRequestMessage request, [FromBody] TrayCheckoutNotificacao tn)
{
try
{
string posttray = JsonConvert.SerializeObject(tn);
var queryString = request.RequestUri.ParseQueryString();
string copagto = queryString["cp"];
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO OPTOKEN ANTES: " + queryString["opttoken"].ToString(), "traycheckout", Log.TipoLog.info);
string opttoken = queryString["opttoken"].ToString().Replace(' ', '+');
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO copagto: " + copagto, "traycheckout", Log.TipoLog.info);
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO OPTOKEN DEPOIS: " + opttoken, "traycheckout", Log.TipoLog.info);
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO : " + posttray, "traycheckout", Log.TipoLog.info);
int statusret = 0;
TrayCheckoutNotification tcn = new TrayCheckoutNotification();
TrayCheckouttransactionRet tcret = tcn.ConfirmaRecebimento(string.IsNullOrEmpty(tn.token_transaction) ? tn.token : tn.token_transaction, out statusret);
string tcnstr = JsonConvert.SerializeObject(tcret);
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO confirma: " + tcnstr, "traycheckout", Log.TipoLog.info);
/*
* Aguardando Pagamento 4
* Em Processamento 5
* Aprovada 6
* Cancelada 7
* Em Contestação 24
* Em Monitoramento 87
* Em Recuperação 88
* Reprovada 89
*/
//atualizar o pagamento de acordo com o status
string token = Util.Cripto.Decrypt(opttoken.Replace(" ", "+"), ConfigurationManager.AppSettings.Get("CHAVE"));
string[] val = token.Split('|');
string datasource = val[1]; //datasource
string schema = val[2]; //schema
PedidoRetTrayNotificacao prt = PedidosADO.RetornaPedidoTrayckoutConfirm(copagto, datasource, schema);
//Retorna os dados do pagamento para gravar novamente o pagamento
if (tcret.status_id == "6")
{
List <pedidopagamento> lstpag = PagamentoADO.GravaPagamento(prt.codped, "6", prt.valorpago, "N", "S", prt.parcelas, "N", prt.codpag, prt.operador, "0", tcret.token_transaction, tcret.transaction_id, tcret.payment_response, tcret.status_id + "-" + tcret.status_name, tcret.payment_payment_method_name, datasource, schema, prt.cdformapagamento);
}
else if (tcret.status_id == "7" || tcret.status_id == "89")
{
List <pedidopagamento> lstpag = PagamentoADO.GravaPagamento(prt.codped, "6", prt.valorpago, "N", "N", prt.parcelas, "S", prt.codpag, prt.operador, "0", tcret.token_transaction, tcret.transaction_id, tcret.payment_response, tcret.status_id + "-" + tcret.status_name, tcret.payment_payment_method_name, datasource, schema, prt.cdformapagamento);
}
var aa = tn.token;
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray NOTIFICACAO : " + e.ToString(), "traycheckout", Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage RetornaPedidoPagamentoPaypal(string cdcesta, string codpedpagar, string cdforn)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
RetPaypal ret = new RetPaypal();
try
{
//pega a cesta
List <PedidoPaypal> lstRet = PedidosADO.RetornaPedidoPagamento(codpedpagar, cf.datasource, cf.schema);
double vrtotalpedido = 0;
Cart cart = new Cart();
Product prd;
foreach (var ped in lstRet)
{
prd = new Product();
prd.Id = Convert.ToInt32(ped.cdproduto);
prd.Name = ped.nmproduto;
prd.Price = ped.preco;
vrtotalpedido += Convert.ToInt32(ped.quantidade) * ped.preco;
//prd.Quantidade = ped.quantidade;
cart.Add(prd, Convert.ToInt32(ped.quantidade));
}
double frete = lstRet[0].frete;
vrtotalpedido += frete;
List <pedidopagamento> lstpag = PagamentoADO.GravaPagamento(codpedpagar, "5", vrtotalpedido.ToString(), "N", "N", "1", "N", "0", cdforn, "0", "", "", "", "", "", cf.datasource, cf.schema, "2");
string codpag = lstpag[0].cdpag;
ret.urlRedirect = Checkout.start("http://localhost:47905/PaypalReturn.aspx?codpag=" + codpag + "&codpedpagar=" + codpedpagar, "http://localhost:47905/PaypalCancel.aspx?codped=" + cdcesta + "&codpedpagar=" + codpedpagar, cart, frete, codpedpagar);
Uri uri = new Uri(ret.urlRedirect);
string tokenpaypal = HttpUtility.ParseQueryString(uri.Query).Get("token");
//Lancar o pagamento com o token
PagamentoADO.GravaPagamento(codpedpagar, "5", vrtotalpedido.ToString(), "N", "N", "1", "N", codpag, cdforn, "0", tokenpaypal, "", "", "", "", cf.datasource, cf.schema, "2");
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaPedidoPagamentoPaypal : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaFinalizaPagamentoTray(string token, string PayerID, string codpag)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
string ret = "";
try
{
List <pedidopagamento> lstpag = PagamentoADO.BuscaPagamentoTituloByCodpag(codpag, cf.datasource, cf.schema);
//PagamentoADO.GravaPagamento(lstpag[0].codped, "5", lstpag[0].valorpago, "N", "S", "1", "N", codpag, "", "A", token, PayerID, "", "", "", cf.datasource, cf.schema);
ret = "ok";
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoTray : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaFinalizaPagamentoPaypal(string token, string PayerID, string codpag)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
PaypalFinalize ret = new PaypalFinalize();
try
{
NameValueCollection nvp = Checkout.finalize(token, PayerID);
ret.payerid = PayerID;
ret.tokentransacao = token;
ret.shiptoname = nvp["PAYMENTREQUEST_0_SHIPTONAME"];
ret.shiptocity = nvp["PAYMENTREQUEST_0_SHIPTOCITY"];
ret.shiptostate = nvp["PAYMENTREQUEST_0_SHIPTOSTATE"];
ret.shiptostreet = nvp["PAYMENTREQUEST_0_SHIPTOSTREET"];
ret.shiptostreet2 = nvp["PAYMENTREQUEST_0_SHIPTOSTREET2"];
ret.shiptozip = nvp["PAYMENTREQUEST_0_SHIPTOZIP"];
ret.statusakc = nvp["ACK"];
ret.firstname = nvp["FIRSTNAME"];
ret.lastname = nvp["LASTNAME"];
ret.email = nvp["EMAIL"];
//Finaliza o pagamento
if (ret.statusakc == "Success")
{
List <pedidopagamento> lstpag = PagamentoADO.BuscaPagamentoTituloByCodpag(codpag, cf.datasource, cf.schema);
PagamentoADO.GravaPagamento(lstpag[0].codped, "5", lstpag[0].valorpago, "N", "S", "1", "N", codpag, "", "A", token, PayerID, "", "", "", cf.datasource, cf.schema, "2");
}
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaFinalizaPagamentoPaypal : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage TrayPostTransaction(HttpRequestMessage request, [FromBody] TrayCheckoutPost tc)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
TrayCheckoutPaymentResponse tckResponse = new TrayCheckoutPaymentResponse();
try
{
TrayCheckoutPayment tcp = new TrayCheckoutPayment();
double vrtotalpedido = 0;
CreateTransaction ctrans = new CreateTransaction();
if (tc.payment_method_id == "6")
{
tcp.payment_payment_method_id = tc.payment_method_id;
tcp.payment_split = "1";
}
else
{
//dados do cartao vem do post
tcp.payment_card_cvv = tc.card_cvv;
tcp.payment_card_expdate_month = tc.card_expdate_month;
tcp.payment_card_expdate_year = tc.card_expdate_year;
tcp.payment_card_name = tc.card_name;
tcp.payment_card_number = tc.card_number;
tcp.payment_payment_method_id = tc.payment_method_id;
tcp.payment_split = tc.split.ToString();
}
//dados do produto
List <PedidoPaypal> lstRet = PedidosADO.RetornaPedidoPagamento(tc.order_number, cf.datasource, cf.schema);
vrtotalpedido = PedidosADO.RetornaValorTotalPedido(tc.order_number, cf.datasource, cf.schema);
foreach (var prod in lstRet)
{
transaction_product tp = new transaction_product();
tp.quantity = Convert.ToInt32(prod.quantidade);
tp.price_unit = prod.preco;
tp.description = prod.nmproduto;
tp.sku_code = prod.cdproduto;
tcp.Products.Add(tp);
//vrtotalpedido += Convert.ToInt32(prod.quantidade) * prod.preco;
}
string cdenderecoentrega = lstRet[0].cdenderecoentrega;
double frete = lstRet[0].frete;
//vrtotalpedido += frete;
//Endereco do cliente
Endereco ende = EnderecoADO.RetornaEnderecoById(cdenderecoentrega, cf.datasource, cf.schema);
//frete
if (frete > 0)
{
tcp.shipping_price = frete;
tcp.shipping_type = lstRet[0].txfrete;
}
//pegar os dados do cliente
string cdcliente = lstRet[0].cdcliente;
cliente clie = ClienteADO.RetornaClientById(cdcliente, cf.datasource, cf.schema);
clientecontato contato = (from a in clie.Contatos
where a.stdefault == "1" && !string.IsNullOrEmpty(a.email) && !string.IsNullOrEmpty(a.telresidencial) && !string.IsNullOrEmpty(a.dddresi)
select a).FirstOrDefault();
tcp.customer_addresses_city = ende.txcidade;
tcp.customer_addresses_neighborhood = ende.txbairro;
tcp.customer_addresses_number = ende.txnumero;
tcp.customer_addresses_postal_code = ende.cdcep;
tcp.customer_addresses_state = ende.cduf;
tcp.customer_addresses_street = ende.txlogradouro;
tcp.customer_addresses_type_address = "D";//entrega
/*
* 1 Contato
* 2 Pessoal
* 3 Profissional
* 4 Bancário
* 5 Comercial
* 6 Referência
* 7 Marketing
* 8 Financeiro
* 9 Logistica
*/
/* tray contato
* Residencial H
* Celular M
* Comercial W
*/
string tipocontato = "H";
//switch (contato.cdtipocontato)
//{
// case "1":
// case "2":
// case "3":
// case "4":
// case "6":
// case "7":
// case "9":
// case "8":
// {
// tipocontato = "H";
// break;
// }
// case "5":
// {
// tipocontato = "W";
// break;
// }
// default:
// break;
//}
/* tipo tel
* 4 Pessoal
* 1 Comercial
* 2 Residencial
* 3 Celular
*/
//clientecontatotelefone tel = (from t in contato.Telefones
// where t.cdtipotelefone == "4"
// select t).FirstOrDefault();
//if (tel == null)
//{
// tel = (from t in contato.Telefones
// where t.cdtipotelefone == "1"
// select t).FirstOrDefault();
//}
//if (tel == null)
//{
// tel = (from t in contato.Telefones
// where t.cdtipotelefone == "2"
// select t).FirstOrDefault();
//}
//if (tel == null)
//{
// tel = (from t in contato.Telefones
// where t.cdtipotelefone == "3"
// select t).FirstOrDefault();
//}
tcp.customer_contacts_number_contact = contato.dddresi + contato.telresidencial;//telefone
/* tray
* Residencial H
* Celular M
* Comercial W
*/
tcp.customer_contacts_type_contact = tipocontato;
tcp.customer_cpf = string.IsNullOrEmpty(clie.CPF) ? clie.CNPJ : clie.CPF;
/*
* 1 Comercial
* 2 Pessoal
* 3 NF-e
* 21 Envio de e-mail
*/
clientecontatoemail email = (from e in contato.Emails
where e.cdtipoemail == "1"
select e).FirstOrDefault();
if (email == null)
{
email = (from e in contato.Emails
where e.cdtipoemail == "2"
select e).FirstOrDefault();
}
if (email == null)
{
email = (from e in contato.Emails
where e.cdtipoemail == "3"
select e).FirstOrDefault();
}
if (email == null)
{
tcp.customer_email = contato.email;
tcp.customer_name = clie.nome;
}
else
{
tcp.customer_email = email.txemail;
tcp.customer_name = clie.nome;
}
// nome cpf email
/*tray
* 2 Diners
* 3 Visa
* 4 Mastercard
* 5 American Express
* 6 Boleto Bancário
* 7 Itaú Shopline (Transferência)
* 14 Peela
* 15 Discover
* 16 Elo
* 18 Aura
* 19 JCB
* 22 Transf. Online Bradesco
* 23 Transf. Online Banco do Brasil
*/
/*Optimus
* 1 Dinheiro
* 2 Visa
* 3 Master
* 4 Transferencia
* 5 Paypal
* 6 Traycheckout
* 7 Boleto
* 8 Diners club
* 9 American Express
* 10 Elo
* 11 Aura
*
*/
string cdformaopt = "";
switch (tc.payment_method_id)
{
case "3": cdformaopt = "2"; break;
case "2": cdformaopt = "8"; break;
case "4": cdformaopt = "3"; break;
case "5": cdformaopt = "9"; break;
case "6": cdformaopt = "7"; break;
case "16": cdformaopt = "10"; break;
case "18": cdformaopt = "11"; break;
default: cdformaopt = "4";
break;
}
List <pedidopagamento> lstpag = PagamentoADO.GravaPagamento(tc.order_number, "6", vrtotalpedido.ToString(), "N", "N", tcp.payment_split, "N", "0", tc.cdforn, "0", tckResponse.token_transaction, tckResponse.transaction_id, tckResponse.payment_response, tckResponse.status_id + "-" + tckResponse.status_name, tckResponse.payment_method_name, cf.datasource, cf.schema, cdformaopt);
string codpagamento = lstpag[0].cdpag;
string formdata = string.Empty;
string urltrans = string.Empty;
string qstring = string.Empty;
tcp.transaction_order_number = tc.order_number;
tckResponse = ctrans.CriarTransacao(tcp, codpagamento, cf.token, out formdata, out urltrans, out qstring);
Util.LogUtil.GravaLog(this, "urltrans-->" + urltrans, cf.Cnpj, Log.TipoLog.info);
Util.LogUtil.GravaLog(this, "formdata-->" + formdata, cf.Cnpj, Log.TipoLog.info);
Util.LogUtil.GravaLog(this, "qstring-->" + qstring, cf.Cnpj, Log.TipoLog.info);
tckResponse.codpagamento = codpagamento;
string tkcstring = JsonConvert.SerializeObject(tckResponse);
Util.LogUtil.GravaLog(this, "RETORNO TRAYCHECOUT-->" + tkcstring, cf.Cnpj, Log.TipoLog.info);
//if (tckResponse.sucessResponse)
//{
// PagamentoADO.GravaPagamento(tc.order_number, "5", vrtotalpedido.ToString(), "N", "N", tckResponse.split, "N", codpagamento, tc.cdforn, "0", tckResponse.token_transaction, tckResponse.transaction_id, tckResponse.payment_response, tckResponse.status_id + "-" + tckResponse.status_name, tckResponse.payment_method_name, cf.datasource, cf.schema);
// // tckResponse.codpagamento = lstpag[0].cdpag;
//}
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "TrayPostTransaction : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, tckResponse));
}