public List <Concepto> Concepto_Obtener(enum_Proposito proposito)
{
try
{
return(InformeNegocio.Concepto_Obtener(proposito));
}
catch (Exception err)
{
log.Error(string.Format("{0} - Error:{1}->{2}", System.Reflection.MethodBase.GetCurrentMethod().Name, err.Source, err.Message));
return(null);
}
}
public static List <Concepto> Concepto_Obtener(enum_Proposito proposito)
{
SqlConnection oCnn = new SqlConnection();
SqlCommand oCmd = new SqlCommand();
List <Concepto> conceptos = new List <Concepto>();
try
{
oCnn = Conexion.ObtenerConnexionSQL();
oCmd.CommandText = "MensualesYConceptosObtener";
oCnn.Open();
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Add(new SqlParameter("@Proposito", proposito));
oCmd.Connection = oCnn;
using (SqlDataReader dr = oCmd.ExecuteReader())
{
dr.NextResult();
while (dr.Read())
{
conceptos.Add(obtenerEntidadConcepto(dr));
}
}
return(conceptos);
}
catch (Exception err)
{
throw (err);
}
finally
{
if (oCnn.State != ConnectionState.Closed)
{
oCnn.Close();
}
oCnn.Dispose();
oCmd.Dispose();
}
}