private void DataDependencyToWorkForChanged(DataDependency OldValue,
DataDependency NewValue)
{
if (NewValue == null)
return;
CommonProfileModellInstance.Profile.ActiveTableDefinition
= CommonProfileModellInstance.Profile.DbDataContext.WPMediaAddOnData.TableDefinitions
.Find_via_TableName(NewValue.DataElementeTemplate.PhysicalDataElement.TabellenName);
}
private DataCollection<UseForRootDataTemplates> LoadAvailableUseForRootDataTemplatesForSelectedDataDependencyEntry
(DataDependency Selected)
{
DataCollection<UseForRootDataTemplates> Result = new DataCollection<UseForRootDataTemplates> ();
foreach (Guid EntryGuid in AssignedUseForRootDataTemplates.Keys)
foreach (UseForRootDataTemplates Entry in AssignedUseForRootDataTemplates [EntryGuid])
if (Entry.DataDependencyID == Selected.Id)
Result.Add(Entry);
return Result;
}
public InformationAddOn InsertNew(Information informationToCreateFor,
DataDependency dataDependencyToCreateFor, String userName = "******")
{
InformationAddOn newAddOn = DataContext.AltErlaaInfo.InformationenAddOns.NewRow();
newAddOn.Id = Guid.NewGuid();
newAddOn.InformationenId = informationToCreateFor.Id;
newAddOn.ActuallBezeichner = dataDependencyToCreateFor.ActuallBezeichner;
newAddOn.Tabelle = dataDependencyToCreateFor.DataElementeTemplate.PhysicalDataElement.TabellenName;
int? SortOrder = informationToCreateFor.Get_LastUsedSortOrder(dataDependencyToCreateFor);
if ((SortOrder == null)
|| (SortOrder == 0))
newAddOn.SortOrder = dataDependencyToCreateFor.SortOrder;
else
newAddOn.SortOrder = (int)SortOrder + 1;
newAddOn.CreatedBy = userName;
newAddOn.HasBeenProcessedBefore = null;
newAddOn.ModifyTimeStamp = informationToCreateFor.ModifyTimeStamp;
newAddOn.DataDependency = dataDependencyToCreateFor;
newAddOn.Table.Rows.Add(newAddOn);
return newAddOn;
}
private void RemoveDataDependencyFromRootDataTemplates (RootDataTemplate rootDataTemplatesFromWhichTheEntryShouldBeRemoved,
DataDependency entryToRemove)
{
UseForRootDataTemplate useForUsage = Data.DbServer3.AltErlaaInfo.UseForRootDataTemplates.Where(sel =>
sel.RootDataTemplatesId == rootDataTemplatesFromWhichTheEntryShouldBeRemoved.Id
&& sel.DataDependencyId == entryToRemove.Id).FirstOrDefault();
if (useForUsage != null)
useForUsage.Delete();
UseFor useForAssignement = Data.DbServer3.AltErlaaInfo.UseFors.Where(sel =>
sel.DataDependencyId == entryToRemove.Id
&& sel.RootDataTemplatesId == rootDataTemplatesFromWhichTheEntryShouldBeRemoved.Id).FirstOrDefault();
if (useForAssignement != null)
useForAssignement.Delete();
}
private void RemoveDataDependencyFromTyp (Typ typFromWhichTheEntryShouldBeRemoved, DataDependency entryToRemove)
{
UseForTyp useForUsage = Data.DbServer3.AltErlaaInfo.UseForTypen.Where(sel =>
sel.TypId == typFromWhichTheEntryShouldBeRemoved.Id
&& sel.DataDependencyId == entryToRemove.Id).FirstOrDefault();
if (useForUsage != null)
useForUsage.Delete();
UseFor useForAssignement = Data.DbServer3.AltErlaaInfo.UseFors.Where(sel =>
sel.DataDependencyId == entryToRemove.Id
&& sel.TypId == typFromWhichTheEntryShouldBeRemoved.Id).FirstOrDefault();
if (useForAssignement != null)
useForAssignement.Delete();
}
private void AddDataDependencyToRootDataTemplates (RootDataTemplate rootDataTemplatesToWhichTheEntryShouldBeAdded,
DataDependency entryToAdd)
{
UseForRootDataTemplate newEntry = DbDataContext.AltErlaaInfo.UseForRootDataTemplates.NewRow();
newEntry.Id = Guid.NewGuid();
newEntry.DataDependencyId = entryToAdd.Id;
newEntry.ModifyTimeStamp = DateTime.Now;
newEntry.RootDataTemplatesId = rootDataTemplatesToWhichTheEntryShouldBeAdded.Id;
DbDataContext.AltErlaaInfo.UseForRootDataTemplates.Rows.Add(newEntry);
UseFor newUseForEntry = DbDataContext.AltErlaaInfo.UseFors.NewRow();
newUseForEntry.Id = Guid.NewGuid();
newUseForEntry.DataDependencyId = entryToAdd.Id;
newUseForEntry.ModifyTimeStamp = DateTime.Now;
newUseForEntry.TypId = rootDataTemplatesToWhichTheEntryShouldBeAdded.Id;
DbDataContext.AltErlaaInfo.UseFors.Rows.Add(newEntry);
}
private void AddDataDependencyToTyp (Typ typToWhichTheEntryShouldBeAdded, DataDependency entryToAdd)
{
UseForTyp newEntry = DbDataContext.AltErlaaInfo.UseForTypen.NewRow();
newEntry.Id = Guid.NewGuid();
newEntry.DataDependencyId = entryToAdd.Id;
newEntry.ModifyTimeStamp = DateTime.Now;
newEntry.TypId = typToWhichTheEntryShouldBeAdded.Id;
DbDataContext.AltErlaaInfo.UseForTypen.Rows.Add(newEntry);
UseFor newUseForEntry = DbDataContext.AltErlaaInfo.UseFors.NewRow();
newUseForEntry.Id = Guid.NewGuid();
newUseForEntry.DataDependencyId = entryToAdd.Id;
newUseForEntry.ModifyTimeStamp = DateTime.Now;
newUseForEntry.TypId = typToWhichTheEntryShouldBeAdded.Id;
DbDataContext.AltErlaaInfo.UseFors.Rows.Add(newEntry);
}
public StandBildMapping CreateNewStandBildMapping (DataDependency fullDataDependencyToWorkFor)
{
StandBildMapping newEntry = DbDataContext.AltErlaaInfo.StandBildMappings.NewRow();
newEntry.Id = Guid.NewGuid();
newEntry.SourceDataDependencyId = fullDataDependencyToWorkFor.Id;
newEntry.NameId = "Bitte eintragen";
newEntry.TargetItemTextPostProcessings = "None";
newEntry.TargetItemSplittingTyp = "None";
newEntry.ProcessingOrder = 0;
newEntry.TargetItemSplittingParameter1 = 0;
newEntry.TargetItemSplittingParameter2 = 0;
newEntry.MaxTargetLength = 128;
newEntry.ProcessMultipleEntries = "No";
newEntry.AddContentAllowed = "No";
newEntry.ProcessDuringAllRuns = "No";
newEntry.TargetRedaktion = "*";
newEntry.SourceFreitext = "Freitext";
newEntry.ProcessingOrder = 100;
DbDataContext.AltErlaaInfo.StandBildMappings.Rows.Add(newEntry);
DbDataContext.AltErlaaInfo.SaveAnabolic();
DbDataContext.AltErlaaInfo.AcceptChanges();
return newEntry;
}
public int? Get_LastUsedSortOrder(DataDependency groupElement)
{
return InformationenAddOns.Where(whe => whe.DataDependency == groupElement
&& whe.SortOrder != null)?
.OrderByDescending(ord => ord.SortOrder)?
.Select(sel => (int) sel.SortOrder)?.FirstOrDefault();
}
public DataDependency SetActiveDataDependencyViaId(Guid DataDependencyId)
{
ActiveDataDependency = DbDataContext.AltErlaaInfo.DataDependencies.Find(DataDependencyId);
return ActiveDataDependency;
}
