/// <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;
}
