public SAPDataSetRefCounter SelectByCarrID( string carrID) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "carrID", carrID.Length, 3, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SAPDataSetRefCounter retVal; SWPGenericDbParameter carrIDGenericDbParameter = new SWPGenericDbParameter( "@CarrID", DbType.AnsiStringFixedLength, ParameterDirection.Input, 3, carrID); retVal = (SAPDataSetRefCounter)Select( new SAPDataSetRefCounter(), "uspRefCounterSelectByCarrID", carrIDGenericDbParameter); return(retVal); }
public SAPDataReaderRefCarrier ReaderSelectByCarrID( string carrID) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "carrID", carrID.Length, 6, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SWPGenericDbParameter carrIDGenericDbParameter = new SWPGenericDbParameter( "@CarrID", DbType.String, ParameterDirection.Input, 6, carrID); return(new SAPDataReaderRefCarrier(ReaderSelect( "uspRefCarrierSelectByCarrID", carrIDGenericDbParameter))); }
public int Delete( int venueID) { int retVal; SWPGenericDbParameter venueIDGenericDbParameter = new SWPGenericDbParameter( "@VenueID", DbType.Int32, ParameterDirection.Input, 0, venueID); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspVenueDelete", venueIDGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspVenueDelete", venueIDGenericDbParameter); } return(retVal); }
public SAPDataSetEventType SelectByEventTypeName( string eventTypeName) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "eventTypeName", eventTypeName.Length, 255, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SAPDataSetEventType retVal; SWPGenericDbParameter eventTypeNameGenericDbParameter = new SWPGenericDbParameter( "@EventTypeName", DbType.String, ParameterDirection.Input, 255, eventTypeName); retVal = (SAPDataSetEventType)Select( new SAPDataSetEventType(), "uspEventTypeSelectByEventTypeName", eventTypeNameGenericDbParameter); return(retVal); }
public SAPDataSetEventAttendeeAgencyMap SelectByAgencyNumber( string agencyNumber) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "agencyNumber", agencyNumber.Length, 16, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SAPDataSetEventAttendeeAgencyMap retVal; SWPGenericDbParameter agencyNumberGenericDbParameter = new SWPGenericDbParameter( "@AgencyNumber", DbType.String, ParameterDirection.Input, 16, agencyNumber); retVal = (SAPDataSetEventAttendeeAgencyMap)Select( new SAPDataSetEventAttendeeAgencyMap(), "uspEventAttendeeAgencyMapSelectByAgencyNumber", agencyNumberGenericDbParameter); return(retVal); }
public SAPDataReaderPackage ReaderSelectByPackageName( string packageName) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "packageName", packageName.Length, 255, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SWPGenericDbParameter packageNameGenericDbParameter = new SWPGenericDbParameter( "@PackageName", DbType.String, ParameterDirection.Input, 255, packageName); return(new SAPDataReaderPackage(ReaderSelect( "uspPackageSelectByPackageName", packageNameGenericDbParameter))); }
public SAPDataSetRefCountry SelectByCountryCode( string countryCode) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "countryCode", countryCode.Length, 4, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SAPDataSetRefCountry retVal; SWPGenericDbParameter countryCodeGenericDbParameter = new SWPGenericDbParameter( "@CountryCode", DbType.String, ParameterDirection.Input, 4, countryCode); retVal = (SAPDataSetRefCountry)Select( new SAPDataSetRefCountry(), "uspRefCountrySelectByCountryCode", countryCodeGenericDbParameter); return(retVal); }
public SAPDataReaderRefTravelAgency ReaderSelectByAgencyNumber( string agencyNumber) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "agencyNumber", agencyNumber.Length, 16, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SWPGenericDbParameter agencyNumberGenericDbParameter = new SWPGenericDbParameter( "@AgencyNumber", DbType.String, ParameterDirection.Input, 16, agencyNumber); return(new SAPDataReaderRefTravelAgency(ReaderSelect( "uspRefTravelAgencySelectByAgencyNumber", agencyNumberGenericDbParameter))); }
public SAPDataSetPackageEventMap SelectByPackageIDEventID( int packageID, int eventID) { SAPDataSetPackageEventMap retVal; SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); SWPGenericDbParameter eventIDGenericDbParameter = new SWPGenericDbParameter( "@EventID", DbType.Int32, ParameterDirection.Input, 0, eventID); retVal = (SAPDataSetPackageEventMap)Select( new SAPDataSetPackageEventMap(), "uspPackageEventMapSelectByPackageIDEventID", packageIDGenericDbParameter, eventIDGenericDbParameter); return(retVal); }
public SAPDataSetRefCode SelectByRefTypeCode( string refTypeCode) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "refTypeCode", refTypeCode.Length, 2, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SAPDataSetRefCode retVal; SWPGenericDbParameter refTypeCodeGenericDbParameter = new SWPGenericDbParameter( "@RefTypeCode", DbType.AnsiStringFixedLength, ParameterDirection.Input, 2, refTypeCode); retVal = (SAPDataSetRefCode)Select( new SAPDataSetRefCode(), "uspRefCodeSelectByRefTypeCode", refTypeCodeGenericDbParameter); return(retVal); }
public SAPDataReaderRefLanguage ReaderSelectByLanguageCode( string languageCode) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "languageCode", languageCode.Length, 4, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } SWPGenericDbParameter languageCodeGenericDbParameter = new SWPGenericDbParameter( "@LanguageCode", DbType.String, ParameterDirection.Input, 4, languageCode); return(new SAPDataReaderRefLanguage(ReaderSelect( "uspRefLanguageSelectByLanguageCode", languageCodeGenericDbParameter))); }
public int DeleteByEventID( int eventID) { int retVal; SWPGenericDbParameter eventIDGenericDbParameter = new SWPGenericDbParameter( "@EventID", DbType.Int32, ParameterDirection.Input, 0, eventID); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspEventActorMapDeleteByEventID", eventIDGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspEventActorMapDeleteByEventID", eventIDGenericDbParameter); } return(retVal); }
public int Update( string languageCode, string language) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "languageCode", languageCode.Length, 4, validationErrorReport); ValidateParameterLength( "language", language.Length, 50, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } int retVal; SWPGenericDbParameter languageCodeGenericDbParameter = new SWPGenericDbParameter( "@LanguageCode", DbType.String, ParameterDirection.Input, 4, languageCode); SWPGenericDbParameter languageGenericDbParameter = new SWPGenericDbParameter( "@Language", DbType.String, ParameterDirection.Input, 50, language); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspRefLanguageUpdate", languageCodeGenericDbParameter, languageGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspRefLanguageUpdate", languageCodeGenericDbParameter, languageGenericDbParameter); } return(retVal); }
public int Insert( string countryCode, string countryName) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "countryCode", countryCode.Length, 4, validationErrorReport); ValidateParameterLength( "countryName", countryName.Length, 50, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } int retVal; SWPGenericDbParameter countryCodeGenericDbParameter = new SWPGenericDbParameter( "@CountryCode", DbType.String, ParameterDirection.Input, 4, countryCode); SWPGenericDbParameter countryNameGenericDbParameter = new SWPGenericDbParameter( "@CountryName", DbType.String, ParameterDirection.Input, 50, countryName); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspRefCountryInsert", countryCodeGenericDbParameter, countryNameGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspRefCountryInsert", countryCodeGenericDbParameter, countryNameGenericDbParameter); } return(retVal); }
public int Update( string agencyNumber, string agencyName) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "agencyNumber", agencyNumber.Length, 16, validationErrorReport); ValidateParameterLength( "agencyName", agencyName.Length, 100, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } int retVal; SWPGenericDbParameter agencyNumberGenericDbParameter = new SWPGenericDbParameter( "@AgencyNumber", DbType.String, ParameterDirection.Input, 16, agencyNumber); SWPGenericDbParameter agencyNameGenericDbParameter = new SWPGenericDbParameter( "@AgencyName", DbType.String, ParameterDirection.Input, 100, agencyName); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspRefTravelAgencyUpdate", agencyNumberGenericDbParameter, agencyNameGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspRefTravelAgencyUpdate", agencyNumberGenericDbParameter, agencyNameGenericDbParameter); } return(retVal); }
public int Insert( string eventActorName, out int eventActorID) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "eventActorName", eventActorName.Length, 255, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } int retVal; SWPGenericDbParameter eventActorNameGenericDbParameter = new SWPGenericDbParameter( "@EventActorName", DbType.String, ParameterDirection.Input, 255, eventActorName); SWPGenericDbParameter eventActorIDGenericDbParameter = new SWPGenericDbParameter( "@EventActorID", DbType.Int32, ParameterDirection.Output, 0); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspEventActorInsert", eventActorNameGenericDbParameter, eventActorIDGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspEventActorInsert", eventActorNameGenericDbParameter, eventActorIDGenericDbParameter); } eventActorID = (int)eventActorIDGenericDbParameter.Value; return(retVal); }
public int Update( int cityID, string cityName) { StringBuilder validationErrorReport = new StringBuilder(); ValidateParameterLength( "cityName", cityName.Length, 50, validationErrorReport); if (validationErrorReport.Length > 0) { throw new ApplicationException(validationErrorReport.ToString()); } int retVal; SWPGenericDbParameter cityIDGenericDbParameter = new SWPGenericDbParameter( "@CityID", DbType.Int32, ParameterDirection.Input, 0, cityID); SWPGenericDbParameter cityNameGenericDbParameter = new SWPGenericDbParameter( "@CityName", DbType.String, ParameterDirection.Input, 50, cityName); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspRefFlightCityUpdate", cityIDGenericDbParameter, cityNameGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspRefFlightCityUpdate", cityIDGenericDbParameter, cityNameGenericDbParameter); } return(retVal); }
public int Insert( int eventID, int eventActorID, out int eventActorMapID) { int retVal; SWPGenericDbParameter eventIDGenericDbParameter = new SWPGenericDbParameter( "@EventID", DbType.Int32, ParameterDirection.Input, 0, eventID); SWPGenericDbParameter eventActorIDGenericDbParameter = new SWPGenericDbParameter( "@EventActorID", DbType.Int32, ParameterDirection.Input, 0, eventActorID); SWPGenericDbParameter eventActorMapIDGenericDbParameter = new SWPGenericDbParameter( "@EventActorMapID", DbType.Int32, ParameterDirection.Output, 0); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspEventActorMapInsert", eventIDGenericDbParameter, eventActorIDGenericDbParameter, eventActorMapIDGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspEventActorMapInsert", eventIDGenericDbParameter, eventActorIDGenericDbParameter, eventActorMapIDGenericDbParameter); } eventActorMapID = (int)eventActorMapIDGenericDbParameter.Value; return(retVal); }
public int Update( int packageEventMapID, int packageID, int eventID) { int retVal; SWPGenericDbParameter packageEventMapIDGenericDbParameter = new SWPGenericDbParameter( "@PackageEventMapID", DbType.Int32, ParameterDirection.Input, 0, packageEventMapID); SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); SWPGenericDbParameter eventIDGenericDbParameter = new SWPGenericDbParameter( "@EventID", DbType.Int32, ParameterDirection.Input, 0, eventID); if (_dbTransactionConnection == null) { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbConnectionName, "uspPackageEventMapUpdate", packageEventMapIDGenericDbParameter, packageIDGenericDbParameter, eventIDGenericDbParameter); } else { retVal = SWPDBHelper.StoredProcExecuteNonQuery( _dbTransactionConnection, "uspPackageEventMapUpdate", packageEventMapIDGenericDbParameter, packageIDGenericDbParameter, eventIDGenericDbParameter); } return(retVal); }
public SAPDataReaderEventActorMap ReaderSelectByEventID( int eventID) { SWPGenericDbParameter eventIDGenericDbParameter = new SWPGenericDbParameter( "@EventID", DbType.Int32, ParameterDirection.Input, 0, eventID); return(new SAPDataReaderEventActorMap(ReaderSelect( "uspEventActorMapSelectByEventID", eventIDGenericDbParameter))); }
public SAPDataReaderEvent ReaderSelectByVenueID( int venueID) { SWPGenericDbParameter venueIDGenericDbParameter = new SWPGenericDbParameter( "@VenueID", DbType.Int32, ParameterDirection.Input, 0, venueID); return(new SAPDataReaderEvent(ReaderSelect( "uspEventSelectByVenueID", venueIDGenericDbParameter))); }
public SAPDataReaderRefFlightCity ReaderSelectByCityID( int cityID) { SWPGenericDbParameter cityIDGenericDbParameter = new SWPGenericDbParameter( "@CityID", DbType.Int32, ParameterDirection.Input, 0, cityID); return(new SAPDataReaderRefFlightCity(ReaderSelect( "uspRefFlightCitySelectByCityID", cityIDGenericDbParameter))); }
public SAPDataReaderPackage ReaderSelectByPackageID( int packageID) { SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); return(new SAPDataReaderPackage(ReaderSelect( "uspPackageSelectByPackageID", packageIDGenericDbParameter))); }
public SAPDataReaderEventAttendeeTrip ReaderSelectByPackageID( int packageID) { SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); return(new SAPDataReaderEventAttendeeTrip(ReaderSelect( "uspEventAttendeeTripSelectByPackageID", packageIDGenericDbParameter))); }
public SAPDataSetEventAttendeeTrip SelectByPackageID( int packageID) { SAPDataSetEventAttendeeTrip retVal; SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); retVal = (SAPDataSetEventAttendeeTrip)Select( new SAPDataSetEventAttendeeTrip(), "uspEventAttendeeTripSelectByPackageID", packageIDGenericDbParameter); return(retVal); }
public SAPDataSetEventActor SelectByEventActorID( int eventActorID) { SAPDataSetEventActor retVal; SWPGenericDbParameter eventActorIDGenericDbParameter = new SWPGenericDbParameter( "@EventActorID", DbType.Int32, ParameterDirection.Input, 0, eventActorID); retVal = (SAPDataSetEventActor)Select( new SAPDataSetEventActor(), "uspEventActorSelectByEventActorID", eventActorIDGenericDbParameter); return(retVal); }
public SAPDataSetEvent SelectByVenueID( int venueID) { SAPDataSetEvent retVal; SWPGenericDbParameter venueIDGenericDbParameter = new SWPGenericDbParameter( "@VenueID", DbType.Int32, ParameterDirection.Input, 0, venueID); retVal = (SAPDataSetEvent)Select( new SAPDataSetEvent(), "uspEventSelectByVenueID", venueIDGenericDbParameter); return(retVal); }
public SAPDataSetPackage SelectByPackageID( int packageID) { SAPDataSetPackage retVal; SWPGenericDbParameter packageIDGenericDbParameter = new SWPGenericDbParameter( "@PackageID", DbType.Int32, ParameterDirection.Input, 0, packageID); retVal = (SAPDataSetPackage)Select( new SAPDataSetPackage(), "uspPackageSelectByPackageID", packageIDGenericDbParameter); return(retVal); }
public SAPDataSetRefFlightCity SelectByCityID( int cityID) { SAPDataSetRefFlightCity retVal; SWPGenericDbParameter cityIDGenericDbParameter = new SWPGenericDbParameter( "@CityID", DbType.Int32, ParameterDirection.Input, 0, cityID); retVal = (SAPDataSetRefFlightCity)Select( new SAPDataSetRefFlightCity(), "uspRefFlightCitySelectByCityID", cityIDGenericDbParameter); return(retVal); }
public SAPDataSetEventAttendeeAgencyMap SelectByEventAttendeeID( int eventAttendeeID) { SAPDataSetEventAttendeeAgencyMap retVal; SWPGenericDbParameter eventAttendeeIDGenericDbParameter = new SWPGenericDbParameter( "@EventAttendeeID", DbType.Int32, ParameterDirection.Input, 0, eventAttendeeID); retVal = (SAPDataSetEventAttendeeAgencyMap)Select( new SAPDataSetEventAttendeeAgencyMap(), "uspEventAttendeeAgencyMapSelectByEventAttendeeID", eventAttendeeIDGenericDbParameter); return(retVal); }