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