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; }