public void LoadNewConfigurations(string path)
{
_changedFlag = false;
PageList.Clear();
_excel = ImportExcel.Instance;
_excel.ImportExcelConfiguration(path);
if (_excel.ImportFileOK)
{
ObservableCollection<PageType> tempList = GetAllPages();
GroupList = GetAllGroups();
ItemTypeOrderList = GetAllItems();
LinkCollections(tempList, GroupList, ItemTypeOrderList);
foreach (PageType page in tempList)
{
PageList.Add(page);
}
_groupCounter = 0;
int index = 0;
while (index < WorkSheetktResources.Instance.ktResourceList.Count)
{
if (Convert.ToInt32(WorkSheetktResources.Instance.ktResourceList[index].ResourceID) > _groupCounter)
{
_groupCounter = Convert.ToInt32(WorkSheetktResources.Instance.ktResourceList[index].ResourceID);
}
index++;
}
}
}
public void LoadWorkspace(string path)
{
_changedFlag = false;
ImportExcel.Instance = null;
_excel = ImportExcel.Instance;
_excel.ImportExcelFromFile(path);
if (_excel.ImportFileOK)
{
PageList = GetAllPages();
GroupList = GetAllGroups();
ItemTypeOrderList = GetAllItems();
LinkCollections(PageList, GroupList, ItemTypeOrderList);
_groupCounter = 0;
int index = 0;
while (index < WorkSheetktResources.Instance.ktResourceList.Count)
{
if (Convert.ToInt32(WorkSheetktResources.Instance.ktResourceList[index].ResourceID) > _groupCounter)
{
_groupCounter = Convert.ToInt32(WorkSheetktResources.Instance.ktResourceList[index].ResourceID);
}
index++;
}
}
else
{
MessageBox.Show("Fil ikke importeret");
}
PageTypeItemsView = CollectionViewSource.GetDefaultView(PageList);
PageTypeItemsView.Filter = ItemFilter;
PageTypeItemsView.Refresh();
}
public void Initialize()
{
_importPath = System.IO.Path.Combine(Environment.CurrentDirectory, @"Ressources\Configuration.xlsx");
_exportPath = System.IO.Path.Combine(Environment.CurrentDirectory, @"Ressources\UnitTest.xlsx");
_wvm = WorkspaceViewModel.Instance;
_groupTableVm = new GroupTableViewModel();
_wvm.LoadWorkspace(_importPath);
_impExcel = ImportExcel.Instance;
_exExcel = TreatPraktik.ViewModel.ExportExcel.Instance;
//Get original lists of worksheets
_oldExGroup = (from a in _impExcel._workSheetktExaminedGroup.ExaminedGroupList
select new ktExaminedGroup
{
DataQualityScore = a.DataQualityScore,
Expanded = a.Expanded,
GroupExpendable = a.GroupExpendable,
GroupIdentifier = a.GroupIdentifier,
GroupType = a.GroupType,
ID = a.ID,
Name = a.Name,
RequiredScore = a.RequiredScore
}).ToList();
_oldGroupOrder = (from a in _impExcel._workSheetktUIGroupOrder.ktUIGroupOrderList
select new ktUIGroupOrder
{
DepartmentID = a.DepartmentID,
GroupOrder = a.GroupOrder,
GroupTypeID = a.GroupTypeID,
PageTypeID = a.PageTypeID
}).ToList();
_oldOrder = (from a in _impExcel._workSheetktUIOrder.ktUIOrderList
select new ktUIOrder
{
DesignID = a.DesignID,
GroupOrder = a.GroupOrder,
GroupTypeID = a.GroupTypeID,
IncludedTypeID = a.IncludedTypeID,
PageTypeID = a.PageTypeID
}).ToList();
_oldResources = (from a in _impExcel._workSheetktResources.ktResourceList
select new ktResources
{
ResourceID = a.ResourceID,
ResourceResxID = a.ResourceResxID,
ResourceTypeID = a.ResourceTypeID
}).ToList();
_oldResTranslation = (from a in _impExcel._workSheetktResourceTranslation.ktResourceTranslationList
select new ktResourceTranslation
{
LanguageID = a.LanguageID,
ResourceID = a.ResourceID,
TranslationText = a.TranslationText
}).ToList();
}