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