Ejemplo n.º 1
0
        public void Insert(IMapedFrame frame, Guid playerId, Guid gameId)
        {
            Parameters.Clear();

            Command = "InsertFrame";

            Parameters.Add(ParameterFactory.Create("PlayerId", DbType.Guid, playerId));

            Parameters.Add(ParameterFactory.Create("GameId", DbType.Guid, gameId));

            Parameters.Add(ParameterFactory.Create("FrameId", DbType.Int32, frame.Index));

            Parameters.Add(ParameterFactory.Create("Try1", DbType.Int32, frame.Try1));

            Parameters.Add(ParameterFactory.Create("Try2", DbType.Int32, frame.Try2));

            Parameters.Add(ParameterFactory.Create("Bonus", DbType.Int32, frame.BonusScore));

            Parameters.Add(ParameterFactory.Create("IsStrike", DbType.Boolean, frame.IsStrike));

            Parameters.Add(ParameterFactory.Create("IsSpare", DbType.Boolean, frame.IsSpare));

            Parameters.Add(ParameterFactory.Create("TotalScore", DbType.Int32, frame.TotalScore));

            Parameters.Add(ParameterFactory.Create("CumulativeScore", DbType.Int32, frame.CumulativeTotalScore));

            ExecuteTask(Insert);
        }
Ejemplo n.º 2
0
        public void UpdateFrame(IMapedFrame frame, Guid playerId, Guid gameId)
        {
            Parameters.Clear();

            Command = "UpdateFrame";

            Parameters.Add(ParameterFactory.Create("PlayerId", DbType.Guid, playerId));

            Parameters.Add(ParameterFactory.Create("GameId", DbType.Guid, gameId));

            Parameters.Add(ParameterFactory.Create("FrameId", DbType.Int32, frame.Index));

            Parameters.Add(ParameterFactory.Create("Bonus", DbType.Int32, frame.BonusScore));

            Parameters.Add(ParameterFactory.Create("TotalScore", DbType.Int32, frame.TotalScore));

            Parameters.Add(ParameterFactory.Create("CumulativeScore", DbType.Int32, frame.CumulativeTotalScore));

            ExecuteTask(Update);
        }