public static DateTime GetMaxGameDate(string ConnectionString, string LeagueName, string TableName, DateTime DefaultDate) { string strSql = $"Select IsNull( Max(GameDate), '{DefaultDate}') AS GameDate From {TableName} Where LeagueName = '{LeagueName}'"; DateTime GameDate = (DateTime)DALfunctions.ExecuteSqlQueryReturnSingleParm(ConnectionString, strSql, "GameDate"); return(GameDate); }
public static string TeamLookupTeamNameByTeamNameInDatabase(DateTime StartDate, string LeagueName, string TeamSource, string TeamNameInDatabase) { List <string> SqlParmNames = new List <string>(); List <object> SqlParmValues = new List <object>(); SqlParmNames.Add("@StartDate"); SqlParmValues.Add(StartDate); SqlParmNames.Add("@LeagueName"); SqlParmValues.Add(LeagueName); SqlParmNames.Add("@TeamSource"); SqlParmValues.Add(TeamSource); SqlParmNames.Add("@TeamNameInDatabase"); SqlParmValues.Add(TeamNameInDatabase); string StoredProcedureName = "TeamLookupTeamNameByTeamNameInDatabase"; string ConnectionString = GetConnectionString( ); string s = DALfunctions.ExecuteStoredProcedureQueryReturnSingleParm(ConnectionString, StoredProcedureName, SqlParmNames, SqlParmValues); if (String.IsNullOrEmpty(s)) { throw new Exception($"TeamLoop Exception - {StartDate} - {LeagueName} - TeamSource: {TeamSource} - Team: {TeamNameInDatabase}"); } return(s); }
public static string TeamLookupSourceToSource(DateTime StartDate, string LeagueName, string TeamSourceFrom, string TeamSourceTo, string TeamName) { List <string> SqlParmNames = new List <string>(); List <object> SqlParmValues = new List <object>(); SqlParmNames.Add("@StartDate"); SqlParmValues.Add(StartDate); SqlParmNames.Add("@LeagueName"); SqlParmValues.Add(LeagueName); SqlParmNames.Add("@TeamSourceFrom"); SqlParmValues.Add(TeamSourceFrom); SqlParmNames.Add("@TeamSourceTo"); SqlParmValues.Add(TeamSourceTo); SqlParmNames.Add("@TeamName"); SqlParmValues.Add(TeamName); string StoredProcedureName = "TeamLookupSourceToSource"; string ConnectionString = GetConnectionString(); string s = DALfunctions.ExecuteStoredProcedureQueryReturnSingleParm(ConnectionString, StoredProcedureName, SqlParmNames, SqlParmValues); return(s); }