public void StoreData(ExcelModel excelModel, List <string> prices, List <string> itemNumbers)
{
int dayNumber = 1;
if (FreeColumn > 0)
{
dayNumber = int.Parse(excelModel.ReadCell(0, FreeColumn - 2)) + 1;
}
excelModel.WriteToCell(0, FreeColumn, dayNumber.ToString());
for (int i = 0; i < prices.Count; i++)
{
excelModel.WriteToCell(i + 1, FreeColumn, prices[i]);
}
for (int i = 0; i < itemNumbers.Count; i++)
{
excelModel.WriteToCell(i + 1, FreeColumn + 1, itemNumbers[i]);
}
excelModel.Save();
}
public ExcelModel CreateNewExcelFile(string fileName)
{
ExcelModel output = new ExcelModel();
output.CreateNewFile();
//output.CreateNewSheet();
string currentDirectory = Directory.GetCurrentDirectory();
output.SaveAs($@"{currentDirectory}\StorageFiles\{fileName}.xlsx");
return(output);
}
private void FindOpenColumn(ExcelModel excelModel)
{
int count = 0;
bool valid = false;
while (valid == false)
{
if (excelModel.ReadCell(0, count) == "")
{
valid = true;
}
else
{
count += 2;
}
}
FreeColumn = count;
}
public StorageManager(ExcelModel excelModel)
{
FindOpenColumn(excelModel);
}
