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