public void Create_EmptyLogin_ReturnException()
{
var user = new UserItem()
{
Login = null,
Password = PASSWORD
};
_userService.Create(user);
}
public int Create(UserItem user)
{
using (var sqlh = new SqlHelper())
{
return sqlh.ExecScalar<int>(@"
insert into Access.[user] (login, password)
values (@Login, @Password)
select SCOPE_IDENTITY()", user);
}
}
public void Update(UserItem user)
{
using (var sqlh = new SqlHelper())
{
sqlh.ExecNoQuery(@"
update Access.[user]
set
login = @Login,
password = @Password
where [user] = @Id", user);
}
}
public void Create_CreateUser_ReturnUserId()
{
var id = 1;
var user = new UserItem()
{
Login = LOGIN,
Password = PASSWORD
};
Mock.Get(_userRepository).Setup(x => x.Create(user)).Returns(id);
var result = _userService.Create(user);
Assert.AreEqual(id, result);
}
public void Create_Void_ReturnId()
{
var user = new UserItem()
{
Login = LOGIN,
Password = PASSWORD
};
Mock.Get(_userRepository).Setup(x => x.Create(user)).Returns(ID);
var result = _userService.Create(user);
Assert.AreEqual(result, ID);
}
/// <summary>
/// Создает пользователя.
/// </summary>
/// <param name="user">Данные о пользователе.</param>
/// <returns>Идентификаторо созданного пользователя.</returns>
public int Create(UserItem user)
{
if (string.IsNullOrEmpty(user.Login))
{
throw new Exception("Поле 'Login' не должно быть пустым.");
}
if (string.IsNullOrEmpty(user.Password))
{
throw new Exception("Поле 'Password' не должно быть пустым.");
}
return _userRepository.Create(user);
}
public void Create_IsCreated_ReturnCreatedUser()
{
var user = new UserItem()
{
Login = LOGIN,
Password = PASSWORD
};
int id = _userRepository.Create(user);
var result = _userRepository.Get(id);
Assert.AreEqual(result.Id, id);
Assert.AreEqual(result.Login, user.Login);
Assert.AreEqual(result.Password, user.Password);
}
public void GetListByUser_Void_ReturnNotEmptyListWithRoles()
{
UserItem user = new UserItem()
{
Id = 2,
Login = "******",
Password = "******"
};
RoleItem role = _roleRepository.Get(1);
var result = _roleRepository.GetListByUser(user);
AreEqualRoles(result.First(x=>x.Id == role.Id), role);
}
public List<RoleItem> GetListByUser(UserItem user)
{
using (SqlHelper sqlh = new SqlHelper(@"
select
r.role Id,
r.code Code,
r.mem Mem
from Access.[user] u
join Access.user2role u2r on u2r.[user] = u.[user]
join Access.role r on r.role = u2r.role
where u.[user] = @Id"))
{
sqlh.AddWithValue("Id", user.Id);
var dt = sqlh.ExecTable();
var list = new List<RoleItem>();
foreach (DataRow row in dt.Rows)
{
list.Add(new RoleItem()
{
Id = (int)row["Id"],
Code = (string)row["Code"],
Mem = (string)row["Mem"]
});
}
return list;
}
}
public bool UserInRole(UserItem user, string role_code)
{
return _accessService.UserInRole(user, role_code);
}
/// <summary>
/// Получает список ролей по пользователю.
/// </summary>
/// <param name="user">Пользователь.</param>
/// <returns>Список ролей.</returns>
public List<RoleItem> GetListByUser(UserItem user)
{
List<RoleItem> listRole = new List<RoleItem>();
using (var sqlh = new SqlHelper())
{
listRole = sqlh.ExecMappingList<RoleItem>(@"
select
r.role Id,
r.code Code,
r.mem Mem
from Access.[user] u
join Access.user2role u2r on u2r.[user] = u.[user]
join Access.role r on r.role = u2r.role
where u.[user] = @Id", user);
}
listRole.ForEach(delegate(RoleItem role)
{
listRole.AddRange(GetListByOwnerRole(role));
});
return listRole;
}
public bool UserInRole(UserItem user, string role_code)
{
var role = _roleRepository.GetByCode(role_code);
return UserInRole(user, role);
}
public bool UserInRole(UserItem user, RoleItem role)
{
var list = _roleRepository.GetListByUser(user);
return list.Exists(x => x.Code == "Admin" || role.Code.StartsWith(x.Code));
}
public void Update(UserItem user)
{
_userRepository.Update(user);
}
public void Delete(UserItem user)
{
_userRepository.Delete(user.Id);
}
public void Login(UserItem user, bool remember)
{
DateTime expiresDate = DateTime.Now.AddHours(6);
if (remember)
expiresDate = expiresDate.AddDays(10);
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(
1,
user.Login,
DateTime.Now,
expiresDate, remember, user.Id.ToString());
string encryptedTicket = FormsAuthentication.Encrypt(ticket);
SetValue(AUTH_COOKIE_NAME, encryptedTicket, expiresDate);
}
public void Register(UserItem user)
{
new UserService().Create(user);
}
public static bool UserInRole(UserItem user, RoleItem role)
{
return _accessService.UserInRole(user, role);
}
public bool UserInRole(UserItem user, RoleItem role)
{
var list = _roleRepository.GetListByUser(user);
return list.Exists(x => x.Code == "Admin" || x.Id == role.Id);
}
public static bool CheckRole(UserItem user)
{
return true;
}
