Ejemplo n.º 1
0
        public void InsertRow()
        {
            ThisDTO oThisDTO = populateDTO();

            //                        TableName  ColNames(csv)  DTO             Insert into DTO Method
            SqlFunctions.DALInsertRow(TableName, TableColumns, oThisDTO, populate_ocValuesForInsert, _ConnectionString);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
0
        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);
        }
Ejemplo n.º 4
0
 public void RefreshRow(int NumOfMatchups)
 {
     deleteDailySummary();
     //                            TableName     ColNames (csv)     DTO                     Insert into DTO Method
     SqlFunctions.DALInsertRow(DailySummaryTable, ColumnNames, populateDTO(NumOfMatchups), populateoDailySummaryValuesForInsert, _ConnectionString);
 }
Ejemplo n.º 5
0
 public void InsertRow(AdjustmentsDailyDTO oAdjustmentsDailyDTO)
 {
     SqlFunctions.DALInsertRow(TableName, ColumnNames, oAdjustmentsDailyDTO, populateDTO, _ConnectionString);
 }