public string Registration(string name, string pass) { try { SetSettings(); userRepository = new SimpleChatRepository <Users>(databaseSettings); userRepository.CreatDatabase(); user = new Users(); user.Name = name; user.Pass = Convert.ToInt32(pass); userRepository.Add(user); userRepository.Save(); otvet = "Пользователь зарегистрирован"; log.Info($"Пользователь {name} зарегистрирован"); } catch (Exception e) { otvet = "Ошибка регистрации"; log.Error(otvet, e); } return(otvet); }
public void AddGetUpdateDeleteRole() { roleRepository = new SimpleChatRepository <Roles>(databaseSettings); role = new Roles { NameRole = "main", Id = 1 }; roleRepository.Add(role); roleRepository.Save(); var roleFromDb = roleRepository.GetItem(1); Assert.IsNotNull(role); Assert.AreEqual(roleFromDb.Id, 1); Assert.AreEqual(roleFromDb.NameRole, "main"); role.NameRole = "admin"; roleRepository.Update(role); roleRepository.Save(); roleFromDb = roleRepository.GetItem(1); Assert.IsNotNull(roleFromDb); Assert.AreEqual(roleFromDb.Id, 1); Assert.AreEqual(roleFromDb.NameRole, "admin"); roleRepository.DeleteItem(1); roleRepository.Save(); roleFromDb = roleRepository.GetItem(1); Assert.IsNull(roleFromDb); roleRepository.ContextDispose(); }
public void AddGetUpdateDeleteUser() { userRepository = new SimpleChatRepository <Users>(databaseSettings); userRepository.CreatDatabase(); user = new Users { //Id = 1, Name = "Serge" }; userRepository.Add(user); userRepository.Save(); var userFromDb = userRepository.GetItem(1); Assert.IsNotNull(userFromDb); Assert.AreEqual(userFromDb.Id, 1); Assert.AreEqual(userFromDb.Name, "Serge"); user.Name = "Andrei"; userRepository.Update(user); userRepository.Save(); userFromDb = userRepository.GetItem(1); Assert.IsNotNull(userFromDb); Assert.AreEqual(userFromDb.Id, 1); Assert.AreEqual(userFromDb.Name, "Andrei"); userRepository.DeleteItem(1); userRepository.Save(); userFromDb = userRepository.GetItem(1);; Assert.IsNull(userFromDb); userRepository.ContextDispose(); }
public string Authorization(string name, string pass) { try { SetSettings(); userRepository = new SimpleChatRepository <Users>(databaseSettings); userRepository.CreatDatabase(); user = new Users(); i = 0; while (i < userRepository.Count()) { i++; var userFromDb = userRepository.GetItem(i); if (userFromDb.Name == name) { user = userFromDb; break; } } if (user == null) { otvet = "Пользователь не найден"; } else if (user.Pass == Convert.ToInt32(pass)) { otvet = "Пользователь авторизован"; log.Info($"Пользователь {name} авторизован"); } else { otvet = "Пароль неверный"; log.Info($"Попытка авторизации {name} не удалась"); } } catch (Exception e) { otvet = "Ошибка авторизации"; log.Error(otvet, e); } return(otvet); }
public void AddGetUpdateDeleteMessage() { messageRepository = new SimpleChatRepository <Messages>(databaseSettings); message = new Messages { Id = 1, UserId = 1, Text = "textofmessage" }; messageRepository.Add(message); messageRepository.Save(); var messageFromDb = messageRepository.GetItem(1); Assert.IsNotNull(message); Assert.AreEqual(messageFromDb.Id, 1); Assert.AreEqual(messageFromDb.UserId, 1); Assert.AreEqual(messageFromDb.Text, "textofmessage"); message.Text = "anotherText"; messageRepository.Update(message); messageRepository.Save(); messageFromDb = messageRepository.GetItem(1); Assert.IsNotNull(messageFromDb); Assert.AreEqual(messageFromDb.Id, 1); Assert.AreEqual(messageFromDb.UserId, 1); Assert.AreEqual(messageFromDb.Text, "anotherText"); messageRepository.DeleteItem(1); messageRepository.Save(); messageFromDb = messageRepository.GetItem(1); Assert.IsNull(messageFromDb); messageRepository.ContextDispose(); }
public MessagingController(IHubContext <UpdateChatHub, ITypedHubClient> chatHubContext) { try { this.chatHubContext = chatHubContext; log = new NLogLogger($"{Path}\\{fileName}"); databaseSettings = new DatabaseSettings(); databaseSettings.ConnnectionString = $"{Path}\\{DatabaseName}"; messageRepository = new SimpleChatRepository <Messages>(databaseSettings); userRepository = new SimpleChatRepository <Users>(databaseSettings); messageTable = new DataTable("MessageTable"); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "NameUser"; column.Caption = "NameUser"; column.AutoIncrement = false; column.ReadOnly = false; column.Unique = false; messageTable.Columns.Add(column); column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "Messages"; column.Caption = "Messages"; column.AutoIncrement = false; column.ReadOnly = false; column.Unique = false; messageTable.Columns.Add(column); ShowMessages(); } catch (Exception e) { log.Error("Ошибка настройки", e); } }
public void CtorNulSettingsExceptionThro() { userRepository = new SimpleChatRepository <Users>(null); }