public int InsertMatchParticipant(MatchParticipant newParticipant)
{
string query = "spInsertMatchParticipant";
//RiotSharp.Endpoints.MatchEndpoint.Match mymatch; //just testing
//mymatch.ParticipantIdentities[0].Player. //just testing
SqlParameter[] parameters = new SqlParameter[6];
//parameters[0] = new SqlParameter("ParticipantID", newParticipant.ParticipantID);
parameters[0] = new SqlParameter("MatchID", newParticipant.MatchID);
parameters[1] = new SqlParameter("SummonerID", newParticipant.SummonerID);
parameters[2] = new SqlParameter("ChampionID", newParticipant.ChampionID);
parameters[3] = new SqlParameter("TeamID", newParticipant.TeamID);
parameters[4] = new SqlParameter("Spell1ID", newParticipant.Spell1ID);
parameters[5] = new SqlParameter("Spell2ID", newParticipant.Spell2ID);
int rows = dBManager.ExecuteNonQuery(query, parameters);
return(rows);
}
public MatchParticipant GetMatchParticipantByID(int participantID)
{
string query = "spGetMatchParticipant";
MatchParticipant participant = new MatchParticipant();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter();
DataSet dataset = dBManager.CreateDataSet(query, parameters);
participant.ParticipantID = (int)dataset.Tables[0].Rows[0]["ParticipantID"];
participant.MatchID = (int)dataset.Tables[0].Rows[0]["MatchID"];
participant.SummonerID = dataset.Tables[0].Rows[0]["SummonerID"].ToString();
participant.ChampionID = (int)dataset.Tables[0].Rows[0]["ChampionID"];
//participant.StatID = (int)dataset.Tables[0].Rows[0]["StatID"];
participant.TeamID = (int)dataset.Tables[0].Rows[0]["TeamID"];
participant.Spell1ID = (int)dataset.Tables[0].Rows[0]["Spell1ID"];
participant.Spell2ID = (int)dataset.Tables[0].Rows[0]["Spell2ID"];
return(participant);
}
