/// <summary>
/// Search SheetTranslation by id.
/// </summary>
/// <param name="request">The SheetTranslation Request Pivot to retrive.</param>
/// <returns>SheetTranslation Response Pivot response.</returns>
public SheetTranslationResponsePivot FindSheetTranslations(SheetTranslationRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
List <SheetTranslationPivot> results = new List <SheetTranslationPivot>();
SheetTranslationPivot result = new SheetTranslationPivot();
switch (request.FindSheetTranslationPivot)
{
case FindSheetTranslationPivot.SheetTranslationId:
result = _unitOfWork.SheetTranslationRepository.GetById(request.SheetTranslationPivot.TranslationId)?.ToPivot();
break;
case FindSheetTranslationPivot.SheetId:
results = _unitOfWork.SheetTranslationRepository.Get(s => s.SheetId == request.SheetTranslationPivot.SheetId, null, "Language,Sheet")?.ToList().ToPivotList();
break;
}
return(new SheetTranslationResponsePivot()
{
SheetTranslationPivotList = results,
SheetTranslationPivot = result
});
}
/// <summary>
/// Remove SheetTranslation.
/// </summary>
/// <param name="request">The SheetTranslation Request Pivot to remove.</param>
public void DeleteSheetTranslation(SheetTranslationRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
SheetTranslation sheetTranslation = _unitOfWork.SheetTranslationRepository.GetById(request.SheetTranslationPivot.TranslationId);
_unitOfWork.SheetTranslationRepository.Delete(sheetTranslation);
_unitOfWork.Save();
}
/// <summary>
/// Change SheetTranslation values.
/// </summary>
/// <param name="request">The SheetTranslation Request Pivot to change.</param>
public void UpdateSheetTranslation(SheetTranslationRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
SheetTranslation sheetTranslation = _unitOfWork.SheetTranslationRepository.GetById(request.SheetTranslationPivot.TranslationId);
sheetTranslation.SheetTitle = request.SheetTranslationPivot.SheetTitle;
sheetTranslation.SheetValue = request.SheetTranslationPivot.SheetValue;
_unitOfWork.Save();
}
/// <summary>
/// Change SheetTranslationRange values.
/// </summary>
/// <param name="request">The SheetTranslation Request SheetTranslationRange to change.</param>
public void UpdateSheetTranslationRange(SheetTranslationRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
foreach (var item in request.SheetTranslationPivotList)
{
SheetTranslation sheetTranslation = _unitOfWork.SheetTranslationRepository.GetById(item.TranslationId);
sheetTranslation.SheetTitle = item.SheetTitle;
sheetTranslation.SheetValue = item.SheetValue;
_unitOfWork.Save();
}
}
/// <summary>
/// Create new SheetTranslation.
/// </summary>
/// <param name="request">The SheetTranslation Request Pivot to add.</param>
/// <returns>SheetTranslation Response Pivot created.</returns>
public SheetTranslationResponsePivot CreateSheetTranslation(SheetTranslationRequestPivot request)
{
if (request == null)
{
throw new ArgumentNullException(nameof(request));
}
SheetTranslation sheetTranslation = request.SheetTranslationPivot.ToEntity();
_unitOfWork.SheetTranslationRepository.Insert(sheetTranslation);
_unitOfWork.Save();
return(new SheetTranslationResponsePivot()
{
SheetTranslationPivot = sheetTranslation.ToPivot()
});
}
