//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)); }