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);
}
