Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /// <summary>
- /// Checks if the given username and password match.
- /// </summary>
- /// <param name="username">Username.</param>
- /// <param name="password">Password.</param>
- /// <returns>User if login was successful, null otherwise.</returns>
- public User GetUser(string username, string password)
- {
- string sql = @"
- SELECT id, name, username, money FROM Users
- WHERE username = @username
- AND password = @password
- ";
- SQLiteCommand cmd = new SQLiteCommand(sql, connection);
- cmd.Parameters.AddWithValue("@username", username);
- cmd.Parameters.AddWithValue("@password", password);
- SQLiteDataReader reader = cmd.ExecuteReader();
- User user = null;
- if (reader.Read())
- {
- user = new User(
- (long) reader["id"],
- (string) reader["name"],
- (string) reader["username"],
- (double) reader["money"],
- new List<Diginote>()
- );
- sql = @"
- SELECT id
- FROM Diginotes
- WHERE Diginotes.userId = @userId
- ";
- cmd = new SQLiteCommand(sql, connection);
- cmd.Parameters.AddWithValue("@userId", user.Id);
- reader = cmd.ExecuteReader();
- while (reader.Read())
- {
- user.Wallet.Add(new Diginote((long) reader["id"]));
- }
- }
- return user;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement