private void populateSeasonInfoDTO() { int rows = SysDAL.DALfunctions.ExecuteSqlQuery(SqlFunctions.GetConnectionString(), SeasonInfoRowSql() , null, oSeasonInfoDTO, PopulateDTO); if (rows == 0) { throw new Exception($"SeasonInfo row not found - League: {_LeagueName} GameDate: {GameDate}"); } }
//public static int LoadBoxscore(CoversBoxscore oCoversBoxscore, SeasonInfoDTO oSeasonInfoDTO) //{ // return 0; //} static void InsertRowPrep(string TableName, string ColumnNames, object DTO, PopulateDTOValues delPopulateDTOValues) { List <string> ocColumns = ColumnNames.Split(',').OfType <string>().ToList(); List <string> ocValues = new List <string>(); delPopulateDTOValues(ocValues, DTO); // Execute Delegate string ConnectionString = SqlFunctions.GetConnectionString(); string SQL = SysDAL.DALfunctions.GenSql(TableName, ocColumns); int rc = SysDAL.DALfunctions.InsertRow(ConnectionString, SQL, ocColumns, ocValues); }
private void deleteDailySummary() { string strSql = $"DELETE From {DailySummaryTable} Where LeagueName = '{_oLeagueDTO.LeagueName}' AND GameDate = '{_GameDate.ToShortDateString()}'"; int rows = SysDAL.DALfunctions.ExecuteSqlNonQuery(SqlFunctions.GetConnectionString(), strSql); }
public static void DeleteRestOfRotation(DateTime GameDate, string LeagueName) { string strSql = $"DELETE From {RotationTable} Where LeagueName = '{LeagueName}' AND GameDate >= '{GameDate.ToShortDateString()}'"; int rows = SysDAL.DALfunctions.ExecuteSqlNonQuery(SqlFunctions.GetConnectionString(), strSql); }
public void DeleteDailyAdjustments(DateTime GameDate, string LeagueName) { string strSql = $"DELETE From {TableName} Where LeagueName = '{LeagueName}' AND GameDate = '{GameDate.ToShortDateString()}'"; int rows = SysDAL.DALfunctions.ExecuteSqlNonQuery(SqlFunctions.GetConnectionString(), strSql); }