예제 #1
0
        public BetData Insert(BetData bet)
        {
            var p = new DynamicParameters();

            p.Add("Username", bet.Username);
            p.Add("User2ID", bet.User2ID);
            p.Add("BetActionID", bet.BetActionID);
            p.Add("BetValue", bet.BetValue);
            p.Add("FileExtension", bet.FileExtension);
            p.Add("Guid", dbType: DbType.Guid, direction: ParameterDirection.Output);

            this._db.Execute("spSUP_Bet_Insert", p, commandType: CommandType.StoredProcedure);

            bet.Guid = p.Get <Guid>("Guid");
            return(bet);
        }
예제 #2
0
        //public BetData Update(BetData bet)
        //{
        //    this._db.Execute("spSUP_Bet_Update", param: bet, commandType: CommandType.StoredProcedure);
        //    return bet;
        //}

        public BetData Update(BetData bet)
        {
            var p = new DynamicParameters();

            p.Add("Guid", bet.Guid, direction: ParameterDirection.InputOutput);
            p.Add("BetID", dbType: DbType.Int32, direction: ParameterDirection.Output);
            if (bet.BetActionID == 115)
            {
                p.Add("UserID", bet.User1ID);
            }
            else
            {
                p.Add("UserID", bet.User2ID);
            }
            p.Add("BetStatusID", bet.BetStatusID);

            this._db.Execute("spSUP_Bet_Update", param: p, commandType: CommandType.StoredProcedure);

            bet.Guid  = p.Get <Guid>("Guid");
            bet.BetID = p.Get <Int32>("BetID");
            return(bet);
        }