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