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 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 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 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 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 int Delete(
string refTypeCode)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"refTypeCode",
refTypeCode.Length,
2,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter refTypeCodeGenericDbParameter =
new SWPGenericDbParameter(
"@RefTypeCode",
DbType.AnsiStringFixedLength,
ParameterDirection.Input,
2,
refTypeCode);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspRefCodeDelete",
refTypeCodeGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspRefCodeDelete",
refTypeCodeGenericDbParameter);
}
return(retVal);
}
public int Delete(
string carrID)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"carrID",
carrID.Length,
6,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter carrIDGenericDbParameter =
new SWPGenericDbParameter(
"@CarrID",
DbType.String,
ParameterDirection.Input,
6,
carrID);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspRefCarrierDelete",
carrIDGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspRefCarrierDelete",
carrIDGenericDbParameter);
}
return(retVal);
}
public int Update(
int venueID,
string venueName,
string venueDescription,
string venueStreet,
string venueCity,
string venueState,
string venuePostalCode,
byte [] venueGeographicMap,
byte [] venueFacilityMap,
byte [] venueImage)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"venueName",
venueName.Length,
255,
validationErrorReport);
ValidateParameterLength(
"venueDescription",
venueDescription.Length,
4000,
validationErrorReport);
ValidateParameterLength(
"venueStreet",
venueStreet.Length,
255,
validationErrorReport);
ValidateParameterLength(
"venueCity",
venueCity.Length,
255,
validationErrorReport);
ValidateParameterLength(
"venueState",
venueState.Length,
255,
validationErrorReport);
ValidateParameterLength(
"venuePostalCode",
venuePostalCode.Length,
25,
validationErrorReport);
ValidateParameterLength(
"venueGeographicMap",
venueGeographicMap.Length,
2147483647,
validationErrorReport);
ValidateParameterLength(
"venueFacilityMap",
venueFacilityMap.Length,
2147483647,
validationErrorReport);
ValidateParameterLength(
"venueImage",
venueImage.Length,
2147483647,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter venueIDGenericDbParameter =
new SWPGenericDbParameter(
"@VenueID",
DbType.Int32,
ParameterDirection.Input,
0,
venueID);
SWPGenericDbParameter venueNameGenericDbParameter =
new SWPGenericDbParameter(
"@VenueName",
DbType.String,
ParameterDirection.Input,
255,
venueName);
SWPGenericDbParameter venueDescriptionGenericDbParameter =
new SWPGenericDbParameter(
"@VenueDescription",
DbType.String,
ParameterDirection.Input,
4000,
venueDescription);
SWPGenericDbParameter venueStreetGenericDbParameter =
new SWPGenericDbParameter(
"@VenueStreet",
DbType.String,
ParameterDirection.Input,
255,
venueStreet);
SWPGenericDbParameter venueCityGenericDbParameter =
new SWPGenericDbParameter(
"@VenueCity",
DbType.String,
ParameterDirection.Input,
255,
venueCity);
SWPGenericDbParameter venueStateGenericDbParameter =
new SWPGenericDbParameter(
"@VenueState",
DbType.String,
ParameterDirection.Input,
255,
venueState);
SWPGenericDbParameter venuePostalCodeGenericDbParameter =
new SWPGenericDbParameter(
"@VenuePostalCode",
DbType.StringFixedLength,
ParameterDirection.Input,
25,
venuePostalCode);
SWPGenericDbParameter venueGeographicMapGenericDbParameter =
new SWPGenericDbParameter(
"@VenueGeographicMap",
DbType.Binary,
ParameterDirection.Input,
2147483647,
venueGeographicMap);
SWPGenericDbParameter venueFacilityMapGenericDbParameter =
new SWPGenericDbParameter(
"@VenueFacilityMap",
DbType.Binary,
ParameterDirection.Input,
2147483647,
venueFacilityMap);
SWPGenericDbParameter venueImageGenericDbParameter =
new SWPGenericDbParameter(
"@VenueImage",
DbType.Binary,
ParameterDirection.Input,
2147483647,
venueImage);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspVenueUpdate",
venueIDGenericDbParameter,
venueNameGenericDbParameter,
venueDescriptionGenericDbParameter,
venueStreetGenericDbParameter,
venueCityGenericDbParameter,
venueStateGenericDbParameter,
venuePostalCodeGenericDbParameter,
venueGeographicMapGenericDbParameter,
venueFacilityMapGenericDbParameter,
venueImageGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspVenueUpdate",
venueIDGenericDbParameter,
venueNameGenericDbParameter,
venueDescriptionGenericDbParameter,
venueStreetGenericDbParameter,
venueCityGenericDbParameter,
venueStateGenericDbParameter,
venuePostalCodeGenericDbParameter,
venueGeographicMapGenericDbParameter,
venueFacilityMapGenericDbParameter,
venueImageGenericDbParameter);
}
return(retVal);
}
public int Update(
int eventTypeID,
string eventTypeName,
string eventTypeDescription)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"eventTypeName",
eventTypeName.Length,
255,
validationErrorReport);
ValidateParameterLength(
"eventTypeDescription",
eventTypeDescription.Length,
4000,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter eventTypeIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventTypeID",
DbType.Int32,
ParameterDirection.Input,
0,
eventTypeID);
SWPGenericDbParameter eventTypeNameGenericDbParameter =
new SWPGenericDbParameter(
"@EventTypeName",
DbType.String,
ParameterDirection.Input,
255,
eventTypeName);
SWPGenericDbParameter eventTypeDescriptionGenericDbParameter =
new SWPGenericDbParameter(
"@EventTypeDescription",
DbType.String,
ParameterDirection.Input,
4000,
eventTypeDescription);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspEventTypeUpdate",
eventTypeIDGenericDbParameter,
eventTypeNameGenericDbParameter,
eventTypeDescriptionGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspEventTypeUpdate",
eventTypeIDGenericDbParameter,
eventTypeNameGenericDbParameter,
eventTypeDescriptionGenericDbParameter);
}
return(retVal);
}
public int Update(
int eventAttendeeAgencyMapID,
int eventAttendeeID,
int eventID,
string agencyNumber,
string tripNumber)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"agencyNumber",
agencyNumber.Length,
16,
validationErrorReport);
ValidateParameterLength(
"tripNumber",
tripNumber.Length,
16,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter eventAttendeeAgencyMapIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventAttendeeAgencyMapID",
DbType.Int32,
ParameterDirection.Input,
0,
eventAttendeeAgencyMapID);
SWPGenericDbParameter eventAttendeeIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventAttendeeID",
DbType.Int32,
ParameterDirection.Input,
0,
eventAttendeeID);
SWPGenericDbParameter eventIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventID",
DbType.Int32,
ParameterDirection.Input,
0,
eventID);
SWPGenericDbParameter agencyNumberGenericDbParameter =
new SWPGenericDbParameter(
"@AgencyNumber",
DbType.String,
ParameterDirection.Input,
16,
agencyNumber);
SWPGenericDbParameter tripNumberGenericDbParameter =
new SWPGenericDbParameter(
"@TripNumber",
DbType.String,
ParameterDirection.Input,
16,
tripNumber);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspEventAttendeeAgencyMapUpdate",
eventAttendeeAgencyMapIDGenericDbParameter,
eventAttendeeIDGenericDbParameter,
eventIDGenericDbParameter,
agencyNumberGenericDbParameter,
tripNumberGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspEventAttendeeAgencyMapUpdate",
eventAttendeeAgencyMapIDGenericDbParameter,
eventAttendeeIDGenericDbParameter,
eventIDGenericDbParameter,
agencyNumberGenericDbParameter,
tripNumberGenericDbParameter);
}
return(retVal);
}
public int Update(
string carrID,
string counterNumber,
string airport)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"carrID",
carrID.Length,
3,
validationErrorReport);
ValidateParameterLength(
"counterNumber",
counterNumber.Length,
8,
validationErrorReport);
ValidateParameterLength(
"airport",
airport.Length,
3,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter carrIDGenericDbParameter =
new SWPGenericDbParameter(
"@CarrID",
DbType.AnsiStringFixedLength,
ParameterDirection.Input,
3,
carrID);
SWPGenericDbParameter counterNumberGenericDbParameter =
new SWPGenericDbParameter(
"@CounterNumber",
DbType.AnsiStringFixedLength,
ParameterDirection.Input,
8,
counterNumber);
SWPGenericDbParameter airportGenericDbParameter =
new SWPGenericDbParameter(
"@Airport",
DbType.AnsiStringFixedLength,
ParameterDirection.Input,
3,
airport);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspRefCounterUpdate",
carrIDGenericDbParameter,
counterNumberGenericDbParameter,
airportGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspRefCounterUpdate",
carrIDGenericDbParameter,
counterNumberGenericDbParameter,
airportGenericDbParameter);
}
return(retVal);
}
public int Update(
int packageID,
string packageName,
string packageDescription,
byte [] packageImage)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"packageName",
packageName.Length,
255,
validationErrorReport);
ValidateParameterLength(
"packageDescription",
packageDescription.Length,
4000,
validationErrorReport);
ValidateParameterLength(
"packageImage",
packageImage.Length,
2147483647,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter packageIDGenericDbParameter =
new SWPGenericDbParameter(
"@PackageID",
DbType.Int32,
ParameterDirection.Input,
0,
packageID);
SWPGenericDbParameter packageNameGenericDbParameter =
new SWPGenericDbParameter(
"@PackageName",
DbType.String,
ParameterDirection.Input,
255,
packageName);
SWPGenericDbParameter packageDescriptionGenericDbParameter =
new SWPGenericDbParameter(
"@PackageDescription",
DbType.String,
ParameterDirection.Input,
4000,
packageDescription);
SWPGenericDbParameter packageImageGenericDbParameter =
new SWPGenericDbParameter(
"@PackageImage",
DbType.Binary,
ParameterDirection.Input,
2147483647,
packageImage);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspPackageUpdate",
packageIDGenericDbParameter,
packageNameGenericDbParameter,
packageDescriptionGenericDbParameter,
packageImageGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspPackageUpdate",
packageIDGenericDbParameter,
packageNameGenericDbParameter,
packageDescriptionGenericDbParameter,
packageImageGenericDbParameter);
}
return(retVal);
}
public int Update(
int eventAttendeeID,
int packageID,
string customerNumber,
DateTime dateOfBirth)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"customerNumber",
customerNumber.Length,
25,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter eventAttendeeIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventAttendeeID",
DbType.Int32,
ParameterDirection.Input,
0,
eventAttendeeID);
SWPGenericDbParameter packageIDGenericDbParameter =
new SWPGenericDbParameter(
"@PackageID",
DbType.Int32,
ParameterDirection.Input,
0,
packageID);
SWPGenericDbParameter customerNumberGenericDbParameter =
new SWPGenericDbParameter(
"@CustomerNumber",
DbType.StringFixedLength,
ParameterDirection.Input,
25,
customerNumber);
SWPGenericDbParameter dateOfBirthGenericDbParameter =
new SWPGenericDbParameter(
"@DateOfBirth",
DbType.DateTime,
ParameterDirection.Input,
0,
dateOfBirth);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspEventAttendeeUpdate",
eventAttendeeIDGenericDbParameter,
packageIDGenericDbParameter,
customerNumberGenericDbParameter,
dateOfBirthGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspEventAttendeeUpdate",
eventAttendeeIDGenericDbParameter,
packageIDGenericDbParameter,
customerNumberGenericDbParameter,
dateOfBirthGenericDbParameter);
}
return(retVal);
}
public int Update(
int eventID,
int venueID,
int eventTypeID,
string eventName,
string eventDescription,
byte [] eventPhoto,
DateTime eventDate,
decimal goldPackagePrice,
decimal silverPackagePrice,
decimal bronzePackagePrice,
decimal goldPackageTrueCost,
decimal silverPackageTrueCost,
decimal bronzePackageTrueCost,
decimal eventTotalCost)
{
StringBuilder validationErrorReport = new StringBuilder();
ValidateParameterLength(
"eventName",
eventName.Length,
255,
validationErrorReport);
ValidateParameterLength(
"eventDescription",
eventDescription.Length,
4000,
validationErrorReport);
ValidateParameterLength(
"eventPhoto",
eventPhoto.Length,
2147483647,
validationErrorReport);
if (validationErrorReport.Length > 0)
{
throw new ApplicationException(validationErrorReport.ToString());
}
int retVal;
SWPGenericDbParameter eventIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventID",
DbType.Int32,
ParameterDirection.Input,
0,
eventID);
SWPGenericDbParameter venueIDGenericDbParameter =
new SWPGenericDbParameter(
"@VenueID",
DbType.Int32,
ParameterDirection.Input,
0,
venueID);
SWPGenericDbParameter eventTypeIDGenericDbParameter =
new SWPGenericDbParameter(
"@EventTypeID",
DbType.Int32,
ParameterDirection.Input,
0,
eventTypeID);
SWPGenericDbParameter eventNameGenericDbParameter =
new SWPGenericDbParameter(
"@EventName",
DbType.String,
ParameterDirection.Input,
255,
eventName);
SWPGenericDbParameter eventDescriptionGenericDbParameter =
new SWPGenericDbParameter(
"@EventDescription",
DbType.String,
ParameterDirection.Input,
4000,
eventDescription);
SWPGenericDbParameter eventPhotoGenericDbParameter =
new SWPGenericDbParameter(
"@EventPhoto",
DbType.Binary,
ParameterDirection.Input,
2147483647,
eventPhoto);
SWPGenericDbParameter eventDateGenericDbParameter =
new SWPGenericDbParameter(
"@EventDate",
DbType.DateTime,
ParameterDirection.Input,
0,
eventDate);
SWPGenericDbParameter goldPackagePriceGenericDbParameter =
new SWPGenericDbParameter(
"@GoldPackagePrice",
DbType.Currency,
ParameterDirection.Input,
0,
goldPackagePrice);
SWPGenericDbParameter silverPackagePriceGenericDbParameter =
new SWPGenericDbParameter(
"@SilverPackagePrice",
DbType.Currency,
ParameterDirection.Input,
0,
silverPackagePrice);
SWPGenericDbParameter bronzePackagePriceGenericDbParameter =
new SWPGenericDbParameter(
"@BronzePackagePrice",
DbType.Currency,
ParameterDirection.Input,
0,
bronzePackagePrice);
SWPGenericDbParameter goldPackageTrueCostGenericDbParameter =
new SWPGenericDbParameter(
"@GoldPackageTrueCost",
DbType.Currency,
ParameterDirection.Input,
0,
goldPackageTrueCost);
SWPGenericDbParameter silverPackageTrueCostGenericDbParameter =
new SWPGenericDbParameter(
"@SilverPackageTrueCost",
DbType.Currency,
ParameterDirection.Input,
0,
silverPackageTrueCost);
SWPGenericDbParameter bronzePackageTrueCostGenericDbParameter =
new SWPGenericDbParameter(
"@BronzePackageTrueCost",
DbType.Currency,
ParameterDirection.Input,
0,
bronzePackageTrueCost);
SWPGenericDbParameter eventTotalCostGenericDbParameter =
new SWPGenericDbParameter(
"@EventTotalCost",
DbType.Currency,
ParameterDirection.Input,
0,
eventTotalCost);
if (_dbTransactionConnection == null)
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbConnectionName,
"uspEventUpdate",
eventIDGenericDbParameter,
venueIDGenericDbParameter,
eventTypeIDGenericDbParameter,
eventNameGenericDbParameter,
eventDescriptionGenericDbParameter,
eventPhotoGenericDbParameter,
eventDateGenericDbParameter,
goldPackagePriceGenericDbParameter,
silverPackagePriceGenericDbParameter,
bronzePackagePriceGenericDbParameter,
goldPackageTrueCostGenericDbParameter,
silverPackageTrueCostGenericDbParameter,
bronzePackageTrueCostGenericDbParameter,
eventTotalCostGenericDbParameter);
}
else
{
retVal = SWPDBHelper.StoredProcExecuteNonQuery(
_dbTransactionConnection,
"uspEventUpdate",
eventIDGenericDbParameter,
venueIDGenericDbParameter,
eventTypeIDGenericDbParameter,
eventNameGenericDbParameter,
eventDescriptionGenericDbParameter,
eventPhotoGenericDbParameter,
eventDateGenericDbParameter,
goldPackagePriceGenericDbParameter,
silverPackagePriceGenericDbParameter,
bronzePackagePriceGenericDbParameter,
goldPackageTrueCostGenericDbParameter,
silverPackageTrueCostGenericDbParameter,
bronzePackageTrueCostGenericDbParameter,
eventTotalCostGenericDbParameter);
}
return(retVal);
}
