public void GetAllTest() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); connectionString = @"Data Source=LAPTOP-4GR3EOJP\SQLEXPRESS_AIDA;Initial Catalog=Database1;Integrated Security=True";//todo pn аналогично List <UserModel> users = userRepository.GetAll(); int count = users.Count; using (IDbConnection connection = new SqlConnection(connectionString)) { connection.Open(); var command = connection.CreateCommand(); command.CommandText = "SELECT COUNT(*) FROM Database1.[dbo].[User]"; command.CommandType = CommandType.Text; int count_ = (int)command.ExecuteScalar(); if (count != count_) { Assert.Fail(); } } }
public void SaveEqualTest() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); connectionString = @"Data Source=LAPTOP-4GR3EOJP\SQLEXPRESS_AIDA;Initial Catalog=Database1;Integrated Security=True"; int Id = 111; userRepository.Delete(Id); UserModel user = new UserModel(); user.UserId = Id; user.UserName = "******"; user.UserPassword = "******"; user.UserEmail = "email"; user.UserRole = UserRoleID.Programmer; if (!userRepository.Save(user)) { Assert.Fail("Not saved"); } if (user.Equals(userRepository.Get(user.UserId))) { Assert.Fail("Not equal"); } userRepository.Delete(Id); }
public ActionResult SignUp(UserEntityDb user) { if (ModelState.IsValid) { UserRepository.AddData(user); ViewBag.Message = "Success"; } return(View(user)); }
public void GetByNullID() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); Assert.IsNull(userRepository.Get()); }
public void DeleteWithEmptyID() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); Assert.IsFalse(userRepository.Delete()); }
public void DeleteNotExistingId() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.AddData(); int nonExistId = 999; Assert.IsFalse(userRepository.Delete(nonExistId)); }
public void GetByNotExistingID() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); int NotExistingId = 100; Assert.IsNull(userRepository.Get(NotExistingId)); }
public void DeleteExistingId() { IUserRepository <UserModel> userRepository = new UserRepository <UserModel>(); userRepository.DeleteData(); userRepository.AddData(); int ExistingId = 2; Assert.IsTrue(userRepository.Delete(ExistingId)); }