private void Button_Click(object sender, RoutedEventArgs e) { Package p = new Package(); p.unique_identifier = "boo"; p.version = "1"; Manifest manifest = new Manifest(); manifest.AddItem(new Item("id1",".\\test.html","application/xhtml+xml", null)); manifest.AddItem(new Item("id2", ".\\test.html", "application/xhtml+xml", null)); manifest.AddItem(new Item("toc", txtNcxFile.Text, "application/x-dtbncx+xml", null)); p.myManifest = manifest; Metadata metadata = new Metadata(); p.myMetadata = metadata; metadata.title = "My title"; Spine s = new Spine("ncx"); s.AddItemRef(new ItemRef("id11","yes")); s.AddItemRef(new ItemRef("id12","yes")); p.mySpine = s; Guide g = new Guide(); g.AddReference(new Reference("toc", "title",txtNcxFile.Text)); g.AddReference(new Reference("toc1", "title2", ".//ref.html")); p.myGuide = g; TextWriter tw = serialise(p); txtPackage.Text = tw.ToString(); tw.Close(); NavigationCentereXtended ncx = new NavigationCentereXtended(); ncx.myDocAuthor = new DocAuthor("John h author"); ncx.myDocTitle = new DocTitle("My Book.."); ncx.myNavList.AddNavTarget(new NavTarget(new NavLabel("Nav Label 1"), new Content("content.html"))); ncx.myNavList.AddNavTarget(new NavTarget(new NavLabel("Nav Label 2"), new Content("content2.html"))); ncx.myNavMap.AddNavPoint(new NavPoint(1, "id1", "point class", new NavLabel("Nav Label 1"), new Content("srctext"))); ncx.myNavMap.AddNavPoint(new NavPoint(1, "id1", "point class2 ", new NavLabel("Nav Label 2"), new Content("srctext"))); ncx.myNcxHead = new NcxHead(); ncx.myNcxHead.myMeta = new Meta("content", "name"); ncx.myPageList.AddPageTarget(new PageTarget("id1", "type", "value", new NavLabel("txtLabel"), new Content("src1"))); ncx.myPageList.AddPageTarget(new PageTarget("id2", "type", "value", new NavLabel("txtLabel2"), new Content("src2"))); TextWriter tw2 = serialise(ncx); txtNcx.Text = tw2.ToString(); tw2.Close(); }
/// <summary> /// Inserts the or update package. /// </summary> /// <param name="package">The package.</param> public void InsertOrUpdatePackage(Package package) { lock (this.dataContextLock) { this.CreateDBIfNotExist(); using (var dataContext = new DBContext()) { var queryPackage = from item in dataContext.PackageTable where item.PackageId == package.PackageId select item; if (queryPackage.Any()) { Package databasePackage = queryPackage.First(); databasePackage.CopyFrom(package); } else { dataContext.PackageTable.InsertOnSubmit(package); } dataContext.SubmitChanges(); } } }
private Package run_etl(Package x, string y, Microsoft.SqlServer.Dts.Runtime.Application z) { x = z.LoadPackage(@y, null); return x; }