private void AddEntryExcelB()
{
MyCollectionB.Add(AddExcelB);
MyCollectionBMains = new ObservableCollection <String>(_manager.LoadCollectionBMains(MyCollectionB.ToList()));
_manager.StoreCollectionB(MyCollectionB.ToList());
AddExcelB = new ExcelB();
}
private void InitValuesAndCollections()
{
// IMPOTANT: The order of these is essential as the last attributes are calling command on set()
_manager = new ExcelManager();
AddExcelA = new ExcelA();
AddExcelB = new ExcelB();
MyCollectionA = new ObservableCollection <ExcelA>();
MyCollectionExcelAValue12 = new ObservableCollection <String>();
MyCollectionB = new ObservableCollection <ExcelB>();
MyCollectionC = new ObservableCollection <ExcelC>();
MonthComboboxSource = Constants.Months;
SelectedMonth = Constants.getCurrentDateMonth();
}
public List <ExcelB> LoadCollectionExcelB()
{
try
{
slDocExcelB = new SLDocument("ExcelB.xlsx");
}
catch (System.IO.FileNotFoundException e)
{
slDocExcelB = new SLDocument();
slDocExcelB.SaveAs("ExcelB.xlsx");
slDocExcelB = new SLDocument("ExcelB.xlsx");
}
catch (System.IO.IOException f)
{
throw f;
}
List <ExcelB> tempList = new List <ExcelB>();
for (int i = 2; i < 80; i++)
{
ExcelB temp = new ExcelB();
temp.Val3Main = slDocExcelB.GetCellValueAsString("B" + i.ToString());
temp.Val4 = slDocExcelB.GetCellValueAsString("C" + i.ToString());
temp.Val5 = slDocExcelB.GetCellValueAsString("D" + i.ToString());
if (string.IsNullOrEmpty(temp.Val3Main)) // Check for ID is not empty
{
break;
}
else
{
tempList.Add(temp);
}
}
return(tempList);
}