Ejemplo n.º 1
0
		public static String LoadFileContentAsString(Materialien MaterialContainer)
			{
			WCFStandards DataAccess = new WCFStandards();
			String SelectStatement = "select BlobContent from Materialien where ID = '" + MaterialContainer.ID.ToString() + "'";
			Byte [] Result = DataAccess.GetCommonBlob (SelectStatement);
			if ((Result != null)
				&& (Result.Length > 0))
				using (MemoryStream Helper = new MemoryStream(Result))
					{
					return Basics.ConvertMemoryStreamToString(Helper);
					}
			return String.Empty;
			}
Ejemplo n.º 2
0
		public static String LoadFileContentAsString (Materialien MaterialContainer)
			{
			WCFStandards DataAccess = new WCFStandards();
			String SelectStatement = "select BlobContent = @BlobParam from Materialien where ID = '" + MaterialContainer.ID.ToString() + "'";
			using (MemoryStream Helper = new MemoryStream (DataAccess.GetCommonBlob (SelectStatement)))
				{
				return WMB.Basics.ConvertMemoryStreamToString (Helper);
				}
			}
Ejemplo n.º 3
0
		public static Byte[] LoadFileContent(Materialien MaterialContainer)
			{
			WCFStandards DataAccess = new WCFStandards();
			String SelectStatement = "select BlobContent from Materialien where ID = '" + MaterialContainer.ID.ToString() + "'";
			return DataAccess.GetCommonBlob(SelectStatement);
			}
Ejemplo n.º 4
0
	static public List<BitmapSource> GetAvailablePictures (DataRow ProcessingRow)
		{
		String TableName = ProcessingRow ["Tabelle"].ToString ();
		String TableID = ProcessingRow ["TabelleID"].ToString ();
		WCFStandardsNS.WCFStandards DataAccess = new WCFStandards ();
		DataAccess.DefaultConnectionStringName = "WPMediaAddOnDataConnectionString";
		DataSet AvailablePicturesEntries = DataAccess.GetCommonDataSet ("Select ID from Materialien where Tabelle = '"
		            + TableName + "' and TabelleID = '" + TableID + "'");
		List<BitmapSource> Result = new List<BitmapSource> ();
		foreach (DataRow Available in AvailablePicturesEntries.Tables ["Materialien"].Rows)
			{
			String ID = Available ["ID"].ToString ();
			Byte [] JpegBytes = DataAccess.GetCommonBlob ("Select BlobContent from Materialien where ID = '" + ID + "'");
			BitmapSource PictureData = XAMLHandling.ConvertJPegStreamToBitmapSource (JpegBytes);
			Result.Add (PictureData);
			}

		return Result;
		}