public static List<KalenderSearchClass> ReadAllLastModifiedInformationenData (DateTime StartTime, DateTime StopTime) { WCFStandards KalenderSearchAccess = new WCFStandards (); DataSet SearchDataSet = KalenderSearchAccess.GetCommonDataSet ("Select ID, TypID, NameID, Titel, " + "LastModifiedBy, ModifyTimeStamp, TypID, CreatedBy, AccessRightsID " + "from Informationen " + "where " + Basics.GetSQLFormattedDateTime (StartTime) + " < ModifyTimeStamp and " + Basics.GetSQLFormattedDateTime (StopTime) + " > ModifyTimeStamp order by ModifyTimeStamp desc"); List<KalenderSearchClass> Result = new List<KalenderSearchClass> (); foreach (DataRow KalenderTable in SearchDataSet.Tables ["Informationen"].Rows) { Result.Add (FillKalenderSearchClass (KalenderTable)); } return Result; }
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; }
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(); }
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()) + "') "; }
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 GetProcessInfoAddOnWithConnectorDataRows (String InformationenID) { WCFStandards Helper = new WCFStandards (); return Helper.GetCommonDataSet ("Select * from InformationenAddOn where InformationenID = '" + InformationenID + "' and Tabelle = 'ProcessConnector'").Tables ["InformationenAddOn"]; }
public static int GetNumberOfInformationenUsedThisTableEntry (String Tabelle, String TabelleID) { WCFStandards DistinctHelper = new WCFStandards (); DataSet DistinctTableEntryDataSet = DistinctHelper.GetCommonDataSet ("Select count (distinct (InformationenID)) from InformationenAddOn where " + "Tabelle = '" + Tabelle + "' and TabelleID = '" + TabelleID + "'"); return Convert.ToInt32 (DistinctTableEntryDataSet.Tables [0].Rows [0] [0]); }
public static List<Guid> GetInformationenUsedThisTableEntry (String Tabelle, String TabelleID) { WCFStandards DistinctHelper = new WCFStandards (); DataSet DistinctTableEntryDataSet = DistinctHelper.GetCommonDataSet ("Select distinct (InformationenID) from InformationenAddOn where " + "Tabelle = '" + Tabelle + "' and TabelleID = '" + TabelleID + "'"); List<Guid> Result = new List<Guid> (); foreach (DataRow InfoIDRow in DistinctTableEntryDataSet.Tables [0].Rows) { Result.Add ((Guid) InfoIDRow [0]); } return Result; }
public static System.Guid? InsertOrModifyEntity (ITemplateElementeBackgroundFunctions ConnectedITemplateElementeBackgroundFunctions, Object EntityToProcess, bool CheckForPreExistence = false) { if (EntityToProcess == null) { Basics.ReportErrorToEventViewer ("TemplateManagement.InsertOrModifyEntity", "EntityToProcess == null\r\n" + (new Exception ("EntityToProcess == null")).ToString ()); return null; } Type ObjectType = EntityToProcess.GetType (); String TableName = ObjectType.Name; String IDName = "ID"; PropertyInfo IDPropInfo = ObjectType.GetProperty (IDName); if (IDPropInfo == null) { IDName = "TimingsID"; IDPropInfo = ObjectType.GetProperty (IDName); } if (IDPropInfo == null) { Basics.ReportErrorToEventViewer ("TemplateManagement.InsertOrModifyEntity", "Keine ID (TimingsID) bei EntityToProcess\r\n" + (new Exception ("Keine ID (TimingsID) bei EntityToProcess")).ToString ()); return null; } Object IDValue = IDPropInfo.GetValue (EntityToProcess, null); bool InsertIsTrueModifyIsFalse = true; if (IDValue != null) { if (IDValue is System.Guid) { InsertIsTrueModifyIsFalse = ((Guid) IDValue == Guid.Empty); } else if (IDValue is System.Guid?) InsertIsTrueModifyIsFalse = ((Guid?) IDValue == Guid.Empty); } DoTabelleDefaultModifications (ConnectedITemplateElementeBackgroundFunctions, EntityToProcess, InsertIsTrueModifyIsFalse); WCFStandards DataAccess = new WCFStandards (); if ((CheckForPreExistence) && (IDValue != null)) { DataTable CheckTable = DataAccess.GetCommonDataSet ("Select * from " + TableName + " where " + IDName + " = '" + (Guid) IDValue + "'").Tables [TableName]; if (CheckTable.Rows.Count == 0) InsertIsTrueModifyIsFalse = true; } String SQLCommand = String.Empty; if (InsertIsTrueModifyIsFalse) { SQLCommand = WMB.Basics.CreateInsertStatement (TableName, EntityToProcess, EntityToProcess.GetType ().GetProperties()); } else { SQLCommand = WMB.Basics.CreateModifyStatement (TableName, EntityToProcess, EntityToProcess.GetType ().GetProperties ()); } IDValue = IDPropInfo.GetValue (EntityToProcess, null); DataAccess.RunSQLBatch (SQLCommand); return (System.Guid?) IDValue; }
public static List<Guid> GetTableEntriesInInfoAddOn (String Tabelle) { List<Guid> Result = new List<Guid> (); WCFStandards DistinctHelper = new WCFStandards (); DataSet TableEntryDataSet = DistinctHelper.GetCommonDataSet ("Select distinct (TabelleID) from InformationenAddOn where Tabelle = '" + Tabelle + "'"); foreach (DataRow EntryRow in TableEntryDataSet.Tables [0].Rows) if ((EntryRow [0] != Convert.DBNull) && ((Guid) EntryRow [0] != Guid.Empty)) Result.Add ((Guid) EntryRow [0]); return Result; }
private DataCollection<SelectionDataClass> LoadAllSelectionData() { if (TableSelectionCache.ContainsKey(ViewNameForSelection) == false) { WCFStandardsNS.WCFStandards DataAccess = new WCFStandardsNS.WCFStandards(); DataSet PersonenDataSet = DataAccess.GetCommonDataSet("Select " + String.Join(", ", ItemsToSelectForSelection) + " from " + ViewNameForSelection + " where (" + DataModell.GetWhereClauseFromBereich(BereichToUse) + " ) order by " + String.Join(", ", SortingItemsForSelection)); DataCollection<SelectionDataClass> PersistentResult = GetSelectionDataFormatting(PersonenDataSet.Tables[ViewNameForSelection]); TableSelectionCache [ViewNameForSelection] = PersistentResult; } DataCollection<SelectionDataClass> Result = new DataCollection<SelectionDataClass>(); Result.AddRange(TableSelectionCache[ViewNameForSelection]); return Result; }
private void SetNumberOfPages (String TableName, String TableID, DataRow UsedTableRow, int NumberOfPages) { if (UsedTableRow.Table.Columns ["NumberOfPages"] == null) return; WCFStandardsNS.WCFStandards DataBase = new WCFStandardsNS.WCFStandards (); DataBase.DefaultConnectionStringName = "WPMediaAddOnDataConnectionString"; DataTable ExistingEntryTable = DataBase.GetCommonDataSet ("Select * from " + TableName + " where ID = '" + TableID + "'").Tables [TableName]; UsedTableRow ["NumberOfPages"] = NumberOfPages; if (ExistingEntryTable.Rows.Count != 1) { Basics.ReportErrorToEventViewer ("StandBildRedaktionInstance.SetNumberOfPages", TableName + " mit der ID " + TableID + " brachte Rows.Count != 1"); return; } String UpdateStatement = "Update " + TableName + " set NumberOfPages = " + Convert.ToString (NumberOfPages) + " where ID = '" + TableID + "'"; DataBase.RunSQLBatch (UpdateStatement); }
public static List<KalenderSearchClass> ReadAllInformationenData (DateTime StartTime, DateTime StopTime) { WCFStandards KalenderSearchAccess = new WCFStandards (); DataSet SearchDataSet = KalenderSearchAccess.GetCommonDataSet ("Select ID, TypID, NameID, Titel, " + "TimeA, TimeB, LastModifiedBy, ModifyTimeStamp, TypNameID, CreatedBy, AccessRightsID " + "from InformationenWithTimings where TimeA > " + Basics.GetSQLFormattedDateTime (StartTime) + " and TimeA < " + Basics.GetSQLFormattedDateTime (StopTime) + " and TimingTypID = 'EventVonBis' order by ModifyTimeStamp desc"); List<KalenderSearchClass> Result = new List<KalenderSearchClass> (); foreach (DataRow KalenderTable in SearchDataSet.Tables ["InformationenWithTimings"].Rows) { Result.Add (FillKalenderSearchClass (KalenderTable)); } return Result; }
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 GetCommonDataRow (String TableName, String ID) { WCFStandards DataAccess = new WCFStandards (); DataTable ResultedRows = DataAccess.GetCommonDataSet ("Select * from " + TableName + " where ID = '" + ID + "'").Tables [TableName]; if (ResultedRows.Rows.Count != 1) return null; return ResultedRows.Rows [0]; }
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 DataTable GetConnectedAVInformationen (List<String> All_AV_AVIDs) { WCFStandards DataAccess = new WCFStandards (); DataAccess.DefaultConnectionStringName = "AltErlaaInfoConnectionString"; String AVIDs = ("( BearbeitungsHinweis = '" + String.Join ("' or BearbeitungsHinweis = '", All_AV_AVIDs) + "' )"); return DataAccess.GetCommonDataSet ("Select * from Informationen where " + AVIDs).Tables ["Informationen"]; }
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 String GetMyOrUsedUnifiedTableIDsSelectClause (InformationenAddOn InfoAddOn, AuswahlSelection EntriesToShow) { WCFStandards DataAccess = new WCFStandards (); String WhereClause = String.Empty; if (EntriesToShow == AuswahlSelection.My) { DataSet MyInformationenIDs = DataAccess.GetCommonDataSet ("Select ID from Informationen where CreatedBy ='" + CurrentUserName + "' or LastModifiedBy = '" + CurrentUserName + "'"); if (MyInformationenIDs.Tables ["Informationen"].Rows.Count == 0) return String.Empty; List<string> IDsToSearchFor = new List<string> (); foreach (DataRow IDRow in MyInformationenIDs.Tables ["Informationen"].Rows) IDsToSearchFor.Add (IDRow ["ID"].ToString ()); WhereClause = " and (InformationenID = '" + String.Join ("' or InformationenID = '", IDsToSearchFor.ToArray ()) + "') "; } DataSet OccurenceOrderedMyTableIDs = DataAccess.GetCommonDataSet ("Select distinct (TabelleID), count (*) as Occurence from " + " InformationenAddOn where Tabelle = '" + InfoAddOn.Tabelle + "' " + WhereClause + " Group by TabelleID order by Occurence"); if (OccurenceOrderedMyTableIDs.Tables ["InformationenAddOn"].Rows.Count == 0) return String.Empty; List<string> UnifiedTableIDs = new List<string> (); foreach (DataRow UnifiedRow in OccurenceOrderedMyTableIDs.Tables ["InformationenAddOn"].Rows) UnifiedTableIDs.Add (UnifiedRow ["TabelleID"].ToString ()); return " (ID = '" + String.Join ("' or ID = '", UnifiedTableIDs.ToArray ()) + "') "; }
//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(); }
public static List<SelectionDataClass> ReorderSelectionData (InformationenAddOn InfoAddOn, List<SelectionDataClass> UnorderedSelectionData) { WCFStandards DataAccess = new WCFStandards (); DataSet MyUsedEntries = DataAccess.GetCommonDataSet (String.Format (OCCURENCY_SQL_COMMAND, InfoAddOn.ActuallBezeichner, InfoAddOn.Tabelle, String.Empty, CurrentUserName)); DataSet AllUsedEntries = DataAccess.GetCommonDataSet (String.Format (OCCURENCY_SQL_COMMAND, InfoAddOn.ActuallBezeichner, InfoAddOn.Tabelle, "NOT", CurrentUserName)); return FillReorderedSelectionDataClass (UnorderedSelectionData, CombineIDEntries (MyUsedEntries.Tables ["InformationenAddOn"], AllUsedEntries.Tables ["InformationenAddOn"])); }
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 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; }
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 static DataTable GetAllInformationIDs () { WCFStandards Helper = new WCFStandards (); DataSet InformationenIDDataSet = Helper.GetCommonDataSet ("Select ID, TypID from Informationen"); return InformationenIDDataSet.Tables ["Informationen"]; }
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 (); }
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 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; }
public static DataSet GetAllInformationenAddOns (String InformationenID) { WCFStandards Helper = new WCFStandards (); DataSet InformationenAddOnsDataSet = Helper.GetCommonDataSet ("Select * from InformationenAddOn where InformationenID = '" + InformationenID + "'"); return InformationenAddOnsDataSet; }