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