public bool? ProcessImagesAsAddOnToTables (WMB.TableContentDefinition SpecialFieldProcessingParameter)
{
SpecialFieldProcessing = SpecialFieldProcessingParameter;
MaterialTypeToSearchFor = "ImagesAsAddOn";
return ShowDialog ();
}
public static Timings GetTerminEntry (Guid InformationenID, WMB.TypeOfTimingToSearchFor TypeOfTimingsToSearchFor)
{
CVM.ITimingsInterface TimingsHandling = new ManagedTimings.ManagedTimingsControl () as CVM.ITimingsInterface;
TimingsHandling.WCFDataAccess = new WCFStandards ();
DataRow TimingRow = TimingsHandling.GetPurposeSelectedTiming (InformationenID, TypeOfTimingsToSearchFor);
if (TimingRow == null)
return (Timings) null;
return new Timings ()
{
TimingsID = (System.Guid) TimingRow ["TimingsID"],
ConnectedID = (System.Guid ?) TimingRow ["ConnectedID"],
TimeA = Convert.ToDateTime (TimingRow ["TimeA"]),
TimeB = Convert.ToDateTime (TimingRow ["TimeB"]),
ConnectedType = TimingRow ["ConnectedType"].ToString (),
TimingTypID = TimingRow ["TimingTypID"].ToString ()
};
}
public bool CheckOrImportFaceBookPost(WMB.SiteData FaceBookSite, PostData PostEntry)
{
String TableName = FaceBookSite.TableName;
String ID = PostEntry.ID;
DataSet BeitraegeDataSet = DataBaseFromName["WPMedia"].GetCommonDataSet
("Select * from BeitragBeschreibungen where TableName = '" + FaceBookSite.TableName
+ "' and NameID = '" + PostEntry.ID + "'");
if (BeitraegeDataSet.Tables["BeitragBeschreibungen"].Rows.Count == 0)
{
DataRow NewRow = BeitraegeDataSet.Tables["BeitragBeschreibungen"].NewRow();
NewRow["BeitragID"] = System.Guid.NewGuid();
NewRow["TableName"] = FaceBookSite.TableName; ;
NewRow["NameID"] = PostEntry.ID;
NewRow["Beschreibung"] = PostEntry.Name;
NewRow["FileFoundInDirectory"] = PostEntry.Link;
NewRow["Type"] = "FaceBookPosts";
NewRow["LastUpdateTimeStamp"] = PostEntry.UpdatedTime;
NewRow["LastCheckTimeStamp"] = DateTime.Now;
NewRow["LastUpdateToken"] = Basics.GetNextLastUpdateTokenHelperAsByteArray();
BeitraegeDataSet.Tables["BeitragBeschreibungen"].Rows.Add(NewRow);
}
else
{
if (Convert.ToDateTime(BeitraegeDataSet.Tables["BeitragBeschreibungen"].Rows[0]["LastUpdateTimeStamp"])
!= PostEntry.UpdatedTime)
BeitraegeDataSet.Tables["BeitragBeschreibungen"].Rows[0]["LastUpdateTimeStamp"]
= PostEntry.UpdatedTime;
else
return false;
}
DataSet Updates = BeitraegeDataSet.GetChanges();
if (Updates != null)
{
DataBaseFromName["WPMedia"].SetCommonDataSet(Updates);
}
return true;
}
public static List<PositioningEntry> ShowFrameGeometry (double DrawingWidth, GraphicsHandling GraphicsHandler,
CVM.RedrawInformation RedrawData, Grid RootGridForAllDrawings, String PageIDToProcess, RedrawMeEvent RedrawMeEventCall,
GraphicsSingleton.DoThisAfterContextProcessingEvent DoThisAfterContextProcessingCall,
SetUIElementsEnabelingToEvent SetUIElementsEnabelingToEventHandlerParameter,
CVM.ActivatePageIDEvent ActivatePageIDEventHandler,
CVM.GetBeitragsDatenFromBeitragsIDEvent GetBeitragsDatenFromBeitragsIDParameter,
WMB.CloseRequested PosWindow_CloseRequestedEntry,
RedrawFrameGeometryEvent RedrawFrameGeometryCall)
{
RedrawMeEventHandler = RedrawMeEventCall;
DoThisAfterContextProcessingEventHandler = DoThisAfterContextProcessingCall;
SetUIElementsEnabelingToEventHandler = SetUIElementsEnabelingToEventHandlerParameter;
GetBeitragsDatenFromBeitragsIDHandler = GetBeitragsDatenFromBeitragsIDParameter;
GraphicsSingleton SingletonInstance = GraphicsSingleton.Instance;
SingletonInstance.SetDoThisAfterContextProcessingCall (DoThisAfterContextProcessingCall);
SingletonInstance.RedrawData = RedrawData;
//DeleteExistingFrames (SingletonInstance.ListOfPositioningEntryInstances);
TargetAspectRatio = GraphicsHandler.TargetPictureWidth / GraphicsHandler.TargetPictureHeight;
ResizingFactor = GraphicsHandler.TargetPictureWidth / DrawingWidth;
TargetPictureWidth = GraphicsHandler.TargetPictureWidth / ResizingFactor;
TargetPictureHeight = GraphicsHandler.TargetPictureHeight / ResizingFactor;
PositioningEntry.TargetPictureWidth = TargetPictureWidth;
PositioningEntry.TargetPictureHeight = TargetPictureHeight;
PositioningEntry.TargetAspectRatio = TargetAspectRatio;
PositioningEntry.ResizingFactor = ResizingFactor;
int LocalRootGridLastIndexNotToDelete = RootGridForAllDrawings.Children.Count;
if (SingletonInstance.ListOfPositioningEntryInstances == null)
SingletonInstance.ListOfPositioningEntryInstances = new List<PositioningEntry> ();
// by sac
SingletonInstance.GraphicsHandler.ClearRootCanvas ();
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.MinWidth = TargetPictureWidth;
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.Width = TargetPictureWidth;
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.MinHeight = TargetPictureHeight;
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.Height = TargetPictureHeight;
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.AllowDrop = true;
int DuplicationID = RedrawData.PageIndex;
Image TargetImage = RedrawData.TargetImage;
DataRow PageRow = GraphicsHandler.FrameDataDataSetReader.Tables ["Pages"]
.Select ("ID = '" + RedrawData.PageID + "'") [0];
DataRow [] FrameContentRows = GraphicsHandler.FrameDataDataSetReader.Tables ["FrameContent"]
.Select ("PageID = '" + RedrawData.PageID + "'", "FrameOrder");
foreach (DataRow FrameContentRow in FrameContentRows)
{
if (DuplicationID != -1)
if ((Convert.ToInt32 (FrameContentRow ["MultiPageIndex"]) != -1)
&& (Convert.ToInt32 (FrameContentRow ["MultiPageIndex"]) != DuplicationID))
continue;
if (!String.IsNullOrEmpty (FrameContentRow ["ItemName"].ToString ()))
if (GraphicsHandler.ActuallReadableContentRow.Table.Columns [FrameContentRow ["ItemName"].ToString ()] == null)
continue;
DataRow [] FrameRows = GraphicsHandler.FrameDataDataSetReader.Tables ["Frames"]
.Select ("ID = '" + FrameContentRow ["FrameID"].ToString () + "'");
if (FrameRows.Length != 1)
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.ShowFrameGeometry",
"Fehler in der Frame und FrameContent Kombination:\r\n"
+ "FrameContentID = \"" + FrameContentRow ["ID"].ToString ()
+ "\" NameID = \"" + FrameContentRow ["NameID"].ToString () + "\r\nFrameID = \""
+ FrameContentRow ["FrameID"].ToString () + "\"");
MessageBox.Show ("Fehler in der Frame und FrameContent Kombination:\r\n"
+ "FrameContentID = \"" + FrameContentRow ["ID"].ToString ()
+ "\" NameID = \"" + FrameContentRow ["NameID"].ToString () + "\r\nFrameID = \""
+ FrameContentRow ["FrameID"].ToString () + "\"");
continue;
}
bool Found = false;
String FrameID = FrameContentRow ["FrameID"].ToString ();
foreach (PositioningEntry ExistingPositioningEntryInstance in SingletonInstance.ListOfPositioningEntryInstances)
{
if (ExistingPositioningEntryInstance.FrameID == FrameID)
{
ExistingPositioningEntryInstance.FillMeFromDataBase ();
Found = true;
break;
}
}
if (Found == false)
{
PositioningEntry NewPositioningEntryInstance = new PositioningEntry ();
NewPositioningEntryInstance.FrameRow = FrameRows [0];
NewPositioningEntryInstance.FrameID = FrameID;
NewPositioningEntryInstance.FrameContentRow = FrameContentRow;
PositioningEntry.SetUIElementsEnabelingToEventHandler = SetUIElementsEnabelingToEventHandler;
PositioningEntry.ActivatePageIDEventHandler = ActivatePageIDEventHandler;
NewPositioningEntryInstance.RootUIElement = RootGridForAllDrawings;
NewPositioningEntryInstance.RedrawMeEventCall += RedrawMeEventCall;
NewPositioningEntryInstance.RedrawFrameGeometryCall += RedrawFrameGeometryCall;
NewPositioningEntryInstance.PageID = PageIDToProcess;
NewPositioningEntryInstance.RootGrid = RootGridForAllDrawings;
NewPositioningEntryInstance.RootGridLastIndexNotToDelete = LocalRootGridLastIndexNotToDelete;
// NewPositioningEntryInstance.AllFrames = SingletonInstance.ListOfPositioningEntryInstances;
NewPositioningEntryInstance.CloseRequestedCall += PosWindow_CloseRequestedEntry;
NewPositioningEntryInstance.FillMeFromDataBase ();
SingletonInstance.ListOfPositioningEntryInstances.Add (NewPositioningEntryInstance);
}
}
int Index = 0;
PositioningEntry PosWindowToSelect = null;
foreach (PositioningEntry PosEntry in SingletonInstance.ListOfPositioningEntryInstances)
{
if (SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities
.Children.Contains (PosEntry.FramingRectangle) == false)
SingletonInstance.GraphicsHandler.RootCanvasForDrawingActivities.Children.Add (PosEntry.FramingRectangle);
Canvas.SetLeft (PosEntry.FramingRectangle, PosEntry.Left);
Canvas.SetTop (PosEntry.FramingRectangle, PosEntry.Top);
if (Index == LastSelectedIndex)
PosWindowToSelect = PosEntry;
Index++;
}
//if (PosWindowToSelect != null)
// {
// PosWindowToSelect.PositionableEntry_MouseDown (PosWindowToSelect.FramingRectangle, null);
// }
if (Basics.IsTestRun)
Basics.ReportInformationToEventViewer ("PositioningEntry.ShowFrameGeometry (static)",
"SingletonInstance.ListOfPositioningEntryInstances mit "
+ Convert.ToString (SingletonInstance.ListOfPositioningEntryInstances.Count)
+ " returned");
return SingletonInstance.ListOfPositioningEntryInstances;
}
private void ProcessConnectorID (WMB.TableContentDefinition SpecialFieldProcessing)
{
String [] Additionals = new String [SpecialFieldProcessing.m_ParameterColumns.Length];
String [] BackAdditionals = new String [SpecialFieldProcessing.m_ParameterColumns.Length];
int Index = 0;
foreach (String AdditionalColumn in SpecialFieldProcessing.m_ParameterColumns)
{
Additionals [Index] = m_RowToProcess [AdditionalColumn].ToString ();
BackAdditionals [Index] = m_RowToProcess [AdditionalColumn].ToString ();
Index++;
}
String NewValue = OpenSelectionWindow (this, SpecialFieldProcessing, m_RowToProcess,
Additionals, BackAdditionals);
if (NewValue != null)
{
if (NewValue == "")
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName] = Convert.DBNull;
else
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName] = NewValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
Index = 0;
foreach (String AdditionalColumn in SpecialFieldProcessing.m_ParameterColumns)
{
if (m_RowToProcess [AdditionalColumn].ToString () != BackAdditionals [Index])
{
if (String.IsNullOrEmpty (BackAdditionals [Index]))
m_RowToProcess [AdditionalColumn] = DBNull.Value;
else
m_RowToProcess [AdditionalColumn] = BackAdditionals [Index];
foreach (TextBox ColumnText in m_UpdateableControls)
{
if ((String) ColumnText.Tag == AdditionalColumn)
{
ColumnText.Text = GetReadableTextForEntryCall
(this, AdditionalColumn,
m_RowToProcess [AdditionalColumn].ToString ());
break;
}
}
}
Index++;
}
}
}
private bool CheckForContextMenu (ref Control ControlAddProcessingTo, ref WMB.TableContentDefinition SpecialFieldProcessing)
{
if (String.IsNullOrEmpty (SpecialFieldProcessing.m_PredefinedContentGroupKeys))
return false;
if (ControlAddProcessingTo.ContextMenu == null)
ControlAddProcessingTo.ContextMenu = new ContextMenu ();
((ContextMenu) ControlAddProcessingTo.ContextMenu).Tag = ControlAddProcessingTo;
((ContextMenu) ControlAddProcessingTo.ContextMenu).Items.Clear ();
String [] Entries = SpecialFieldProcessing.m_PredefinedContentGroupKeys.Split (';');
foreach (String Entry in Entries)
{
String [] EntryParts = Entry.Split (',');
MenuItem PredefinedContentMenuItem = new MenuItem ();
PredefinedContentMenuItem.Header = "Einfügen " + EntryParts [1] + " ...";
PredefinedContentMenuItem.Tag = Entry;
ControlAddProcessingTo.ContextMenuOpening += new ContextMenuEventHandler (ControlAddProcessingTo_ContextMenuOpening);
PredefinedContentMenuItem.Click += new RoutedEventHandler (PredefinedContentMenuItem_Click);
((ContextMenu) ControlAddProcessingTo.ContextMenu).Items.Add (PredefinedContentMenuItem);
}
return true;
}
private void DoScreenUpdateAfterContentModification (WMB.TableContentDefinition SpecialFieldProcessing)
{
foreach (TextBox ColumnText in m_UpdateableControls)
{
if ((String)ColumnText.Tag == SpecialFieldProcessing.m_ColumnName)
{
if ((SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_ALLOWED_KEYS)
|| (SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_ALLOWED_VALUES)
|| (SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_ALLOWED_TEMPLATES)
|| (SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_IMAGE_LINK_ID)
|| (SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_DATE_TIME)
|| (SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_DO_LOCAL_FILE_SELECTION))
{
if (String.IsNullOrEmpty (SpecialFieldProcessing.m_ForeignKeyName))
ColumnText.Text = m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString ();
else
ColumnText.Text = m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName].ToString ();
if ((SpecialFieldProcessing.m_TypeOfSpecialFieldProcessing
== WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_DATE_TIME)
&& (SpecialFieldProcessing.m_AllowedValues.Length > 1))
{
if (SpecialFieldProcessing.m_AllowedValues [1].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_VON_PARTNER) != -1)
{
String VonColumnName = SpecialFieldProcessing.m_AllowedValues [1].ToString ()
.Replace (WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_VON_PARTNER, "");
TextBox AdditionalColumnControl = (TextBox) GetUpdateableControlViaColumnName (VonColumnName);
if (AdditionalColumnControl != null)
AdditionalColumnControl.Text = m_RowToProcess [VonColumnName].ToString ();
}
if (SpecialFieldProcessing.m_AllowedValues [1].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_BIS_PARTNER) != -1)
{
String BisColumnName = SpecialFieldProcessing.m_AllowedValues [1].ToString ()
.Replace (WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_BIS_PARTNER, "");
TextBox AdditionalColumnControl = (TextBox) GetUpdateableControlViaColumnName (BisColumnName);
if (AdditionalColumnControl != null)
AdditionalColumnControl.Text = m_RowToProcess [BisColumnName].ToString ();
}
}
}
else
{
if (SpecialFieldProcessing.m_DefaultContentRules == null)
{
ColumnText.Text = GetReadableTextForEntryCall
(this, SpecialFieldProcessing.m_ForeignTableName,
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName].ToString ());
}
else
{
ColumnText.Text = m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString ();
}
}
break;
}
}
}
private void ProcessMaterialien (WMB.TableContentDefinition SpecialFieldProcessing)
{
WMB.ICommonMaterialInterface Material = Basics.GetLateBindingInstance
("ManagedMaterials.ManagedMaterialWindow,ManagedMaterials.dll") as WMB.ICommonMaterialInterface;
if (Material == null)
{
MessageBox.Show ("ManagedMaterials.ManagedMaterialWindow,ManagedMaterials.dll\r\nnot accessable");
return;
}
if (ReadableSqlStatement != null)
{
String SQLForReadable = String.Format (ReadableSqlStatement, m_RowToProcess ["ID"].ToString ());
DataRow ReadableRow = DataBase.GetCommonDataSet (SQLForReadable).Tables [m_RowToProcess.Table.TableName].Rows [0];
SpecialFieldProcessing.m_ReadableName = String.Join (" ", ReadableRow.ItemArray);
}
else
{
if (m_RowToProcess.Table.Columns ["NameID"] != null)
SpecialFieldProcessing.m_ReadableName = m_RowToProcess ["NameID"].ToString ();
else
if ((m_RowToProcess.Table.Columns ["Name"] != null)
&& (m_RowToProcess.Table.Columns ["Vorname"] != null))
SpecialFieldProcessing.m_ReadableName = m_RowToProcess ["Vorname"].ToString ()
+ " " + m_RowToProcess ["Name"].ToString ();
}
Material.TypeOfPictureHandling = WMB.TypeOfPictureHandlingEnum.PictureAsMaterialForDataTables;
SpecialFieldProcessing.m_ExistingOrNewValue = m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString ();
SpecialFieldProcessing.m_TableID = m_RowToProcess ["ID"].ToString ();
if (Material.ProcessImagesAsAddOnToTables (SpecialFieldProcessing) == true)
{
String SelectedValue = SpecialFieldProcessing.m_ExistingOrNewValue;
m_RowToProcess [SpecialFieldProcessing.m_ColumnName] = SelectedValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
}
private bool ProcessExistingColumnNames (WMB.TableContentDefinition SpecialFieldProcessing)
{
//DataRow [] ExistingColumns = GetTableFields (SpecialFieldProcessing.m_TableName);
// xxx to do by sac not implemented up to now
DataSet AllowedKeyValuesDataSet = m_DataBase.GetCommonDataSet ("Select distinct ("
+ SpecialFieldProcessing.m_ForeignTableKeyFieldName +
") from " + SpecialFieldProcessing.m_ForeignTableName +
" order by " + SpecialFieldProcessing.m_ForeignTableKeyFieldName);
String [] AllowedValues = new string [AllowedKeyValuesDataSet.Tables [0].Rows.Count];
int Index = 0;
while (Index < AllowedKeyValuesDataSet.Tables [0].Rows.Count)
{
AllowedValues [Index] = AllowedKeyValuesDataSet.Tables [0].Rows [Index] [0].ToString ();
Index++;
}
return HandleProcessAllowedKeys (SpecialFieldProcessing, AllowedValues);
}
private void ProcessColorPicker (WMB.TableContentDefinition SpecialFieldProcessing)
{
SimpleInputWindow AllowedSelectionWindow = new SimpleInputWindow ();
AllowedSelectionWindow.RunAsColorPicker = true;
if (AllowedSelectionWindow.ShowDialog () == true)
{
String SelectedValue = AllowedSelectionWindow.GetInput ();
m_RowToProcess [SpecialFieldProcessing.m_ColumnName] = SelectedValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
}
private void ProcessAllowedTemplates (WMB.TableContentDefinition SpecialFieldProcessing)
{
SimpleInputWindow AllowedSelectionWindow = new SimpleInputWindow ();
AllowedSelectionWindow.AllowedValues =
GetSelectionTextEntriesForPredefinedTemplates (SpecialFieldProcessing.m_TableName);
AllowedSelectionWindow.CreateTextFromUserWindow ("Template für"
+ SpecialFieldProcessing.m_FieldNameWithAllowedValues + " setzten",
m_RowToProcess [SpecialFieldProcessing.m_FieldNameWithAllowedValues].ToString ());
if (AllowedSelectionWindow.ShowDialog () == true)
{
String SelectedValue = AllowedSelectionWindow.GetInput ();
m_RowToProcess [SpecialFieldProcessing.m_FieldNameWithAllowedValues] = SelectedValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
}
private void ProcessLocalFileSelection (WMB.TableContentDefinition SpecialFieldProcessing)
{
if (SpecialFieldProcessing.m_DefaultFillingMethode.IndexOf ("SelectFileOfType=") != -1)
{
String FileExtensionToSearchFor = SpecialFieldProcessing.m_DefaultFillingMethode.Replace
("SelectFileOfType=", "");
OpenFileDialog OFD = new OpenFileDialog ();
OFD.Filter = FileExtensionToSearchFor;
OFD.Title = "Bitte wählen Sie den gewünschten File aus";
OFD.Multiselect = false;
if (OFD.ShowDialog () == true)
{
m_RowToProcess [SpecialFieldProcessing.m_ColumnName] = OFD.FileName;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
else
{
return;
}
}
}
private void ProcessDateTime (WMB.TableContentDefinition SpecialFieldProcessing)
{
if (SpecialFieldProcessing.m_AllowedValues.Length == 2)
{
ISimpleTimingsInterface TimingsWindow = Basics.GetLateBindingInstance
("ManagedTimings.ManagedTimingsWindow,ManagedTimings.dll") as ISimpleTimingsInterface;
if (TimingsWindow == null)
return;
if ((SpecialFieldProcessing.m_AllowedValues [0].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_BIS_TYPE) != -1)
&& (SpecialFieldProcessing.m_AllowedValues [1].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_VON_PARTNER) != -1))
{
if (m_RowToProcess [SpecialFieldProcessing.m_ColumnName] == Convert.DBNull)
TimingsWindow.BisTiming = DateTime.Now;
else
{
DateTime BisTimingHelper;
if (DateTime.TryParse (m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString (),
out BisTimingHelper))
TimingsWindow.BisTiming = BisTimingHelper;
else
TimingsWindow.BisTiming = DateTime.Now;
}
String VonColumnName = SpecialFieldProcessing.m_AllowedValues [1].ToString ()
.Replace (WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_VON_PARTNER, "");
if (m_RowToProcess [VonColumnName] == Convert.DBNull)
TimingsWindow.VonTiming = DateTime.Now;
else
{
DateTime VonTimingHelper;
if (DateTime.TryParse (m_RowToProcess [VonColumnName].ToString (),
out VonTimingHelper))
TimingsWindow.VonTiming = VonTimingHelper;
else
TimingsWindow.VonTiming = DateTime.Now;
}
TimingsWindow.ProcessingType = TimingsProcessingType.BisTiming;
if (TimingsWindow.ShowTimingDialog ())
{
if (TimingsWindow.AnythingChanged == true)
{
m_RowToProcess [SpecialFieldProcessing.m_ColumnName] = TimingsWindow.BisTiming;
m_RowToProcess [VonColumnName] = TimingsWindow.VonTiming;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
}
}
if ((SpecialFieldProcessing.m_AllowedValues [0].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_VON_TYPE) != -1)
&& (SpecialFieldProcessing.m_AllowedValues [1].IndexOf
(WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_BIS_PARTNER) != -1))
{
if (m_RowToProcess [SpecialFieldProcessing.m_ColumnName] == Convert.DBNull)
TimingsWindow.VonTiming = DateTime.Now;
else
{
DateTime VonTimingHelper;
if (DateTime.TryParse (m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString (),
out VonTimingHelper))
TimingsWindow.VonTiming = VonTimingHelper;
else
TimingsWindow.VonTiming = DateTime.Now;
}
String BisColumnName = SpecialFieldProcessing.m_AllowedValues [1].ToString ()
.Replace (WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_BIS_PARTNER, "");
if (m_RowToProcess [BisColumnName] == Convert.DBNull)
TimingsWindow.BisTiming = DateTime.Now;
else
{
DateTime BisTimingHelper;
if (DateTime.TryParse (m_RowToProcess [BisColumnName].ToString (),
out BisTimingHelper))
TimingsWindow.BisTiming = BisTimingHelper;
else
TimingsWindow.BisTiming = DateTime.Now;
}
TimingsWindow.ProcessingType = TimingsProcessingType.VonTiming;
if (TimingsWindow.ShowTimingDialog ())
{
if (TimingsWindow.AnythingChanged == true)
{
m_RowToProcess [SpecialFieldProcessing.m_ColumnName] = TimingsWindow.VonTiming;
m_RowToProcess [BisColumnName] = TimingsWindow.BisTiming;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
}
}
}
}
}
private void ProcessConnectedValueEntries (WMB.TableContentDefinition SpecialFieldProcessing)
{
String ConnectedKeyValue = m_RowToProcess [SpecialFieldProcessing.m_ColumnName].ToString ();
DataSet KeyValuesDataSet = m_DataBase.GetCommonDataSet ("Select * from "
+ SpecialFieldProcessing.m_ForeignTableName + " where " +
SpecialFieldProcessing.m_ForeignTableKeyFieldName
+ " = '" + ConnectedKeyValue + "'");
if (KeyValuesDataSet.Tables [SpecialFieldProcessing.m_ForeignTableName].Rows.Count != 1)
return;
foreach (Control UpdateableControl in m_UpdateableControls)
{
if (UpdateableControl.Tag == null)
continue;
String ColumnName = UpdateableControl.Tag as String;
WMB.TableContentDefinition ConnectedControlsSpecialFiledProcessing
= GetTableContentDefinition (SpecialFieldProcessing.m_TableName, ColumnName);
if (ConnectedControlsSpecialFiledProcessing == null)
continue;
if (ConnectedControlsSpecialFiledProcessing.m_TypeOfSpecialFieldProcessing
!= WMB.TableContentDefinition.SQL_COLUMN_PROPERTY_CONNECTED_VALUE)
continue;
if (ConnectedControlsSpecialFiledProcessing.m_ConnectedValueControllingTable
!= SpecialFieldProcessing.m_ColumnName)
continue;
String NewValue = KeyValuesDataSet.Tables [SpecialFieldProcessing.m_ForeignTableName].Rows
[0] [ConnectedControlsSpecialFiledProcessing.m_ForeignTableKeyFieldName].ToString ();
m_RowToProcess [ColumnName] = NewValue;
if (UpdateableControl.GetType () == typeof (TextBox))
((TextBox) UpdateableControl).Text = NewValue;
}
}
public List<Timings> GetPurposeSelectedTiming (WMB.TypeOfTimingToSearchFor TypOfTiming)
{
String [] PriorityArray = null;
List<Timings> Result = new List<Timings> ();
switch (TypOfTiming)
{
case TypeOfTimingToSearchFor.BestFoEvent:
{
PriorityArray = new String [] {"EventVonBis", "AktivVonBis", "AnzVonBis"};
break;
}
case TypeOfTimingToSearchFor.BestForStandBild:
{
PriorityArray = new String [] {"AnzVonBis", "EventVonBis", "AktivVonBis"};
break;
}
case TypeOfTimingToSearchFor.BestForBanner:
{
PriorityArray = new String [] {"BannerVonBis", "AnzVonBis", "EventVonBis", "AktivVonBis"};
break;
}
case TypeOfTimingToSearchFor.BestForDuration:
{
PriorityArray = new String [] {"EventVonBis", "AktivVonBis"};
break;
}
}
Dictionary<String, List<Timings>> LastEntries = GetLastEntries (PriorityArray);
foreach (String FoundTyp in PriorityArray)
{
if (LastEntries.ContainsKey (FoundTyp))
{
foreach (Timings Entry in LastEntries [FoundTyp])
Result.Add (Entry);
}
}
return Result;
}
private bool ProcessAllowedKeys (WMB.TableContentDefinition SpecialFieldProcessing)
{
DataSet AllowedKeyValuesDataSet = m_DataBase.GetCommonDataSet ("Select distinct ("
+ SpecialFieldProcessing.m_ForeignTableKeyFieldName +
") from " + SpecialFieldProcessing.m_ForeignTableName +
" order by " + SpecialFieldProcessing.m_ForeignTableKeyFieldName);
String [] AllowedValues = new string[AllowedKeyValuesDataSet.Tables [0].Rows.Count];
int Index = 0;
while (Index < AllowedKeyValuesDataSet.Tables [0].Rows.Count)
{
AllowedValues [Index] = AllowedKeyValuesDataSet.Tables [0].Rows [Index] [0].ToString ();
Index++;
}
return HandleProcessAllowedKeys (SpecialFieldProcessing, AllowedValues);
}
public String ProcessOverwriteContent(WMB.TableContentDefinition TableContentDefinition,
String TableName, String ColumnNameToProcess, DataRow RowToProcess, String NewContent)
{
String IDToProcess = RowToProcess["ID"].ToString();
RowToProcess[ColumnNameToProcess] = NewContent;
SetOverwrittenDefaultContent(TableName, IDToProcess,
ColumnNameToProcess, NewContent);
List<WMB.TableContentDefinition> TableContentDefinitions = new List<WMB.TableContentDefinition>();
TableContentDefinitions.Add(TableContentDefinition);
ProcessDefaultFilling(TableName, TableContentDefinitions,
IDToProcess);
String SelectStatement = String.Format("Select {0} from {1} where ID = '{2}'",
ColumnNameToProcess, TableName, IDToProcess);
DataSet OverwrittenContentDataSet = GetCommonDataSet(SelectStatement);
return OverwrittenContentDataSet.Tables[0].Rows[0][0].ToString();
}
private bool HandleProcessAllowedKeys (WMB.TableContentDefinition SpecialFieldProcessing, String [] AllowedValues)
{
SimpleInputWindow AllowedSelectionWindow = new SimpleInputWindow ();
AllowedSelectionWindow.AllowKeyChangeAndAdd = SpecialFieldProcessing.m_AllowNewKeysInForeignTable;
AllowedSelectionWindow.AllowedValues = AllowedValues;
AllowedSelectionWindow.CreateTextFromUserWindow ("Neuen Inhalt für "
+ SpecialFieldProcessing.m_ForeignKeyName + " setzen",
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName].ToString ());
if (AllowedSelectionWindow.ShowDialog () == true)
{
if (AllowedSelectionWindow.ValueChangeRequested == true)
{
if (ProcessModifyKeyTableCall != null)
{
Cursor = Cursors.Wait;
String NewValue = ProcessModifyKeyTableCall (SpecialFieldProcessing);
if (!String.IsNullOrEmpty (NewValue))
{
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName] = NewValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
if (SpecialFieldProcessing.m_ConnectedValueControllerItem == true)
{
ProcessConnectedValueEntries (SpecialFieldProcessing);
}
return true;
}
Cursor = Cursors.Arrow;
}
return false;
}
String SelectedValue = AllowedSelectionWindow.GetInput ();
m_RowToProcess [SpecialFieldProcessing.m_ForeignKeyName] = SelectedValue;
m_ForeignKeyUpdated = true;
DoScreenUpdateAfterContentModification (SpecialFieldProcessing);
if (SpecialFieldProcessing.m_ConnectedValueControllerItem == true)
{
ProcessConnectedValueEntries (SpecialFieldProcessing);
}
}
return true;
}
public bool? ProcessImagesAsAddOnToTables (WMB.TableContentDefinition SpecialFieldProcessing)
{
return null;
}
private String OpenSelectionWindow (Object Sender,
WMB.TableContentDefinition SpecialFieldProcessing,
DataRow RowToProcess, String [] Additionals, String [] BackAdditionals)
{
// Return value null means Do Nothing
// all other Values should be stored into the initiating field
String TableName = SpecialFieldProcessing.m_ForeignTableName;
String ConnectionFieldName = SpecialFieldProcessing.m_ForeignKeyName;
String ExistingForeignKeyNameValue = RowToProcess [SpecialFieldProcessing.m_ForeignKeyName].ToString ();
if (OpenSelectionWindowCall != null)
return OpenSelectionWindowCall (m_Bereich, DataBase, Sender,
TableName, ExistingForeignKeyNameValue, Additionals, BackAdditionals);
CommonSelectionWindow SelectionWindow = new CommonSelectionWindow ();
SelectionWindow.HandleShowAndEditListBoxEntry_MouseRightButtonUpCall +=
new HandleShowAndEditListBoxEntry_MouseRightButtonUpEvent
(SelectionWindow_HandleShowAndEditListBoxEntry_MouseRightButtonUpCall);
SelectionWindow.ActuallSpecialFieldProcessing = SpecialFieldProcessing;
if (CheckTheSelectionFillStatementCall != null)
SelectionWindow.CheckTheSelectionFillStatementCall
+= new CheckTheSelectionFillStatementEvent (SelectionWindow_CheckTheSelectionFillStatementCall);
SelectionWindow.SetData (m_Bereich, DataBase, Sender, TableName,
ConnectionFieldName, ExistingForeignKeyNameValue, Additionals, BackAdditionals);
Nullable<bool> ReturnValue = SelectionWindow.ShowDialog ();
return SelectionWindow.NewID;
}
