public void ConvertToMMUnits(bool dynamicOrStatic)
{
Data.DbServer3.MultiMedia.LoadAll_IfHasNotBeenLoaded();
if (dynamicOrStatic)
allOldButton = Data.DbServer3.WPMediaAddOnData.ButtonDatas.Load_All()
.Where(whe => whe.EntryType == "Entry"
|| String.IsNullOrEmpty(whe.EntryType)).ToArray();
else
allOldButton = Data.DbServer3.WPMediaAddOnData.ButtonDatas.Load_All()
.Where(whe => whe.EntryType == "StaticEntry"
|| String.IsNullOrEmpty(whe.EntryType)).ToArray();
Data.DbServer3.WPMediaAddOnData.ButtonDatas.HasBeenLoaded = true;
mmUnitTypForButtonData = Data.DbServer3.MultiMedia.MMUnitTypen.Find_By_Name("ButtonData");
mmUnitTypForButtonDataStatic = Data.DbServer3.MultiMedia.MMUnitTypen.Find_By_Name("ButtonDataStatic");
ButtonData startingButton = allOldButton.Where(whe =>
whe.ParentId != null && whe.ParentId == Guid.Empty).FirstOrDefault();
List<Guid> allOldIds = allOldButton.Select(sel => sel.Id).Distinct().ToList<Guid>();
MMUnit[] allOldButtons = Data.DbServer3.MultiMedia.PreloadAllForAllPlayerMMUnits(allOldIds);
foreach (MMUnit oldButton in allOldButtons.ToArray())
oldButton.Delete(false);
Data.DbServer3.MultiMedia.SaveKatabolic(new Object());
Data.DbServer3.MultiMedia.AcceptChanges();
Data.DbServer3.MultiMedia.Pages.HasBeenLoaded = true;
ConvertToMMUnitsLoop(startingButton, null, 0);
Debug.WriteLine($"insgesamt {LoopCounter} Durchläufe");
foreach (int key in EntriesPerLevel.Keys.OrderBy(ord => ord))
{
Debug.WriteLine($"für den Level {key} wurden {EntriesPerLevel[key]} Entries gezählt");
}
Data.DbServer3.MultiMedia.Texts.HasBeenLoaded = true;
Data.DbServer3.MultiMedia.Links.HasBeenLoaded = true;
Data.DbServer3.MultiMedia.Images.HasBeenLoaded = true;
Data.DbServer3.MultiMedia.Videos.HasBeenLoaded = true;
Data.DbServer3.MultiMedia.SaveAnabolic(new Object());
Data.DbServer3.MultiMedia.AcceptChanges();
Debug.WriteLine($"Root Entry Einträge:");
foreach (MMUnit mmUnit in Data.DbServer3.MultiMedia.MMUnits
.Where(whe => whe.MMUnitTyp == mmUnitTypForButtonData))
{
MMUnitExtensions.DebugMMUnit(mmUnit);
}
Debug.WriteLine($"Root StaticEntry Einträge:");
foreach (MMUnit mmUnit in Data.DbServer3.MultiMedia.MMUnits
.Where(whe => whe.MMUnitTyp == mmUnitTypForButtonDataStatic))
{
MMUnitExtensions.DebugMMUnit(mmUnit);
}
}
public void LoadButtonBasics()
{
if (MultiMediaDb == null)
return;
if (mmUnitTypForButtonData == null)
mmUnitTypForButtonData = MultiMediaDb.MMUnitTypen.Find_By_Name("ButtonData");
if (mmUnitTypForButtonDataStatic == null)
mmUnitTypForButtonDataStatic = MultiMediaDb.MMUnitTypen.Find_By_Name("ButtonDataStatic");
if ((mmUnitTypForButtonData == null)
|| (mmUnitTypForButtonDataStatic == null))
return;
_listOfRootButton = MultiMediaDb.MMUnits.Find_By_TypId(mmUnitTypForButtonData.Id).ToArray();
_listOfStaticButton = MultiMediaDb.MMUnits.Find_By_TypId(mmUnitTypForButtonDataStatic.Id).ToArray();
ListOfActivePages = ListOfRootPages;
}
public AddOnDataToReProcess(MMUnitTyp mmUnitTypToProcess, ObservableCollection<ReProcessEntry> entriesToReProcess)
{
MMUnitTypToProcess = mmUnitTypToProcess;
EntriesToReProcess = entriesToReProcess;
CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName(MMUnitTypToProcess.TypNameId);
}
public AddOnDataToReProcess(DataConversion parent, MMUnitTyp mmUnitTypToProcess)
{
MMUnitTypToProcess = mmUnitTypToProcess;
switch (mmUnitTypToProcess.Redaktion)
{
case "StandBild":
CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName(MMUnitTypToProcess.TypNameId);
break;
case "Banner":
CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName(MMUnitTypToProcess.TypNameId);
TitelColumnName = "Text";
break;
case "Video":
CsTableToProcess = Data.DbServer3.WPMedia.GetTableByName(MMUnitTypToProcess.TypNameId);
IdColumnName = "BeitragId";
NameIdColumnName = "Name";
TitelColumnName = "ShortDescription";
break;
default:
throw new Exception($"Wrong mmUnitTypToProcess.Redaktion {mmUnitTypToProcess.Redaktion}");
}
Parent = parent;
}
private void ImportWPMediaAddOnDataMMElemente(MMUnitTyp mmUnitTyp, Guid mMUnitId,
DataRow tableContentRow, String[] columnNamens)
{
TableDefinition tableDefinition =
Data.DbServer3.WPMediaAddOnData.TableDefinitions.Find_via_TableName(mmUnitTyp.TypNameId);
if (tableDefinition.PageFactoryParameter.Contains("DefaultKarteiPage01,"))
ImportStandardKartei(tableDefinition, mMUnitId, tableContentRow, columnNamens);
else
if (tableDefinition.PageFactoryParameter == "SimpleTextPage")
{
if (tableDefinition.TableName == "ButtonData")
ImportButtonData(tableDefinition, mMUnitId, tableContentRow, columnNamens);
if (tableDefinition.TableName == "BannerData")
ImportBannerData(tableDefinition, mMUnitId, tableContentRow, columnNamens);
}
else
if (tableDefinition.PageFactoryParameter.Contains("WellnessSaunaAToday;"))
{
if (tableDefinition.TableName == "AEAGWellness")
ImportAEAGWellness(tableDefinition, mMUnitId, tableContentRow, columnNamens);
}
else
if (tableDefinition.PageFactoryParameter.Contains("TennisToday;"))
{
if (tableDefinition.TableName == "AEAGSport")
ImportAEAGSport(tableDefinition, mMUnitId, tableContentRow, columnNamens);
}
}
private void ImportMMElemente(MMUnitTyp mmUnitTyp, Guid mMUnitId,
DataRow tableContentRow, String[] columnNamens)
{
switch (mmUnitTyp.Redaktion)
{
case "Banner":
case "StandBild":
ImportWPMediaAddOnDataMMElemente(mmUnitTyp, mMUnitId,
tableContentRow, columnNamens);
break;
case "Video":
throw new Exception($"ImportWPMediaMMElemente(mmUnitTyp, mMUnitId, " +
$"tableContentRow, columnNamens); ");
break;
default:
throw new Exception($"{mmUnitTyp.TypNameId} is not legal");
}
}
public TypedMMUnitModell(MMUnitTyp unitTyp, Information information)
{
UnitTyp = unitTyp;
UnitTypId = UnitTyp.Id;
Information = information;
}
private String GetNameIDForAddOnDataId(MMUnitTyp tableDefinition, Guid Id)
{
DataTable EntriesToSearchFor = Data.DbServer3.WPMediaAddOnData.DbProxy.ExecuteCommand
($"select Id, NameId from {tableDefinition.TypNameId} where Id = '{Id}'");
if (EntriesToSearchFor.Rows.Count == 0)
return String.Empty;
return EntriesToSearchFor.Rows[0]["NameId"].ToString();
}
