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