public void InsertRow() { ThisDTO oThisDTO = populateDTO(); // TableName ColNames(csv) DTO Insert into DTO Method SqlFunctions.DALInsertRow(TableName, TableColumns, oThisDTO, populate_ocValuesForInsert, _ConnectionString); }
public void InsertRow() { List <string> ocValues = new List <string>(); LinesDTO oLinesDTO = populateDTO(); populate_ocValuesForInsert(ocValues, oLinesDTO); // TableName ColNames(csv) DTO Insert into DTO Method SqlFunctions.DALInsertRow(TableName, TableColumns, ocValues, _ConnectionString); }
private void writeAdjustment(Row oAdjRow) { AdjustmentDTO oAdjustmentDTO = new AdjustmentDTO() { LeagueName = _oLeagueDTO.LeagueName , StartDate = _GameDate , EndDate = _GameDate , Team = oAdjRow.Team , AdjustmentType = oAdjRow.Type , AdjustmentAmount = oAdjRow.AdjAmt , Player = oAdjRow.Player , Description = oAdjRow.Desc , TS = (string.IsNullOrEmpty(oAdjRow.TS) ? _GameDate : Convert.ToDateTime(oAdjRow.TS)) }; // TableName ColNames (csv) DTO Insert DTO into ocValues Method SqlFunctions.DALInsertRow(TableName, TableColumns, oAdjustmentDTO, populate_ocValuesForInsert, _ConnectionString); }
public void RefreshRow(int NumOfMatchups) { deleteDailySummary(); // TableName ColNames (csv) DTO Insert into DTO Method SqlFunctions.DALInsertRow(DailySummaryTable, ColumnNames, populateDTO(NumOfMatchups), populateoDailySummaryValuesForInsert, _ConnectionString); }
public void InsertRow(AdjustmentsDailyDTO oAdjustmentsDailyDTO) { SqlFunctions.DALInsertRow(TableName, ColumnNames, oAdjustmentsDailyDTO, populateDTO, _ConnectionString); }