public ReProcessEntry(AddOnDataToReProcess parent, Guid id, String nameId,
DateTime? dBTimeStampToConfirm, DateTime? fileTimeStampToConfirm)
{
Id = id;
NameId = nameId;
Parent = parent;
Position = Parent.EntriesToReProcess.Count + 1;
if (dBTimeStampToConfirm != null)
DBTimeStampToConfirm = dBTimeStampToConfirm;
if (fileTimeStampToConfirm != null)
FileTimeStampToConfirm = fileTimeStampToConfirm;
LastModifiedTimeToUse = dBTimeStampToConfirm;
}
public ObservableCollection<AddOnDataToReProcess> LoadTestEntriesToReProcess
(ObservableCollection<AddOnDataToReProcess> listOfWPMediaAddOnDataToReProcess)
{
listOfWPMediaAddOnDataToReProcess.Clear();
if (Application.Current.Properties.Contains("TestEntries"))
{
Dictionary<String,Dictionary<Guid,String>> testEntries = (Dictionary<String, Dictionary<Guid, String>>) Application.Current.Properties["TestEntries"];
foreach (string tableKey in testEntries.Keys)
{
AddOnDataToReProcess newInfoTestTableEntry = new AddOnDataToReProcess(this,
Data.DbServer3.MultiMedia.MMUnitTypen.Find_By_Name(tableKey));
if (tableKey == "Beitraege")
newInfoTestTableEntry.CsTableToProcess = Data.DbServer3.WPMedia
.GetTableByName(tableKey);
else
newInfoTestTableEntry.CsTableToProcess = Data.DbServer3.WPMediaAddOnData
.GetTableByName (tableKey);
newInfoTestTableEntry.Activate(true);
newInfoTestTableEntry.EntriesToReProcess = new ObservableCollection<ReProcessEntry>();
foreach(Guid entryKey in testEntries[tableKey].Keys)
{
newInfoTestTableEntry.EntriesToReProcess.Add(new ReProcessEntry(newInfoTestTableEntry,
entryKey, testEntries[tableKey][entryKey], DateTime.Now, null)
{
RecreationRequired = true
});
}
listOfWPMediaAddOnDataToReProcess.Add(newInfoTestTableEntry);
}
return listOfWPMediaAddOnDataToReProcess;
}
AddOnDataToReProcess newWohnParkInfoTestEntry = new AddOnDataToReProcess(this);
newWohnParkInfoTestEntry.MMUnitTypToProcess = Data.DbServer3.MultiMedia
.MMUnitTypen.Find_By_Name("KaufParkWerbung");
newWohnParkInfoTestEntry.EntriesToReProcess = new ObservableCollection<ReProcessEntry>()
{
new ReProcessEntry(newWohnParkInfoTestEntry, Guid.Parse("BBB16454-1B26-44AA-9A72-EB7D3C27D8CE"),
"KP_2016_03 - Kaufparkverein - Verein der Kaufleute", null, null)
};
newWohnParkInfoTestEntry.CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName
(newWohnParkInfoTestEntry.MMUnitTypToProcess.TypNameId);
listOfWPMediaAddOnDataToReProcess.Add(newWohnParkInfoTestEntry);
return listOfWPMediaAddOnDataToReProcess;
/*
AddOnDataToReProcess newSportTestEntry = new AddOnDataToReProcess(this);
newSportTestEntry.MMUnitTypToProcess = Data.DbServer3.WPMediaAddOnData.TableDefinitions.Find_via_TableName("AEAGSport");
newSportTestEntry.ReProcessEntriesToProcess = new ObservableCollection<ReProcessEntry>()
{
new ReProcessEntry(newSportTestEntry, Guid.Parse("4EFC0CE8-FF86-4D6E-8F63-51C5FA5A01AA"), "SportBelegung",
null, null)
};
newSportTestEntry.CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName
(newSportTestEntry.MMUnitTypToProcess.TableName);
AddOnDataToReProcess newWellnessTestEntry = new AddOnDataToReProcess(this);
newWellnessTestEntry.MMUnitTypToProcess = Data.DbServer3.WPMediaAddOnData.TableDefinitions.Find_via_TableName("AEAGWellness");
newWellnessTestEntry.ReProcessEntriesToProcess = new ObservableCollection<ReProcessEntry>()
{
new ReProcessEntry(newWellnessTestEntry, Guid.Parse("8BC50B75-B9C6-41CF-87F0-5FBB88086EDD"), "WellnessBelegung",
null, null)
};
newWellnessTestEntry.CsTableToProcess = Data.DbServer3.WPMediaAddOnData.GetTableByName
(newWellnessTestEntry.MMUnitTypToProcess.TableName);
listOfWPMediaAddOnDataToReProcess.Add(newSportTestEntry);
listOfWPMediaAddOnDataToReProcess.Add(newWellnessTestEntry);
return listOfWPMediaAddOnDataToReProcess;
*/
}
public void GetListOfTableEntriesToProcess(ObservableCollection<AddOnDataToReProcess>
ListOfWPMediaAddOnDataToReProcess, List<String> desiredFunction)
{
ListOfWPMediaAddOnDataToReProcess.Clear();
StatusCollector CollectNewUnits = new StatusCollector(this);
if (desiredFunction.Contains("Test"))
{
LoadTestEntriesToReProcess(ListOfWPMediaAddOnDataToReProcess);
CollectNewUnits.CollectTableEntriesForLaterProcessing(ListOfWPMediaAddOnDataToReProcess, 150);
return;
}
List<MMUnitTyp> mmUnitTypsToProcess = new List<MMUnitTyp>();
mmUnitTypsToProcess = Data.DbServer3.MultiMedia
.MMUnitTypen.Collection.Where(sel =>
sel.Redaktion == "StandBild"
|| sel.Redaktion == "Banner"
|| sel.Redaktion == "Video").ToList();
if ((desiredFunction.Count == 0)
|| (desiredFunction.Contains("Load")))
{
foreach (MMUnitTyp mmUnitTypToProcess in mmUnitTypsToProcess.OrderBy(ord => ord.TypNameId))
{
AddOnDataToReProcess newEntry = new AddOnDataToReProcess
(this, mmUnitTypToProcess);
ListOfWPMediaAddOnDataToReProcess.Add(newEntry);
newEntry.Activate(true);
}
return;
}
foreach (MMUnitTyp mmUnitTypToProcess in mmUnitTypsToProcess.OrderBy(ord => ord.TypNameId))
{
AddOnDataToReProcess newEntry = new AddOnDataToReProcess
(this, mmUnitTypToProcess);
ListOfWPMediaAddOnDataToReProcess.Add(newEntry);
if (desiredFunction.Contains("Actualize"))
{
newEntry.Activate(true);
continue;
}
if (desiredFunction.Contains(mmUnitTypToProcess.TypNameId))
{
newEntry.Activate(true);
}
else
{
newEntry.Activate(false);
}
}
CollectNewUnits.CollectTableEntriesForLaterProcessing(ListOfWPMediaAddOnDataToReProcess, 150);
}
private void DoCompletenessCheck(AddOnDataToReProcess addOnDataToReProcess)
{
String ProtokollDirectory = "\\\\WebServer2\\WPMediaSender\\Temp\\WPMediaCompletenessCheck";
if (!Directory.Exists(ProtokollDirectory))
Directory.CreateDirectory(ProtokollDirectory);
MMUnitTyp mmUnitTypToProcess = addOnDataToReProcess.MMUnitTypToProcess;
StreamWriter Protokoll = new StreamWriter(File
.Create(Path.Combine(ProtokollDirectory, mmUnitTypToProcess.TypNameId + ".Log")));
CsDbTable dynamicTable = null;
switch (mmUnitTypToProcess.Redaktion)
{
case "Banner":
case "StandBild":
dynamicTable = Data.DbServer3.WPMediaAddOnData.GetTableByName(mmUnitTypToProcess.TypNameId);
break;
case "Video":
dynamicTable = Data.DbServer3.WPMedia.GetTableByName(mmUnitTypToProcess.TypNameId);
break;
}
dynamicTable.Generic_DownloadRows($"Select {dynamicTable.DefaultSqlSelector} from {mmUnitTypToProcess.TypNameId} ");
dynamicTable.HasBeenLoaded = true;
Protokoll.WriteLine($"Anzahl Rows in {mmUnitTypToProcess.TypNameId} = {dynamicTable.Rows.Count}");
DbEntities.dbserver3.wpmediaaddondata.rows.Timing[] AllTimings
= Data.DbServer3.WPMediaAddOnData.Timings.Load_Via_ConnectedType(mmUnitTypToProcess.TypNameId);
Protokoll.WriteLine($"Anzahl Timings in Timings = {AllTimings.Length}");
MMUnit[] AllMMUnits = Data.DbServer3.MultiMedia.MMUnits.Collection
.Where(sel => sel.ForeignUnitTypId == mmUnitTypToProcess.Id).ToArray();
Protokoll.WriteLine($"Anzahl der MMUnits = {AllMMUnits.Length}");
Protokoll.WriteLine("");
Protokoll.Close();
dynamicTable.HasBeenLoaded = false;
}
public bool? ReConvertAllConnectedForeignEntries(Guid informationId)
{
DoStartup();
ListOfAddOnDataToReProcessInstance.Clear();
if (!Data.DbServer3.AltErlaaInfo.PreLoadAddOnsForOneInformation(informationId))
return false;
List<Guid> MMUnitIdsToProcess = new List<Guid>();
foreach (ProcessConnector connector in Data.DbServer3.AltErlaaInfo.ProcessConnectoren.Collection
.Where(sel => sel.InformationenId == informationId))
{
if ((String.IsNullOrEmpty(connector.TableName))
|| (connector.TableId == null)
|| (connector.TableId == Guid.Empty))
continue;
if ((connector.TableName == "Beitraege")
// || (connector.TableName == "BannerData")
|| (connector.TableName == "ButtonData"))
continue;
AddOnDataToReProcess addOnDataToReProcess = new AddOnDataToReProcess
(this, Data.DbServer3.MultiMedia.MMUnitTypen.Find_By_Name(connector.TableName));
addOnDataToReProcess.IsBatchRun = false;
CsDbRowBase Helper = addOnDataToReProcess.CsTableToProcess.Generic_FindOrLoad(connector.TableId);
ReProcessEntry newReProcessEntry = new ReProcessEntry(addOnDataToReProcess,
(Guid)connector.TableId, Helper["NameId"].ToString() , Convert.ToDateTime(Helper["ModifyTimeStamp"]), null);
addOnDataToReProcess.EntriesToReProcess.Add(newReProcessEntry);
MMUnitIdsToProcess.Add(newReProcessEntry.Id);
ListOfAddOnDataToReProcessInstance.Add(addOnDataToReProcess);
}
if (MMUnitIdsToProcess.Count > 0)
Data.DbServer3.MultiMedia.PreLoadAllForAllMMUnits(MMUnitIdsToProcess);
if (Data.DbServer3.MultiMedia.GetChanges() != null)
throw new Exception("Data.DbServer3.MultiMedia.GetChanges() != null");
foreach (AddOnDataToReProcess addOnDataToReProcess in
ListOfAddOnDataToReProcessInstance)
{
addOnDataToReProcess.LastCheckedTime = DateTime.Now;
addOnDataToReProcess.SummOfProcessingDurations = 0;
new StandBildConversion().ConvertToMMUnits(addOnDataToReProcess, false);
//(new TimingsConversion()).CheckAndCorrectWPMediaAddOnDataTimings
// (addOnDataToReProcess.ReProcessEntriesToProcess.Select(sel => sel.Id).ToList());
(new InformationConversion()).CheckOrCreateWPMediaAddOnDataDummyInformation
(addOnDataToReProcess.EntriesToReProcess.Select(sel => sel.Id).ToList());
addOnDataToReProcess.SetAllProcessingDone();
}
ClearAllConnectedForAllMMUnitLocally(MMUnitIdsToProcess);
return false;
}