/// <summary> /// Сохраняет данные пользователя /// </summary> /// <param name="user"></param> public void SaveOrUpdate(User user) { using (var conn = sqlConnection.Connection) { conn.Open(); if (user.ID == 0) { int ID = indexService.NextID(User.TABLE_NAME); string passHash = PassCrypto.GetMD5Hash(user.Pass); string sql = string.Format(insertIntoSql, User.TABLE_NAME, ID, user.Login, passHash, user.FirstName, user.LastName, user.Role.ToString(), user.Group); ExecuteNonQuery(conn, sql); user.Pass = passHash; } else { using (SQLiteCommand insertSQL = new SQLiteCommand("UPDATE USERS SET Login = @Login, Pass = @Pass, FirstName = @FirstName, LastName = @LastName, Role = @Role, USER_GROUP = @USER_GROUP WHERE ID = @ID", conn)) { insertSQL.Parameters.AddWithValue("@Login", user.Login); insertSQL.Parameters.AddWithValue("@Pass", user.Pass); insertSQL.Parameters.AddWithValue("@FirstName", user.FirstName); insertSQL.Parameters.AddWithValue("@LastName", user.LastName); insertSQL.Parameters.AddWithValue("@USER_GROUP", user.Group); insertSQL.Parameters.AddWithValue("@Role", user.Role.ToString()); insertSQL.Parameters.AddWithValue("@ID", user.ID); insertSQL.ExecuteNonQuery(); } } } }
public void UpdateUser(User newUserdata) { currentUser.Login = newUserdata.Login; currentUser.Pass = PassCrypto.GetMD5Hash(newUserdata.Pass); currentUser.FirstName = newUserdata.FirstName; currentUser.LastName = newUserdata.LastName; userService.SaveOrUpdate(currentUser); }
public void CreateTestUser() { User testUser = new User(); testUser.FirstName = "Геральд"; testUser.LastName = "из Ривии"; testUser.Group = "Школа Волка"; testUser.Login = "******"; testUser.Pass = "******"; testUser.Role = UserRoles.USER; userService.SaveOrUpdate(testUser); }
private User ToUser(SQLiteDataReader reader) { User user = new User(); user.ID = (int)reader["ID"]; user.Login = (string)reader["Login"]; user.Pass = (string)reader["Pass"]; user.FirstName = (string)reader["FirstName"]; user.LastName = (string)reader["LastName"]; user.Group = (string)reader["USER_GROUP"]; user.Role = (UserRoles)Enum.Parse(typeof(UserRoles), (string)reader["Role"], true); return user; }
/// <summary> /// Метод для авторизации пользователя /// </summary> /// <param name="login">Логин</param> /// <param name="pass">Пароль</param> public bool Authorization(string login, string pass) { User user = userService.FindByLogin(login); if (user != null && PassCrypto.VerifyMd5Hash(pass, user.Pass)) { currentUser = user; return true; } else { return false; } }
/// <summary> /// Преверяет существует ли администратор, если нет, то создает его /// </summary> public void Update() { if (!userService.isExist(UserRoles.ADMIN)) { User admin = new User(); admin.Login = "******"; admin.Pass = "******"; admin.Role = UserRoles.ADMIN; admin.FirstName = "Admin"; admin.LastName = "Admin"; userService.SaveOrUpdate(admin); } }
/// <summary> /// Добавить пользователя /// </summary> /// <param name="_group">Группа</param> /// <param name="_lastName">Фамилия</param> /// <param name="_firstName">Имя</param> /// <param name="_login">Логин</param> /// <param name="_password">Пароль</param> /// <param name="_groupBox">Родитель компонентов для очистки</param> /// <returns></returns> public void Add_Users(string _group, string _lastName, string _firstName, string _login, string _password, GroupBox _groupBox) { try { if (_UserService.isExist(_login)) throw new System.Exception("Логин уже существует"); User _user = new User(_group, _lastName, _firstName, _login, _password); _UserService.SaveOrUpdate(_user); FormsUtility.Clear(_groupBox); MyMessage.Info("Пользователь успешно создан"); } catch (System.Exception _exception) { MyMessage.Error(_exception.Message); return; } }
public TestResult(User UserName, string SubjectTitle) { this.UserName = UserName; this.SubjectTitle = SubjectTitle; StartTime = DateTime.Now; }