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