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