Пример #1
0
        public int InsertMatch(LAMatch match)
        {
            string query = "spInsertMatch";

            SqlParameter[] parameters = new SqlParameter[9];
            parameters[0] = new SqlParameter("MatchID", match.MatchID);
            parameters[1] = new SqlParameter("RegionID", match.RegionID);
            parameters[2] = new SqlParameter("DatePlayed", match.DatePlayed);
            parameters[3] = new SqlParameter("DurationSeconds", match.DurationSeconds);
            parameters[4] = new SqlParameter("SeasonID", match.SeasonID);
            parameters[5] = new SqlParameter("GameVersion", match.GameVersion);
            parameters[6] = new SqlParameter("GameMode", match.GameMode);
            parameters[7] = new SqlParameter("GameType", match.GameType);
            parameters[8] = new SqlParameter("MapID", match.MapID);
            int rows = dBManager.ExecuteNonQuery(query, parameters);

            return(rows);
        }
Пример #2
0
        public LAMatch GetMatchByID(int matchID)
        {
            string  query = "spGetMatch";
            LAMatch match = new LAMatch();

            SqlParameter[] parameters = new SqlParameter[1];
            parameters[0] = new SqlParameter("MatchID", matchID);
            DataSet dataset = dBManager.CreateDataSet(query, parameters);

            match.MatchID         = (long)dataset.Tables[0].Rows[0]["MatchID"];
            match.RegionID        = (int)dataset.Tables[0].Rows[0]["RegionID"];
            match.DatePlayed      = (DateTime)dataset.Tables[0].Rows[0]["DatePlayed"];
            match.DurationSeconds = (double)dataset.Tables[0].Rows[0]["DurationSeconds"];
            match.SeasonID        = (int)dataset.Tables[0].Rows[0]["SeasonID"];
            match.GameVersion     = dataset.Tables[0].Rows[0]["GameVersion"].ToString();
            match.GameMode        = dataset.Tables[0].Rows[0]["GameMode"].ToString();
            match.GameType        = dataset.Tables[0].Rows[0]["GameType"].ToString();
            match.MapID           = (int)dataset.Tables[0].Rows[0]["MapID"];
            return(match);
        }
Пример #3
0
        public List <LAMatch> GetMatchesBySummonerID(string summonerID)
        {
            string         query   = "spGetMatchesBySummonerID";
            List <LAMatch> matches = new List <LAMatch>();
            LAMatch        match;

            SqlParameter[] parameters = new SqlParameter[1];
            parameters[0] = new SqlParameter("SummonerID", summonerID);
            DataSet dataset = dBManager.CreateDataSet(query, parameters);
            // TODO:
            // Decide on an appropriate number of matches to retrieve
            int datasetlen = dataset.Tables[0].Rows.Count;
            int len        = 20;

            if (datasetlen <= len)
            {
                len = datasetlen;
            }
            for (int x = 0; x < len; x++)
            {
                match = new LAMatch()
                {
                    MatchID         = (long)dataset.Tables[0].Rows[x]["MatchID"],
                    RegionID        = (int)dataset.Tables[0].Rows[x]["RegionID"],
                    DatePlayed      = (DateTime)dataset.Tables[0].Rows[x]["DatePlayed"],
                    DurationSeconds = (double)dataset.Tables[0].Rows[x]["DurationSeconds"],
                    SeasonID        = (int)dataset.Tables[0].Rows[x]["SeasonID"],
                    GameVersion     = dataset.Tables[0].Rows[x]["GameVersion"].ToString(),
                    GameMode        = dataset.Tables[0].Rows[x]["GameMode"].ToString(),
                    GameType        = dataset.Tables[0].Rows[x]["GameType"].ToString(),
                    MapID           = (int)dataset.Tables[0].Rows[x]["MapID"],
                };
                matches.Add(match);
            }

            return(matches);
        }