public int UpdateTourInfo(TourBDto objTourBDto) { Database db = null; DbCommand dbCmd = null; DataSet ds = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_TOUR_UPDATE); db.AddInParameter(dbCmd, "@TOUR_CODE", DbType.String, objTourBDto.TourCode); db.AddInParameter(dbCmd, "@TOUR_SHORT_NAME", DbType.String, objTourBDto.TourSortName); db.AddInParameter(dbCmd, "@TOUR_LONG_DESC", DbType.String, objTourBDto.TourLongName); db.AddInParameter(dbCmd, "@TOUR_ITENARY_TYPE_ID", DbType.Int32, objTourBDto.TourItenaryId); db.AddInParameter(dbCmd, "@TOUR_TYPE_ID", DbType.Int32, objTourBDto.TourTypeId); db.AddInParameter(dbCmd, "@TOUR_FROM_DATE", DbType.DateTime, objTourBDto.TourFormDate); db.AddInParameter(dbCmd, "@TOUR_TO_DATE", DbType.DateTime, objTourBDto.TourToDate); db.AddInParameter(dbCmd, "@NO_OF_DAYS", DbType.Int32, objTourBDto.NoOfDays); db.AddInParameter(dbCmd, "@NO_OF_SEATS", DbType.Int32, objTourBDto.NoOfSeats); db.AddInParameter(dbCmd, "@NO_OF_NIGHTS", DbType.Int32, objTourBDto.NoOfNights); //db.AddInParameter(dbCmd, "@TOUR_COST_ADULT", DbType.Int32, objTourBDto.TourCostAdult); //db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITH_BED", DbType.Int32, objTourBDto.TourCostChildWithBed); //db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITHOUT_BED", DbType.Int32, objTourBDto.TourCostChildWithoutBed); //db.AddInParameter(dbCmd, "@INFANT_PRICE", DbType.Int32, objTourBDto.InfantPrice); //db.AddInParameter(dbCmd, "@TOUR_CURRANCY", DbType.String, objTourBDto.TourCurrancy); db.AddInParameter(dbCmd, "@COUNTRIES_FOR_VISA", DbType.String, objTourBDto.CountriesForVisa); db.AddInParameter(dbCmd, "@CITIES_TO_TRAVEL", DbType.String, objTourBDto.CityToTravel); db.AddInParameter(dbCmd, "@START_END_CITY", DbType.String, objTourBDto.StartEndCity); db.AddInParameter(dbCmd, "@TOUR_HIGHLIGHT", DbType.Binary, objTourBDto.TourHighlight); db.AddInParameter(dbCmd, "@TOUR_HIGHLIGHT_CONTENT_TYPE", DbType.String, objTourBDto.TourHighlightContentType); db.AddInParameter(dbCmd, "@TOUR_HIGHLIGHT_FILE_NAME", DbType.String, objTourBDto.TourHighlightFileName); db.AddInParameter(dbCmd, "@IMPORTANT_NOTES", DbType.Binary, objTourBDto.ImportantNotes); db.AddInParameter(dbCmd, "@IMPORTANT_NOTES_CONTENT_TYPE", DbType.String, objTourBDto.ImportantNotesContentType); db.AddInParameter(dbCmd, "@IMPORTANT_NOTES_FILE_NAME", DbType.String, objTourBDto.ImportantNotesFileName); db.AddInParameter(dbCmd, "@TERMS_AND_CONDITIONS", DbType.Binary, objTourBDto.TermsAndConditions); db.AddInParameter(dbCmd, "@TERMS_AND_CONDITIONS_CONTENT_TYPE", DbType.String, objTourBDto.TermsAndConditionsContentType); db.AddInParameter(dbCmd, "@TERMS_AND_CONDITIONS_FILE_NAME", DbType.String, objTourBDto.TermsAndConditionsFileName); db.AddInParameter(dbCmd, "@PAYMENT_TERMS", DbType.Binary, objTourBDto.PaymentTerms); db.AddInParameter(dbCmd, "@PAYMENT_TERMS_CONTENT_TYPE", DbType.String, objTourBDto.PaymentTermsContentType); db.AddInParameter(dbCmd, "@PAYMENT_TERMS_FILE_NAME", DbType.String, objTourBDto.PaymentTermsFileName); db.AddInParameter(dbCmd, "@CANCELLATION_CHARGES", DbType.Binary, objTourBDto.CancellationCharges); db.AddInParameter(dbCmd, "@CANCELLATION_CHARGES_CONTENT_TYPE", DbType.String, objTourBDto.CancellationChargesContentType); db.AddInParameter(dbCmd, "@CANCELLATION_CHARGES_FILE_NAME", DbType.String, objTourBDto.CancellationChargesFileName); db.AddInParameter(dbCmd, "@TOUR_ITENARY", DbType.Binary, objTourBDto.TourItenary); db.AddInParameter(dbCmd, "@TOUR_ITENARY_CONTENT_TYPE", DbType.String, objTourBDto.TourItenaryContentType); db.AddInParameter(dbCmd, "@TOUR_ITENARY_FILE_NAME", DbType.String, objTourBDto.TourItenaryFileName); db.AddInParameter(dbCmd, "@OPTIONAL_SITE_SEEING_COST", DbType.Binary, objTourBDto.OptionalSiteSeeingCost); db.AddInParameter(dbCmd, "@OPTIONAL_SITE_SEEING_COST_CONTENT_TYPE", DbType.String, objTourBDto.OptionalSiteSeeingCostContentType); db.AddInParameter(dbCmd, "@OPTIONAL_SITE_SEEING_COST_FILE_NAME", DbType.String, objTourBDto.OptionalSiteSeeingCostFileName); db.AddInParameter(dbCmd, "@USP", DbType.Binary, objTourBDto.Usp); db.AddInParameter(dbCmd, "@USP_CONTENT_TYPE", DbType.String, objTourBDto.UspContentType); db.AddInParameter(dbCmd, "@USP_FILE_NAME", DbType.String, objTourBDto.UspFileName); db.AddInParameter(dbCmd, "@LIMITATIONS", DbType.Binary, objTourBDto.Limitations); db.AddInParameter(dbCmd, "@LIMITATIONS_CONTENT_TYPE", DbType.String, objTourBDto.LimitationsContentType); db.AddInParameter(dbCmd, "@LIMITATIONS_FILE_NAME", DbType.String, objTourBDto.LimitationsFileName); db.AddInParameter(dbCmd, "@COMPETITORS_COMPARISON", DbType.Binary, objTourBDto.CompetitorsComparison); db.AddInParameter(dbCmd, "@COMPETITORS_COMPARISON_CONTENT_TYPE", DbType.String, objTourBDto.CompetitorsComparisonContentType); db.AddInParameter(dbCmd, "@COMPETITORS_COMPARISON_FILE_NAME", DbType.String, objTourBDto.CompetitorsComparisonFileName); db.AddInParameter(dbCmd, "@FINAL_ITERNARY", DbType.Binary, objTourBDto.FinalIternary); db.AddInParameter(dbCmd, "@FINAL_ITERNARY_CONTENT_TYPE", DbType.String, objTourBDto.FinalIternaryContentType); db.AddInParameter(dbCmd, "@FINAL_ITERNARY_FILE_NAME", DbType.String, objTourBDto.FinalIternaryFileName); db.AddInParameter(dbCmd, "@FINAL_TERMS_CONDITIONS", DbType.Binary, objTourBDto.FinalTermsConditions); db.AddInParameter(dbCmd, "@FINAL_TERMS_CONDITIONS_CONTENT_TYPE", DbType.String, objTourBDto.FinalTermsConditionsContentType); db.AddInParameter(dbCmd, "@FINAL_TERMS_CONDITIONS_FILE_NAME", DbType.String, objTourBDto.FinalTermsConditionsFileName); db.AddInParameter(dbCmd, "@FINAL_VOUCHURES", DbType.Binary, objTourBDto.FinalVouchures); db.AddInParameter(dbCmd, "@FINAL_VOUCHURES_CONTENT_TYPE", DbType.String, objTourBDto.FinalVouchuresContentType); db.AddInParameter(dbCmd, "@FINAL_VOUCHURES_FILE_NAME", DbType.String, objTourBDto.FinalVouchuresFileName); db.AddInParameter(dbCmd, "@DESTINATION_DETAILS", DbType.Binary, objTourBDto.DestinationDetails); db.AddInParameter(dbCmd, "@DESTINATION_DETAILS_CONTENT_TYPE", DbType.String, objTourBDto.DestinationDetailsContentType); db.AddInParameter(dbCmd, "@DESTINATION_DETAILS_FILE_NAME", DbType.String, objTourBDto.DestinationDetailsFileName); db.AddInParameter(dbCmd, "@GENERAL_GUIDE_LINES", DbType.Binary, objTourBDto.GeneralGuideLines); db.AddInParameter(dbCmd, "@GENERAL_GUIDE_LINES_CONTENT_TYPE", DbType.String, objTourBDto.GeneralGuideLinesContentType); db.AddInParameter(dbCmd, "@GENERAL_GUIDE_LINES_FILE_NAME", DbType.String, objTourBDto.GeneralGuideLinesFileName); db.AddInParameter(dbCmd, "@BROCHURE1", DbType.Binary, objTourBDto.Brochure1); db.AddInParameter(dbCmd, "@BROCHURE1_CONTENT_TYPE", DbType.String, objTourBDto.Brochure1ContentType); db.AddInParameter(dbCmd, "@BROCHURE1_FILE_NAME", DbType.String, objTourBDto.Brochure1FileName); db.AddInParameter(dbCmd, "@BROCHURE2", DbType.Binary, objTourBDto.Brochure2); db.AddInParameter(dbCmd, "@BROCHURE2_CONTENT_TYPE", DbType.String, objTourBDto.Brochure2ContentType); db.AddInParameter(dbCmd, "@BROCHURE2_FILE_NAME", DbType.String, objTourBDto.Brochure2FileName); db.AddInParameter(dbCmd, "@BROCHURE3", DbType.Binary, objTourBDto.Brochure3); db.AddInParameter(dbCmd, "@BROCHURE3_CONTENT_TYPE", DbType.String, objTourBDto.Brochure3ContentType); db.AddInParameter(dbCmd, "@BROCHURE3_FILE_NAME", DbType.String, objTourBDto.Brochure3FileName); db.AddInParameter(dbCmd, "@WEB_PHOTO", DbType.Binary, objTourBDto.WebPhoto); db.AddInParameter(dbCmd, "@WEB_PHOTO_CONTENT", DbType.String, objTourBDto.WebPhotoContent); db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32, objTourBDto.UserId); db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, objTourBDto.TourId); db.AddInParameter(dbCmd, "@TOUR_INTER_DOMEST", DbType.String, objTourBDto.TourInterDomestic); db.AddInParameter(dbCmd, "@BASE_TOUR_ID", DbType.Int32, objTourBDto.BaseTourId); db.AddOutParameter(dbCmd, "@IS_UPDATE", DbType.Int32, 1); db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_UPDATE")); if (db.GetParameterValue(dbCmd, "@IS_UPDATE") != DBNull.Value) Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_UPDATE")); if (Result == 1) return 1; // SUCCESSFUL INSERTION RETURN TRUE else return 0; // UNSUCCESSFUL INSERTION RETUN FALSE ( ALREADY EXISTS ) } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return 0; }
public int UpdateFareTourCurrencyPrice(TourBDto objTourBDto) { Database db = null; DbCommand dbCmd = null; DataSet ds = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_TOUR_CURRENCY_PRICE_UPDATE); db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, objTourBDto.TourId); db.AddInParameter(dbCmd, "@CURRENCY_PRICE_ID", DbType.Int32, objTourBDto.CurrencyPriceId); // if (objTourBDto.TourCostAdult != 0) db.AddInParameter(dbCmd, "@TOUR_COST_ADULT", DbType.Int32, objTourBDto.TourCostAdult); // else // db.AddInParameter(dbCmd, "@TOUR_COST_ADULT", DbType.Int32, DBNull.Value); // if (objTourBDto.TourCostChildWithBed != 0) db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITH_BED", DbType.Int32, objTourBDto.TourCostChildWithBed); // else // db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITH_BED", DbType.Int32, DBNull.Value); // if (objTourBDto.TourCostChildWithoutBed != 0) db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITHOUT_BED", DbType.Int32, objTourBDto.TourCostChildWithoutBed); // else // db.AddInParameter(dbCmd, "@TOUR_COST_CHILD_WITHOUT_BED", DbType.Int32, DBNull.Value); // if (objTourBDto.InfantPrice != 0) db.AddInParameter(dbCmd, "@INFANT_PRICE", DbType.Int32, objTourBDto.InfantPrice); // else // db.AddInParameter(dbCmd, "@INFANT_PRICE", DbType.Int32, DBNull.Value); db.AddInParameter(dbCmd, "@TOUR_CURRANCY", DbType.String, objTourBDto.TourCurrancy); Result = db.ExecuteNonQuery(dbCmd); return Result; } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return 0; }