private void Window_Loaded ( object sender, RoutedEventArgs e )
{
WPMediaNetworkAccess.WPMediaDataBase DataBase = new WPMediaDataBase ();
DataSet Schema = DataBase.GetSimpleSchemaDataSet ();
int i = 1;
i++;
//CommonWCFService.CommonWCFServiceClient WCFAccess = new CommonWCFService.CommonWCFServiceClient ();
//WCFAccess.ClientCredentials.UserName.UserName = "******";
//WCFAccess.ClientCredentials.UserName.Password = "******";
//CommonWCFService.ICommonWCFService CommonInterface = WCFAccess as CommonWCFService.ICommonWCFService;
//CommonWCFService.ICommonWCFServiceChannel CommonServiceChannel = WCFAccess as CommonWCFService.ICommonWCFServiceChannel;
//WCFAccess.OpenConnection ("Heinz", "monika", "WPMediaConnectionString");
//String BeitragID = "CD1D199C-E481-4A69-8DC5-B5489E2EB9FB";
//DataSet TimedBeitraege = WCFAccess.GetTimingsReducedTable (DateTime.Now.ToString (),
// "Select BeitragID, Name from Beitraege where BeitragID = '" + BeitragID + "'", "BeitragID", String.Empty, String.Empty);
//DataTable TimedTable = TimedBeitraege.Tables ["Beitraege"];
//int Count = TimedTable.Rows.Count;
//String Base64Pixel = new String ('x', 1256000);
//DataSet TestDataSet = WCFAccess.GetAllForBeitrag ("Heinz;monika", "Haus", BeitragID, false, false, true);
//WCFAccess.SetPictureForBeitrag ("Heinz;monika", BeitragID, Base64Pixel);
//DataGrid TestDataGrid = new DataGrid ();
//RootGrid.Children.Add (TestDataGrid);
//TestDataGrid.ItemsSource = TestDataSet.Tables ["StructuredMaterial"].DefaultView;
//DataSet HausScheduling = WCFAccess.GetActuallScheduling ("Heinz", "Haus", DateTime.Now.Date, DateTime.Now.AddDays ( 1 ).Date );
//DataSet KircheScheduling = WCFAccess.GetActuallScheduling ("Kirche", DateTime.Now.Date, DateTime.Now.AddDays (1).Date);
//DataSet KaufParkScheduling = WCFAccess.GetActuallScheduling ("Kaufpark", DateTime.Now.Date, DateTime.Now.AddDays (1).Date);
//DataSet WohnParkScheduling = WCFAccess.GetActuallScheduling ("Wohnpark", DateTime.Now.Date, DateTime.Now.AddDays (1).Date);
//DataSet SchemaDataSet = WCFAccess.GetCommonSchemaDataSet ("Heinz");
//DataSet HausIndependent = WCFAccess.GetProgrammIndependentTables ("Haus");
//DataSet KircheIndependent = WCFAccess.GetProgrammIndependentTables ("Kirche");
//DataSet KaufparkIndependent = WCFAccess.GetProgrammIndependentTables ("Kaufpark");
//DataSet WohnparkIndependent = WCFAccess.GetProgrammIndependentTables ("Wohnpark");
//WCFAccess.Close ();
}
private void Window_Loaded (object sender, RoutedEventArgs e)
{
//DataTable Test = CommonDataBase.CSVHandling.GetTableFromCSVTextFile
// ("D:\\MBRWahl2011Basis\\MBRWahl\\DatenAusSchließAnlage\\TopListe20110927.csv", "TopListe", '\t');
//m_DataBase = new WPMediaDataBase ();
//m_DataBase.ConnectionStringName = "MBRConnectionString";
//m_DataBase.UserName = "******";
//m_DataBase.PassWord = "******";
m_LocalDataBase = new WPMediaDataBase ();
m_LocalDataBase.ConnectionStringName = "MBRConnectionString";
m_LocalDataBase.UserName = "******";
m_LocalDataBase.PassWord = "******";
String UserName = null;
String [] Rollen = m_LocalDataBase.CheckUser (ref UserName);
DataSet LocalKeyDataSet = m_LocalDataBase.GetCommonDataSet ("Select * from KeyDaten");
int NumberOfEntries = LocalKeyDataSet.Tables ["KeyDaten"].Rows.Count;
foreach (DataRow Row in LocalKeyDataSet.Tables ["KeyDaten"].Rows)
{
String KartenNr = Row ["KartenNr"].ToString ();
if (String.IsNullOrEmpty (KartenNr))
continue;
MessageBox.Show ("Gefunden - " + KartenNr);
}
Close ();
return;
ManagedBeitraege.ManagedBeitraegeWindow BeitragsWindow = new ManagedBeitraegeWindow ();
if (BeitragsWindow.ShowDialog () == true)
{
MessageBox.Show ("Selected ID = \"" + BeitragsWindow.SelectedBeitragID + "\"\r\n\"" +
BeitragsWindow.SelectedBeitragName + "\"");
}
Close ();
return;
HTMLCreator TestHTMLCreator = new HTMLCreator ();
TestHTMLCreator.SetData ("D:\\WPMediaSender\\XMLs\\WPMediaProgramm.ser");
TestHTMLCreator.CreateHTML ();
// CreateKalenderKeyTables ();
Close ();
}
void CreateKalenderKeyTables ()
{
m_DataBase = new WPMediaDataBase ();
m_DataBase.ConnectionStringName = "WPMediaAddOnDataConnectionString";
DataSet KalenderDataSet = m_DataBase.GetCommonDataSet ("Select * from Kalender");
DataSet KeyDataSet = m_DataBase.GetCommonDataSet (new string []
{"Select* from KalenderOrganisation",
"Select * from KalenderPerson",
"Select * from KalenderTyp",
"Select * from KalenderVeranstaltungsOrt"});
KeyDataSet.Tables ["KalenderOrganisation"].Clear ();
KeyDataSet.Tables ["KalenderPerson"].Clear ();
KeyDataSet.Tables ["KalenderTyp"].Clear ();
KeyDataSet.Tables ["KalenderVeranstaltungsOrt"].Clear ();
m_DataBase.SetCommonDataSet (KeyDataSet);
KeyDataSet = m_DataBase.GetCommonDataSet (new string []
{"Select* from KalenderOrganisation",
"Select * from KalenderPerson",
"Select * from KalenderTyp",
"Select * from KalenderVeranstaltungsOrt"});
KeyDataSet.AcceptChanges ();
LoadBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Veranstalter", "KalenderOrganisation", "NameID");
FillBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Veranstalter", "KalenderOrganisation", "NameID",
new String [] { "OrganisationAdresse", "OrganisationeMail", "OrganisationUrl",
"OrganisationTelefon", "OrganisationTelefax", "OrganisationTeletext", "OrganisationLogoDatei" },
new String [] {"Adresse", "eMail", "Url", "Telefon", "Fax", "TTX", "LogoDatei" });
LoadBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "KontaktPerson", "KalenderPerson", "NameID");
FillBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "KontaktPerson", "KalenderPerson", "NameID",
new String [] { "PersonTitel", "PersoneMail", "PersonUrl",
"PersonTelefon", "PersonTelefax", "PersonBildDatei" },
new String [] { "Titel", "eMail", "Url", "Telefon", "Fax", "BildDatei" });
LoadBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Typ", "KalenderTyp", "NameID");
FillBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Typ", "KalenderTyp", "NameID",
new String [] { },
new String [] { });
LoadBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Ort", "KalenderVeranstaltungsOrt", "NameID");
FillBasicTable (KeyDataSet, KalenderDataSet.Tables ["Kalender"], "Ort", "KalenderVeranstaltungsOrt", "NameID",
new String [] { "VeranstaltungsOrtOrt", "VeranstaltungsOrtUrl", "VeranstaltungsOrtTelefon",
"VeranstaltungsOrtTelefax", "VeranstaltungsTypBildDatei",
"VeranstaltungsOrtBildDatei", "VeranstaltungsOrtLagePlan" },
new String [] { "Adresse", "Url", "Telefon", "Fax", "LogoDatei", "BildDatei", "LagePlan" });
m_DataBase.SetCommonDataSet (KeyDataSet);
}
