public static bool cadPartComplende(CL_Partcomplende objPartComplende, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); try { string sql = "INSERT INTO part_compl (pc_codigo, pc_codpart, pc_nome, pc_cnpj, pc_ende, pc_nr, pc_compl, pc_bairro, pc_ibge, " + "pc_cida, pc_uf, pc_respons, pc_matric, pc_email, pc_fone, pc_cep, pc_iest, pc_ativo, pc_situac) VALUES (" + "@pc_codigo, @pc_codpart, @pc_nome, @pc_cnpj, @pc_ende, @pc_nr, @pc_compl, @pc_bairro, @pc_ibge, " + "@pc_cida, @pc_uf, @pc_respons, @pc_matric, @pc_email, @pc_fone, @pc_cep, @pc_iest, @pc_ativo, @pc_situac)"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); comand.Parameters.AddWithValue("pc_codigo", objPartComplende.pc_codigo); comand.Parameters.AddWithValue("pc_codpart", objPartComplende.pc_codpart); comand.Parameters.AddWithValue("pc_nome", objPartComplende.pc_nome); comand.Parameters.AddWithValue("pc_cnpj", objPartComplende.pc_cnpj); comand.Parameters.AddWithValue("pc_ende", objPartComplende.pc_ende); comand.Parameters.AddWithValue("pc_nr", objPartComplende.pc_nr); comand.Parameters.AddWithValue("pc_compl", objPartComplende.pc_compl); comand.Parameters.AddWithValue("pc_ibge", objPartComplende.pc_ibge); comand.Parameters.AddWithValue("pc_cida", objPartComplende.pc_cida); comand.Parameters.AddWithValue("pc_uf", objPartComplende.pc_uf); comand.Parameters.AddWithValue("pc_matric", objPartComplende.pc_matric); comand.Parameters.AddWithValue("pc_bairro", objPartComplende.pc_bairro); comand.Parameters.AddWithValue("pc_email", objPartComplende.pc_email); comand.Parameters.AddWithValue("pc_fone", objPartComplende.pc_fone); comand.Parameters.AddWithValue("pc_cep", objPartComplende.pc_cep); comand.Parameters.AddWithValue("pc_iest", objPartComplende.pc_iest); comand.Parameters.AddWithValue("pc_ativo", objPartComplende.pc_ativo); comand.Parameters.AddWithValue("pc_respons", objPartComplende.pc_respons); comand.Parameters.AddWithValue("pc_situac", objPartComplende.pc_situac); Conn.Open(); comand.ExecuteScalar(); return(true); } catch (Exception ex) { ex.ToString(); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool confereParticip(int clicod, int codend, string token, string con) { try { string cgc = "", sql = ""; if (codend != 0) { CL_Partcomplende objPartComplend = new CL_Partcomplende(); objPartComplend = NG_Partcomplende.buscaPartComplende(codend.ToString(), con); if (objPartComplend != null) { cgc = cgc = objPartComplend.pc_cnpj.Replace(".", "").Replace("/", "").Replace("-", ""); cgc = cgc + "-" + objPartComplend.pc_codigo; sql = "UPDATE part_compl SET pc_situac='S' WHERE pc_codigo=" + objPartComplend.pc_codigo; if (objPartComplend.pc_situac == "S") { return(true); } else if (objPartComplend.pc_situac == "A") { string post = acertaXmlAlterar(objPartComplend.pc_nome, objPartComplend.pc_nome, objPartComplend.pc_uf, "BRASIL", objPartComplend.pc_cida, objPartComplend.pc_bairro, objPartComplend.pc_ende, objPartComplend.pc_nr, objPartComplend.pc_compl, objPartComplend.pc_cep, objPartComplend.pc_fone.Trim(), objPartComplend.pc_fone.Trim(), objPartComplend.pc_email); if (attDadosApp(token, "serviceLocal", post, cgc)) { if (attSituac(sql, con)) { return(true); } else { return(false); } } else { return(false); } } else if (objPartComplend.pc_situac == "I" || objPartComplend.pc_situac == "") { string post = acertaXmlNovo(cgc, objPartComplend.pc_nome, objPartComplend.pc_nome, objPartComplend.pc_uf, "BRASIL", objPartComplend.pc_cida, objPartComplend.pc_bairro, objPartComplend.pc_ende, objPartComplend.pc_nr, objPartComplend.pc_compl, objPartComplend.pc_cep, objPartComplend.pc_fone.Trim(), objPartComplend.pc_fone.Trim(), objPartComplend.pc_email); if (sincronizaApp(token, "serviceLocal", post)) { if (attSituac(sql, con)) { return(true); } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } } else { //PARTICIP CL_Particip objParticip = new CL_Particip(); objParticip = NG_Particip.buscaParticip(clicod.ToString(), con); if (objParticip != null) { cgc = cgc = objParticip.p_cgc.Replace(".", "").Replace("/", "").Replace("-", ""); sql = "UPDATE particip SET p_situac='S' WHERE p_cod=" + objParticip.p_clicod; if (objParticip.p_situac == "S") { return(true); } else if (objParticip.p_situac == "A") { string post = acertaXmlAlterar(objParticip.p_nome, objParticip.p_fantas, objParticip.p_est, objParticip.p_pais, objParticip.p_cida, objParticip.p_bairro, objParticip.p_ende, objParticip.p_nr, objParticip.p_comend, objParticip.p_cep, objParticip.p_celul, objParticip.p_fone, objParticip.p_email); if (attDadosApp(token, "serviceLocal", post, cgc)) { if (attSituac(sql, con)) { return(true); } else { return(false); } } else { return(false); } } else if (objParticip.p_situac == "I" || objParticip.p_situac == "") { string post = acertaXmlNovo(cgc, objParticip.p_nome, objParticip.p_fantas, objParticip.p_est, objParticip.p_pais, objParticip.p_cida, objParticip.p_bairro, objParticip.p_ende, objParticip.p_nr, objParticip.p_comend, objParticip.p_cep, objParticip.p_celul, objParticip.p_fone, objParticip.p_email); if (sincronizaApp(token, "serviceLocal", post)) { if (attSituac(sql, con)) { return(true); } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } } } catch (Exception ex) { ex.ToString(); return(false); } }
public static CL_Partcomplende buscaPartComplende(string codigo, string con) { DB_Funcoes.DesmontaConexao(con); CONEXAO = montaDAO(CONEXAO); Conn = new NpgsqlConnection(CONEXAO); string sql = "SELECT * FROM part_compl WHERE pc_codigo=@codigo"; NpgsqlCommand comand = new NpgsqlCommand(sql, Conn); NpgsqlDataReader dr; comand.Parameters.AddWithValue("codigo", codigo); CL_Partcomplende objPartComplende = new CL_Partcomplende(); try { Conn.Open(); dr = comand.ExecuteReader(); if (dr.HasRows) { if (dr.Read()) { objPartComplende.pc_codigo = Convert.ToInt32(codigo); objPartComplende.pc_codpart = Convert.ToInt32(dr["pc_codpart"]); objPartComplende.pc_nome = dr["pc_nome"].ToString().Trim(); objPartComplende.pc_cnpj = dr["pc_cnpj"].ToString().Trim(); objPartComplende.pc_ende = dr["pc_ende"].ToString().Trim(); objPartComplende.pc_nr = dr["pc_nr"].ToString().Trim(); objPartComplende.pc_compl = dr["pc_compl"].ToString().Trim(); objPartComplende.pc_bairro = dr["pc_bairro"].ToString().Trim(); objPartComplende.pc_ibge = dr["pc_ibge"].ToString().Trim(); objPartComplende.pc_cida = dr["pc_cida"].ToString().Trim(); objPartComplende.pc_uf = dr["pc_uf"].ToString().Trim(); objPartComplende.pc_respons = dr["pc_respons"].ToString().Trim(); objPartComplende.pc_matric = dr["pc_matric"].ToString().Trim(); objPartComplende.pc_email = dr["pc_email"].ToString().Trim(); objPartComplende.pc_fone = dr["pc_fone"].ToString().Trim(); objPartComplende.pc_cep = dr["pc_cep"].ToString().Trim(); objPartComplende.pc_iest = dr["pc_iest"].ToString().Trim(); objPartComplende.pc_ativo = dr["pc_ativo"].ToString().Trim(); objPartComplende.pc_situac = dr["pc_situac"].ToString().Trim(); return(objPartComplende); } else { objPartComplende = null; return(objPartComplende); } } else { objPartComplende = null; return(objPartComplende); } } catch (Exception ex) { ex.ToString(); objPartComplende = null; return(objPartComplende); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
public static bool excluiPartComplende(CL_Partcomplende objPartComplende, string con) { return(DB_Partcomplende.excluiPartComplende(objPartComplende, con)); }
public static bool alteraPartComplende(CL_Partcomplende objPartComplende, string con) { return(DB_Partcomplende.alteraPartComplende(objPartComplende, con)); }