public async Task <UserResponseModel> GetUserById(int userId)
{
UserResponseModel user = null;
using (MySqlConnection conn = new MySqlConnection(_configuration["Database:ConnectionString"]))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_user_by_id", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("userId", userId);
using (var reader = await cmd.ExecuteReaderAsync())
{
user = UserServiceMapper.ToUser(reader);
}
}
return(user);
}
public async Task <List <UserResponseModel> > GetReportingManagerEmployees(int reportingManagerId)
{
List <UserResponseModel> users = new List <UserResponseModel>();
using (MySqlConnection conn = new MySqlConnection(_configuration["Database:ConnectionString"]))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("get_reporting_manager_users", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("userId", reportingManagerId);
using (var reader = await cmd.ExecuteReaderAsync())
{
users = UserServiceMapper.ToUsers(reader);
}
}
return(users);
}
/// <summary>
/// Performs the installation in the <see cref="T:Castle.Windsor.IWindsorContainer" />.
/// </summary>
/// <param name="container">The container.</param>
/// <param name="store">The configuration store.</param>
public void Install(IWindsorContainer container, IConfigurationStore store)
{
if (container == null)
{
throw new ArgumentNullException(nameof(container));
}
UserServiceMapper.Register();
container.Register(
Component.For <IPasswordEncoder>().ImplementedBy <PasswordEncoder>());
const string UsersContextLocatorName = "UsersContextLocator";
const string ContextLocatorFieldName = "contextLocator";
container.Register(
Component.For <Func <UsersContext> >().Instance(() => new UsersContext())
.Named(UsersContextLocatorName));
container.Register(
Component.For <IUsersDataService>().ImplementedBy <UsersDataService>()
.DependsOn(ServiceOverride.ForKey(ContextLocatorFieldName).Eq(UsersContextLocatorName)));
}
