/// <summary> /// Insert GdsAirportDal detail. /// </summary> /// <param name="xmlData">Data that converted into xml format.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int InsertGdsAirport(GdsAirportBDto objGdsAirportBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_AIRLINE_GDS_AIRPORT_INSERT); db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.String, objGdsAirportBDto.AirlineId); db.AddInParameter(dbCmd, "@GDS_AIRPORT_CODE", DbType.String, objGdsAirportBDto.GDSAirportCode); db.AddInParameter(dbCmd, "@GDS_PRILIMINARY_BOOKING", DbType.String, objGdsAirportBDto.GDSPriliminaryBooking); db.AddInParameter(dbCmd, "@TOTAL_FARE", DbType.Decimal, objGdsAirportBDto.TotalFare); db.AddInParameter(dbCmd, "@TOTAL_TAXES", DbType.Decimal, objGdsAirportBDto.TotalTaxs); db.AddInParameter(dbCmd, "@TIME_LIMIT", DbType.DateTime, objGdsAirportBDto.TimeLimit); db.AddInParameter(dbCmd, "@BAGGAGE_ALLWANCE", DbType.String, objGdsAirportBDto.BaggageAllwance); db.AddInParameter(dbCmd, "@CANCELLATION_POLICY", DbType.String, objGdsAirportBDto.CancellationPolicy); db.AddInParameter(dbCmd, "@DATE_CHANGE_POLICY", DbType.String, objGdsAirportBDto.DatechangePolicy); db.AddInParameter(dbCmd, "@LOCAL_CONTACT_NUM_OF_PAX", DbType.String, objGdsAirportBDto.LocalContactPax); db.AddInParameter(dbCmd, "@EMAIL_ID", DbType.String, objGdsAirportBDto.Email); db.AddInParameter(dbCmd, "@PAYMENT_POLICCY", DbType.String, objGdsAirportBDto.PaymentPolicy); db.AddInParameter(dbCmd, "@FAQ_DOCUMENT", DbType.Binary, objGdsAirportBDto.FaqDocument); db.AddInParameter(dbCmd, "@TERMS_AND_CONDITION_DOCUMENT", DbType.Binary, objGdsAirportBDto.TermsAndConditionDocument); 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; }
/// <summary> /// Insert GdsAirportDal detail. /// </summary> /// <param name="xmlData">Data that converted into xml format.</param> /// <returns>Returns 1 and 0; (1 indicates successful operation).</returns> public int InsertUpdateAirport(GdsAirportBDto objGdsAirportBDto) { Database db = null; DbCommand dbCmd = null; int Result = 0; try { db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING); dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_AIRPORT_MASTER_INSERT_UPDATE); db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, objGdsAirportBDto.SrNo); db.AddInParameter(dbCmd, "@DESTINATION_CITY", DbType.Int32, objGdsAirportBDto.DestinationCity); db.AddInParameter(dbCmd, "@AIRPORT_NAME", DbType.String, objGdsAirportBDto.AirportName); db.AddInParameter(dbCmd, "@AIRPORT_CODE", DbType.String, objGdsAirportBDto.AirportCode); 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; }