public static CL_Visita buscaVisitaIDUmov(int idUmov, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "SELECT v_lcto, v_clicod, p_nome, v_idumov, con_nome, v_hist1, v_desc " +
"FROM visitas, convenio, particip WHERE v_idumov=@v_idumov AND p_cod=v_clicod AND v_vend=con_cod ORDER BY v_lcto";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("v_idumov", idUmov);
NpgsqlDataReader dr;
CL_Visita obj = new CL_Visita();
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
if (dr.Read())
{
obj.v_lcto = Convert.ToInt32(dr["v_lcto"]);
obj.v_clicod = Convert.ToInt32(dr["v_clicod"]);
obj.v_clinome = dr["p_nome"].ToString().Trim();
obj.v_idumov = idUmov;
obj.v_vendnom = dr["con_nome"].ToString().Trim();
obj.v_hist1 = dr["v_hist1"].ToString().Trim();
obj.v_desc = dr["v_desc"].ToString().Trim();
return(obj);
}
else
{
obj = null;
return(obj);
}
}
else
{
obj = null;
return(obj);
}
}
catch (Exception ex)
{
ex.ToString();
obj = null;
return(obj);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static List <CL_Visita> pesqVisita(string sql, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
List <CL_Visita> objList = new List <CL_Visita>();
CL_Visita objVisita = null;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
objVisita = new CL_Visita();
objVisita.v_lcto = Convert.ToInt32(dr["v_lcto"]);
objVisita.v_clicod = Convert.ToInt32(dr["v_clicod"]);
objVisita.v_clinome = dr["p_nome"].ToString().Trim();
objVisita.v_ultvisit = Convert.ToDateTime(dr["v_ultvisit"]);
objVisita.v_vend = Convert.ToInt32(dr["v_vend"]);
objVisita.v_vendnom = dr["con_nome"].ToString().Trim();
objVisita.v_desc = dr["v_desc"].ToString().Trim();
objVisita.v_prxvis = Convert.ToDateTime(dr["v_prxvis"]);
objVisita.v_hist1 = dr["v_hist1"].ToString().Trim();
objVisita.v_idumov = Convert.ToInt64(dr["v_idumov"]);
objVisita.v_situac = dr["v_situac"].ToString().Trim();
objVisita.v_cnpj = dr["p_cgc"].ToString().Trim();
objList.Add(objVisita);
}
dr.Close();
return(objList);
}
else
{
objList = null;
return(objList);
}
}
catch (Exception ex)
{
ex.ToString();
objList = null;
return(objList);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool incluiVisita(CL_Visita objVisita, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
try
{
string sql = "INSERT INTO visitas (v_lcto, v_clicod, v_cnpj, v_desc, v_hist1, v_prxvis, v_ultvisit, v_vend, v_idumov, v_situac, v_foto, v_assina) " +
"VALUES " +
"(@v_lcto, @v_clicod, @v_cnpj, @v_desc, @v_hist1, @v_prxvis, @v_ultvisit, @v_vend, @v_idumov, @v_situac, @v_foto, @v_assina)";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("v_lcto", objVisita.v_lcto);
comand.Parameters.AddWithValue("v_clicod", objVisita.v_clicod);
comand.Parameters.AddWithValue("v_cnpj", objVisita.v_cnpj);
comand.Parameters.AddWithValue("v_desc", objVisita.v_desc);
comand.Parameters.AddWithValue("v_hist1", objVisita.v_hist1);
comand.Parameters.AddWithValue("v_prxvis", objVisita.v_prxvis.ToShortDateString());
comand.Parameters.AddWithValue("v_ultvisit", objVisita.v_ultvisit.ToShortDateString());
comand.Parameters.AddWithValue("v_vend", objVisita.v_vend);
comand.Parameters.AddWithValue("v_idumov", objVisita.v_idumov);
comand.Parameters.AddWithValue("v_situac", objVisita.v_situac);
comand.Parameters.AddWithValue("v_foto", objVisita.v_foto);
comand.Parameters.AddWithValue("v_assina", objVisita.v_assina);
Conn.Open();
comand.ExecuteScalar();
return(true);
}
catch (Exception ex)
{
ex.ToString();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool incluiVisita(CL_Visita objVisita, string con)
{
return(DB_Visita.incluiVisita(objVisita, con));
}
