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 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 ShowMessages() { try { messageTable.Rows.Clear(); messageId = messageRepository.Count(); i = 1; if (messageId < 11) { while (i <= messageId) { var messageFromDb = messageRepository.GetItem(i); var userFromDb = userRepository.GetItem(messageFromDb.UserId); row = messageTable.NewRow(); row["NameUser"] = userFromDb.Name; row["Messages"] = messageFromDb.Text; messageTable.Rows.Add(row); i++; } } else { i = messageId - 9; while (i <= messageId) { var messageFromDb = messageRepository.GetItem(i); var userFromDb = userRepository.GetItem(messageFromDb.UserId); row = messageTable.NewRow(); row["NameUser"] = userFromDb.Name; row["Messages"] = messageFromDb.Text; messageTable.Rows.Add(row); i++; } } } catch (Exception e) { log.Error("Ошибка показа сообщений", e); } }
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 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); }