public Match(string matchDesc, string squadDesc, int campaignId) { MatchId = Convert.ToInt32(matchDesc.Substring(matchDesc.IndexOf("#") + 1)); WeekNumber = Convert.ToInt32(squadDesc.Substring(5, squadDesc.IndexOf(":") - 5)); _Campaign = Campaign.GetCampaign(campaignId); Squad.GetSquadsFromDesc(squadDesc, _Campaign, ref AwaySquad, ref HomeSquad); }
public static void GetSquadsFromDesc(string squadDesc, Campaign campaign, ref Squad awaySquad, ref Squad homeSquad) { SqlConnection connSql = new SqlConnection( Gravoc.Encryption.Encryption.Decrypt(Properties.Settings.Default.ConnectionString)); connSql.Open(); SqlCommand cmdSql; squadDesc = squadDesc.Substring(squadDesc.IndexOf(":") + 1).Trim(); string[] x = squadDesc.Split(new string[] { " at " }, StringSplitOptions.None); if (x.Length < 2) throw (new InvalidOperationException()); if (x.Length > 2) { cmdSql = new SqlCommand("GetSquad", connSql); cmdSql.CommandType = System.Data.CommandType.StoredProcedure; cmdSql.Parameters.AddWithValue("@Campaign", campaign.ID); string annoyingTeamNameThatContainsAt = ""; using (SqlDataReader rReader = cmdSql.ExecuteReader()) { while (rReader.Read()) { if (rReader["Name"].ToString().Contains(" at ") && squadDesc.Contains(rReader["Name"].ToString())) { annoyingTeamNameThatContainsAt = rReader["Name"].ToString(); } } } if (squadDesc.IndexOf(annoyingTeamNameThatContainsAt) == 0) { x = new string[] { annoyingTeamNameThatContainsAt, squadDesc.Substring(annoyingTeamNameThatContainsAt.Length + 4)}; } else { x = new string[] { squadDesc.Substring(0, squadDesc.IndexOf(annoyingTeamNameThatContainsAt) - 4), annoyingTeamNameThatContainsAt }; } } if (x.Length == 2) { cmdSql = new SqlCommand("GetSquad", connSql); cmdSql.CommandType = System.Data.CommandType.StoredProcedure; cmdSql.Parameters.AddWithValue("@Name", x[0]); cmdSql.Parameters.AddWithValue("@Campaign", campaign.ID); using (SqlDataReader rReader = cmdSql.ExecuteReader()) { if (rReader.Read()) { awaySquad = new Squad(); awaySquad.SquadId = Convert.ToInt32(rReader["Id"]); awaySquad.Name = Convert.ToString(rReader["Name"]); awaySquad.Sponsor = Convert.ToString(rReader["Sponsor"]); awaySquad.City = Convert.ToString(rReader["City"]); awaySquad._Campaign = campaign; awaySquad.PopulatePlayers(); } else throw new Exception("Away Squad not found!"); } cmdSql = new SqlCommand("GetSquad", connSql); cmdSql.CommandType = System.Data.CommandType.StoredProcedure; cmdSql.Parameters.AddWithValue("@Name", x[1]); cmdSql.Parameters.AddWithValue("@Campaign", campaign.ID); using (SqlDataReader rReader = cmdSql.ExecuteReader()) { if (rReader.Read()) { homeSquad = new Squad(); homeSquad.SquadId = Convert.ToInt32(rReader["Id"]); homeSquad.Name = Convert.ToString(rReader["Name"]); homeSquad.Sponsor = Convert.ToString(rReader["Sponsor"]); homeSquad.City = Convert.ToString(rReader["City"]); homeSquad._Campaign = campaign; homeSquad.PopulatePlayers(); } else throw new Exception("Home Squad not found!"); } } connSql.Close(); }
public static Campaign GetCampaignFromMatch(int matchId) { SqlConnection connSql = new SqlConnection( Gravoc.Encryption.Encryption.Decrypt(Properties.Settings.Default.ConnectionString)); connSql.Open(); SqlCommand cmdSql = new SqlCommand("select campaign from match where id = @match", connSql); cmdSql.Parameters.AddWithValue("@match", matchId); Campaign campaign = new Campaign(-1, Season.Fall, 0, Class.SuperA, Conference.Boston, null); using (SqlDataReader rReader = cmdSql.ExecuteReader()) { if (rReader.Read()) campaign = GetCampaign(Convert.ToInt32(rReader[0])); } connSql.Close(); return campaign; }
public static Campaign GetCampaign(int campaignId) { Campaign campaign = new Campaign(0, Season.Fall, 0, Class.SuperA, Conference.Boston, null); SqlConnection connSql = new SqlConnection( Gravoc.Encryption.Encryption.Decrypt(Properties.Settings.Default.ConnectionString)); connSql.Open(); SqlCommand cmdSql = new SqlCommand("GetCampaign", connSql); cmdSql.CommandType = System.Data.CommandType.StoredProcedure; cmdSql.Parameters.AddWithValue("@CampaignID", campaignId); using (SqlDataReader rReader = cmdSql.ExecuteReader()) { if (rReader.Read()) { if (rReader["Identifier"] != DBNull.Value) campaign = new Campaign( campaignId, (Season)rReader["Season"], Convert.ToInt32(rReader["Year"]), (Class)rReader["Class"], (Conference)rReader["Conference"], Convert.ToInt32(rReader["Identifier"])); else campaign = new Campaign( campaignId, (Season)rReader["Season"], Convert.ToInt32(rReader["Year"]), (Class)rReader["Class"], (Conference)rReader["Conference"], null); } } connSql.Close(); return campaign; }