Esempi in C# (CSharp) per PageGroup.Copy_BundledData_In_New_DataSet

Esempio n. 1

File: ProgrammSchemaModell.cs Progetto: heinzsack/DEV

		/*
		 * use WPMedia

use WPMedia

select * from Timings where ConnectedId in 
	(select BeitragID from  VideoFilesZuBeitraege where FileID in (SELECT FileID 
		  FROM [WPMedia].[dbo].[VideoFiles] where not BeitragsTyp = 'PlayingPackage' 
		  and not BeitragsTyp = 'Video' 
		  and not BeitragsTyp = 'ExternesProgramm'))

select * from StructuredMaterialDataBase where FileId in
	(SELECT FileID 
		  FROM [WPMedia].[dbo].[VideoFiles] where not BeitragsTyp = 'PlayingPackage' 
		  and not BeitragsTyp = 'Video' 
		  and not BeitragsTyp = 'ExternesProgramm')

select * from BeitraegeZuZuordnungen where BeitragID in (select BeitragID from Beitraege where BeitragId in
	(select BeitragID from  VideoFilesZuBeitraege where FileID in (SELECT FileID 
		  FROM [WPMedia].[dbo].[VideoFiles] where not BeitragsTyp = 'PlayingPackage' 
		  and not BeitragsTyp = 'Video' 
		  and not BeitragsTyp = 'ExternesProgramm')))

E06B9253-D90C-4ABC-B333-05880EC9697B
9AC3704B-D62E-4D99-87F7-0F5DF8E87380
E5586956-54FF-4C1B-B71C-1C96AF03009B
2FF02774-2E2B-41A7-A65C-22D50585A465
29399797-9387-4C3C-A833-24F0C00FC2BB
577A17CE-2154-4429-886B-26CAFFBE965B
77E133F3-3AA9-48E7-9E15-418DC4941493
684B80E9-E585-425F-BC90-514AD22A5245
1A27507B-1E93-458B-805B-5F0CA806E2D3
88C3DB2B-76F9-42E5-B521-75D8E1F4D9D0
AA129509-DFC9-4625-91C3-A94B4D27CBD6
6E6CD009-1CB2-4AB0-A57D-F1B453D8FB56
BA7E7E24-8B11-46B9-B9A2-F948ED792722

select * from Beitraege where BeitragId in
	(select BeitragID from  VideoFilesZuBeitraege where FileID in (SELECT FileID 
		  FROM [WPMedia].[dbo].[VideoFiles] where not BeitragsTyp = 'PlayingPackage' 
		  and not BeitragsTyp = 'Video' 
		  and not BeitragsTyp = 'ExternesProgramm'))

SELECT * FROM [WPMedia].[dbo].[VideoFiles] where not BeitragsTyp = 'PlayingPackage' 
		  and not BeitragsTyp = 'Video' 
		  and not BeitragsTyp = 'ExternesProgramm'

select * from VideoFiles where not FileID in (SELECT FileID 
		  FROM VideoFilesZuBeitraege ) and beitragsTyp = 'ExternesProgramm' 

 select * from StructuredMaterialDataBase where FileId in
	(SELECT FileID from VideoFiles where not FileID in (SELECT FileID 
		  FROM VideoFilesZuBeitraege ) and beitragsTyp = 'ExternesProgramm')

				*/

		#region Manipulating PlayLists


		public String CreateAndStorePageGroupAsDataSet(PageGroup pageGroup, String pageGroupSerializedName = "")
			{
			pageGroup.DataSet.SetHasBeenLoaded();
			RingPlayerDb dataSet = pageGroup.Copy_BundledData_In_New_DataSet(true);
			
			FileInfo fileInfo;
			if (String.IsNullOrEmpty(pageGroupSerializedName))
				fileInfo = VisualBasics.CreateScreenGroupFileInfo(pageGroup.Id, pageGroup.Name);
			else
				fileInfo = VisualBasics.GetWeatherScreenGroupFileInfo($"{pageGroupSerializedName}.ScreenGroup");
			if (!fileInfo.Exists)
				dataSet.SaveAs_SerializedBinary(fileInfo);
			return fileInfo.FullName;
			}