public HttpResponseMessage RetornaConfigApp(string pkgname) { ConfigAppobj cfret = new ConfigAppobj(); try { cfret = ConfigADO.RetornaConfig(pkgname); } 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, JsonConvert.SerializeObject(cfret))); }
public static ConfigAppobj RetornaConfig(string packagename) { ConfigAppobj ret = new ConfigAppobj(); string query = string.Format("SELECT * FROM CONFIGAPP WHERE TXPACKAGENAME = '{0}'", packagename); DataSet dts = OracleHelper.ExecQuery(query, null, null, ConfigurationManager.AppSettings.Get("conintegracao")); string datasource = string.Empty; string schema = string.Empty; if (dts.Tables.Count > 0) { foreach (DataRow dr in dts.Tables[0].Rows) { ret.optcodapp = dr["CDAPP"].ToString(); ret.optcssfundotopo = dr["txcssfundotopo"].ToString(); ret.optcsstopo = dr["txcsstopo"].ToString(); ret.optdadosempresa = dr["stmostradadosempresa"].ToString(); ret.optemailcontato = dr["txcontaemail"].ToString(); ret.optfilial = dr["cdentifilial"].ToString(); ret.optpkgname = dr["txpackagename"].ToString(); ret.optsenderidandroid = dr["txsenderidandroid"].ToString(); ret.optsenderidios = dr["txsenderidios"].ToString(); if (!string.IsNullOrEmpty(dr["txtelefones"].ToString())) { if (dr["txtelefones"].ToString().Contains('|')) { string[] tels = dr["txtelefones"].ToString().Split('|'); foreach (var item in tels) { ret.opttelefones.Add(new telefone(item)); } } else { ret.opttelefones.Add(new telefone(dr["txtelefones"].ToString())); } } ret.opttoken = dr["txtoken"].ToString(); ret.opttxhoraatendimento = dr["txhoraatendimento"].ToString(); ret.opturllogo = dr["txurllogo"].ToString(); if (ret.optdadosempresa == "1") { datasource = dr["txdatasource"].ToString(); schema = dr["txesquema"].ToString(); } } if (ret.optdadosempresa == "1") { //buscar a filial string q = string.Format("select cnpj,nmrazaosocial,cdcep,txcidade,txbairro,txlogradouro,txnumero,txcomplemento,cduf from vw_filial where cdentifilial = {0}", ret.optfilial); DataSet dtsf = OracleHelper.ExecQuery(q.ToString(), null, "", OracleHelper.BancoOracle.optimus, schema, datasource); if (dtsf.Tables.Count > 0) { if (dtsf.Tables[0].Rows.Count > 0) { ret.filial.bairro = dtsf.Tables[0].Rows[0]["txbairro"].ToString().ToUpper(); ret.filial.cep = Convert.ToUInt64(dtsf.Tables[0].Rows[0]["cdcep"].ToString()).ToString(@"00000\-000"); ret.filial.cnpj = Convert.ToUInt64(dtsf.Tables[0].Rows[0]["cnpj"].ToString()).ToString(@"00\.000\.000\/0000\-00"); ret.filial.complemento = dtsf.Tables[0].Rows[0]["txcomplemento"].ToString().ToUpper(); ret.filial.logradouro = dtsf.Tables[0].Rows[0]["txlogradouro"].ToString().ToUpper(); ret.filial.NmRazao = dtsf.Tables[0].Rows[0]["nmrazaosocial"].ToString().ToUpper(); ret.filial.numero = dtsf.Tables[0].Rows[0]["txnumero"].ToString(); ret.filial.uf = dtsf.Tables[0].Rows[0]["cduf"].ToString().ToUpper(); ret.filial.cidade = dtsf.Tables[0].Rows[0]["txcidade"].ToString().ToUpper(); } } } } return(ret); }