public List <Corresponsales> ListarCorresponsales()
{
string strQuery = "EXEC ListarCorresponsales";
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlCommand cmd = new SqlCommand(strQuery, conn);
SqlDataReader read = cmd.ExecuteReader();
List <Corresponsales> corresponsales = new List <Corresponsales>();
if (read.HasRows)
{
while (read.Read())
{
Corresponsales cor = new Corresponsales()
{
idCorresponsales = Convert.ToInt32(read["COR_CORRESPONSAL_ID"]),
nombreCoresponsal = read["COR_NOMBRE"].ToString(),
nroOficina = Convert.ToInt32(read["COR_NRO_OFI"])
};
corresponsales.Add(cor);
}
}
return(corresponsales);
}
}
public Corresponsales ObtenerCaracteresOficinas(int idCorresponsal)
{
try
{
string strQuery = "ContarCaracteres" + idCorresponsal.ToString();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlCommand cmd = new SqlCommand(strQuery, conn);
SqlDataReader read = cmd.ExecuteReader();
read.Read();
Corresponsales cor = new Corresponsales()
{
idCorresponsales = Convert.ToInt32(read["COR_CORRESPONSAL_ID"]),
nombreCoresponsal = read["COR_NOMBRE"].ToString(),
nombreOficina = read["OFI_NOMBRE"].ToString()
};
return(cor);
}
}
catch
{
return(null);
}
}
public string ObtenerCaracteresOficinas(int idCorresponsal)
{
ConexionBaseDatosClient cliente = new ConexionBaseDatosClient();
Corresponsales cor = cliente.ObtenerCaracteresOficinas(idCorresponsal);
lblCorresponsal.Text = cor.nombreCoresponsal;
lblOficina.Text = cor.nombreOficina;
}