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