private void LoadFileIntoDataTable()
{
if (File.Exists(_FileName))
{
string fileType = _FileName.Substring(_FileName.LastIndexOf(".") + 1);
switch (fileType.ToLower())
{
case "csv":
string csvText = Utilities.readFile(_FileName);
_UploadedSheetTable = CsvParser.Parse(csvText);
break;
case "xls":
case "xlsx":
case "xlsm":
_UploadedSheetTable = ExcelParser.Parse(_FileName);
break;
case "pdf":
_UploadedSheetTable = PDFParser.Parse(_FileName);
break;
default:
break;
}
}
if (_UploadedSheetTable == null)
{
throw new Exception("There was an issue converting the file to a data table.");
}
}
public async Task <JsonResult> Add(string date)
{
try
{
var localFile = Server.MapPath(Core.Helper.GetLocalFile(date));
if (System.IO.File.Exists(localFile))
{
var data = await ExcelParser.Parse(localFile);
var count = data.Count();
if (count > 0)
{
await repository.Add(data, date);
}
return(Json(new { success = true, count = data.Count() }));
}
else
{
return(Json(new { success = false, message = "Файл не найден, скачайте его" }));
}
}
catch (Exception ex)
{
Logger logger = LogManager.GetCurrentClassLogger();
logger.Error("Date: {0} {1} \n {2}", date, ex.Message, ex);
}
return(Json(new { success = false, message = "При обработке файла произошла ошибка, обратитесь к разработчикам" }));
}
public void ParseAllFunds()
{
var parser = new ExcelParser("etfbook.xlsx", 0, new EtfConverterFactory());
var funds = parser.Parse();
var fundsRepository = new FundRepository();
fundsRepository.AddOrUpdate(funds);
}
private async void LoadData()
{
OpenFileDialog fileDialog = new OpenFileDialog();
fileDialog.ShowDialog();
FileName = fileDialog.FileName;
ExpenseData.Clear();
//YearWiseExpenses.Clear();
IList <Expense> Result = await ExcelParser.Parse(FileName);
await ExpenseQueryHandler.GetDBConnector().ImportDataBase(Result);
PopulateData();
}
private void btnOrderLoader_Click(object sender, RoutedEventArgs e)
{
if (this.fileName != string.Empty && this.filePath != string.Empty)
{
var reportsFolder = this.filePath + defaultFolder;
var fileExtension = "*.xls";
var files = new List <string>();
ReportFinder.TraverseDirectory(reportsFolder, fileExtension, files);
var productsSheet = "Products";
var orderSheet = "Order";
var loadedComplete = true;
foreach (var file in files)
{
var result = ExcelParser.Parse(file, productsSheet, orderSheet);
if (!result)
{
loadedComplete = false;
}
}
if (loadedComplete)
{
MessageBox.Show("Successfully loaded the orders!",
"Loaded successfully",
MessageBoxButton.OK,
MessageBoxImage.Information);
}
else
{
MessageBox.Show("One or more orders cannot be loaded!",
"Loaded failed",
MessageBoxButton.OK,
MessageBoxImage.Error);
}
}
else
{
MessageBox.Show("There is no zip archive chosen!",
"Warning",
MessageBoxButton.OK,
MessageBoxImage.Warning);
}
}
public void Parse_CorrectDocument_WorksOk(string culture)
{
var cultureInfo = new CultureInfo(culture);
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
string filePath = Path.Combine(TestContext.CurrentContext.TestDirectory, "Parser", "ItemsToParse.xlsx");
List <ItemToParse> items;
using (var parser = new ExcelParser <ItemToParse>(filePath))
{
items = parser.Parse(true);
}
items.Count.Should().Be(3);
items[0].Number.Should().Be(1);
items[0].Description.Should().Be("description one");
items[0].Created.Should().Be(new DateTime(2018, 2, 3));
Math.Round(items[0].Sum, 2).Should().Be(33000.66M);
}
static public void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("Files/DataConsolidationExchange_v1_17-06-2016_LightSearchData.xlsx", 0, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
static public void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("etfbookSmallData.xlsx", 0, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
public static void ParseAllFundsFromFile(TestContext testContext)
{
var parser = new ExcelParser("Files/FullLightSearch_010716.xlsx", 2, new EtfConverterExcelFactory());
_allFunds = parser.Parse();
}
