public async Task UpdateAsync(Department department)
{
await _repository.UpdateAsync(department);
// Update item in cache
string departmentCacheKey = DepartmentCacheKeys.GetKey(department.Id);
await _distributedCache.SetAsync <Department>(departmentCacheKey, department);
string departmentDetailsCacheKey = DepartmentCacheKeys.GetDetailsKey(department.Id);
DepartmentDetailsDto departmentDetailsDto = new DepartmentDetailsDto()
{
DepartmentId = department.Id,
DepartmentName = department.Name,
Description = department.Description,
IsActive = department.IsActive,
CreatedAtUtc = department.CreatedAtUtc,
LastModifiedAtUtc = department.LastModifiedAtUtc
};
await _distributedCache.SetAsync(departmentDetailsCacheKey, departmentDetailsDto);
string departmentListKey = DepartmentCacheKeys.ListKey;
await _distributedCache.UpdateInListAsync <Department>(departmentListKey, d => d.Id == department.Id, department);
string departmenSelecttListKey = DepartmentCacheKeys.SelectListKey;
await _distributedCache.UpdateInListAsync(departmenSelecttListKey, d => d.Id == department.Id, department);
}
public async Task <int> InsertAsync(Department department)
{
object[] primaryKeyValues = await _repository.InsertAsync(department);
int departmentId = (int)primaryKeyValues[0];
department.Id = departmentId;
// Add item to the cache list
string departmentCacheKey = DepartmentCacheKeys.GetKey(department.Id);
await _distributedCache.SetAsync(departmentCacheKey, department);
string departmentDetailsCacheKey = DepartmentCacheKeys.GetDetailsKey(department.Id);
DepartmentDetailsDto departmentDetailsDto = new DepartmentDetailsDto()
{
DepartmentId = department.Id,
DepartmentName = department.Name,
Description = department.Description,
IsActive = department.IsActive,
CreatedAtUtc = department.CreatedAtUtc,
LastModifiedAtUtc = department.LastModifiedAtUtc
};
await _distributedCache.SetAsync(departmentDetailsCacheKey, departmentDetailsDto);
string departmentListKey = DepartmentCacheKeys.ListKey;
await _distributedCache.AddToListAsync(departmentListKey, department, d => d.Name);
string departmentSelectListKey = DepartmentCacheKeys.SelectListKey;
await _distributedCache.AddToListAsync(departmentSelectListKey, department, d => d.Name);
return(departmentId);
}
public async Task <Department> GetByIdAsync(int departmentId)
{
string cacheKey = DepartmentCacheKeys.GetKey(departmentId);
Department department = await _distributedCache.GetAsync <Department>(cacheKey);
if (department == null)
{
department = await _repository.GetByIdAsync <Department>(departmentId);
await _distributedCache.SetAsync <Department>(cacheKey, department);
}
return(department);
}
public async Task DeleteAsync(Department department)
{
await _repository.DeleteAsync(department);
// Remove item from cache
string cacheKey = DepartmentCacheKeys.GetKey(department.Id);
await _distributedCache.RemoveAsync(cacheKey);
string departmentDetailsCacheKey = DepartmentCacheKeys.GetDetailsKey(department.Id);
await _distributedCache.RemoveAsync(departmentDetailsCacheKey);
string departmentListKey = DepartmentCacheKeys.ListKey;
await _distributedCache.RemoveFromListAsync <Department>(departmentListKey, d => d.Id == department.Id);
string departmentSelectListKey = DepartmentCacheKeys.SelectListKey;
await _distributedCache.RemoveFromListAsync <Department>(departmentSelectListKey, d => d.Id == department.Id);
}
public async Task <DepartmentDetailsDto> GetDetailsByIdAsync(int departmentId)
{
string cacheKey = DepartmentCacheKeys.GetDetailsKey(departmentId);
DepartmentDetailsDto department = await _distributedCache.GetAsync <DepartmentDetailsDto>(cacheKey);
if (department == null)
{
Expression <Func <Department, DepartmentDetailsDto> > selectExp = d => new DepartmentDetailsDto
{
DepartmentId = d.Id,
DepartmentName = d.Name,
Description = d.Description,
IsActive = d.IsActive,
CreatedAtUtc = d.CreatedAtUtc,
LastModifiedAtUtc = d.LastModifiedAtUtc
};
department = await _repository.GetByIdAsync(departmentId, selectExp);
await _distributedCache.SetAsync <DepartmentDetailsDto>(cacheKey, department);
}
return(department);
}
