예제 #1
0
 private void RegistrationButtom_Click(object sender, EventArgs e)
 {
     var user = new User();
     if (user.LoginAvailable(loginField.Text))
     {
         MessageBox.Show(Resources.user_there_in_db, Resources.error_operation_msg);
     }
     else
     {
         user.CreateNew(loginField.Text, pswField.Text);
     }
 }
예제 #2
0
 /// <summary>
 /// Inserts the user.
 /// </summary>
 /// <param name="user">The user.</param>
 /// <returns><c>true</c> on success.</returns>
 public bool InsertUser(User user)
 {
     Log.DebugFormat("InsertUser '{0}'", user);
     using (dbConnection)
     {
         using (DbCommand dbCommand = dbConnection.CreateCommand())
         {
             dbConnection.Open();
             string commandText = String.Format(CultureInfo.InvariantCulture,
                                                "INSERT INTO Users (Name, Password, Level) VALUES('{0}', '{1}', {2})",
                                                user.Name, user.Password, user.Level);
             Log.Debug(commandText);
             dbCommand.CommandText = commandText;
             if (dbCommand.ExecuteNonQuery() == 1)
             {
                 return true;
             }
             Log.ErrorFormat("Failed to insert user [{0}]", user);
             return false;
         }
     }
 }
예제 #3
0
 /// <summary>
 /// Gets the list of users.
 /// </summary>
 /// <returns><see cref="IList{T}"/></returns>
 public IList<User> GetUsers()
 {
     Log.Debug("GetUsers");
     List<User> users = new List<User>();
     using (dbConnection)
     {
         using (DbCommand dbCommand = dbConnection.CreateCommand())
         {
             dbConnection.Open();
             // Create a table in the database
             //dbCommand.CommandText = "CREATE TABLE FOO (ID INTEGER PRIMARY KEY, MYVALUE VARCHAR(50))";
             //dbCommand.ExecuteNonQuery();
             // Create a parameterized insert command
             //dbCommand.CommandText = "INSERT INTO FOO (MYVALUE) VALUES(?)";
             //dbCommand.Parameters.Add(dbCommand.CreateParameter());
             // Insert 10 rows into the database
             //for (int n = 0; n < 10; n++)
             //{
             //    dbCommand.Parameters[0].Value = "Value " + n;
             //    dbCommand.ExecuteNonQuery();
             //}
             // Now read them back
             const string commandText = "SELECT * FROM Users";
             dbCommand.CommandText = commandText;
             Log.Debug(commandText);
             using (DbDataReader reader = dbCommand.ExecuteReader())
             {
                 while (reader.Read())
                 {
                     User user = new User
                         {
                             Id = Int32.Parse(reader[0].ToString()),
                             Name = reader[1].ToString(),
                             Password = reader[2].ToString(),
                             Level = Int32.Parse(reader[3].ToString())
                         };
                     Log.DebugFormat("Adding user : [{0}]", user);
                     users.Add(user);
                 }
             }
         }
     }
     return users;
 }
예제 #4
0
 /// <summary>
 /// Gets the user.
 /// </summary>
 /// <param name="username">The username.</param>
 /// <returns></returns>
 public User GetUser(string username)
 {
     Log.DebugFormat("GetUser '{0}'", username);
     using (dbConnection)
     {
         using (DbCommand dbCommand = dbConnection.CreateCommand())
         {
             dbConnection.Open();
             string commandText = String.Format(CultureInfo.InvariantCulture,
                                           "SELECT * FROM Users WHERE Name='{0}'", username);
             dbCommand.CommandText = commandText;
             Log.Debug(commandText);
             using (DbDataReader reader = dbCommand.ExecuteReader())
             {
                 while (reader.Read())
                 {
                     User user = new User
                         {
                             Id = Int32.Parse(reader[0].ToString()),
                             Name = reader[1].ToString(),
                             Password = reader[2].ToString(),
                             Level = Int32.Parse(reader[3].ToString())
                         };
                     Log.DebugFormat("Have user : [{0}]", user);
                     return user;
                 }
             }
         }
     }
     Log.WarnFormat("User '{0}' not found!", username);
     return null;
 }