void CheckAllEntries (List<String> PackageList)
{
DataSet PageEntriesDataSet =
m_DataBase.GetCommonDataSet (
"Select * from Pages where NameID > 'DefaultKarteiPage01' and NameID < 'DefaultKarteiPage10'");
if (PageEntriesDataSet.Tables ["Pages"].Rows.Count != 8)
throw new Exception ("Alles im Eimer bei \"PageEntriesDataSet\"");
foreach (String PackageName in PackageList)
{
GraphicsHandling Handler = new GraphicsHandling ();
Handler.GetInstatiatedPackage (PackageName, true);
DataSet FrameDataSet = Handler.FrameDataDataSetReader;
if (FrameDataSet.Tables ["FrameContent"].Select( "FormattingTemplate = 'DefaultKartei'").Length == 0)
continue;
bool UpdateRequired = false;
foreach (DataRow PageRow in PageEntriesDataSet.Tables ["Pages"].Rows)
{
String PageID = PageRow ["ID"].ToString ();
if (FrameDataSet.Tables ["Pages"].Select ("ID = '" + PageID + "'").Length == 0)
{
FrameDataSet.Tables ["Pages"].ImportRow (PageRow);
UpdateRequired = true;
}
}
String IDForOldEntry =
FrameDataSet.Tables ["Pages"].Select ("NameID = 'DefaultKarteiPage01'") [0] ["ID"].ToString ();
int PageIndex = 2;
while (PageIndex < 10)
{
String PageSearchString = "DefaultKarteiPage0" + Convert.ToString (PageIndex);
String IDForNewEntry =
FrameDataSet.Tables ["Pages"].Select ("NameID = '" + PageSearchString + "'") [0] ["ID"].ToString ();
foreach (DataRow ContentRow in FrameDataSet.Tables ["FrameContent"].Select
("PageID = '" + IDForOldEntry + "' and MultiPageIndex = " + Convert.ToString (PageIndex), "FrameOrder"))
{
String NameID = ContentRow ["NameID"].ToString ();
String ItemName = ContentRow ["ItemName"].ToString ();
ContentRow ["PageID"] = IDForNewEntry;
UpdateRequired = true;
}
PageIndex++;
}
if (UpdateRequired == true)
{
Handler.RenewFrameDataSet (FrameDataSet);
Handler.Close ();
}
WMB.Basics.DoEvents ();
}
}
void CorrectThisEntry (String PackageName)
{
GraphicsHandling Handler = new GraphicsHandling ();
Handler.GetInstatiatedPackage (PackageName, true);
DataSet FrameDataSet = Handler.FrameDataDataSetReader;
bool UpdateRequired = false;
foreach (DataRow ContentRow in FrameDataSet.Tables ["FrameContent"].Select ("", "FrameOrder"))
{
String FrameContentID = "421156b1-f009-47c7-a6c6-913d7ab7dbd7";
if (ContentRow ["ID"].ToString () == FrameContentID)
UpdateRequired = true;
if (!UpdateRequired)
continue;
String NameID = ContentRow ["NameID"].ToString ();
String ItemName = ContentRow ["ItemName"].ToString ();
if ((NameID == "KurzText")
&& (ItemName == "LangTextSeite1"))
{
ContentRow ["NameID"] = "LangTextSeite1";
ContentRow ["ItemName"] = "LangTextSeite1";
continue;
}
if ((NameID == "LangtextSeite1")
&& (ItemName == "LangTextSeite2"))
{
ContentRow ["NameID"] = "LangTextSeite2";
continue;
}
if ((NameID == "LangtextSeite2")
&& (ItemName == "LangTextSeite3"))
{
ContentRow ["NameID"] = "LangTextSeite3";
continue;
}
if ((NameID == "LangtextSeite3")
&& (ItemName == "LangTextSeite4"))
{
ContentRow ["NameID"] = "LangTextSeite4";
continue;
}
if ((NameID == "LangtextSeite4")
&& (ItemName == "LangTextSeite4"))
{
ContentRow ["NameID"] = "LangTextSeite5";
ContentRow ["ItemName"] = "LangTextSeite5";
continue;
}
String PictureName = ContentRow ["PictureName"].ToString ();
}
if (UpdateRequired == true)
{
Handler.RenewFrameDataSet (FrameDataSet);
}
Handler.Close ();
}
public bool DoTemplating (Object Sender, String FileNameToTemplate, String TemplateTableName, String TemplateTableID)
{
String TemplateFileName = CheckLoadAndGetFileNameOfTemplate (TemplateTableName, TemplateTableID);
CVM.GraphicsHandling ToTemplateGraphicsHandler = new GraphicsHandling (Basics.GetLocalWPMediaRoot ());
ToTemplateGraphicsHandler.GetInstatiatedPackage (FileNameToTemplate);
ToTemplateGraphicsHandler.Close ();
Basics.SecureFileDelete (FileNameToTemplate);
File.Copy (TemplateFileName, FileNameToTemplate);
CVM.GraphicsHandling TemplateGraphicsHandler = new GraphicsHandling (Basics.GetLocalWPMediaRoot ());
Object TemplatePkg = TemplateGraphicsHandler.GetInstatiatedPackage (FileNameToTemplate, true);
DataRow ToTemplateFrameContentRow = ToTemplateGraphicsHandler.ActuallReadableContentRow;
DataRow TemplateFrameContentRow = TemplateGraphicsHandler.ActuallReadableContentRow;
Basics.ReplaceTableInDataSet (TemplateGraphicsHandler.FrameDataDataSetReader, TemplateFrameContentRow.Table,
ToTemplateFrameContentRow.Table);
Basics.CopyDataRowToDataRow (ToTemplateGraphicsHandler.FrameDataDataSetReader.Tables ["TableDefinitions"].Rows [0],
TemplateGraphicsHandler.FrameDataDataSetReader.Tables ["TableDefinitions"].Rows [0]);
TemplateGraphicsHandler.RenewFrameDataSet ();
TemplateGraphicsHandler.Close ();
return true;
}
