//public async Task<IHttpActionResult> Add()
public async Task <HttpResponseMessage> Add()
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
double ret = 0;
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
var root = ConfigurationManager.AppSettings.Get("PATHARQUIVOS") + "\\UPLOAD";
if (!Directory.Exists(root))
{
Directory.CreateDirectory(root);
}
var provider = new CustomMultipartFormDataStreamProvider(root);
var result = await Request.Content.ReadAsMultipartAsync(provider);
int id = 0;
var model = result.FormData["model"];
UploadParceiroADO upado = new UploadParceiroADO();
UploadParceiro up = JsonConvert.DeserializeObject <UploadParceiro>(model);
up.cdentifilial = Convert.ToInt32(cf.cdentifilial);
id = upado.InsertUpload(up, cf.datasource, cf.schema, cf.cdentifilial);
FileInfo fi = null;
string extensao = string.Empty;
foreach (var file in result.FileData)
{
fi = new FileInfo(file.LocalFileName);
System.IO.File.Move(file.LocalFileName, root + "\\" + id.ToString() + fi.Extension);
up.txpath = id.ToString() + fi.Extension;
up.CdUploadParceiro = id;
upado.UpdatePath(up, cf.datasource, cf.schema);
}
return(Request.CreateResponse(HttpStatusCode.OK, "OK"));
}
public HttpResponseMessage logar(HttpRequestMessage request, [FromBody] Usuario user)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
user = Database.UsuarioADO.Login(user, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Login post: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
public HttpResponseMessage ProdutoParceiroInsertnolist(HttpRequestMessage request, [FromBody] Produto prod)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
Database.ProdutoADO.CadastrarProdParceironolist(prod.cdproduto, cf.cdentifilial, prod.codforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "ProdutoParceiroInsertnolist: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "ok"));
}
public HttpResponseMessage DeleteParceiroRestprod(HttpRequestMessage request, [FromBody] Produto prod)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
Database.ProdutoADO.ExcluirProdParceiro(prod.cdprodparceiro, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "DeleteParceiroRestprod: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "ok"));
}
public HttpResponseMessage RetornaEnderecoByCdEntidade(string cdentidade)
{
List <Endereco> cfret = new List <Endereco>();
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
cfret = EnderecoADO.RetornaEnderecoByCdEntidade(cdentidade, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaEnderecoByCdEntidade: " + e.ToString(), "SEMCNPJ", Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.BadRequest, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, cfret));
}
public HttpResponseMessage RetornaEnderecoByCep2(string cep)
{
RetornoCep cfret = new RetornoCep();
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
cfret = RetornaEndereco(cep, cf.datasource, cf.schema);
}
catch (Exception e)
{
//Util.LogUtil.GravaLog(this, "RetornaConfigApp: " + e.ToString(), "SEMCNPJ", Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.BadRequest, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, cfret));
}
public HttpResponseMessage RetornaProdutoPesquisaParceiroRest(HttpRequestMessage request, [FromBody] Produto prod)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <Produto> ret = new List <Produto>();
try
{
ret = Database.ProdutoADO.RetornaProdutoPesquisaParceiro(cf.datasource, cf.schema, prod.codforn);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaProdutoPesquisaParceiroRest: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage ParceiroBuscaByParam(HttpRequestMessage request, [FromBody] ParceiroSearch parc)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <ParceiroComissao> ret = new List <ParceiroComissao>();
try
{
ret = Database.ParceiroADO.RetornaComissaoFuncAggByParam(parc, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "ParceiroBuscaByParam: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage PesquisaColaborador(HttpRequestMessage request, [FromBody] UsuarioPost user)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <UsuarioRetorno> ret = new List <UsuarioRetorno>();
try
{
ret = Database.UsuarioADO.RetornaColaborador(user.nomeuser, user.usuario, user.cdforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "PesquisaColaborador: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage updatePedido(HttpRequestMessage request, [FromBody] PedidoUpdateFrete ped)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
string ret = string.Empty;
try
{
ret = Database.PedidosADO.AtualizaFrete(ped.cdpedido, ped.vrfrete, ped.txtipofrete, ped.tokenaxado, cf.cdentifilial, ped.cdenderecoentregra, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "updatePedido: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "ok"));
}
public HttpResponseMessage ProdutoPesquisaSemfilial(HttpRequestMessage request, [FromBody] produtosearch prod)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <Produto> ret = new List <Produto>();
try
{
ret = Database.ProdutoADO.RetornaProdutoPesquisaSemFilial(prod, cf.datasource, cf.schema, cf.cdentifilial);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "ProdutoPesquisaSemfilial: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage Login(HttpRequestMessage request, [FromBody] UsuarioPost user)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
UsuarioRetorno ret = new UsuarioRetorno();
try
{
ret = Database.UsuarioADO.Login(user.usuario, user.senha, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Login: "******"ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage cadastrarFuncionario(HttpRequestMessage request, [FromBody] UsuarioPost user)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
string ret = string.Empty;
try
{
Database.UsuarioADO.CadastrarColaborador(user.cdfuncionario.ToString(), user.nomeuser, user.usuario, user.senha, user.cdforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "cadastrarFuncionario:" + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, "ok"));
}
public HttpResponseMessage Retornacolaboradorparceiro(string cdforn)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <UsuarioRetorno> ret = new List <UsuarioRetorno>();
try
{
ret = Database.UsuarioADO.RetornaColaboradoresByIdPai(cdforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Retornacolaboradorparceiro: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage PesquisaColaboradorbynome(string nome)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
bool ret = false;
try
{
ret = Database.UsuarioADO.TemColaboradorByNome(nome, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "PesquisaColaborador: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaClienteByCpfCnpj(string cpfcnpj)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
cliente ret = new cliente();
try
{
ret = Database.ClienteADO.RetornaClientByCpfCnpj(cpfcnpj, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaClienteByCpfCnpj: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaTipoEnderecoRest()
{
List <Basico> bret = new List <Basico>();
ConfigAppMembers cf = Util.ConfigApp.getConfig();
try
{
bret = BasicoADO.RetornaTipoEndereco(cf.datasource, cf.schema);
}
catch (Exception e)
{
//Util.LogUtil.GravaLog(this, "RetornaConfigApp: " + e.ToString(), "SEMCNPJ", Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.BadRequest, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, bret));
}
public HttpResponseMessage CestaGet(string cdcesta, string cdforn)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <cesta> ret = new List <cesta>();
try
{
ret = Database.CestaADO.RetornaCesta(cdcesta, cdforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Retorna cesta : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage GetPedidosDetalhe(string cdpedido)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
PedidoDetalheRet ret = new PedidoDetalheRet();
try
{
ret = Database.PedidosADO.RetornaPedidoDetalhe(cdpedido, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "GetPedidosDetalhe: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage CestaInsert(HttpRequestMessage request, [FromBody] cestapost cesta)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <cesta> ret = new List <cesta>();
try
{
ret = Database.CestaADO.GravaCesta(cf.cdentifilial, cesta.codped, cesta.cliente, cesta.produ, cesta.finaliza, cesta.codforn, cesta.codend, cesta.preco, cesta.subsquant, cesta.codforn, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Grava cesta : " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage ClienteBuscaByParam(HttpRequestMessage request, [FromBody] clientesearch cli)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <cliente> ret = new List <cliente>();
try
{
ret = Database.ClienteADO.RetornaClientByParam(cli, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Cliente search: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaContatoByCdEntidade(string cdentidade)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <ContatoRet> ret = new List <ContatoRet>();
try
{
ret = Database.ClienteADO.RetornaContatoByCdEntidade(cdentidade, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaContatoByCdEntidade: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage checkEmail(string email)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
Usuario user = new Usuario();
try
{
user = Database.UsuarioADO.ChecaEmail(email, cf.codapp, cf.cdentifilial, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "checkEmail get: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, user));
}
public HttpResponseMessage BannerDelete(HttpRequestMessage request, [FromBody] Banner banner)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
double ret = 0;
try
{
BannerADO bado = new BannerADO();
ret = bado.DeleteBanner(banner.cdbanner, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "BannerInsert: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage GetNfeByForn(HttpRequestMessage request, [FromBody] UploadParceiroPesquisa pesq, string cdpai)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <UploadParceiro> ret = new List <UploadParceiro>();
string query = string.Empty;
try
{
ret = Database.UploadParceiroADO.ConsultarNfe(pesq, cdpai, cf.cdentifilial, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "GetPedidosByForn: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
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 GetPedidosByForn(HttpRequestMessage request, [FromBody] PedidoPesquisa ped)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <PedidoConsulta> ret = new List <PedidoConsulta>();
string query = string.Empty;
try
{
ret = Database.PedidosADO.RetornaPedidosForn(ped, cf.cdentifilial, cf.datasource, cf.schema, out query);
Util.LogUtil.GravaLog(this, "GetPedidosByForn QUERY: " + query, cf.Cnpj, Log.TipoLog.erro);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "GetPedidosByForn: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage ClienteInsert(HttpRequestMessage request, [FromBody] cliente cli)
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
double ret = 0;
try
{
Util.LogUtil.GravaLog(this, "Cliente post: " + JsonConvert.SerializeObject(cli), cf.Cnpj, Log.TipoLog.info);
ret = Database.ClienteADO.GravaClienteRest(cli, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "Cliente post: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage BannersAtivos()
{
ConfigAppMembers cf = Util.ConfigApp.getConfig();
List <Banner> ret = new List <Banner>();
try
{
BannerADO bado = new BannerADO();
ret = bado.RetornaBannersAtivos(cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "BannersAtivos: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
public HttpResponseMessage RetornaPromocaoByIdFilial()
{
List <Promocao> lstReturn = new List <Promocao>();
ConfigAppMembers cf = new ConfigAppMembers();
try
{
cf = Util.ConfigApp.getConfig();
lstReturn = PromocaoADO.GetPromocao(cf.cdentifilial, cf.datasource, cf.schema);
}
catch (Exception e)
{
Util.LogUtil.GravaLog(this, "RetornaPromocaoByIdFilial: " + e.ToString(), cf.Cnpj, Log.TipoLog.erro);
return(Request.CreateResponse(HttpStatusCode.BadRequest, "ERRO"));
}
return(Request.CreateResponse(HttpStatusCode.OK, lstReturn));
}
