/// <summary>
/// Search Sheet by id.
/// </summary>
/// <param name="request">The Sheet Request Pivot to retrive.</param>
/// <returns>Sheet Response Pivot response.</returns>
public SheetResponsePivot FindSheets(SheetRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
List <SheetPivot> results = new List <SheetPivot>();
SheetPivot result = new SheetPivot();
switch (request.FindSheetPivot)
{
case FindSheetPivot.SheetId:
result = _unitOfWork.SheetRepository.Get(s => s.SheetId == request.SheetPivot.SheetId, null, "Country")?.FirstOrDefault().ToPivot();
break;
case FindSheetPivot.CountryId:
results = _unitOfWork.SheetRepository.Get(s => s.CountryId == request.SheetPivot.CountryId, null, "Country")?.ToList().ToPivotList();
break;
}
return(new SheetResponsePivot()
{
SheetPivotList = results,
SheetPivot = result
});
}
/// <summary>
/// Change Sheet values.
/// </summary>
/// <param name="request">The Sheet Request Pivot to change.</param>
public void UpdateSheet(SheetRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
//Sheet sheet = _unitOfWork.SheetRepository.GetById(request.SheetPivot.SheetId);
//_unitOfWork.Save();
}
/// <summary>
/// Create new Sheet.
/// </summary>
/// <param name="request">The Sheet Request Pivot to add.</param>
/// <returns>Sheet Response Pivot created.</returns>
public SheetResponsePivot CreateSheet(SheetRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
Sheet sheet = request.SheetPivot.ToEntity();
_unitOfWork.SheetRepository.Insert(sheet);
_unitOfWork.Save();
return(new SheetResponsePivot()
{
SheetPivot = sheet.ToPivot()
});
}
