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;
}
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 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);
}
