public void AddUser(String stringUser, User user) { if (user.AuthSuccess == true && user.UserRole == "Администратор") { ClassResource.User tempUser = JsonConvert.DeserializeObject <ClassResource.User>(stringUser); if (tempUser.Snapping != "") { DatabaseWork.ExecuteUpdate("INSERT INTO [Users] ([Login], [Password], [FIO User], [Role], [Snapping]) VALUES (" + "N'" + tempUser.Login + "'," + "N'" + tempUser.Password + "'," + "N'" + tempUser.Name + "'," + "N'" + tempUser.Role + "'," + "N'" + tempUser.Snapping + "')"); } else { DatabaseWork.ExecuteUpdate("INSERT INTO [Users] ([Login], [Password], [FIO User], [Role]) VALUES (" + "N'" + tempUser.Login + "'," + "N'" + tempUser.Password + "'," + "N'" + tempUser.Name + "'," + "N'" + tempUser.Role + "')"); } Server.UpdateUsers(); } else { Functions.AddJournalEntry($": __ATTENTION__ {user.UserID} {user.UserName} Попытка доступа без соответствующих прав."); } }
public void UpdateUser(String stringUser, User user) { if (user.AuthSuccess == true && user.UserRole == "Администратор") { ClassResource.User tempUser = JsonConvert.DeserializeObject <ClassResource.User>(stringUser); DatabaseWork.ExecuteUpdate("UPDATE [Users] SET" + "[Login] = N'" + tempUser.Login + "'," + "[FIO User] = N'" + tempUser.Name + "'," + "[Role] = N'" + tempUser.Role + "'," + (tempUser.Snapping != "" ? "[Snapping] = '" + tempUser.Snapping + "' " : "") + "WHERE [Login] = '" + tempUser.Engineer + "'"); Server.UpdateUsers(); } else { Functions.AddJournalEntry($": __ATTENTION__ {user.UserID} {user.UserName} Попытка доступа без соответствующих прав."); } }
private void BGo_Click(object sender, RoutedEventArgs e) { if (tbUserLogin.Text == "" || tbUserName.Text == "" || tbUserFirstPassword.Password == "" || tbUserSecondPassword.Password == "" || cbUserRole.SelectedIndex < 0) { lErrorMessage.Content = "Заполните все поля, помеченные *"; return; } if (!regexLogin.IsMatch(tbUserLogin.Text)) { lErrorMessage.Content = "Логин введен некорректно"; return; } if (users.Find(x => x.Login == tbUserLogin.Text) != null) { lErrorMessage.Content = "Пользователь с таким логином уже существует"; return; } if (!regexPassword.IsMatch(tbUserFirstPassword.Password)) { lErrorMessage.Content = "Пароль введен некорректно"; return; } if (cbUserSnappingInfo.SelectedIndex < 0 && cbUserRole.SelectedItem.ToString() == "Инженер") { lErrorMessage.Content = "Для инженера обязательна ссылка"; return; } if (tbUserFirstPassword.Password != tbUserSecondPassword.Password) { lErrorMessage.Content = "Пароли не совпадают"; return; } ClassResource.User user = new ClassResource.User(tbUserLogin.Text, tbUserName.Text, cbUserRole.SelectedItem.ToString(), tbUserSnapping.Text, null, null, Sources.Cryptography.GetHash(tbUserFirstPassword.Password)); Sources.Client.SendMessage("AddUser", new String[] { JsonConvert.SerializeObject(user) }); this.Close(); }