public MasterBCA getListMasterBCAbyidhijo(Int32 id_solicitud) { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SP_R_GetMAsterBCAbyid"; SqlParameter oParam = cmd.Parameters.AddWithValue("@id_solicitud", id_solicitud); SqlDataReader reader = cmd.ExecuteReader(); MasterBCA mMasterBCA = new MasterBCA(); if (reader.Read()) { mMasterBCA.Id_solicitud = Convert.ToInt32(reader["id_solicitud"]); mMasterBCA.Id_interno = reader["n_interno"].ToString(); //mMasterBCA.Id_credito = Convert.ToInt32(reader["id_hijo"]); mMasterBCA.Id_credito = Convert.ToInt32(reader["id_credito"]); } else { mMasterBCA = null; } return(mMasterBCA); } } catch (Exception ex) { throw ex; } }
public List <MasterBCA> getListMasterBCAall() { try { using (SqlConnection sqlConn = new SqlConnection(this.strConn)) { sqlConn.Open(); SqlCommand cmd = new SqlCommand(strConn, sqlConn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SP_R_GetMAsterBCAall"; SqlDataReader reader = cmd.ExecuteReader(); List <MasterBCA> lBCA = new List <MasterBCA>(); while (reader.Read()) { MasterBCA mMasterBCA = new MasterBCA(); mMasterBCA.Id_solicitud = Convert.ToInt32(reader["id_solicitud"]); mMasterBCA.Id_interno = reader["n_interno"].ToString(); mMasterBCA.Id_credito = Convert.ToInt32(reader["id_credito"]); lBCA.Add(mMasterBCA); } return(lBCA); } } catch (Exception ex) { throw ex; } }