public static bool excluiParticip(CL_Particip objParticip, string con)
{
string sql = "DELETE FROM particip WHERE p_cod =" + objParticip.p_clicod;
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
try
{
Conn.Open();
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.ExecuteScalar();
return(true);
}
catch (Exception ex)
{
ex.ToString();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool alteraParticip(CL_Particip objParticip, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
try
{
string sql = "UPDATE particip SET p_cliente=@p_cliente, p_fornec=@p_fornec, p_transp=@p_transp, p_cgc=@p_cgc, p_nome=@p_nome, " +
"p_fantas=@p_fantas, p_cep=@p_cep, p_ende=@p_ende, p_nr=@p_nr, p_comend=@p_comend, p_bairro=@p_bairro, p_cida=@p_cida, " +
"p_est=@p_est, p_pais=@p_pais, p_ibge=@p_ibge, p_fone=@p_fone, p_contat=@p_contat, p_iest=@p_iest, p_celul=@p_celul, " +
"p_email=@p_email, p_situac=@p_situac, p_localiz=@p_localiz, p_cult=@p_cult, p_nasc=@p_nasc, p_ident=@p_ident " +
"WHERE p_cod=@p_cod";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("p_cod", objParticip.p_clicod);
comand.Parameters.AddWithValue("p_cliente", objParticip.p_cliente);
comand.Parameters.AddWithValue("p_fornec", objParticip.p_fornec);
comand.Parameters.AddWithValue("p_transp", objParticip.p_transp);
comand.Parameters.AddWithValue("p_cgc", objParticip.p_cgc);
comand.Parameters.AddWithValue("p_nome", objParticip.p_nome);
comand.Parameters.AddWithValue("p_fantas", objParticip.p_fantas);
comand.Parameters.AddWithValue("p_cep", objParticip.p_cep);
comand.Parameters.AddWithValue("p_ende", objParticip.p_ende);
comand.Parameters.AddWithValue("p_nr", objParticip.p_nr);
comand.Parameters.AddWithValue("p_comend", objParticip.p_comend);
comand.Parameters.AddWithValue("p_bairro", objParticip.p_bairro);
comand.Parameters.AddWithValue("p_cida", objParticip.p_cida);
comand.Parameters.AddWithValue("p_est", objParticip.p_est);
comand.Parameters.AddWithValue("p_pais", objParticip.p_pais);
comand.Parameters.AddWithValue("p_ibge", objParticip.p_ibge);
comand.Parameters.AddWithValue("p_fone", objParticip.p_fone);
comand.Parameters.AddWithValue("p_contat", objParticip.p_contat);
comand.Parameters.AddWithValue("p_iest", objParticip.p_iest);
comand.Parameters.AddWithValue("p_celul", objParticip.p_celul);
comand.Parameters.AddWithValue("p_email", objParticip.p_email);
comand.Parameters.AddWithValue("p_situac", objParticip.p_situac);
comand.Parameters.AddWithValue("p_localiz", objParticip.p_localiz);
comand.Parameters.AddWithValue("p_cult", objParticip.p_cultura);
comand.Parameters.AddWithValue("p_ident", objParticip.p_rg);
comand.Parameters.AddWithValue("p_nasc", objParticip.p_nasc.ToShortDateString());
Conn.Open();
comand.ExecuteScalar();
return(true);
}
catch (Exception ex)
{
ex.ToString();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool incluiParticip(CL_Particip objParticip, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
try
{
string sql = "INSERT INTO particip (p_cliente, p_fornec, p_transp, p_cgc, p_nome, p_fantas, p_cep, p_ende, p_nr, p_comend, p_bairro, p_cida, p_est, p_pais, p_ibge, p_fone, p_contat, p_iest, p_celul, p_email, p_situac, p_localiz, p_cult, p_ident, p_nasc) " +
"VALUES (@p_cliente, @p_fornec, @p_transp, @p_cgc, @p_nome, @p_fantas, @p_cep, @p_ende, @p_nr, @p_comend, @p_bairro, @p_cida, @p_est, @p_pais, @p_ibge, @p_fone, @p_contat, @p_iest, @p_celul, @p_email, @p_situac, @p_localiz, @p_cult, @p_ident, @p_nasc)";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("p_cliente", objParticip.p_cliente);
comand.Parameters.AddWithValue("p_fornec", objParticip.p_fornec);
comand.Parameters.AddWithValue("p_transp", objParticip.p_transp);
comand.Parameters.AddWithValue("p_cgc", objParticip.p_cgc);
comand.Parameters.AddWithValue("p_nome", objParticip.p_nome);
comand.Parameters.AddWithValue("p_fantas", objParticip.p_fantas);
comand.Parameters.AddWithValue("p_cep", objParticip.p_cep);
comand.Parameters.AddWithValue("p_ende", objParticip.p_ende);
comand.Parameters.AddWithValue("p_nr", objParticip.p_nr);
comand.Parameters.AddWithValue("p_comend", objParticip.p_comend);
comand.Parameters.AddWithValue("p_bairro", objParticip.p_bairro);
comand.Parameters.AddWithValue("p_cida", objParticip.p_cida);
comand.Parameters.AddWithValue("p_est", objParticip.p_est);
comand.Parameters.AddWithValue("p_pais", objParticip.p_pais);
comand.Parameters.AddWithValue("p_ibge", objParticip.p_ibge);
comand.Parameters.AddWithValue("p_fone", objParticip.p_fone);
comand.Parameters.AddWithValue("p_contat", objParticip.p_contat);
comand.Parameters.AddWithValue("p_iest", objParticip.p_iest);
comand.Parameters.AddWithValue("p_celul", objParticip.p_celul);
comand.Parameters.AddWithValue("p_email", objParticip.p_email);
comand.Parameters.AddWithValue("p_situac", objParticip.p_situac);
comand.Parameters.AddWithValue("p_localiz", objParticip.p_localiz);
comand.Parameters.AddWithValue("p_cult", objParticip.p_cultura);
comand.Parameters.AddWithValue("p_ident", objParticip.p_rg);
comand.Parameters.AddWithValue("p_nasc", objParticip.p_nasc.ToShortDateString());
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 bool cadParticipUmov(CL_Particip objParticip, CL_Empresa objEmpresa, string con)
{
WebRequest request = WebRequest.Create("https://api.umov.me/CenterWeb/api/" + objEmpresa.emp_token + "/serviceLocal.xml");
request.Method = "POST";
string postData = "data=" +
"<serviceLocal>" +
"<description>" + objParticip.p_nome + "</description>" +
"<active>true</active>" +
"<alternativeIdentifier>" + objParticip.p_cgc.Replace(".", "").Replace("/", "").Replace("-", "") + "</alternativeIdentifier>" +
"<corporateName>" + objParticip.p_fantas + "</corporateName>" +
"<country>" + objParticip.trocaPais(objParticip.p_pais) + "</country>" +
"<state>" + objParticip.p_est + "</state>" +
"<city>" + objParticip.p_cida + "</city>" +
"<cityNeighborhood>" + objParticip.p_bairro + "</cityNeighborhood>" +
"<streetType></streetType>" +
"<street>" + objParticip.p_ende + "</street>" +
"<streetNumber>" + objParticip.trocaNum(objParticip.p_nr).Trim() + "</streetNumber>" +
"<streetComplement>" + objParticip.p_comend + "</streetComplement>" +
"<zipCode>" + objParticip.p_cep.Trim() + "</zipCode>" +
"<cellphoneStd></cellphoneStd>" +
"<cellphoneNumber>" + objParticip.acertaTel(objParticip.p_celul) + "</cellphoneNumber>" +
"<phoneStd></phoneStd>" +
"<phoneNumber>" + objParticip.acertaTel(objParticip.p_fone) + "</phoneNumber>" +
"<email>" + objParticip.p_email + "</email>" +
"<observation></observation>";
if (objParticip.p_localiz != "")
{
postData = postData + "<geoCoordinate>" + objParticip.p_localiz + "</geoCoordinate>";
}
postData = postData + "<exportStatus>0</exportStatus></serviceLocal>";
byte[] byteArray = Encoding.UTF8.GetBytes(postData);
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = byteArray.Length;
Stream dataStream = request.GetRequestStream();
dataStream.Write(byteArray, 0, byteArray.Length);
dataStream.Close();
WebResponse response = request.GetResponse();
dataStream = response.GetResponseStream();
StreamReader reader = new StreamReader(dataStream);
if ((((HttpWebResponse)response).StatusDescription) == "Created")
{
try
{
reader.Close();
dataStream.Close();
response.Close();
return(true);
}
catch (Exception ex)
{
ex.ToString();
return(false);
}
}
else
{
return(false);
}
}
public static bool alteraParticip(CL_Particip objParticip, string con)
{
return(DB_Particip.alteraParticip(objParticip, con));
}
public static bool excluiParticip(CL_Particip objParticip, string con)
{
return(DB_Particip.excluiParticip(objParticip, con));
}
public List <CL_Particip> listar(string pesquisa, string con, string filtroPesq)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "";
List <CL_Particip> objList = new List <CL_Particip>();
CL_Particip objParticip = null;
if (pesquisa == "")
{
sql = "SELECT * FROM particip ORDER BY p_cod";
if (filtroPesq == "APP")
{
sql = "SELECT * FROM particip ORDER BY p_cod";
}
}
else
{
if (filtroPesq == "1")//FILTRO PESQ PARTICIP COD
{
sql = "SELECT * FROM particip WHERE p_cod = '" + pesquisa + "' ORDER BY p_cod";
}
else if (filtroPesq == "2")//FILTRO PESQ PARTICIP NOME
{
sql = "SELECT * FROM particip WHERE p_nome LIKE '%" + pesquisa + "%' ORDER BY p_cod";
}
else if (filtroPesq == "3")//FILTRO PESQ PARTICIP CGC
{
sql = "SELECT * FROM particip WHERE p_cgc = '" + pesquisa + "' ORDER BY p_cod";
}
else if (filtroPesq == "4")//FILTRO CIDADE
{
sql = "SELECT * FROM particip WHERE p_cida = '" + pesquisa + "' ORDER BY p_cod";
}
else if (filtroPesq == "5")//FILTRO FANTASIA
{
sql = "SELECT * FROM particip WHERE p_fantas = '" + pesquisa + "' ORDER BY p_cod";
}
else
{
sql = "SELECT * FROM particip ORDER BY p_cod";
}
}
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
//instancio objeto cliente a cada item da lista de registos
objParticip = new CL_Particip();
//leio as informações dos campos e jogo para o objeto
objParticip.p_clicod = Convert.ToInt32(dr["p_cod"]);
objParticip.p_cliente = dr["p_cliente"].ToString().Trim();
objParticip.p_fornec = dr["p_fornec"].ToString().Trim();
objParticip.p_transp = dr["p_transp"].ToString().Trim();
objParticip.p_cgc = dr["p_cgc"].ToString().Trim();
objParticip.p_nome = dr["p_nome"].ToString().Trim();
objParticip.p_fantas = dr["p_fantas"].ToString().Trim();
objParticip.p_cep = dr["p_cep"].ToString().Trim();
objParticip.p_ende = dr["p_ende"].ToString().Trim();
objParticip.p_nr = dr["p_nr"].ToString().Trim();
objParticip.p_comend = dr["p_comend"].ToString().Trim();
objParticip.p_bairro = dr["p_bairro"].ToString().Trim();
objParticip.p_cida = dr["p_cida"].ToString().Trim();
objParticip.p_est = dr["p_est"].ToString().Trim();
objParticip.p_pais = dr["p_pais"].ToString().Trim();
objParticip.p_ibge = dr["p_ibge"].ToString().Trim();
objParticip.p_fone = dr["p_fone"].ToString().Trim();
objParticip.p_contat = dr["p_contat"].ToString().Trim();
objParticip.p_iest = dr["p_iest"].ToString().Trim();
objParticip.p_celul = dr["p_celul"].ToString().Trim();
objParticip.p_email = dr["p_email"].ToString().Trim();
objParticip.p_situac = dr["p_situac"].ToString().Trim();
objParticip.p_localiz = dr["p_localiz"].ToString().Trim();
objParticip.p_ramo = dr["p_ramo"].ToString().Trim();
objParticip.p_lcred = dr["p_lcred"] is DBNull ? 0 : Convert.ToDouble(dr["p_lcred"]);
objParticip.p_cultura = dr["p_cult"].ToString().Trim();
objParticip.p_nasc = dr["p_nasc"] is DBNull?Convert.ToDateTime("01/01/0001") : Convert.ToDateTime(dr["p_nasc"]);
objParticip.p_rg = dr["p_ident"].ToString().Trim();
objParticip.p_codNome = objParticip.p_clicod.ToString() + " - " + objParticip.p_nome;
objList.Add(objParticip);
}
return(objList);
}
else
{
objList = null;
return(objList);
}
}
catch (Exception ex)
{
ex.Message.ToString();
objList = null;
return(objList);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static List <CL_Particip> listarParticipCidade(string cidade, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "SELECT p_cod, p_cgc, p_nome, p_fantas, p_cep, p_ende, p_nr, p_comend, p_bairro, p_cida, p_est, p_pais, p_ibge, p_fone, p_iest, p_situac FROM particip WHERE p_cida='" + cidade + "' AND p_cgc<>'' AND p_cgc<>'.'";
List <CL_Particip> objList = new List <CL_Particip>();
CL_Particip objParticip = null;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
//instancio objeto cliente a cada item da lista de registos
objParticip = new CL_Particip();
//leio as informações dos campos e jogo para o objeto
objParticip.p_clicod = Convert.ToInt32(dr["p_cod"]);
objParticip.p_cgc = dr["p_cgc"].ToString().Trim();
objParticip.p_nome = dr["p_nome"].ToString().Trim();
objParticip.p_fantas = dr["p_fantas"].ToString().Trim();
objParticip.p_cep = dr["p_cep"].ToString().Trim();
objParticip.p_ende = dr["p_ende"].ToString().Trim();
objParticip.p_nr = dr["p_nr"].ToString().Trim();
objParticip.p_comend = dr["p_comend"].ToString().Trim();
objParticip.p_bairro = dr["p_bairro"].ToString().Trim();
objParticip.p_cida = dr["p_cida"].ToString().Trim();
objParticip.p_est = dr["p_est"].ToString().Trim();
objParticip.p_pais = dr["p_pais"].ToString().Trim();
objParticip.p_ibge = dr["p_ibge"].ToString().Trim();
objParticip.p_fone = dr["p_fone"].ToString().Trim();
objParticip.p_iest = dr["p_iest"].ToString().Trim();
objParticip.p_situac = dr["p_situac"].ToString().Trim();
objParticip.p_codNome = objParticip.p_clicod.ToString() + " - " + objParticip.p_nome;
objList.Add(objParticip);
}
return(objList);
}
else
{
objList = null;
return(objList);
}
}
catch (Exception ex)
{
ex.Message.ToString();
objList = null;
return(objList);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static CL_Particip buscarParticip(string p_clicod, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
CL_Particip objParticip = new CL_Particip();
String sql = "SELECT * FROM particip WHERE p_cod =" + p_clicod;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
if (dr.Read())
{
objParticip.p_clicod = Convert.ToInt32(dr["p_cod"]);
objParticip.p_cliente = dr["p_cliente"].ToString().Trim();
objParticip.p_fornec = dr["p_fornec"].ToString().Trim();
objParticip.p_transp = dr["p_transp"].ToString().Trim();
objParticip.p_cgc = dr["p_cgc"].ToString().Trim();
objParticip.p_nome = dr["p_nome"].ToString().Trim();
objParticip.p_fantas = dr["p_fantas"].ToString().Trim();
objParticip.p_cep = dr["p_cep"].ToString().Trim();
objParticip.p_ende = dr["p_ende"].ToString().Trim();
objParticip.p_nr = dr["p_nr"].ToString().Trim();
objParticip.p_comend = dr["p_comend"].ToString().Trim();
objParticip.p_bairro = dr["p_bairro"].ToString().Trim();
objParticip.p_cida = dr["p_cida"].ToString().Trim();
objParticip.p_est = dr["p_est"].ToString().Trim();
objParticip.p_pais = dr["p_pais"].ToString().Trim();
objParticip.p_ibge = dr["p_ibge"].ToString().Trim();
objParticip.p_fone = dr["p_fone"].ToString().Trim();
objParticip.p_contat = dr["p_contat"].ToString().Trim();
objParticip.p_iest = dr["p_iest"].ToString().Trim();
objParticip.p_celul = dr["p_celul"].ToString().Trim();
objParticip.p_email = dr["p_email"].ToString().Trim();
objParticip.p_situac = dr["p_situac"].ToString().Trim();
objParticip.p_localiz = dr["p_localiz"].ToString().Trim();
objParticip.p_ramo = dr["p_ramo"].ToString().Trim();
objParticip.p_lcred = dr["p_lcred"] is DBNull ? 0 : Convert.ToDouble(dr["p_lcred"]);
objParticip.p_cultura = dr["p_cult"].ToString().Trim();
objParticip.p_rg = dr["p_ident"].ToString().Trim();
objParticip.p_nasc = dr["p_nasc"] is DBNull?Convert.ToDateTime("01/01/0001") : Convert.ToDateTime(dr["p_nasc"]);
objParticip.p_codNome = objParticip.p_clicod.ToString() + " - " + objParticip.p_nome;
return(objParticip);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
ex.ToString();
return(null);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static List <CL_Particip> buscaEntregaManual(string particip, string cida, string tipo, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "";
if (particip != "")
{
sql = "SELECT p_cod, p_nome, p_cep, p_ende, p_nr, p_comend, p_bairro, p_cida, p_est, p_pais, p_fone, p_iest, p_situac, p_fantas, p_pais, p_celul, p_fone, p_email" +
" FROM particip WHERE p_cod=@p_cod AND p_ramo=@p_idecli";
}
else
{
sql = "SELECT p_cod, p_nome, p_cep, p_ende, p_nr, p_comend, p_bairro, p_cida, p_est, p_pais, p_fone, p_iest, p_situac, p_fantas, p_pais, p_celul, p_fone, p_email" +
" FROM particip WHERE p_cida=@p_cida AND p_ramo=@p_idecli";
}
List <CL_Particip> objList = new List <CL_Particip>();
CL_Particip objParticip = null;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("p_cod", particip);
comand.Parameters.AddWithValue("p_cida", cida);
comand.Parameters.AddWithValue("p_idecli", tipo);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
objParticip = new CL_Particip();
objParticip.p_clicod = Convert.ToInt32(dr["p_cod"]);
objParticip.p_nome = dr["p_nome"].ToString().Trim();
objParticip.p_cep = dr["p_cep"].ToString().Trim();
objParticip.p_ende = dr["p_ende"].ToString().Trim();
objParticip.p_nr = dr["p_nr"].ToString().Trim();
objParticip.p_comend = dr["p_comend"].ToString().Trim();
objParticip.p_bairro = dr["p_bairro"].ToString().Trim();
objParticip.p_cida = dr["p_cida"].ToString().Trim();
objParticip.p_est = dr["p_est"].ToString().Trim();
objParticip.p_pais = dr["p_pais"].ToString().Trim();
objParticip.p_fone = dr["p_fone"].ToString().Trim();
objParticip.p_situac = dr["p_situac"].ToString().Trim();
objParticip.p_fantas = dr["p_fantas"].ToString().Trim();
objParticip.p_pais = dr["p_pais"].ToString().Trim();
objParticip.p_celul = dr["p_celul"].ToString().Trim();
objParticip.p_fone = dr["p_fone"].ToString().Trim();
objParticip.p_email = dr["p_email"].ToString().Trim();
objList.Add(objParticip);
}
return(objList);
}
else
{
return(objList);
}
}
catch (Exception ex)
{
ex.Message.ToString();
objList = null;
return(objList);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
