public User GetUserByLogin(string login)
{
User user = new User();
if (!string.IsNullOrEmpty(login))
{
_executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd);
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetUserByLogin", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Login", login);
user = executer(sqlConnection, cmd).FirstOrDefault();
if (user != null)
{
user.UserRoles = GetUserRolesByUserId(user.UserId);
}
}
}
}
return(user);
}
public List <User> GetUsers()
{
_executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd);
List <User> users = new List <User>();
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetUsers", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
users = executer(sqlConnection, cmd);
}
return(users);
}
}
public User GetUserById(int userId)
{
User user = new User();
if (userId > 0)
{
_executerUserCmd executer = new _executerUserCmd(ExecuteUserSqlCmd);
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetUserById", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", userId);
user = executer(sqlConnection, cmd).FirstOrDefault();
}
}
}
return(user);
}
