/// <summary>
///
/// </summary>
/// <param name="oTipoValorFilter"></param>
/// <returns></returns>
public List <TipoValor> GetValoresByFilter(TipoValorFilter oTipoValorFilter)
{
using (ValoresDataAccess oValoresDataAccess = new ValoresDataAccess())
{
DataSet ds = oValoresDataAccess.GetListByFilter(oTipoValorFilter);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(TipoValor.GetFromDS(ds));
}
}
return(null);
}
/// <summary>
///
/// </summary>
/// <param name="oValor"></param>
/// <returns></returns>
public DataSet GetListByFilter(TipoValorFilter oTipoValorFilter)
{
// Creo la conexión y la transacción
SqlConnection oConn = new SqlConnection(ConfigurationManager.ConnectionStrings["CONEXION"].ConnectionString);
oConn.Open();
SqlTransaction oTran = oConn.BeginTransaction();
DataSet ds = new DataSet();
try
{
using (SqlDataAdapter adapter = new SqlDataAdapter())
{
using (SqlCommand oComm = new SqlCommand())
{
oComm.Connection = (oTran != null) ? oTran.Connection : oConn;
oComm.Transaction = oTran;
oComm.CommandType = CommandType.StoredProcedure;
oComm.CommandText = ObjectName + "_GetListByFilter";
oComm.Parameters.Add(new SqlParameter("@Valor", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Original, oTipoValorFilter.Valor));
oComm.Parameters.Add(new SqlParameter("@Campo", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Original, oTipoValorFilter.Campo));
oComm.Parameters.Add(new SqlParameter("@Descripcion", SqlDbType.NVarChar, 200, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Original, oTipoValorFilter.Descripcion));
oComm.Parameters.Add(new SqlParameter("@ClaveEntidad", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Original, oTipoValorFilter.ClaveEntidad));
adapter.SelectCommand = oComm;
adapter.Fill(ds);
}
}
}
catch (Exception e)
{
oTran.Rollback();
throw e;
}
finally
{
oConn.Close();
oTran.Dispose();
}
return(ds);
}
public List <TipoValor> GetValoresByFilter(string campo, string valor, string descripcion, string claveEntidad)
{
try
{
TipoValorFilter oTipoValorFilter = new TipoValorFilter()
{
Campo = campo,
ClaveEntidad = claveEntidad,
Valor = valor,
Descripcion = descripcion
};
using (ValoresBusiness oValoresBusiness = new ValoresBusiness())
{
return(oValoresBusiness.GetValoresByFilter(oTipoValorFilter));
}
}
catch (Exception)
{
return(null);
}
}
