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