protected void LoadList(ref List <T> targetList, string storedProcedure, Parameters parameters)
{
List <Record> recordSet = null;
recordSet = DtAccess.ExecuteQuery(ConnectionString, storedProcedure, parameters);
targetList.AddRange(recordSet.Exists(r => r.Result > 0) ? GetEntitiesFromRecords(recordSet) : recordSet.Select(FromRecord));
}
public void UpdateMovimentosAnalisados(List <Movimento> movimentos)
{
foreach (var movimento in movimentos)
{
Parameters parameters = new Parameters();
parameters.Add(new DataElement("IdMov", movimento.IdMov));
DtAccess.ExecuteNonQuery(ConnectionString, USP_SET_MOVIMENTO_ANALISADO, parameters);
}
}
protected void StoreList(List <T> sourceList, string storedProcedure)
{
foreach (T entity in sourceList)
{
Parameters completeParams = new Parameters();
Record entityRecord = ToRecord(entity);
completeParams.AddRange(entityRecord);
DtAccess.ExecuteNonQuery(ConnectionString, storedProcedure, completeParams);
}
}
protected T LoadSingle(string storedProcedure, Parameters parameters)
{
List <Record> recordSet = null;
recordSet = DtAccess.ExecuteQuery(ConnectionString, storedProcedure, parameters);
if (recordSet.Count > 0)
{
if (recordSet.Exists(r => r.Result > 0))
{
return(GetEntityFromRecords(recordSet));
}
return(FromRecord(recordSet[0]));
}
return(null);
}
