/// <summary>
/// Retorna objeto somente pela PK
/// </summary>
/// <param name="pDto">Objeto</param>
public TDto Get(TDto pDto)
{
DBExecution _execution = DBExecution.NewConstructor();
DBParameter _parameter = DBParameter.NewConstructor();
try
{
this.FillParameters(ref pDto, ref _parameter, ExecutionTypes.Get);
var _dataSet = _execution.ExecuteDataSet(_parameter.Parameter, CommandType.StoredProcedure, this.CommandGet);
if (_dataSet != null && _dataSet.Tables[0].Rows.Count > 0)
{
return(this.Convert(_dataSet.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
catch (Exception ex)
{
if (ex is Exception)
{
throw;
}
else
{
throw new Exception(this.ErrorMessageGet);
}
}
finally { _execution.Dispose(); }
}
/// <summary>
/// Retorna objeto aplicando os filtros informados
/// </summary>
/// <param name="pDto">Objeto</param>
public List <TDto> GetByParameters(TDto pDto)
{
DBExecution _execution = DBExecution.NewConstructor();
DBParameter _parameter = DBParameter.NewConstructor();
try
{
this.FillParameters(ref pDto, ref _parameter, ExecutionTypes.GetByParameters);
var _objDataSet = _execution.ExecuteDataSet(_parameter.Parameter, CommandType.StoredProcedure, this.CommandGetByParameters);
if (_objDataSet != null && _objDataSet.Tables[0].Rows.Count > 0)
{
var _resultSet = new List <TDto>();
foreach (DataRow _objDataRow in _objDataSet.Tables[0].Rows)
{
_resultSet.Add(this.Convert(_objDataRow));
}
return(_resultSet);
}
else
{
return(new List <TDto>());
}
}
catch (Exception ex)
{
if (ex is Exception)
{
throw;
}
else
{
throw new Exception(this.ErrorMessageGetByParameters);
}
}
finally { _execution.Dispose(); }
}
