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