public CreateDataForLeisureDisplay () { WPMediaAddOnDataAccess= new WCFStandards (); WPMediaAddOnDataAccess.DefaultConnectionStringName = "WPMediaAddOnDataConnectionString"; AEAGDataAccess = new WCFStandards (); AEAGDataAccess.DefaultConnectionStringName = "AEAGConnectionString"; }
public static List<String> GetMaterialElementeForThisInformation (String InformationenID) { WCFStandards Helper = new WCFStandards (); DataTable MaterialTable = Helper.GetCommonDataSet ("Select TechnicalAddOn from InformationenAddOn where InformationenID = '" + InformationenID + "' and TechnicalAddOn > ' '").Tables ["InformationenAddOn"]; List<String> PictureElementeForThisInformation = new List<String> (); foreach (DataRow PictureElementRow in MaterialTable.Rows) { String [] SingleTechnicalAddOn = PictureElementRow ["TechnicalAddOn"].ToString ().Split (';'); foreach (String Entry in SingleTechnicalAddOn) PictureElementeForThisInformation.Add (Entry.Trim ( )); } return PictureElementeForThisInformation; }
public Object CheckAndGetInstatiatedPackage (WCFStandards m_DataBase , String TableToProcess , String SelectedID ) { Paketieren.PackagingHandler Pkg; DataSet ActuallRowDataSet = m_DataBase.GetCommonDataSet ("Select * from " + TableToProcess + " where ID = '" + SelectedID + "'"); if ((ActuallRowDataSet.Tables.Count != 1) || (ActuallRowDataSet.Tables [0].Rows.Count != 1)) throw new Exception ("ActuallRowDataSet nicht gefüllt bei Table " + TableToProcess + " und ID = " + SelectedID); if (!CheckForIncompleteEntry (ActuallRowDataSet.Tables [0].Rows [0])) { Pkg = (Paketieren.PackagingHandler) GetInstatiatedPackage (m_DataBase, TableToProcess, SelectedID); } else { String PackageName = GetPackageName (TableToProcess, SelectedID); if (File.Exists (PackageName)) { FileInfo FInfo = new FileInfo (PackageName); DateTime RemoteLastWriteTime = DateTime.MinValue; RemoteLastWriteTime = GetLastWriteTimeForServerFileCall (Basics.GetRemoteFileNameFromLocalFileName (PackageName)); if (RemoteLastWriteTime == DateTime.MinValue) RemoteLastWriteTime = GetLastWriteTimeForServerFileCall (Basics.GetRemoteArchivFileNameFromLocalFileName (PackageName)); if (RemoteLastWriteTime != DateTime.MinValue) { if (RemoteLastWriteTime > FInfo.LastWriteTime.AddSeconds (180)) Basics.SecureFileDelete (PackageName); } } if (!File.Exists (PackageName)) { if (DoCentralFileDownloadCall != null) { DoCentralFileDownloadCall (TableToProcess, PackageName, Basics.GetRemoteFileNameFromLocalFileName (PackageName)); if (!File.Exists (PackageName)) { DoCentralFileDownloadCall (TableToProcess, PackageName, Basics.GetRemoteArchivFileNameFromLocalFileName (PackageName)); if (File.Exists (PackageName)) LoadedFromTheArchive = true; } } } if (File.Exists (PackageName)) Pkg = (Paketieren.PackagingHandler) GetInstatiatedPackage (TableToProcess, SelectedID); else Pkg = (Paketieren.PackagingHandler) GetInstatiatedPackage (m_DataBase, TableToProcess, SelectedID); } ModificationRequired = false; return Pkg; }
void InsertRuW_Ausnahmen () { String StartRuWDateSQLCommand = TransportData.GetSQLFormattedDateTime(DateTime.Now.AddDays(-32)); String [] IIS_AE1_SelectCommands = new String [] { "Select * from RuW_Ausnahmen where Datum > " + StartRuWDateSQLCommand + " order by Datum" }; DataSet IIS_AE1_DataSet = DataBase.GetCommonMultiDataSet (IIS_AE1_SelectCommands); if (IIS_AE1_DataSet.Tables.Count != 1) { WMB.Basics.ReportErrorToEventViewer("Beim lesen der iis_ae1 Daten aus der DatenBank\r\n\"" + DataBase.DefaultConnectionStringName + "\"\r\nmit dem SQLString\r\n\"" + String.Join ("\r\n", IIS_AE1_SelectCommands) + "\"\r\n kamen nicht 1 Tables zurück"); throw new Exception ("Beim lesen der iis_ae1 Daten kamen nicht 1 Tables zurück"); } WCFStandardsNS.WCFStandards AEAGDataBase = new WCFStandards (); AEAGDataBase.DefaultConnectionStringName = "AEAGConnectionString"; String [] AEAG_SelectCommands = new String [] { "Select * from Ressource", "Select * from FullBookableUnits" }; DataSet AEAG_DataSet = AEAGDataBase.GetCommonMultiDataSet (AEAG_SelectCommands); if (AEAG_DataSet.Tables.Count != 2) { WMB.Basics.ReportErrorToEventViewer("Beim lesen der AEAG Daten aus der DatenBank\r\n\"" + AEAGDataBase.DefaultConnectionStringName + "\"\r\nmit dem SQLString \"" + String.Join("\r\n", AEAG_SelectCommands) + "\"\r\n kamen nicht 1 Tables zurück"); throw new Exception("Beim lesen der AEAG Daten kamen nicht 2 Tables zurück"); } NameValueCollection TypBloHalSauPlaConverter = LoadTypBloHalSauPlaConverter (AEAG_DataSet); foreach (DataRow AusnahmenRow in IIS_AE1_DataSet.Tables ["RuW_Ausnahmen"].Rows) { String TypBloHalSauPla = AusnahmenRow ["Typ"].ToString () + AusnahmenRow ["BloHal"].ToString () + AusnahmenRow ["SauPla"].ToString (); if ((TypBloHalSauPlaConverter [TypBloHalSauPla] == null) || String.IsNullOrEmpty (TypBloHalSauPlaConverter [TypBloHalSauPla])) { WMB.Basics.ReportErrorToEventViewer ("AEAGProcessCollectedData.InsertRuW_Ausnahmen", "\"" + TypBloHalSauPla + "\" aus den RuW_Ausnahmen ist in Ressourcen nicht definiert"); continue; } String RessourceID = TypBloHalSauPlaConverter [TypBloHalSauPla]; if (String.IsNullOrEmpty (RessourceID)) { WMB.Basics.ReportErrorToEventViewer("\"" + TypBloHalSauPla + "\" aus den RuW_Ausnahmen ist in Ressourcen nicht definiert"); throw new Exception ("\"" + TypBloHalSauPla + "\" aus den RuW_Ausnahmen ist in Ressourcen nicht definiert"); } String TimingTypForThisRessource = AEAG_DataSet.Tables ["FullBookableUnits"] .Select ("RessourceID = '" + RessourceID + "'") [0] ["TimingTyp"].ToString (); int NumberOfHoursForOneBooking = 0; if (TimingTypForThisRessource == "Stunde") NumberOfHoursForOneBooking = 1; if (TimingTypForThisRessource == "Doppel") NumberOfHoursForOneBooking = 2; int StartValue = Convert.ToInt32 (AusnahmenRow ["Start"]); int DauAnz = Convert.ToInt32 (AusnahmenRow ["Dauer"]); int GeneratingStep = 0; while ((GeneratingStep * NumberOfHoursForOneBooking) < DauAnz) { int BeginnValue = StartValue + GeneratingStep * NumberOfHoursForOneBooking; GeneratingStep++; if ((BeginnValue < 7) || (BeginnValue > 21)) continue; String StartHour = Convert.ToString (BeginnValue + 100).Substring (1); DataRow [] SelectedBookables = AEAG_DataSet.Tables ["FullBookableUnits"].Select ("RessourceID = '" + RessourceID + "' and TimingTyp = '" + TimingTypForThisRessource + "'", "TimeTableNameID"); if (SelectedBookables.Length < 1) { WMB.Basics.ReportErrorToEventViewer ("AEAGProcessCollectedData.InsertRuW_Ausnahmen", "\"" + RessourceID + "\" mit \"" + TimingTypForThisRessource + "\" ist in Ressourcen nicht definiert"); continue; } String BookableUnitID = String.Empty; foreach (DataRow Entry in SelectedBookables) { if (Entry ["TimeTableNameID"].ToString ().Substring (0, 2) == StartHour) { BookableUnitID = Entry ["ID"].ToString (); break; } } if (String.IsNullOrEmpty (BookableUnitID)) continue; DateTime BookedFor = Convert.ToDateTime (AusnahmenRow ["Datum"]).Date; String OldContent = GetBooking (AEAGDataBase, BookableUnitID, BookedFor); String NewContent = AusnahmenRow ["Art"].ToString (); if (OldContent != NewContent) { DateTime BookingDateTime = DateTime.Now; SetBooking (AEAGDataBase, BookableUnitID, BookedFor, NewContent, BookingDateTime); } } } }
public bool Run () { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("Starting Run ()"); DataBase = new WCFStandards(); DataBase.DefaultConnectionStringName = "IIS_AE1_ConnectionString"; String DeviceToCheck = String.Empty; String TransportDirectoryName = String.Empty; if (String.Compare (WMB.Basics.GetComputerName ().ToUpper( ), "HEINZ64", true) == 0) { DeviceToCheck = WMB.Basics.GetUserConfigurationSettingsValue ("DeviceOnHeinz64"); } if (String.Compare (WMB.Basics.GetComputerName ().ToUpper( ), "KPINFO01", true) == 0) { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("Before Try Read DeviceToCheck on \"" + WMB.Basics.GetComputerName().ToUpper() + "\""); DeviceToCheck = WMB.Basics.GetUserConfigurationSettingsValue("DeviceOnKPInfo01") + ":\\"; if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("Read DeviceToCheck on \"" + WMB.Basics.GetComputerName().ToUpper() + "\" resulted in \"" + DeviceToCheck + "\""); DeviceToCheck = SearchForCorrectDevice(DeviceToCheck, WMB.Basics.GetUserConfigurationSettingsValue ("TransportDirectory")); if (String.IsNullOrEmpty (DeviceToCheck)) { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("AEAGLeisureManagement.ProcessCollectedData.Run", "Error by SearchForCorrectDevice für \"" + WMB.Basics.GetUserConfigurationSettingsValue("DeviceOnKPInfo01") + ":\\" + "\", \"" + WMB.Basics.GetUserConfigurationSettingsValue("TransportDirectory") + "\" ended with errors"); //Messages.Add (WMB.Basics.GetUserConfigurationSettingsValue ("DeviceOnKPInfo01") + ":\\" + " as Parameter not set"); return false; } } if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("DeviceToCheck on \"" + WMB.Basics.GetComputerName ().ToUpper( ) + "\" = \"" + DeviceToCheck + "\""); TransportDirectoryName = Path.Combine(DeviceToCheck, WMB.Basics.GetUserConfigurationSettingsValue ("TransportDirectory")); if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("TransportDirectoryName = \"" + TransportDirectoryName + "\""); try { if (!Directory.Exists (TransportDirectoryName)) Directory.CreateDirectory (TransportDirectoryName); } catch (Exception Excp) { Messages.Add ("Create Directory for \"" + TransportDirectoryName + "\" not funtioning properly:\r\n" + Excp.ToString()); return false; } String ToProcessFileName = TransportData.DataBaseCommandsResultsFileName (TransportDirectoryName); TransportData.DataBaseCommandsToProcessFileName (TransportDirectoryName); if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("AEAGLeisureManagement.ProcessCollectedData.Run", "ProcessDataRead (TransportDirectoryName) für \"" + TransportDirectoryName + "\"\r\nund \"ToProcessFileName\" = \"" + ToProcessFileName + "\" Started"); if (!ProcessDataRead(TransportDirectoryName)) { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer ("AEAGLeisureManagement.ProcessCollectedData.Run", "ProcessDataRead (TransportDirectoryName) für \"" + TransportDirectoryName + "\" ended with Nothing Read"); //Messages.Add ("ProcessDataRead (\"" + TransportDirectoryName+ "\"\r\nund \"ToProcessFileName\" = \"" // + ToProcessFileName + "\" ended with Nothing Read"); if (File.Exists(TransportData.DataBaseCommandsToProcessFileName(TransportDirectoryName))) return false; } else { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer ("AEAGLeisureManagement.ProcessCollectedData.Run", "ProcessDataRead (TransportDirectoryName) für \"" + TransportDirectoryName + "\" ended correctly"); Messages.Add ("ProcessDataRead (\"" + TransportDirectoryName+ "\"\r\nund \"ToProcessFileName\" = \"" + ToProcessFileName + "\" ended correctly"); } bool Return = false; try { Return = ProcessCreateCommandsFoNextRun(TransportDirectoryName); } catch (Exception Excp) { WMB.Basics.ReportErrorToEventViewer ("Fehler bei \"ProcessCreateCommandsFoNextRun(" + TransportDirectoryName + ")\":\r\n" + Excp.ToString ()); } if (!Return) { if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer ("AEAGLeisureManagement.ProcessCollectedData.Run", "ProcessCreateCommandsFoNextRun (TransportDirectoryName) für \"" + TransportDirectoryName + "\" ended with errors"); Messages.Add ("ProcessCreateCommandsFoNextRun (\"" + TransportDirectoryName + "\") ended with Errors"); return false; } return true; }
String GetBooking (WCFStandards AEAGDataBase, String BookableUnitsID, DateTime BookedFor) { DataSet TodaysBooking = AEAGDataBase.GetCommonDataSet ("Select * from Booking where BookedFor = " + TransportData.GetSQLFormattedDateTime(BookedFor) + " and BookableUnitsID = '" + BookableUnitsID + "'"); if (TodaysBooking.Tables ["Booking"].Rows.Count == 0) return String.Empty; return TodaysBooking.Tables ["Booking"].Rows [0] ["BookingStatus"].ToString (); }
private List<SelectionDataClass> LoadMyOrUsedSelectionData (InformationenAddOn InfoAddOn, String BereichToUse, TemplateManagement.AuswahlSelection EntriesToShow, TemplateManagement.AuswahlSortOrder SortOrder) { String SelectClause = String.Empty; SelectClause = TemplateManagement.GetMyOrUsedUnifiedTableIDsSelectClause (InfoAddOn, EntriesToShow); if (String.IsNullOrEmpty (SelectClause)) return new List<SelectionDataClass> (); WCFStandards DataAccess = new WCFStandards (); DataSet ResultDataSet = null; if (SortOrder == TemplateManagement.AuswahlSortOrder.Alphabetic) ResultDataSet = DataAccess.GetCommonDataSet ("Select " + String.Join (", ", ItemsToSelectForSelection) + " from " + ViewNameForSelection + " where ( " + TemplateManagement.GetWhereClauseFromBereich (BereichToUse) + " ) and " + SelectClause + " order by " + String.Join (", ", SortingItemsForSelection)); else ResultDataSet = DataAccess.GetCommonDataSet ("Select " + String.Join (", ", ItemsToSelectForSelection) + " from " + ViewNameForSelection + " where ( " + TemplateManagement.GetWhereClauseFromBereich (BereichToUse) + " ) and " + SelectClause ); return GetSelectionDataFormatting (ResultDataSet.Tables [ViewNameForSelection]); }
public String GetTypeSelectClause(InformationenAddOn InfoAddOn, Guid? TypesToProcess) { WCFStandards DataAccess = new WCFStandards(); DataSet TypeInformationenIDs = DataAccess.GetCommonDataSet("Select ID from Informationen where TypID ='" + ((Guid)TypesToProcess).ToString() + "'"); if (TypeInformationenIDs.Tables["Informationen"].Rows.Count == 0) return String.Empty; List<string> IDsToSearchFor = new List<string>(); foreach (DataRow IDRow in TypeInformationenIDs.Tables["Informationen"].Rows) IDsToSearchFor.Add(IDRow["ID"].ToString()); String InfoAddOnSelectClause = " (InformationenID = '" + String.Join("' or InformationenID = '", IDsToSearchFor.ToArray()) + "') "; DataSet DistinctEntries = DataAccess.GetCommonDataSet("Select distinct (TabelleID), count (*) as Occurence from " + " InformationenAddOn where Tabelle = '" + InfoAddOn.Tabelle + "' and " + InfoAddOnSelectClause + " Group By TabelleID order by Occurence"); if (DistinctEntries.Tables["InformationenAddOn"].Rows.Count == 0) return String.Empty; List<string> TabelleIDSearchFor = new List<string>(); foreach (DataRow IDRow in DistinctEntries.Tables["InformationenAddOn"].Rows) TabelleIDSearchFor.Add(IDRow["TabelleID"].ToString()); return " (ID = '" + String.Join("' or ID = '", TabelleIDSearchFor.ToArray()) + "') "; }
private static void DeleteDeleteteAbleTableEntriesFromDataBase(Informationen ActuallInformation) { WCFStandards DataAccess = new WCFStandards (); DataTable ExistingInformationenAddOn = DataAccess.GetCommonDataSet ("Select * from InformationenAddOn where InformationenID = '" + ActuallInformation.ID.ToString () + "'").Tables ["InformationenAddOn"]; foreach (DataRow InfoAddOn in ExistingInformationenAddOn.Rows) { if ((String.IsNullOrEmpty (InfoAddOn ["Tabelle"].ToString ())) || (InfoAddOn ["TabelleID"] == Convert.DBNull) || (InfoAddOn["Tabelle"].ToString() == "Timings")) continue; DataRowCollection ExistingReferences = DataAccess.GetCommonDataSet ("Select * from InformationenAddOn where not InformationenID = '" + ActuallInformation.ID.ToString() + "' and Tabelle = '" + InfoAddOn["Tabelle"].ToString() + "' and TabelleID = '" + InfoAddOn["TabelleID"].ToString () + "'").Tables["InformationenAddOn"].Rows; if (ExistingReferences.Count > 0) continue; String DeleteStatement = "Delete from " + InfoAddOn ["Tabelle"].ToString () + " where ID = '" + InfoAddOn ["TabelleID"].ToString () + "'"; RunSQLBatch(DeleteStatement); } }
public static bool DoInformationenUpdate (Informationen ActuallInformation, ITemplateElementeBackgroundFunctions EntryToProcess) { //if (EntryToProcess.InfoAddOn.Informationen != ActuallInformation) // throw new Exception ("EntryToProcess.InfoAddOn.Informationen != ActuallInformation"); WCFStandards ExistenceCheck = new WCFStandards (); DataTable InformationenTable = ExistenceCheck.GetCommonDataSet ("Select * from Informationen where ID = '" + ActuallInformation.ID.ToString () + "'").Tables ["Informationen"]; if (InformationenTable.Rows.Count == 0) { ExistenceCheck.RunSQLBatch ("Insert into Informationen (ID, NameID, TypID, ModifyTimeStamp) values ('" + ActuallInformation.ID.ToString () + "', 'Empty ActiveInformationen', '" + ActuallInformation.TypID.ToString () + "', '" + DateTime.Now.ToString (WMB.Basics.ISO_DATE_TIME_FORMAT) + "')"); } try { System.Guid? ProcessedEntityID = InsertOrModifyEntity (EntryToProcess, ActuallInformation); if (ProcessedEntityID == null) return false; return true; } catch (Exception Excp) { Basics.ReportErrorToEventViewer ("TemplateManagement.DoInformationenUpdate", "Beim Add/Modify für ActuallInformation \"" + ActuallInformation.ID.ToString () + "\" kam es zu folgendem Problem:\r\n" + Excp.ToString ()); return false; } }
public static DataTable GetStatisticInformationTable (String TableName, String BeitragID) { WCFStandards AccessHelper = new WCFStandards (); AccessHelper.DefaultConnectionStringName = "WPMediaConnectionString"; DataSet StatisticDataSet = AccessHelper.GetCommonDataSet ("Select * from WPMediaLogView where " + "TableName = '" + TableName + "' and BeitragID = '" + BeitragID + "' and TimingTyp > 'A' and TimingTyp < 'AZ'" + " order by ComputerName"); return StatisticDataSet.Tables ["WPMediaLogView"]; }
public static DataSet GetAllEntriesForOneRedaktion (String InformationenID, String Redaktion) { WCFStandards Helper = new WCFStandards (); return Helper.GetCommonMultiDataSet (new String [] { "Select * from ProcessConnector where InformationenID = '" + InformationenID + "' and Redaktion = '" + Redaktion + "'", "Select * from InformationenAddOn where TableID in (select ID from ProcessConnector where InformationenID = '" + InformationenID + "' and Redaktion = '" + Redaktion + "')" }); }
public static DataSet GetAllInformationenAddOns (String InformationenID, String [] DontPresent, String [] PresentOnly) { WCFStandards Helper = new WCFStandards (); String PresentClause = GetPresentDependingSelectClause (DontPresent, PresentOnly); DataSet InformationenAddOnsDataSet = Helper.GetCommonDataSet ("Select * from InformationenAddOn where InformationenID = '" + InformationenID + "' " + PresentClause); return InformationenAddOnsDataSet; }
public static DataRow GetInformationAddOnDataRow (String InfoAddOnID) { WCFStandards Helper = new WCFStandards (); DataTable InformationenAddOnDataTable = Helper.GetCommonDataSet ("Select * from InformationenAddOn where ID = '" + InfoAddOnID + "'").Tables ["InformationenAddOn"]; if (InformationenAddOnDataTable.Rows.Count != 1) return null; return InformationenAddOnDataTable.Rows [0]; }
public static DataTable GetAllInformationIDs () { WCFStandards Helper = new WCFStandards (); DataSet InformationenIDDataSet = Helper.GetCommonDataSet ("Select ID, TypID from Informationen"); return InformationenIDDataSet.Tables ["Informationen"]; }
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); }
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; }
public static DataTable GetProcessInfoAddOnWithConnectorDataRows (String InformationenID) { WCFStandards Helper = new WCFStandards (); return Helper.GetCommonDataSet ("Select * from InformationenAddOn where InformationenID = '" + InformationenID + "' and Tabelle = 'ProcessConnector'").Tables ["InformationenAddOn"]; }
public static DataSet GetEmptyAltErlaaInfoTimingsDataSet() { WCFStandards AccessHelper = new WCFStandards(); AccessHelper.DefaultConnectionStringName = "AltErlaaInfoConnectionString"; return AccessHelper.GetCommonMultiDataSet(new String[] { "Select top (0) * from Timings", "Select * from TimingTypen"}); }
public void Associate(string catalogName) { _wcfStandard = new WCFStandards { DefaultConnectionStringName = $"{catalogName}ConnectionString" }; }
private List<SelectionDataClass> LoadAllSelectionData(InformationenAddOn InfoAddOnParameter, String BereichToUse) { if (TemplateManagement.TableSelectionCache.ContainsKey (ViewNameForSelection) == false) { WCFStandardsNS.WCFStandards DataAccess = new WCFStandardsNS.WCFStandards (); DataSet PersonenDataSet = DataAccess.GetCommonDataSet ("Select " + String.Join (", ", ItemsToSelectForSelection) + " from " + ViewNameForSelection + " where (" + TemplateManagement.GetWhereClauseFromBereich (BereichToUse) + " ) order by " + String.Join (", ", SortingItemsForSelection)); List<SelectionDataClass> PersistentResult = GetSelectionDataFormatting (PersonenDataSet.Tables [ViewNameForSelection]); TemplateManagement.TableSelectionCache.Add (ViewNameForSelection, PersistentResult); } List<SelectionDataClass> Result = new List<SelectionDataClass>(); Result.AddRange (TemplateManagement.TableSelectionCache [ViewNameForSelection]); return Result; }
//public String GetMaterialLink (Materialien Material) // { // String[] Result = new String[(int)WMB.DataWrapper.MaterialElementIndex.TechnicalTableLength]; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedConnectionString] = "AltErlaaInfoConnectionString"; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedMaterialTableName] = "Materialien"; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedMaterialTableID] = Material.ID.ToString(); // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedTableName] = ""; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedTableID] = ""; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedNameID] = ""; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedType] = Material.Typ; // Result[(int)WMB.DataWrapper.MaterialElementIndex.UsedSubEntryID] = Material.SubEntryID; // return String.Join(",", Result); // } public String GetMaterialLink(String TableName, String TableID) { WCFStandards Helper = new WCFStandards(); DataTable MaterialTable = Helper.GetCommonDataSet("Select MaterialConnector from " + TableName + " where ID = '" + TableID + "'").Tables[TableName]; if (MaterialTable.Rows.Count != 1) return String.Empty; return MaterialTable.Rows[0]["MaterialConnector"].ToString(); }
void SetBooking(WCFStandards AEAGDataBase, String BookableUnitsID, DateTime BookedFor, String SetTo, DateTime BookingDateTime) { DataSet Bookings = AEAGDataBase.GetCommonDataSet (String.Format ("Select * from Booking where BookableUnitsID = '{0}' and BookedFor = {1}", BookableUnitsID, TransportData.GetSQLFormattedDateTime(BookedFor))); if (String.IsNullOrEmpty (SetTo)) { if (Bookings.Tables ["Booking"].Rows.Count == 0) return; Bookings.Tables ["Booking"].Rows [0].Delete (); } else { DataRow RowToProcess; if (Bookings.Tables ["Booking"].Rows.Count == 0) { RowToProcess = Bookings.Tables ["Booking"].NewRow (); RowToProcess ["ID"] = System.Guid.NewGuid (); RowToProcess ["BookableUnitsID"] = BookableUnitsID; RowToProcess ["BookedFor"] = BookedFor; Bookings.Tables ["Booking"].Rows.Add (RowToProcess); } else { RowToProcess = Bookings.Tables ["Booking"].Rows [0]; } RowToProcess ["BookingStatus"] = SetTo; RowToProcess ["BookingDateTime"] = BookingDateTime; } AEAGDataBase.SetCommonDataSet (Bookings); }
public String GetMaterialLink(String TableName, Guid TableID) { if ((TableID == null) || ((System.Guid)TableID == System.Guid.Empty)) return String.Empty; WCFStandards Helper = new WCFStandards(); DataTable MaterialTable = Helper.GetCommonDataSet("Select MaterialConnector from " + TableName + " where ID = '" + TableID.ToString() + "'").Tables[TableName]; if (MaterialTable.Rows.Count != 1) return String.Empty; return MaterialTable.Rows[0]["MaterialConnector"].ToString(); }
bool InsertLeisureBookings () { String StartDateString = DateTime.Now.AddDays (-3).ToString ("yyyyMMdd"); String StartDateSQLCommand = TransportData.GetSQLFormattedDateTime(DateTime.Now.AddDays(-3)); String StartRuWDateSQLCommand = TransportData.GetSQLFormattedDateTime(DateTime.Now.AddDays(-4)); String [] IIS_AE1_SelectCommands = new String [] { "Select RecID, InsDate, InsBarKarte, Typ, BloHal, SauPla, Datum, Beginn, DauAnz, TarifID, ChipNr from Buchungen " + " where Datum > '" + StartDateString + "' order by Typ, BloHal, SauPla", "Select * from Orte", "Select * from RuW_Regel order by Datum desc", "Select * from RuW_Ausnahmen where Datum > " + StartRuWDateSQLCommand + " order by Datum" }; DataSet IIS_AE1_DataSet = DataBase.GetCommonMultiDataSet (IIS_AE1_SelectCommands); if (IIS_AE1_DataSet.Tables.Count != 4) { WMB.Basics.ReportErrorToEventViewer("AEAGProcessCollectedData.InsertLeisureBookings", "Beim lesen der IIS_AE1 Daten kamen nicht 4 Tables zurück - FormatFehler ???"); throw new Exception("Beim lesen der iis_ae1 Daten kamen nicht 4 Tables zurück"); } WCFStandardsNS.WCFStandards AEAGDataBase = new WCFStandards (); AEAGDataBase.DefaultConnectionStringName = "AEAGConnectionString"; //TODO //if (AEAGDataBase.GetSimpleSchemaDataSet () == null) // return false; String [] AEAG_SelectCommands = new String [] { "Select * from Ressource", "Select * from TimeTable", "Select * from BookableUnits", "Select * from FullBookableUnits", "Select * from Booking where BookedFor > " + StartDateSQLCommand }; DataSet AEAG_DataSet = AEAGDataBase.GetCommonMultiDataSet (AEAG_SelectCommands); if (AEAG_DataSet.Tables.Count != 5) { WMB.Basics.ReportErrorToEventViewer ("AEAGProcessCollectedData.InsertLeisureBookings", "Beim lesen der AEAG Daten kamen nicht 5 Tables zurück - FormatFehler ???"); return false; } NameValueCollection TypBloHalSauPlaConverter = LoadTypBloHalSauPlaConverter (AEAG_DataSet); if (WMB.Basics.IsTestRun) WMB.Basics.ReportInformationToEventViewer("Aus der Tabelle \"Buchungen\" werden " + Convert.ToString(IIS_AE1_DataSet.Tables["Buchungen"].Rows.Count) + " aus der DatenBank \"" + DataBase.DefaultConnectionStringName + "\" in die DatenBank \"" + AEAGDataBase.DefaultConnectionStringName + "\" übertragen"); foreach (DataRow BuchungenRow in IIS_AE1_DataSet.Tables["Buchungen"].Rows) { if (BuchungenRow ["SauPla"] == Convert.DBNull) continue; String TypBloHalSauPla = BuchungenRow ["Typ"].ToString () + BuchungenRow ["BloHal"].ToString () + BuchungenRow ["SauPla"].ToString (); if ((TypBloHalSauPlaConverter [TypBloHalSauPla] == null) || String.IsNullOrEmpty (TypBloHalSauPlaConverter [TypBloHalSauPla])) { WMB.Basics.ReportErrorToEventViewer ("AEAGProcessCollectedData.InsertLeisureBookings", "\"" + TypBloHalSauPla + "\" ist in Ressourcen nicht definiert"); continue; } String RessourceID = TypBloHalSauPlaConverter [TypBloHalSauPla]; if (String.IsNullOrEmpty (RessourceID)) { WMB.Basics.ReportErrorToEventViewer("\"" + TypBloHalSauPla + "\" ist in Ressourcen nicht definiert"); throw new Exception("\"" + TypBloHalSauPla + "\" ist in Ressourcen nicht definiert"); } String TimingTypForThisRessource = AEAG_DataSet.Tables ["FullBookableUnits"] .Select ("RessourceID = '" + RessourceID + "'") [0] ["TimingTyp"].ToString (); int NumberOfHoursForOneBooking = 0; if (TimingTypForThisRessource == "Stunde") NumberOfHoursForOneBooking = 1; if (TimingTypForThisRessource == "Doppel") NumberOfHoursForOneBooking = 2; int BeginnValue = Convert.ToInt32 (BuchungenRow ["Beginn"]); int DauAnz = Convert.ToInt32 (BuchungenRow ["DauAnz"]); int GeneratingStep = 0; while ((GeneratingStep * NumberOfHoursForOneBooking) < DauAnz) { BeginnValue += GeneratingStep * NumberOfHoursForOneBooking; GeneratingStep++; String StartHour = Convert.ToString (BeginnValue + 100).Substring (1); DataRow [] SelectedBookables = AEAG_DataSet.Tables ["FullBookableUnits"].Select ("RessourceID = '" + RessourceID + "' and TimingTyp = '" + TimingTypForThisRessource + "'", "TimeTableNameID"); if (SelectedBookables.Length < 1) { WMB.Basics.ReportErrorToEventViewer("\"" + RessourceID + "\" mit \"" + TimingTypForThisRessource + "\" ist in Ressourcen nicht definiert"); throw new Exception("\"" + RessourceID + "\" mit \"" + TimingTypForThisRessource + "\" ist in Ressourcen nicht definiert"); } String BookableUnitID = String.Empty; foreach (DataRow Entry in SelectedBookables) { if (Entry ["TimeTableNameID"].ToString ().Substring (0, 2) == StartHour) { BookableUnitID = Entry ["ID"].ToString (); break; } } if (String.IsNullOrEmpty (BookableUnitID)) continue; String BookedForBase = Convert.ToString (BuchungenRow ["Datum"]); DateTime BookedFor = DateTime.Parse (BookedForBase.Substring (0, 4) + "-" + BookedForBase.Substring (4, 2) + "-" + BookedForBase.Substring (6, 2)); String OldContent = GetBooking (AEAGDataBase, BookableUnitID, BookedFor); String NewContent = BuchungenRow ["InsBarKarte"].ToString (); if (OldContent != NewContent) { DateTime BookingDateTime = Convert.ToDateTime (BuchungenRow ["InsDate"]); SetBooking (AEAGDataBase, BookableUnitID, BookedFor, NewContent, BookingDateTime); } } } return true; }
public DataTable GetPersonenForOrganisation(String OrganisationsID, String PersonenTypID) { WCFStandards Helper = new WCFStandards(); String SelectStatement = String.Empty; if (String.IsNullOrEmpty(PersonenTypID)) SelectStatement = "Select * from PersonenEinerOrganisation where OrganisationsID = '" + OrganisationsID + "'"; else SelectStatement = "Select * from PersonenEinerOrganisation where OrganisationsID = '" + OrganisationsID + "' and PersonenTypID = '" + PersonenTypID + "'"; DataSet PersonenDataSet = Helper.GetCommonDataSet(SelectStatement); return PersonenDataSet.Tables["PersonenEinerOrganisation"]; }
public WMB.IReadGraphicsHandling CheckLoadAndGetInstance(String TableNameParameter, String TemplateID) { WCFStandardsNS.WCFStandards DataBase = new WCFStandards(); DataBase.DefaultConnectionStringName = "WPMediaAddOnDataConnectionString"; ReadGraphicsHandler.CheckAndGetInstatiatedPackage(DataBase, TableNameParameter, TemplateID); return ReadGraphicsHandler; }
public static void SetInformationenStatus(Guid InformationenID, String NewStatusToSet) { String UpdateStatement = "Update Informationen set Status = '" + NewStatusToSet + "' where ID = '" + InformationenID.ToString() + "'"; WCFStandards WCFAccess = new WCFStandards(); WCFAccess.DefaultConnectionStringName = "AltErlaaInfoConnectionString"; WCFAccess.RunSQLBatch(UpdateStatement); }
public Byte[] ModifyMaterialContentViaName(Materialien Material, MemoryStream NewMemoryStreamContentToUse, String NameOfTheNewContentToStore = "", String TypOfTheContentToStore = "") { if ((Material == null) || (Material.ID == Guid.Empty)) return null; if (String.IsNullOrEmpty(NameOfTheNewContentToStore)) NameOfTheNewContentToStore = Material.NameID; if (String.IsNullOrEmpty(TypOfTheContentToStore)) TypOfTheContentToStore = Material.Typ; CacheStoreMaterialBlobContentDataBaseCommand(Material, NameOfTheNewContentToStore, NewMemoryStreamContentToUse, TypOfTheContentToStore); String ModifyAfterBlobChanged = "Update Materialien set BlobLength = " + Convert.ToString(Material.BlobLength) + ", NameID = '" + NameOfTheNewContentToStore + "', Typ = '" + TypOfTheContentToStore + "', ModifyTimeStamp = " + Basics.GetSQLFormattedDateTime(DateTime.Now) + " where ID = '" + Material.ID.ToString() + "'"; WCFStandards WCFAccess = new WCFStandards(); WCFAccess.DefaultConnectionStringName = "AltErlaaInfoConnectionString"; WCFAccess.RunSQLBatch(ModifyAfterBlobChanged); return LoadFileContent(Material); }
public static DataSet LoadPossibleKeyValues () { WCFStandards DataAccess = new WCFStandards (); return DataAccess.GetCommonMultiDataSet(new string [] { "Select * from ZielGruppen order by ZielGruppe", "SELECT ID, Name FROM Organisationen WHERE (ID IN " + "(SELECT DISTINCT TabelleID FROM InformationenAddOn " + " WHERE (Tabelle = 'Organisationen'))) order by Name", "SELECT ID, Vorname, Name FROM Personen WHERE (ID IN " + "(SELECT DISTINCT TabelleID FROM InformationenAddOn " + " WHERE (Tabelle = 'Personen'))) order by Name, Vorname", "SELECT ID, NameID FROM Typ where (ID in " + "(SELECT distinct TypID FROM Informationen)) order by NameID" }); }