public void InitializeMe (String Bereich, WCFStandardsNS.WCFStandards DataBase,
CommonDataBase.StatusCallBack StatusCallbackHandler)
{
SetMessageCallback (StatusCallbackHandler);
m_DataBase = DataBase;
m_ShowFullPage.InitializeMe (Bereich, m_DataBase, m_StatusCallBackHandler);
}
public IntelliSenseAutoCompletionFactoryRoutines (WCFStandardsNS.WCFStandards DataBase)
{
if (DataBase != null)
{
m_DataBase = DataBase;
//TODO its not running for all databases
return;
SchemaDataSet = m_DataBase.GetCommonSchemaDataSet ();
}
}
public void InitializeMe (String Bereich, WCFStandardsNS.WCFStandards DataBase,
CommonDataBase.StatusCallBack StatusCallBackHandler)
{
m_Bereich = Bereich;
m_DataBase = DataBase;
SetMessageCallback (StatusCallBackHandler);
if (m_StructureDataSet != null)
m_StructureDataSet.Dispose ();
m_StructureDataSet = null;
LoadStructure ();
}
public Object UpdateDataPackage (WCFStandardsNS.WCFStandards m_DataBase,
Object Package, DataSet FrameDataDataSet)
{
if ((Package == null)
&& (FrameDataDataSet == null))
return null;
if ((Package == null)
&& (FrameDataDataSet != null))
{
Package = CreateNewPackageFromFrameDataSet (FrameDataDataSet);
}
else
{
if ((Package != null)
&& (FrameDataDataSet == null))
{
FrameDataDataSet = (Package as Paketieren.PackagingHandler).GetDataSetFromDataSetName ("FrameDefinitions");
}
else
{
(Package as Paketieren.PackagingHandler).AddDataSet (FrameDataDataSet);
}
}
return Package;
}
public bool ActualizeInstanceDataIntoFrameDataSet (WCFStandardsNS.WCFStandards m_DataBase,
String TableNameParameter, String ID)
{
return SetInstanceDataIntoFrameDataSet(m_FrameDataDataSet, m_DataBase, TableNameParameter, ID);
}
private DataSet CreateDefaultFrameDataSet (WCFStandardsNS.WCFStandards m_DataBase,
String TableNameParameter)
{
DataSet ReturnDataSet =
m_DataBase.GetCommonDataSet("Select * from TableDefinitions where TableName = '" + TableNameParameter
+ "' and DefinitionNameToCreate IS NULL");
if ((ReturnDataSet.Tables.Count != 1)
|| (ReturnDataSet.Tables [0].Rows.Count != 1))
return null;
// by sac - remove the following two lines when the Change to new Format procedure is finished
//ReturnDataSet.Tables ["TableDefinitions"].Rows [0] ["TargetWidth"] = 1920;
//ReturnDataSet.Tables ["TableDefinitions"].Rows [0] ["TargetHeight"] = 1080;
String TableID = ReturnDataSet.Tables [0].Rows [0] ["ID"].ToString ();
String FormattingTemplate = ReturnDataSet.Tables [0].Rows [0] ["FormattingTemplate"].ToString ();
if (String.IsNullOrEmpty (FormattingTemplate))
FormattingTemplate = "DefaultKartei";
DataSet TableDataSet =
m_DataBase.GetCommonMultiDataSet (new String [] {
"Select * from FrameContent where FormattingTemplate = '"
+ FormattingTemplate + "' order by MultiPageIndex, FrameOrder"
});
ReturnDataSet.DataSetName = "FrameDefinitions";
DataTable FrameContent = TableDataSet.Tables ["FrameContent"];
TableDataSet.Tables.Remove (FrameContent);
ReturnDataSet.Tables.Add (FrameContent);
List<String> RequiredPageIDs = new List<string> ();
List<String> RequiredFrameIDs = new List<string> ();
foreach (DataRow FrameContentRow in ReturnDataSet.Tables ["FrameContent"].Rows)
{
if (String.IsNullOrEmpty (FrameContentRow ["FrameID"].ToString ()))
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.CreateDefaultFrameDataSet",
"Beim FrameContentEintrag \"" + FrameContentRow ["ID"].ToString ()
+ "\" ist der KarteiID Eintrag leer");
continue;
}
if (!RequiredPageIDs.Contains (FrameContentRow ["PageID"].ToString ()))
RequiredPageIDs.Add (FrameContentRow ["PageID"].ToString ());
if (!RequiredFrameIDs.Contains (FrameContentRow ["FrameID"].ToString ()))
RequiredFrameIDs.Add (FrameContentRow ["FrameID"].ToString ());
}
String PageWhereClause = " (ID = '" + String.Join ("' or ID = '", RequiredPageIDs.ToArray ()) + "')";
String FrameWhereClause = " (ID = '" + String.Join ("' or ID = '", RequiredFrameIDs.ToArray ()) + "')";
DataSet PagesAndFrames = m_DataBase.GetCommonMultiDataSet (new string [] {
"Select * from Pages where " + PageWhereClause,
"Select * from Frames where " + FrameWhereClause
});
DataTable PagesDataTable = PagesAndFrames.Tables ["Pages"];
PagesAndFrames.Tables.Remove (PagesDataTable);
ReturnDataSet.Tables.Add (PagesDataTable);
DataTable FramesDataTable = PagesAndFrames.Tables ["Frames"];
PagesAndFrames.Tables.Remove (FramesDataTable);
ReturnDataSet.Tables.Add (FramesDataTable);
return ReturnDataSet;
}
public Object GetInstatiatedPackage (WCFStandardsNS.WCFStandards m_DataBase,
String TableNameParameter, String ID, bool ReadWriteOpen = true)
{
String PackageDirectory = Path.Combine(Path.Combine(LocalWPMediaRoot, "Source"), TableNameParameter);
String PackageName = GetPackageName(TableNameParameter, ID);
if (!File.Exists (PackageName))
{
try
{
m_Pkg = (Paketieren.PackagingHandler) CreateNewPackage (m_DataBase,
TableNameParameter, ID);
InsertDefaultPackageMaterials (m_DataBase, m_Pkg);
m_Pkg.FlushPackage ();
}
catch (Exception Excp)
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.GetInstatiatedPackage",
" bei der Tabelle \"" + TableNameParameter + "\" und der ID = \"" + ID + "\" trat fogender Fehler auf:\r\n"
+ Excp.ToString());
return null;
}
DoStartupProcessing (m_DataBase, m_Pkg);
if (ReadWriteOpen == true)
ModificationRequired = true;
m_Pkg.ModificationStatusChangedCall += Package_ModificationStatusChangedCall;
return m_Pkg;
}
m_Pkg = new Paketieren.PackagingHandler ();
if (m_Pkg.OpenExistingReadWritePackage (PackageName) == null)
return null;
if (DoStartupProcessing (m_DataBase, m_Pkg) == false)
return null;
m_Pkg.ModificationStatusChangedCall += Package_ModificationStatusChangedCall;
return m_Pkg;
}
public bool DoStartupProcessing (WCFStandardsNS.WCFStandards m_DataBase, Object PkgObject)
{
if (PkgObject == null)
return false;
if (PkgObject as Paketieren.PackagingHandler == null)
return false;
m_FrameDataDataSet = (PkgObject as Paketieren.PackagingHandler).GetDataSetFromDataSetName ("FrameDefinitions");
if (m_FrameDataDataSet == null)
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.DoStartupProcessing",
"Weil das m_FrameDataDataSet nicht lesbar ist, wird dieses Package (\""
+ (PkgObject as Paketieren.PackagingHandler).PackageName + "\") gelöscht");
if (Application.Current.MainWindow != null)
{
MessageBox.Show ("Weil das m_FrameDataDataSet nicht lesbar ist, wird dieses Package (\""
+ (PkgObject as Paketieren.PackagingHandler).PackageName + "\") gelöscht");
}
(PkgObject as Paketieren.PackagingHandler).ClosePackage ();
Basics.SecureFileDelete ((PkgObject as Paketieren.PackagingHandler).PackageName);
return false;
}
m_Pkg = PkgObject as Paketieren.PackagingHandler;
TableName = m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0] ["TableName"].ToString ();
// by sac - Banner/Button could be removed, when Format definitions actualized (In each Package)
if (((TableName == "BannerData")
|| (TableName == "ButtonData"))
&& (String.IsNullOrEmpty (m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0]
["PageFactoryParameter"].ToString ())))
{
PageFactoryParameters = ("SimpleTextPage").Split (';');
}
else
{
if (String.IsNullOrEmpty (m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0] ["PageFactoryParameter"].ToString ()))
PageFactoryParameters =
String.Format ("DefaultKarteiPage01,LangTextSeite1;DefaultKarteiPage02,LangTextSeite2;DefaultKarteiPage03,"
+ "LangTextSeite3;DefaultKarteiPage04,LangTextSeite4;DefaultKarteiPage05,LangTextSeite5"
+ ";DefaultKarteiPage06,LangTextSeite6;DefaultKarteiPage07,LangTextSeite7;DefaultKarteiPage08,LangTextSeite8"
+ ";DefaultKarteiPage09,LangTextSeite9").Split (';');
else
PageFactoryParameters = m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0]
["PageFactoryParameter"].ToString ().Split (';');
}
TargetPictureWidth = Convert.ToDouble (m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0] ["TargetWidth"]);
TargetPictureHeight = Convert.ToDouble (m_FrameDataDataSet.Tables ["TableDefinitions"].Rows [0] ["TargetHeight"]);
if (m_FrameDataDataSet.Tables [TableName].Rows.Count < 1)
return false;
ActuallContentRow = m_FrameDataDataSet.Tables [TableName].Rows [0];
if (UpdateFromDataBaseOccured (m_DataBase, m_FrameDataDataSet, TableName))
ModificationRequired = true;
CalculatePagesToPlayAndTheirDurations ();
if (PageIDsToPlay.Count == 0)
{
if (LoopCounter++ > 3)
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.DoStartupProcessing",
"Weil PageIDsToPlay.Count == 0, wird dieses Package (\""
+ (PkgObject as Paketieren.PackagingHandler).PackageName + "\") gelöscht");
Basics.SecureFileDelete ((PkgObject as Paketieren.PackagingHandler).PackageName);
LoopCounter = -1;
return false;
}
//avoid endlessloop if no pages available
// by sac Not carefully testet -
// RevertEntryToFileDefault ();
// CalculatePagesToPlayAndTheirDurations ();
}
return true;
}
public static bool ClearAndMirrorCompleteDataSetTo(WCFStandardsNS.WCFStandards TargetDataBase, DataSet DataSetToMirror)
{
if (DataSetToMirror == null)
return true;
foreach (DataTable SourceTable in DataSetToMirror.Tables)
{
String DeleteCommand = "Delete from " + SourceTable.TableName;
TargetDataBase.RunSQLBatch(DeleteCommand);
}
return MirrorDataSetTo(TargetDataBase, DataSetToMirror);
}
public static List<String> GetExistingKeyWords(WCFStandardsNS.WCFStandards DataBase)
{
DataTable KeyWordsTable =
DataBase.GetCommonDataSet ("Select * from Material where not KeyWords Is null and not KeyWords = ''").Tables ["Material"];
List<String> KeyWords = new List<string> ();
foreach (DataRow KeyWordsRow in KeyWordsTable.Rows)
{
if (String.IsNullOrEmpty (KeyWordsRow ["KeyWords"].ToString ()))
continue;
String [] StoredKeyWords = KeyWordsRow ["KeyWords"].ToString ().Split (';');
foreach (String KeyWord in StoredKeyWords)
{
if (KeyWords.Contains (KeyWord) == false)
{
KeyWords.Add (KeyWord);
}
}
}
return KeyWords;
}
public static String GetProjektText(WCFStandardsNS.WCFStandards DataBase, String ID)
{
if (String.IsNullOrEmpty (ID))
return String.Empty;
DataRow ProjectRow = DataBase.GetCommonDataSet ("Select * from Projekte where ID = '" + ID + "'")
.Tables ["Projekte"].Rows [0];
DataRow OrtsRow = DataBase.GetCommonDataSet ("Select * from Orte where ID = '" + ProjectRow ["OrteID"].ToString () + "'")
.Tables ["Orte"].Rows [0];
return OrtsRow ["NameID"].ToString () + "-" + ProjectRow ["NameID"].ToString ();
}
public static String GetOrtsTeilText(WCFStandardsNS.WCFStandards DataBase, String ID)
{
if (String.IsNullOrEmpty (ID))
return String.Empty;
return DataBase.GetCommonDataSet ("Select * from Orte where ID = '" + ID + "'")
.Tables ["Orte"].Rows [0] ["OrtsTeil"].ToString ();
}
public static String GetAGText(WCFStandardsNS.WCFStandards DataBase, String ID)
{
if (String.IsNullOrEmpty (ID))
return String.Empty;
DataRow AGRow =
DataBase.GetCommonDataSet ("Select * from ArbeitsGruppen where ID = '" + ID + "'").Tables ["ArbeitsGruppen"].Rows [0];
return AGRow ["NameID"].ToString () + "-" + AGRow ["Beschreibung"].ToString ();
}
public static String GetSchulText(WCFStandardsNS.WCFStandards DataBase, String ID)
{
if (String.IsNullOrEmpty (ID))
return String.Empty;
return ID;
}
public static String GetIDForOrtsTeil(WCFStandardsNS.WCFStandards DataBase, String OrtsTeil)
{
return DataBase.GetCommonDataSet("Select * from Orte where OrtsTeil = '"
+ OrtsTeil + "' and (NameID = 'Gesamter Ortsteil' or NameID = 'Liesing Bezirk')")
.Tables ["Orte"].Rows [0] ["ID"].ToString ();
}
public DataSet GetInstatiatedFormatDataSet(WCFStandardsNS.WCFStandards WPMediaAddOnDataDataBase,
String TableName, String ID, String WPMediaRoot)
{
String ControlFileName = GetActuallFormatDataSetFileName (WPMediaRoot, TableName, ID);
if (!File.Exists (ControlFileName))
{
String OldSourceFileName = GetOldFormatDataSetFileName (WPMediaRoot, TableName, ID);
if (File.Exists (OldSourceFileName))
File.Move (OldSourceFileName, ControlFileName);
else
{
CommonDataBase.CommonBasics.SerializeObjectToFile (ControlFileName,
GetFormatierDataSet(WPMediaAddOnDataDataBase, TableName, ID, WPMediaRoot));
}
}
DataSet FormatierDataSet;
try
{
FormatierDataSet = Basics.DeSerializeObjectFromFile (ControlFileName) as DataSet;
if (FormatierDataSet == null)
{
Basics.ReportErrorToEventViewer
("WPMediaStandbildPlayingData.GetInstatiatedFormatDataSet",
"Der File \"" + ControlFileName + "\" aus der Tabelle \""
+ TableName + "\" kann nicht Desrialized werden.\r\nEs wird versucht ihn zu löschen");
CommonDataBase.CommonBasics.SecureFileDelete (ControlFileName, null);
return null;
}
if ((FormatierDataSet.Tables.Count == 0)
|| (FormatierDataSet.Tables [0].Rows.Count == 0)
|| (FormatierDataSet.Tables [0].Columns.Contains ("NameID") == false))
{
Basics.ReportErrorToEventViewer
("WPMediaStandbildPlayingData.GetInstatiatedFormatDataSet",
"Der FormatierDataSet aus dem \"" + ControlFileName + "\" ist illegal aufgebaut");
return null;
}
}
catch (Exception Excp)
{
Basics.ReportErrorToEventViewer
("WPMediaStandbildPlayingData.GetInstatiatedFormatDataSet",
"Folgender Fehler trat beim ControlFile \"" + ControlFileName + "\":\r\n"
+ Excp.ToString());
return null;
}
return FormatierDataSet;
}
public static String ModifyThisRow(WCFStandardsNS.WCFStandards DataBase, DataRow RowToStore)
{
if (RowToStore == null)
return String.Empty;
String TableName = RowToStore.Table.TableName;
List<String> SetCommandPart = new List<string>();
foreach (DataColumn Col in RowToStore.Table.Columns)
{
if (Col.ColumnName == "ID")
continue;
if (RowToStore[Col.ColumnName] == Convert.DBNull)
{
SetCommandPart.Add(Col.ColumnName + " = NULL");
continue;
}
if ((Col.DataType == typeof(Int32))
|| (Col.DataType == typeof(Int64))
|| (Col.DataType == typeof(Double))
)
{
SetCommandPart.Add(Col.ColumnName + " = " + RowToStore[Col.ColumnName].ToString());
continue;
}
if (Col.DataType == typeof(DateTime))
{
SetCommandPart.Add(Col.ColumnName + " = Convert (DateTime, '" + Convert.ToDateTime(RowToStore[Col.ColumnName])
.ToString(WMB.Basics.ISO_DATE_TIME_FORMAT) + "', 120)");
continue;
}
SetCommandPart.Add(Col.ColumnName + " = '" + RowToStore[Col.ColumnName].ToString() + "'");
}
String UpdateStatement = "Update " + RowToStore.Table.TableName + " set " +
String.Join(", ", SetCommandPart.ToArray())
+ " where ID = '" + RowToStore["ID"].ToString() + "'";
return DataBase.RunSQLBatch(UpdateStatement);
}
public static void RemoveAllNotRequiredMaterial(WCFStandardsNS.WCFStandards DataBase,
DataSet EntriesToProcess, String FremdArbeitsgruppe, bool TrueIsRemoveFremdFalseIsRemoveBezirk)
{
List<String> IDsToRemove = new List<string> ();
foreach (DataRow EntryRow in EntriesToProcess.Tables ["Material"].Rows)
{
if (IsMaterialForFremdProject (DataBase, EntryRow, FremdArbeitsgruppe))
{
if (TrueIsRemoveFremdFalseIsRemoveBezirk == true)
IDsToRemove.Add (EntryRow ["ID"].ToString ());
}
else
{
if (TrueIsRemoveFremdFalseIsRemoveBezirk == false)
IDsToRemove.Add (EntryRow ["ID"].ToString ());
}
}
foreach (String ID in IDsToRemove)
{
EntriesToProcess.Tables ["Material"].Select ("ID = '" + ID + "'") [0].Delete ();
}
EntriesToProcess.AcceptChanges ();
}
public static bool MirrorDataSetTo(WCFStandardsNS.WCFStandards TargetDataBase, DataSet DataSetToMirror)
{
if (DataSetToMirror == null)
return true;
foreach (DataTable SourceTable in DataSetToMirror.Tables)
{
DataTable DeletedRows = SourceTable.GetChanges(DataRowState.Deleted);
if (DeletedRows != null)
foreach (DataRow ToDelete in DeletedRows.Rows)
{
if (TargetDataBase.GetCommonDataSet
("Select ID from " + SourceTable.TableName
+ " where ID = '" + ToDelete["ID"].ToString() + "'")
.Tables[SourceTable.TableName].Rows.Count > 0)
{
String DeleteCommand = "Delete from " + SourceTable.TableName
+ " where ID = '" + ToDelete["ID"].ToString() + "'";
TargetDataBase.RunSQLBatch(DeleteCommand);
}
}
List<String> SourceIDs = new List<string>();
foreach (DataRow SourceRow in SourceTable.Rows)
if (SourceRow.RowState != DataRowState.Deleted)
SourceIDs.Add(SourceRow["ID"].ToString());
if (SourceIDs.Count == 0)
continue;
String WhereClause = " where (ID = '" + String.Join("' or ID = '", SourceIDs.ToArray()) + "') ";
DataSet TargetDataSet = TargetDataBase.GetCommonDataSet("Select * from "
+ SourceTable.TableName + WhereClause);
if (TargetDataSet == null)
{
WMB.Basics.ReportErrorToEventViewer("MBRStatics.MirrorDataSetTo",
"Bei der Table \"" + SourceTable.TableName + "\" konnte nichts gelesen werden");
return false;
}
foreach (DataRow SourceRow in SourceTable.Rows)
{
DataRow[] TargetRows = TargetDataSet.Tables[SourceTable.TableName]
.Select("ID = '" + SourceRow["ID"].ToString() + "'");
if (TargetRows.Length > 1)
{
WMB.Basics.ReportErrorToEventViewer("MBRStatics.MirrorDataSetTo",
"Bei der Table \"" + SourceTable.TableName + "\" für die ID \""
+ SourceRow["ID"].ToString() + "\" gibt es mehr als einen Record!!!");
return false;
}
if (TargetRows.Length > 1)
{
WMB.Basics.ReportErrorToEventViewer("MBRStatics.MirrorDataSetTo",
"Bei der Tabelle \"" + SourceTable.TableName + "\"\r\n"
+ "Bei der ID \"" + SourceRow["ID"].ToString() +
"\" tritt ein Datenbank Fehler auf.\r\n"
+ "Mehr als ein Record für diese ID");
continue;
}
DataRow TargetRow = null;
if (TargetRows.Length < 1)
{
TargetRow = TargetDataSet.Tables[SourceTable.TableName].NewRow();
TargetRow["ID"] = SourceRow["ID"].ToString();
TargetRow["LastUpdateToken"] = WMB.Basics.GetNextLastUpdateTokenHelper();
TargetDataSet.Tables[SourceTable.TableName].Rows.Add(TargetRow);
}
else
{
TargetRow = TargetRows[0];
}
foreach (DataColumn Col in TargetDataSet.Tables[SourceTable.TableName].Columns)
{
if (Col.ColumnName != "ID")
if (String.Compare(TargetRow[Col.ColumnName].ToString(),
SourceRow[Col.ColumnName].ToString()) != 0)
{
if (Convert.IsDBNull(SourceRow[Col.ColumnName]) == true)
TargetRow[Col.ColumnName] = Convert.DBNull;
else
TargetRow[Col.ColumnName] = SourceRow[Col.ColumnName].ToString();
}
}
}
String ReturnMessage = TargetDataBase.SetCommonDataSet(TargetDataSet);
if (!String.IsNullOrEmpty(ReturnMessage))
{
WMB.Basics.ReportErrorToEventViewer("MBRStatics.MirrorDataSetTo",
"Bei der Table \"" + SourceTable.TableName + "\" kam es zu folgendem Fehler:\r\n"
+ ReturnMessage);
return false;
}
}
return true;
}
public static bool IsMaterialForFremdProject(WCFStandardsNS.WCFStandards DataBase, DataRow MaterialRow, String FremdArbeitsGruppe)
{
if (MaterialRow ["AGID"].ToString () == FremdArbeitsGruppe)
return true;
return IsFremdProject (DataBase, MaterialRow ["ProjectID"].ToString ());
}
private bool UpdateFromDataBaseOccured(WCFStandardsNS.WCFStandards m_DataBase,
DataSet FrameDataSet, String TableNameParameter)
{
if ((m_DataBase == null)
|| (ActuallContentRow.Table.Columns ["ModifyTimeStamp"] == null)
|| (ActuallContentRow ["ModifyTimeStamp"] == Convert.DBNull))
return false;
DateTime ExistingModifyTimeStamp = Convert.ToDateTime (ActuallContentRow ["ModifyTimeStamp"]);
DataSet DataBaseEntry =
m_DataBase.GetCommonDataSet("Select ID, ModifyTimeStamp from " + TableNameParameter + " where ID = '"
+ ActuallContentRow ["ID"].ToString () + "'");
if ((DataBaseEntry == null)
|| (DataBaseEntry.Tables.Count != 1)
|| (DataBaseEntry.Tables[TableNameParameter] == null)
|| (DataBaseEntry.Tables[TableNameParameter].Rows.Count != 1))
{
Basics.ReportErrorToEventViewer ("GraphicsHandling.UpdateFromDataBaseOccured",
"Bei der Table \"" + TableNameParameter + "\" bei der ID \"" + ActuallContentRow["ID"].ToString()
+ "\" konnte kein übereinstimmender Datebank Eintrag gefunden werden");
return false;
}
if (DataBaseEntry.Tables [0].Rows [0] ["ModifyTimeStamp"] == Convert.DBNull)
return false;
DateTime DataBaseModifyTimeStamp = Convert.ToDateTime (DataBaseEntry.Tables [0].Rows [0] ["ModifyTimeStamp"]);
if (DataBaseModifyTimeStamp == ExistingModifyTimeStamp)
return false;
DataRow NewRow =
m_DataBase.GetCommonDataSet("Select * from " + TableNameParameter + " where ID = '"
+ ActuallContentRow ["ID"].ToString () + "'").Tables [0].Rows [0];
foreach (DataColumn Col in NewRow.Table.Columns)
{
if ((NewRow.Table.Columns [Col.ColumnName] != null)
&& (ActuallContentRow.Table.Columns [Col.ColumnName] != null))
ActuallContentRow [Col.ColumnName] = NewRow [Col.ColumnName];
}
return true;
}
public static bool IsFremdProject(WCFStandardsNS.WCFStandards DataBase, String ProjectID)
{
if (String.IsNullOrEmpty (ProjectID))
return false;
String Zustaendig =
DataBase.GetCommonDataSet ("Select * from Projekte where ID = '" + ProjectID + "'")
.Tables ["Projekte"].Rows [0] ["Zustaendig"].ToString ();
if (String.IsNullOrEmpty (Zustaendig))
return false;
if (Zustaendig == "Fremd")
return true;
return false;
}
public Object CreateNewPackage (WCFStandardsNS.WCFStandards m_DataBase,
String TableNameParameter, String ID)
{
m_FrameDataDataSet = CreateDefaultFrameDataSet(m_DataBase, TableNameParameter);
SetInstanceDataIntoFrameDataSet (m_FrameDataDataSet, m_DataBase,
TableNameParameter, ID);
Object Package = CreateNewPackageFromFrameDataSet (m_FrameDataDataSet);
return UpdateDataPackage (m_DataBase, Package, m_FrameDataDataSet);
}
public DataSet GetFormatierDataSet(WCFStandardsNS.WCFStandards WPMediaAddOnDataDataBase,
String TableName, String ID, String WPMediaRoot)
{
return GetFormatierDataSet(WPMediaAddOnDataDataBase, null, TableName, ID, WPMediaRoot);
}
public bool SetInstanceDataIntoFrameDataSet (DataSet FrameDataSet, WCFStandardsNS.WCFStandards m_DataBase,
String TableNameParameter, String ID)
{
DataSet InstanceDataSet =
m_DataBase.GetCommonDataSet("Select * from " + TableNameParameter + " where ID = '" + ID + "'");
DataTable InstanceDataTable = InstanceDataSet.Tables[TableNameParameter];
InstanceDataSet.Tables.Remove (InstanceDataTable);
if (m_FrameDataDataSet == null)
m_FrameDataDataSet = m_Pkg.GetDataSetFromDataSetName ("FrameDefinitions");
if (FrameDataSet.Tables[TableNameParameter] != null)
FrameDataSet.Tables.Remove(FrameDataSet.Tables[TableNameParameter]);
FrameDataSet.Tables.Add (InstanceDataTable);
m_FrameDataDataSet = FrameDataSet;
return RenewFrameDataSet ();
}
public DataSet GetFormatierDataSet(WCFStandardsNS.WCFStandards WPMediaAddOnDataDataBase,
String DefinitionNameToCreate, String TableName, String ID, String WPMediaRoot)
{
DataSet TableDataSet;
if (String.IsNullOrEmpty (DefinitionNameToCreate))
TableDataSet = WPMediaAddOnDataDataBase.GetCommonDataSet("Select * from TableDefinitions where TableName = '" + TableName + "' and "
+ "(DefinitionNameToCreate is NUll or DefinitionNameToCreate = '')");
else
{
TableDataSet = WPMediaAddOnDataDataBase.GetCommonDataSet("Select * from TableDefinitions where TableName = '" + TableName
+ "' and DefinitionNameToCreate = '" + DefinitionNameToCreate + "'");
}
if (TableDataSet.Tables.Count != 1)
return null;
if (TableDataSet.Tables [0].Rows.Count != 1)
return null;
String Type = TableDataSet.Tables ["TableDefinitions"].Rows [0] ["Type"].ToString ();
DataSet PageDataSet = WPMediaAddOnDataDataBase.GetCommonDataSet("Select * from PageDefinitions where TableID = '"
+ TableDataSet.Tables [0].Rows [0] ["ID"].ToString () + "' order by PagePlayingOrder");
if (PageDataSet.Tables.Count != 1)
return null;
if (PageDataSet.Tables [0].Rows.Count < 1)
{
PageDataSet = WPMediaAddOnDataDataBase.GetCommonDataSet("Select * from PageDefinitions where TableID = '"
+ TableDataSet.Tables [0].Rows [0] ["TableIDForFormattingUsages"].ToString () + "' order by PagePlayingOrder");
if (PageDataSet.Tables [0].Rows.Count < 1)
return null;
}
List<String> PageIDs = new List<string> ();
foreach (DataRow PageRow in PageDataSet.Tables [0].Rows)
{
PageIDs.Add (PageRow ["ID"].ToString ());
}
if (String.IsNullOrEmpty (ID)) // deliver all but without TableData
ID = System.Guid.Empty.ToString ();
String WhereClause = " where ((PageID = '" + String.Join ("') Or (PageID = '", PageIDs.ToArray ()) + "'))";
DataSet PictureDefinitions = WPMediaAddOnDataDataBase.GetCommonMultiDataSet(new String[] {
"Select * from " + TableName + " where ID = '" + ID + "'",
"Select * from PictureDefinitions " + WhereClause + " order by PicturePlayingOrder",
"Select * from TextDefinitions " + WhereClause + " order by TextPlayingOrder",
"Select * from BlockDefinitions " + WhereClause + " order by BlockPlayingOrder"});
DataTable TableDataTable = TableDataSet.Tables [0];
TableDataSet.Tables.Remove (TableDataTable);
PictureDefinitions.Tables.Add (TableDataTable);
DataTable PageDataTable = PageDataSet.Tables [0];
PageDataSet.Tables.Remove (PageDataTable);
PictureDefinitions.Tables.Add (PageDataTable);
if (ID == System.Guid.Empty.ToString ())
return PictureDefinitions;
return ActualizeContentDataInFormatierDataSet(WPMediaAddOnDataDataBase,
PictureDefinitions, TableName, ID, WPMediaRoot);
}
public bool InsertDefaultPackageMaterials (WCFStandardsNS.WCFStandards DataBase, Object Package)
{
DataSet FrameDataDataSet = (Package as Paketieren.PackagingHandler).GetDataSetFromDataSetName ("FrameDefinitions");
String TableNameParameter = FrameDataDataSet.Tables["TableDefinitions"].Rows[0]["TableName"].ToString();
String ID = FrameDataDataSet.Tables[TableNameParameter].Rows[0]["ID"].ToString();
String NameID = FrameDataDataSet.Tables[TableNameParameter].Rows[0]["NameID"].ToString();
String DefaultDirectoryName = String.Empty;
DefaultDirectoryName = NameID;
if (NameID.IndexOf (':') != -1)
{
DefaultDirectoryName = NameID.Split (':') [0];
}
//else
// {
// DefaultDirectoryName = NameID.TrimEnd (new char [] { '0', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0' });
// }
if (Basics.CheckForValidPersistentName (DefaultDirectoryName) == false)
return false;
if (Basics.CheckForValidPersistentName(TableNameParameter) == false)
return false;
String RemotePackageDirectory = Path.Combine(Path.Combine(RemoteWPMediaRoot, "Source"), TableNameParameter);
// String RemoteDefaultDirectory = Path.Combine (RemotePackageDirectory, Basics.XML_AUTO_DEFAULT_DIRECTORY_NAME);
String PackageDirectory = Path.Combine(Path.Combine(LocalWPMediaRoot, "Source"), TableNameParameter);
String DefaultDirectory = Path.Combine (PackageDirectory, Basics.XML_AUTO_DEFAULT_DIRECTORY_NAME);
String LocalizedDirectory = Path.Combine (PackageDirectory, DefaultDirectoryName);
DataSet RemoteDefaultPictures = DataBase.GetRemoteFileData (RemotePackageDirectory,
Basics.AUTO_GRAPHICS_EXTENSIONS, 2);
List<String> AvailableRemoteFiles = new List<string> ();
List<String> AllAvailableFiles = new List<string> ();
foreach (DataRow RemoteDataRow in RemoteDefaultPictures.Tables [0].Rows)
{
if (((!String.IsNullOrEmpty (DefaultDirectoryName))
&& (Path.GetFileName (Path.GetDirectoryName (RemoteDataRow ["FileName"].ToString ())) == DefaultDirectoryName))
|| (Path.GetFileName (Path.GetDirectoryName (RemoteDataRow ["FileName"].ToString ())) == "_Default"))
{
AvailableRemoteFiles.Add (RemoteDataRow ["FileName"].ToString ());
if (!AllAvailableFiles.Contains (Path.GetFileNameWithoutExtension (RemoteDataRow ["FileName"].ToString ().ToUpper ())))
AllAvailableFiles.Add (Path.GetFileNameWithoutExtension (RemoteDataRow ["FileName"].ToString ().ToUpper ()));
}
}
List<String> DefaultPictures = new List<string> ();
if (Directory.Exists (DefaultDirectory))
DefaultPictures = Basics.GetFilesFromDirectory (DefaultDirectory, Basics.AUTO_GRAPHICS_EXTENSIONS, 1);
List<String> LocalizedPictures = new List<string> ();
if (Directory.Exists (LocalizedDirectory))
LocalizedPictures = Basics.GetFilesFromDirectory (LocalizedDirectory, Basics.AUTO_GRAPHICS_EXTENSIONS, 1);
foreach (String FileName in DefaultPictures)
if (!AllAvailableFiles.Contains (Path.GetFileNameWithoutExtension (FileName.ToUpper ())))
AllAvailableFiles.Add (Path.GetFileNameWithoutExtension (FileName.ToUpper ()));
foreach (String FileName in LocalizedPictures)
if (!AllAvailableFiles.Contains (Path.GetFileNameWithoutExtension (FileName.ToUpper ())))
AllAvailableFiles.Add (Path.GetFileNameWithoutExtension (FileName.ToUpper ()));
foreach (String CoreFileName in AllAvailableFiles)
{
String SourceFileNameToTransfer = String.Empty;
String ElementName = String.Empty;
bool SourceIsRemote = false;
bool FoundInLocalized = false;
foreach (String LocalizedFileName in LocalizedPictures)
{
if (LocalizedFileName.IndexOf ("\\" + DefaultDirectoryName + "\\" + CoreFileName + ".", StringComparison.OrdinalIgnoreCase) != -1)
{
ElementName = Path.GetFileName (LocalizedFileName);
SourceFileNameToTransfer = LocalizedFileName;
SourceIsRemote = false;
break;
}
}
if (String.IsNullOrEmpty (ElementName))
{
foreach (String DefaultFileName in DefaultPictures)
{
if (DefaultFileName.IndexOf ("\\_Default\\" + CoreFileName + ".", StringComparison.OrdinalIgnoreCase) != -1)
{
ElementName = Path.GetFileName (DefaultFileName);
SourceFileNameToTransfer = DefaultFileName;
SourceIsRemote = false;
break;
}
}
}
if (String.IsNullOrEmpty (ElementName))
{
foreach (String LocalizedRemoteFileName in AvailableRemoteFiles)
{
if (LocalizedRemoteFileName.IndexOf ("\\" + DefaultDirectoryName + "\\" + CoreFileName + ".", StringComparison.OrdinalIgnoreCase) != -1)
{
ElementName = Path.GetFileName (LocalizedRemoteFileName);
SourceFileNameToTransfer = LocalizedRemoteFileName;
SourceIsRemote = true;
break;
}
}
}
if (String.IsNullOrEmpty (ElementName))
{
foreach (String LocalizedRemoteFileName in AvailableRemoteFiles)
{
if (LocalizedRemoteFileName.IndexOf ("\\_Default\\" + CoreFileName + ".", StringComparison.OrdinalIgnoreCase) != -1)
{
ElementName = Path.GetFileName (LocalizedRemoteFileName);
SourceFileNameToTransfer = LocalizedRemoteFileName;
SourceIsRemote = true;
break;
}
}
}
if (SourceIsRemote)
{
DateTime SourceFileLastWriteTime = DateTime.MinValue;
MemoryStream RemoteFileStream = GetRemoteFileStream (SourceFileNameToTransfer, ref SourceFileLastWriteTime);
if (RemoteFileStream != null)
(Package as Paketieren.PackagingHandler).AddStreamElement (RemoteFileStream,
ElementName);
}
else
{
(Package as Paketieren.PackagingHandler).AddFileElement
(SourceFileNameToTransfer, ElementName);
}
}
return true;
}
public DataSet ActualizeContentDataInFormatierDataSet(WCFStandardsNS.WCFStandards WPMediaAddOnDataDataBase,
DataSet FormatierDataSet, String TableName, String ID, String WPMediaRoot)
{
if (ID == System.Guid.Empty.ToString ())
return null;
DataSet ActuallData = WPMediaAddOnDataDataBase.GetCommonMultiDataSet(new String[] { "Select * from " + TableName + " where ID = '" + ID + "'" });
if (ActuallData.Tables [0].Rows.Count < 1)
return null;
String TemplateID = String.Empty;
FormatierDataSet.Tables [0].Rows.Clear ();
FormatierDataSet.Tables [0].ImportRow (ActuallData.Tables [0].Rows [0]);
int TestCount = FormatierDataSet.Tables [0].Rows.Count;
if (FormatierDataSet.Tables [0].Rows [0] != null)
if (FormatierDataSet.Tables [0].Columns ["TemplateName"] != null)
if (FormatierDataSet.Tables [0].Rows [0] ["TemplateName"] != null)
TemplateID = FormatierDataSet.Tables [0].Rows [0] ["TemplateName"].ToString ();
String NameID = FormatierDataSet.Tables [TableName].Rows [0] ["NameID"].ToString ();
NameValueCollection UsedPictures = LoadAllPictures (TableName, NameID, TemplateID, WPMediaRoot);
DataTable ActuallPictures = ConnectPictures (FormatierDataSet.Tables ["PictureDefinitions"], UsedPictures,
TableName, NameID);
DataTable MaterialTable = FormatierDataSet.Tables ["MaterialTable"];
foreach (DataRow PictureRow in ActuallPictures.Rows)
{
MaterialTable = CheckOrCreateMaterials (MaterialTable, WPMediaRoot, PictureRow ["PictureFileName"].ToString ());
}
if ((FormatierDataSet.Tables ["MaterialTable"] == null)
&& (MaterialTable != null))
{
FormatierDataSet.Tables.Add (MaterialTable);
}
if (FormatierDataSet.Tables ["ConnectPictures"] != null)
FormatierDataSet.Tables.RemoveAt (FormatierDataSet.Tables.IndexOf ("ConnectPictures"));
FormatierDataSet.Tables.Add (ActuallPictures);
return FormatierDataSet;
}
public static void ProcessContextMenu (object Sender, ContextMenuEventArgs e,
WCFStandardsNS.WCFStandards DataBase,
DoThisAfterContextProcessingEvent DoThisAfterContextProcessingCall)
{
Button ParentItem = Sender as Button;
Singleton SingletonInstance = Singleton.Instance;
SingletonInstance.m_DataBase = DataBase;
SingletonInstance.SetDoThisAfterContextProcessingCall (DoThisAfterContextProcessingCall);
ContextMenu FrameContextMenu = new ContextMenu ();
ParentItem.ContextMenu = FrameContextMenu;
MenuItem ReloadDefaultFormat = new MenuItem ();
ReloadDefaultFormat.Header = "DefaultFormat";
FrameContextMenu.Items.Add (ReloadDefaultFormat);
ReloadDefaultFormat.Click += new RoutedEventHandler (ReloadDefaultFormat_Click);
int SelectedIndex = 0;
int LastSelectedIndex = -1;
if (SingletonInstance.ListOfPositioningWindows != null)
foreach (PositioningEntry PosWindow in SingletonInstance.ListOfPositioningWindows)
{
if (PosWindow.IsSelected == true)
LastSelectedIndex = SelectedIndex;
SelectedIndex++;
}
if ((SingletonInstance.ListOfPositioningWindows == null)
|| (LastSelectedIndex == -1))
{
MenuItem NewTextBlock = new MenuItem ();
NewTextBlock.Header = "Neuer TextBlock";
FrameContextMenu.Items.Add (NewTextBlock);
NewTextBlock.Click += new RoutedEventHandler (NewTextBlock_Click);
MenuItem NewPictureBlock = new MenuItem ();
NewPictureBlock.Header = "Neuer BildBlock";
FrameContextMenu.Items.Add (NewPictureBlock);
NewPictureBlock.Click += new RoutedEventHandler (NewPictureBlock_Click);
return;
}
MenuItem BlockToDelete = new MenuItem ();
BlockToDelete.Header = "Block löschen?";
FrameContextMenu.Items.Add (BlockToDelete);
BlockToDelete.Tag = SingletonInstance.ListOfPositioningWindows [LastSelectedIndex];
BlockToDelete.Click += new RoutedEventHandler (BlockToDelete_Click);
}
public bool CreateDefaultFormatDataSet(WCFStandardsNS.WCFStandards WPMediaAddOnDataDataBase,
DataSet FormatierDataSet, String WPMediaRoot)
{
String TableName = FormatierDataSet.Tables [0].TableName;
String ID = FormatierDataSet.Tables [TableName].Rows [0] ["ID"].ToString ();
String ControlFileName = GetActuallFormatDataSetFileName (WPMediaRoot, TableName, ID);
//if (File.Exists (ControlFileName))
// Basics.SecureFileDelete (ControlFileName);
Basics.SerializeObjectToFile (ControlFileName,
GetFormatierDataSet(WPMediaAddOnDataDataBase, TableName, ID, WPMediaRoot));
return true;
}
