//public string ErrorMessage(string message) //{ // StringBuilder sb = new StringBuilder(); // int i = 1; // while(message!=null) // { // if (message.Contains("(" + i + ")")) // { // } // else // { // i++; // } // } //} public IDataResult <string> GetColorValue (IExcelWorksheetEntity excelWorksheetEntity) { IDataResult <string> dataResult = new DataResult <string>() { Success = false }; int rowNo = excelWorksheetEntity.RowNo; int cellNo = excelWorksheetEntity.CellNo; string colorName = excelWorksheetEntity.ExcelWorksheet. Cells[rowNo, cellNo].Style.Fill.BackgroundColor.Rgb; if (string.IsNullOrEmpty(colorName)) { dataResult.Success = false; return(dataResult); } dataResult.Success = true; dataResult.Data = colorName; return(dataResult); }
public IDataResult <string> GetValue(IExcelWorksheetEntity excelWorksheet) { IDataResult <string> dataResult = new DataResult <string>() { Success = false }; int rowNo = excelWorksheet.RowNo; int cellNo = excelWorksheet.CellNo; if (excelWorksheet.ExcelWorksheet.Cells[rowNo, cellNo].Value != null) { string result = excelWorksheet.ExcelWorksheet .Cells[rowNo, cellNo].Value.ToString(); dataResult.Success = true; dataResult.Data = result; return(dataResult); } dataResult.Message = "(" + AlphabetHolder.GetSmbol(cellNo) + ") " + MessageHolder.GetErrorMessage (MessageType.IsNullOrEmpty); // MessageHolder.GetErrorMessage(MessageType.FrontBracket) + //"("+rowNo+")" +; //MessageHolder.GetErrorMessage(MessageType.BackBracket); return(dataResult); }
private IDataResult <Data> HelperGenerat (Data data, IExcelWorksheetEntity tmpEntity, int endColumn) { IDataResult <Data> dataResult = new DataResult <Data>() { Success = false }; string nameTitle = data.Name; nameTitle = _dataNormalization.NormalizeString(nameTitle).Data; for (int i = 1; i <= endColumn; i++) { tmpEntity.CellNo = i; IDataResult <string> tmpDataResultValue = _readExcelData.GetValue(tmpEntity); if (!tmpDataResultValue.Success) { continue; } string nameExcelTitle = tmpDataResultValue.Data; nameExcelTitle = _dataNormalization.NormalizeString(nameExcelTitle).Data; nameTitle = _dataNormalization.NormalizeString(nameTitle).Data; if (nameExcelTitle.Equals(nameTitle)) { data.Nomer = i; dataResult.Success = true; dataResult.Data = data; return(dataResult); } } return(dataResult); }
private IBaseEntity GetBaseEntity(IExcelWorksheetEntity excelWorksheet, string data, int column, ExcelConfiguration excelConfiguration) { IBaseEntity baseEntity = new BaseEntity() { Value = data }; if (column == excelConfiguration.DataColumn .Datas.FirstOrDefault(p => p.ColumnType == (int)ColumnType.Section)?.Nomer || column == excelConfiguration.DataColumn.Datas .FirstOrDefault(p => p.ColumnType == (int)ColumnType.Language)?.Nomer) { string name = excelConfiguration.NameColumnSection.MainLanguage; ITranslationEntity entity = new TranslationEntity(); entity.Language = LanguageHolder.GetISOCodes(name, _dataNormalization); entity.Value = data; return(entity); } if (column == excelConfiguration.DataColumn.Datas .FirstOrDefault(p => p.ColumnType == (int)ColumnType.Picture)?.Nomer) { IDataResult <string> colorNameResult = _readExcelData.GetColorValue(excelWorksheet); IExcelColor excelColor = new ExcelColor(); if (colorNameResult.Success) { Color color = ColorTranslator.FromHtml("#" + colorNameResult.Data); excelColor.R = color.R; excelColor.G = color.G; excelColor.B = color.B; } return(excelColor); } return(baseEntity); }
private IResult HelpGetConfig (Data data, IExcelWorksheetEntity tmpEntity) { IResult result = new Result() { Success = false }; IDataResult <string> tmpDataResultValue = _readExcelData.GetValue(tmpEntity); string nameTitle = tmpDataResultValue.Data; nameTitle = _dataNormalization.NormalizeString(nameTitle).Data; string congiTitle = _dataNormalization.NormalizeString(data.Name).Data; if (congiTitle.Equals(nameTitle)) { result.Success = true; } return(result); }
public IDataResult <IColumnItem> ColumnParser (IExcelWorksheetEntity excelWorksheet, ExcelConfiguration excelConfiguration) { IDataResult <IColumnItem> dataResult = new DataResult <IColumnItem>() { Success = false }; IColumnItem columnItem = new ColumnItem(); int column = excelWorksheet.CellNo; IDataResult <string> resultValue = _readExcelData.GetValue(excelWorksheet); int nomertitle = excelConfiguration.DataRowIndex.Title; IExcelWorksheetEntity tmpExcel = new ExcelWorksheetEntity(); tmpExcel.RowNo = nomertitle; tmpExcel.ExcelWorksheet = excelWorksheet.ExcelWorksheet; tmpExcel.CellNo = column; string nameTitle = _readExcelData.GetValue(tmpExcel).Data; string configNameSection = excelConfiguration.DataColumn.Datas .FirstOrDefault(p => p.ColumnType == (int)ColumnType.Section)?.Name; configNameSection = _dataNormalization.NormalizeString(configNameSection).Data; columnItem.BaseEntity = new BaseEntity(); bool isResult = false; foreach (var data in excelConfiguration.DataColumn.Datas) { if (column == data.Nomer) { if (!resultValue.Success) { if (data.MustExist) { dataResult.Message += resultValue.Message; } } columnItem.ColumnType = (ColumnType)data.ColumnType; columnItem.BaseEntity = GetBaseEntity (excelWorksheet, resultValue.Data, column, excelConfiguration); isResult = true; } } if (!isResult) { nameTitle = _dataNormalization.NormalizeString(nameTitle).Data; if (nameTitle == null) { //TODO dataResult.Success = true; return(dataResult); } if (nameTitle.Contains(configNameSection)) { columnItem.ColumnType = ColumnType.SectionTransfer; nameTitle = nameTitle.Replace(configNameSection, string.Empty); } else { columnItem.ColumnType = ColumnType.WorldSection; } dataResult.Message += resultValue.Message; string language = LanguageHolder.GetISOCodes(nameTitle, _dataNormalization); ITranslationEntity entity = new TranslationEntity(); entity.Language = language; entity.Value = resultValue.Data; columnItem.BaseEntity = entity; } columnItem.ColumNumber = column; dataResult.Data = columnItem; dataResult.Success = true; return(dataResult); }
public IDataResult <IColumnItem> ColumnParser (IExcelWorksheetEntity worksheetEntity, ExcelConfiguration excelConfiguration) { IDataResult <IColumnItem> dataResult = new DataResult <IColumnItem>() { Success = false }; IColumnItem columnItem = new ColumnItem(); int column = worksheetEntity.CellNo; IDataResult <string> resultValue = _readExcelData.GetValue(worksheetEntity); int nomertitle = excelConfiguration.DataRowIndex.Title; if (!resultValue.Success) { dataResult.Message = resultValue.Message; } IExcelWorksheetEntity tmpExcel = new ExcelWorksheetEntity(); tmpExcel.RowNo = nomertitle; tmpExcel.ExcelWorksheet = worksheetEntity.ExcelWorksheet; tmpExcel.CellNo = column; IDataResult <string> resultNameTitle = _readExcelData.GetValue(tmpExcel); if (!resultNameTitle.Success) { dataResult.Message = MessageHolder.GetErrorMessage(MessageType.NotNameTitle); } string nameTitle = resultNameTitle.Data; nameTitle = _dataNormalization.NormalizeString(nameTitle).Data; string titleConfig = excelConfiguration.DataColumn.Datas? .FirstOrDefault(p => p.ColumnType == (int)ColumnType.Section)?.Name; titleConfig = _dataNormalization.NormalizeString(titleConfig).Data; ITranslationEntity translationEntity = new TranslationEntity(); translationEntity.Value = resultValue.Data; string mainLanguage = excelConfiguration.NameColumnSection.MainLanguage; mainLanguage = _dataNormalization.NormalizeString(mainLanguage).Data; string excelLanguage = null; if (titleConfig != null) { excelLanguage = nameTitle.Replace(titleConfig, string.Empty); } if (nameTitle.Equals(titleConfig) || (excelLanguage != null && excelLanguage.Equals(mainLanguage))) { columnItem.ColumnType = ColumnType.Section; translationEntity.Language = LanguageHolder.GetISOCodes(mainLanguage, _dataNormalization); if (!resultValue.Success) { dataResult.Message = resultValue.Message; return(dataResult); } columnItem.BaseEntity = translationEntity; } else { columnItem.ColumnType = ColumnType.SectionTransfer; translationEntity.Language = LanguageHolder.GetISOCodes(excelLanguage, _dataNormalization); if (!resultValue.Success) { dataResult.Message = resultValue.Message; return(dataResult); } columnItem.BaseEntity = translationEntity; } dataResult.Data = columnItem; dataResult.Success = true; return(dataResult); }