Beispiel #1
0
        public static bool CheckBalance(string id)
        {
            string        sql  = @"select Balance from dbo.GameUsers where UserId = '" + id + "';";
            GameUserModel user = SqlDataAccess.LoadSingleData <GameUserModel>(sql);

            if (user.Balance >= 10)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
        public static PersonM LoadPerson(string Id)
        {
            string sql = @"SELECT * FROM dbo.Person WHERE PersonID = @Id";

            return(SqlDataAccess.LoadSingleData <PersonM>(sql, Id));
        }
Beispiel #3
0
        public static GameModel LoadGame(string id)
        {
            string sql = @"select * from dbo.Games where Id ='" + id + "';";

            return(SqlDataAccess.LoadSingleData <GameModel>(sql));
        }