/// <summary>
/// Insert TourInfo.
/// </summary>
/// <param name="customer">TourBDto object that TourInfo data to insert.</param>
/// <returns>Returns 1 and 0; 1 indicates successfull operation.</returns>
public int UpdateTourTravelPriceDetail(TourTravelBDto objTourTravelBDto)
{
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_TRAVEL_CURRENCY_PRICE_UPDATE);
db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, objTourTravelBDto.SrNoPrice);
db.AddInParameter(dbCmd, "@TRANSPORT_MODE", DbType.Int32, objTourTravelBDto.TransportModeId);
db.AddInParameter(dbCmd, "@TRANSPORTATTION_ID", DbType.Int32, objTourTravelBDto.transporationId);
db.AddInParameter(dbCmd, "@CURRENCY", DbType.Int32, objTourTravelBDto.Currency);
db.AddInParameter(dbCmd, "@SEATS_FOR", DbType.Int32, objTourTravelBDto.SeatsFor);
db.AddInParameter(dbCmd, "@NO_OF_SEATS", DbType.Int32, objTourTravelBDto.NoOfSeats);
db.AddInParameter(dbCmd, "@AMOUNT", DbType.Decimal, objTourTravelBDto.Amount);
db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, objTourTravelBDto.Tax);
db.AddInParameter(dbCmd, "@GST", DbType.Decimal, objTourTravelBDto.Gst);
db.AddInParameter(dbCmd, "@TOTAL_AMOUNT", DbType.Decimal, objTourTravelBDto.TotalAmount);
db.AddInParameter(dbCmd, "@FINAL_AMOUNT", DbType.Decimal, objTourTravelBDto.FinalAmount);
db.AddInParameter(dbCmd, "@REMARKS", DbType.String, objTourTravelBDto.Remarks);
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;
}
/// <summary>
/// Insert TourInfo.
/// </summary>
/// <param name="customer">TourBDto object that TourInfo data to insert.</param>
/// <returns>Returns 1 and 0; 1 indicates successfull operation.</returns>
public int UpdateTourTravelDetail(TourTravelBDto objTourTravelBDto)
{
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_TRAVEL_DETAIL_UPDATE);
db.AddInParameter(dbCmd, "@TOUR_ID", DbType.Int32, objTourTravelBDto.tourId);
db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, objTourTravelBDto.SrNo);
db.AddInParameter(dbCmd, "@TRANSPORT_MODE_ID", DbType.Int32, objTourTravelBDto.TransportModeId);
db.AddInParameter(dbCmd, "@TRANSPORT_ID", DbType.Int32, objTourTravelBDto.TransportId);
db.AddInParameter(dbCmd, "@TRANSPORT_NO", DbType.String, objTourTravelBDto.FlightNo);
db.AddInParameter(dbCmd, "@TRANSPORT_DETAILS", DbType.String, objTourTravelBDto.TransportDetail);
db.AddInParameter(dbCmd, "@DATE_OF_ARRIVAL", DbType.DateTime, objTourTravelBDto.DateOfArrival);
db.AddInParameter(dbCmd, "@TIME_OF_ARRIVAL", DbType.DateTime, objTourTravelBDto.TimeOfArrival);
db.AddInParameter(dbCmd, "@PLACE_OF_ARRIVAL", DbType.Int32, objTourTravelBDto.PlaceOfArrivalDestination);
db.AddInParameter(dbCmd, "@DATE_OF_DEPARTURE", DbType.DateTime, objTourTravelBDto.DateOfDeparture);
db.AddInParameter(dbCmd, "@TIME_OF_DEPARTURE", DbType.DateTime, objTourTravelBDto.TimeOfDeparture);
db.AddInParameter(dbCmd, "@PLACE_OF_DEPARTURE", DbType.Int32, objTourTravelBDto.PlaceOfDepartureSource);
db.AddInParameter(dbCmd, "@NO_OF_SEATS", DbType.Int32, objTourTravelBDto.NoOfSeats);
db.AddInParameter(dbCmd, "@AMOUNT", DbType.Decimal, objTourTravelBDto.Amount);
db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, objTourTravelBDto.Branch);
db.AddInParameter(dbCmd, "@BOOKING_REQUEST_TO", DbType.Int32, objTourTravelBDto.BookingRequestTo);
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;
}