public PublicHouseViewModel Get(int id)
{
PublicHouse publicHouseDB = _publicHouseRepository.Get(id);
var publicHouse = Mapper.Map <PublicHouse, PublicHouseViewModel>(publicHouseDB);
return(publicHouse);
}
public async Task Update(PublicHouse item)
{
string query = _queryHelper.GenerateUpdateQuery();
using (var db = new SqlConnection(_connectionString))
{
await db.ExecuteAsync(query, item);
}
}
public async Task <int> Create(PublicHouse item)
{
string query = _queryHelper.GenerateCreateQuery();
using (var db = new SqlConnection(_connectionString))
{
int newRowId = await db.QuerySingleAsync <int>(query, item);
return(newRowId);
}
}
private TypeHouse Converter(PublicHouse type)
{
switch (type)
{
case PublicHouse.Dormitory:
return(TypeHouse.Dormitory);
case PublicHouse.Departmental:
return(TypeHouse.Departmental);
default:
throw new ArgumentOutOfRangeException(nameof(type), type, null);
}
}
public async Task <ActualResult <IEnumerable <PublicHouseEmployeesDTO> > > GetAllAsync(string hashIdEmployee, PublicHouse type)
{
try
{
var id = _hashIdUtilities.DecryptLong(hashIdEmployee);
var publicHouse = await _context.PublicHouseEmployees
.Include(x => x.IdAddressPublicHouseNavigation)
.Where(x => x.IdEmployee == id && x.IdAddressPublicHouseNavigation.Type == Converter(type))
.ToListAsync();
var result = _mapperService.Mapper.Map <IEnumerable <PublicHouseEmployeesDTO> >(publicHouse);
return(new ActualResult <IEnumerable <PublicHouseEmployeesDTO> > {
Result = result
});
}
catch (Exception exception)
{
return(new ActualResult <IEnumerable <PublicHouseEmployeesDTO> >(DescriptionExceptionHelper.GetDescriptionError(exception)));
}
}
