public int UpdateTourTicketBookingDetial(TourTicketDetailBDto tourTicketDetail) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("dbo.USP_BOOKING_TOUR_TICKET_BOOKING_DETAILS_UPDATE"); if (!String.IsNullOrEmpty(tourTicketDetail.xmlString)) db.AddInParameter(dbCmd, "@XML_DATA", DbType.String, tourTicketDetail.xmlString); else db.AddInParameter(dbCmd, "@XML_DATA", DbType.String, DBNull.Value); db.AddOutParameter(dbCmd, "@IS_INSERT", DbType.Int32, 1); Result = db.ExecuteNonQuery(dbCmd); Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_INSERT")); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }
public int UpdateTourBookingAirline(TourTicketDetailBDto ticketBookingHdr) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("dbo.USP_BOOKING_TOUR_AIRLINE_DETAILS_UPDATE"); if (ticketBookingHdr.TourBookingId != 0) db.AddInParameter(dbCmd, "@BOOKING_ID", DbType.Int32, ticketBookingHdr.TourBookingId); else db.AddInParameter(dbCmd, "@BOOKING_ID", DbType.Int32, DBNull.Value); if (ticketBookingHdr.BranchId != 0) db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, ticketBookingHdr.BranchId); else db.AddInParameter(dbCmd, "@BRANCH_ID", DbType.Int32, DBNull.Value); if (ticketBookingHdr.BookingRequestTo != 0) db.AddInParameter(dbCmd, "@BOOKING_REQUEST_TO", DbType.Int32, ticketBookingHdr.BookingRequestTo); else db.AddInParameter(dbCmd, "@BOOKING_REQUEST_TO", DbType.Int32, DBNull.Value); Result = db.ExecuteNonQuery(dbCmd); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }
public int InsertTourTicketBookingDetialIndividual(TourTicketDetailBDto tourTicketDetail, ref int ticketSrNo) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand("dbo.USP_BOOKING_TOUR_TICKET_BOOKING_DETAILS_INSERT1"); if (tourTicketDetail.TicketBookingHeader.TicketTypeId != 0) db.AddInParameter(dbCmd, "@TICKET_TYPE_ID", DbType.Int32, tourTicketDetail.TicketBookingHeader.TicketTypeId); else db.AddInParameter(dbCmd, "@TICKET_TYPE_ID", DbType.Int32, DBNull.Value); if (tourTicketDetail.TicketBookingHeader.TravelModeId != 0) db.AddInParameter(dbCmd, "@MODE_OF_TRAVEL", DbType.Int32, tourTicketDetail.TicketBookingHeader.TravelModeId); else db.AddInParameter(dbCmd, "@MODE_OF_TRAVEL", DbType.Int32, DBNull.Value); if (tourTicketDetail.TicketBookingHeader.InquiryId != 0) db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, tourTicketDetail.TicketBookingHeader.InquiryId); else db.AddInParameter(dbCmd, "@INQUIRY_ID", DbType.Int32, DBNull.Value); if (tourTicketDetail.TourBookingId != 0) db.AddInParameter(dbCmd, "@TOUR_BOOKING_ID", DbType.Int32, tourTicketDetail.TourBookingId); else db.AddInParameter(dbCmd, "@TOUR_BOOKING_ID", DbType.Int32, DBNull.Value); if (tourTicketDetail.TourBookingSerialNo != 0) db.AddInParameter(dbCmd, "@TOUR_BOOKING_SRNO", DbType.Int32, tourTicketDetail.TourBookingSerialNo); else db.AddInParameter(dbCmd, "@TOUR_BOOKING_SRNO", DbType.Int32, DBNull.Value); if (tourTicketDetail.TitleId != 0) db.AddInParameter(dbCmd, "@TITLE_ID", DbType.Int32, tourTicketDetail.TitleId); else db.AddInParameter(dbCmd, "@TITLE_ID", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.LastName)) db.AddInParameter(dbCmd, "@SURNAME", DbType.String, tourTicketDetail.LastName); else db.AddInParameter(dbCmd, "@SURNAME", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.FirstName)) db.AddInParameter(dbCmd, "@NAME", DbType.String, tourTicketDetail.FirstName); else db.AddInParameter(dbCmd, "@NAME", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.PnrNo)) db.AddInParameter(dbCmd, "@PNR_NO", DbType.String, tourTicketDetail.PnrNo); else db.AddInParameter(dbCmd, "@PNR_NO", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.TicketNo)) db.AddInParameter(dbCmd, "@TICKET_NO", DbType.String, tourTicketDetail.TicketNo); else db.AddInParameter(dbCmd, "@TICKET_NO", DbType.String, DBNull.Value); if (tourTicketDetail.DateOfDeparture != DateTime.MinValue) db.AddInParameter(dbCmd, "@DATE_OF_DEPARTURE", DbType.DateTime, tourTicketDetail.DateOfDeparture); else db.AddInParameter(dbCmd, "@DATE_OF_DEPARTURE", DbType.DateTime, DBNull.Value); if (tourTicketDetail.DateOfArrival != DateTime.MinValue) db.AddInParameter(dbCmd, "@DATE_OF_ARRIVAL", DbType.DateTime, tourTicketDetail.DateOfArrival); else db.AddInParameter(dbCmd, "@DATE_OF_ARRIVAL", DbType.DateTime, DBNull.Value); if (tourTicketDetail.PlaceFrom != 0) db.AddInParameter(dbCmd, "@FROM_PLACE", DbType.Int32, tourTicketDetail.PlaceFrom); else db.AddInParameter(dbCmd, "@FROM_PLACE", DbType.Int32, DBNull.Value); if (tourTicketDetail.PlaceTo != 0) db.AddInParameter(dbCmd, "@TO_PLACE", DbType.Int32, tourTicketDetail.PlaceTo); else db.AddInParameter(dbCmd, "@TO_PLACE", DbType.Int32, DBNull.Value); if (tourTicketDetail.AirLineId != 0) db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, tourTicketDetail.AirLineId); else db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, DBNull.Value); if (tourTicketDetail.ClassId != 0) db.AddInParameter(dbCmd, "@CLASS_ID", DbType.Int32, tourTicketDetail.ClassId); else db.AddInParameter(dbCmd, "@CLASS_ID", DbType.Int32, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.FlightFlyNo)) db.AddInParameter(dbCmd, "@FLIGHT_FLY_NO", DbType.String, tourTicketDetail.FlightFlyNo); else db.AddInParameter(dbCmd, "@FLIGHT_FLY_NO", DbType.String, DBNull.Value); if (!String.IsNullOrEmpty(tourTicketDetail.FrequentFlyNo)) db.AddInParameter(dbCmd, "@FREQUENT_FLY_NO", DbType.String, tourTicketDetail.FrequentFlyNo); else db.AddInParameter(dbCmd, "@FREQUENT_FLY_NO", DbType.String, DBNull.Value); if (tourTicketDetail.MarginAmount != 0) db.AddInParameter(dbCmd, "@MARGIN_AMOUNT", DbType.Decimal, tourTicketDetail.MarginAmount); else db.AddInParameter(dbCmd, "@MARGIN_AMOUNT", DbType.Decimal, DBNull.Value); if (tourTicketDetail.FareAmount != 0) db.AddInParameter(dbCmd, "@FAIR_AMOUNT", DbType.Decimal, tourTicketDetail.FareAmount); else db.AddInParameter(dbCmd, "@FAIR_AMOUNT", DbType.Decimal, DBNull.Value); db.AddInParameter(dbCmd, "@IS_E_TICKET", DbType.Boolean, tourTicketDetail.IsETicket); db.AddOutParameter(dbCmd, "@SR_NO", DbType.Int32, 9); Result = db.ExecuteNonQuery(dbCmd); ticketSrNo = Convert.ToInt32(db.GetParameterValue(dbCmd, "@SR_NO")); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME); if (rethrow) { throw ex; } } finally { DALHelper.Destroy(ref dbCmd); } return Result; }