GetSectionTranslation(ExcelWorksheet sheet)
{
IDataResult <Dictionary <ITranslationEntity, List <ITranslationEntity> > > dataResult =
new DataResult <Dictionary <ITranslationEntity, List <ITranslationEntity> > >();
List <IRowItem> rowItems = new List <IRowItem>();
for (int j = sheet.Dimension.Start.Row + 1; j <= sheet.Dimension.End.Row; j++)
{
IDataResult <IRowItem> rowParserResult =
_parserSection.RowParser(sheet, j, _excelConfiguration);
if (!string.IsNullOrEmpty(rowParserResult.Message))
{
IRowItemError error = new RowItemError();
error.ColumnItems = rowParserResult.Data.ColumnItems;
dataResult.Message += MessageHolder.GetErrorMessage
(MessageType.NotPageSection);
dataResult.Message += rowParserResult.Message +
MessageHolder.GetErrorMessage(MessageType.NewLine);
error.RowNmomer = j;
dataResult = _dataNormalization.NormaliseTransliteSection(rowItems);
//dataResult.Success = false;
return(dataResult);
}
rowItems.Add(rowParserResult.Data);
}
IDataResult <Dictionary <ITranslationEntity, List <ITranslationEntity> > > sectiomNormResult =
_dataNormalization.NormaliseTransliteSection(rowItems);
if (!sectiomNormResult.Success)
{
dataResult.Message += MessageHolder.GetErrorMessage
(MessageType.NotPageSection);
dataResult.Message += sectiomNormResult.Message;
dataResult.Success = false;
return(dataResult);
}
dataResult.Data = sectiomNormResult.Data;
dataResult.Success = true;
return(dataResult);
}
public IDataResult <IRowItem> RowParser
(ExcelWorksheet excelWorksheet, int row, ExcelConfiguration excelConfiguration)
{
IDataResult <IRowItem> dataResult =
new DataResult <IRowItem>()
{
Success = false
};
IRowItem rowItem = new RowItem();
IRowItemError error = new RowItemError();
List <IColumnItem> columnItems = new List <IColumnItem>();
List <IDataResult <IColumnItem> > errorColumnItems = new List <IDataResult <IColumnItem> >();
int start = excelWorksheet.Dimension.Start.Column;
int end = excelWorksheet.Dimension.Columns;
for (int j = start; j < end; j++)
{
IExcelWorksheetEntity tmpEntity = new ExcelWorksheetEntity();
tmpEntity.CellNo = j;
tmpEntity.RowNo = row;
//
IExcelWorksheetEntity titleEntity = new ExcelWorksheetEntity();
titleEntity.RowNo = excelConfiguration.DataRowIndex.Title;
titleEntity.CellNo = j;
titleEntity.ExcelWorksheet = excelWorksheet;
IDataResult <string> nametitleResilt = _readExcelData.GetValue(titleEntity);
if (!nametitleResilt.Success)
{
break;
}
tmpEntity.ExcelWorksheet = excelWorksheet;
IDataResult <IColumnItem> getDataResult =
ColumnParser(tmpEntity, excelConfiguration);
dataResult.Message += getDataResult.Message;
if (getDataResult.Success)
{
if (!string.IsNullOrEmpty(getDataResult.Message))
{
getDataResult.Success = false;
errorColumnItems.Add(getDataResult);
}
else
{
columnItems.Add(getDataResult.Data);
}
}
else
{
errorColumnItems.Add(getDataResult);
}
}
error.ListColums = errorColumnItems;
error.ColumnItems = columnItems;
if (errorColumnItems.Any())
{
dataResult.Data = error;
dataResult.Success = false;
return(dataResult);
}
rowItem.ColumnItems = columnItems;
dataResult.Data = rowItem;
dataResult.Success = true;
return(dataResult);
}
