public static int DeleteAthleteTeamChamptionships(int Championship_ID, int Athlete_ID, CSDB Context)
{
string cmd = string.Format("DELETE FROM [AthleteTeamChamptionships] WHERE [Championship_ID] = {0} AND [Athlete_ID] = {1}", Championship_ID, Athlete_ID);
return(Context.ExecuteCommand(cmd));
}
public static int CleanUpCustomData(CSDB Context)
{
return(Context.ExecuteCommand("DELETE FROM[CustomDataValues] WHERE ( [Championship_ID] IS NULL ) AND ( [Competitor_ID] IS NULL ) AND ( [Event_ID] IS NULL )"));
}
internal static int DeleteSchoolTeam(int sch, int team, CSDB Context)
{
string cmd = string.Format("DELETE FROM [SchoolTeams] WHERE [School_ID] = {0} AND [Team_ID] = {1}", sch, team);
return(Context.ExecuteCommand(cmd));
}