public int InsertFlight(FlightBDto flight, ref int flightId)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand("dbo.USP_FARE_FLIGHT_MASTER_INSERT");
if (flight.AirlineId != 0)
db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, flight.AirlineId);
else
db.AddInParameter(dbCmd, "@AIRLINE_ID", DbType.Int32, DBNull.Value);
if (flight.DaysInOperation != 0)
db.AddInParameter(dbCmd, "@DAYS_IN_OPERATION", DbType.Int32, flight.DaysInOperation);
else
db.AddInParameter(dbCmd, "@DAYS_IN_OPERATION", DbType.Int32, DBNull.Value);
if (flight.EffectiveFrom != DateTime.MinValue)
db.AddInParameter(dbCmd, "@EFFECTIVE_FROM", DbType.DateTime, flight.EffectiveFrom);
else
db.AddInParameter(dbCmd, "@EFFECTIVE_FROM", DbType.DateTime, DBNull.Value);
if (flight.DestinationCity != 0)
db.AddInParameter(dbCmd, "@DESTINATION_CITY_ID", DbType.Int32, flight.DestinationCity);
else
db.AddInParameter(dbCmd, "@DESTINATION_CITY_ID", DbType.Int32, DBNull.Value);
if (flight.SourceCity != 0)
db.AddInParameter(dbCmd, "@SOURCE_CITY_ID", DbType.Int32, flight.SourceCity);
else
db.AddInParameter(dbCmd, "@SOURCE_CITY_ID", DbType.Int32, DBNull.Value);
//if (flight.Duration != 0)
db.AddInParameter(dbCmd, "@DURATION", DbType.Decimal, flight.Duration);
//else
// db.AddInParameter(dbCmd, "@DURATION", DbType.Decimal, DBNull.Value);
if (flight.TimeOfArrival != DateTime.MinValue)
db.AddInParameter(dbCmd, "@ARRIVAL_TIME", DbType.DateTime, flight.TimeOfArrival);
else
db.AddInParameter(dbCmd, "@ARRIVAL_TIME", DbType.DateTime, DBNull.Value);
if (flight.TimeOfDeparture != DateTime.MinValue)
db.AddInParameter(dbCmd, "@DEP_TIME", DbType.DateTime, flight.TimeOfDeparture);
else
db.AddInParameter(dbCmd, "@DEP_TIME", DbType.DateTime, DBNull.Value);
if (!String.IsNullOrEmpty(flight.FlightNo))
db.AddInParameter(dbCmd, "@FLIGHT_NO", DbType.String, flight.FlightNo);
else
db.AddInParameter(dbCmd, "@FLIGHT_NO", DbType.String, DBNull.Value);
db.AddInParameter(dbCmd, "@IS_STOP", DbType.Boolean, flight.IsStop);
if (!String.IsNullOrEmpty(flight.Via))
db.AddInParameter(dbCmd, "@VIA", DbType.String, flight.Via);
else
db.AddInParameter(dbCmd, "@VIA", DbType.String, DBNull.Value);
// if (flight.Currancy != 0)
db.AddInParameter(dbCmd, "@CURRENCY_ID", DbType.Int32, flight.Currancy);
// else
// db.AddInParameter(dbCmd, "@CURRENCY_ID", DbType.Int32, DBNull.Value);
// if (flight.TotalFare != 0)
db.AddInParameter(dbCmd, "@TOTAL_FARE", DbType.Int32, flight.TotalFare);
// else
// db.AddInParameter(dbCmd, "@TOTAL_FARE", DbType.Int32, DBNull.Value);
// if (flight.Tax != 0)
db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, flight.Tax);
//else
// db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, DBNull.Value);
// if (flight.GST != 0)
db.AddInParameter(dbCmd, "@GST", DbType.Decimal, flight.GST);
//else
// db.AddInParameter(dbCmd, "@GST", DbType.Decimal, DBNull.Value);
db.AddInParameter(dbCmd, "@DISPLAY_ON_WEB", DbType.Boolean, flight.IsDisplayonweb);
if (flight.UserId != 0)
db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, flight.UserId);
else
db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, DBNull.Value);
db.AddOutParameter(dbCmd, "@FLIGHT_ID", DbType.Int32, 9);
Result = db.ExecuteNonQuery(dbCmd);
flightId = Convert.ToInt32(db.GetParameterValue(dbCmd, "@FLIGHT_ID"));
}
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 UpdateFlightCurrencyPriceDetails(FlightBDto flightGds)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_FLIGHT_CURRENCY_PRICE_UPDATE);
db.AddInParameter(dbCmd, "@CURRENCY_PRICE_ID", DbType.Int32, flightGds.CurrancyPriceId);
db.AddInParameter(dbCmd, "@FLIGHT_ID", DbType.Int32, flightGds.FlightId);
db.AddInParameter(dbCmd, "@FLIGHT_CURRENCY", DbType.Int32, flightGds.Currancy);
// if (flightGds.Adult_Amt != 0)
db.AddInParameter(dbCmd, "@AUDULT_AMT", DbType.Decimal, flightGds.Adult_Amt);
// else
// db.AddInParameter(dbCmd, "@AUDULT_AMT", DbType.Decimal, DBNull.Value);
// if (flightGds.Adult_Tax != 0)
db.AddInParameter(dbCmd, "@AUDULT_TAX", DbType.Decimal, flightGds.Adult_Tax);
// else
// db.AddInParameter(dbCmd, "@AUDULT_TAX", DbType.Decimal, DBNull.Value);
// if (flightGds.Adult_Gst != 0)
db.AddInParameter(dbCmd, "@AUDULT_GST", DbType.Decimal, flightGds.Adult_Gst);
// else
// db.AddInParameter(dbCmd, "@AUDULT_GST", DbType.Decimal, DBNull.Value);
//if (flightGds.Child_Amt != 0)
db.AddInParameter(dbCmd, "@CHILD_AMT", DbType.Decimal, flightGds.Child_Amt);
// else
// db.AddInParameter(dbCmd, "@CHILD_AMT", DbType.Decimal, DBNull.Value);
// if (flightGds.Child_Tax != 0)
db.AddInParameter(dbCmd, "@CHILD_TAX", DbType.Decimal, flightGds.Child_Tax);
//else
// db.AddInParameter(dbCmd, "@CHILD_TAX", DbType.Decimal, DBNull.Value);
// if (flightGds.Child_Gst != 0)
db.AddInParameter(dbCmd, "@CHILD_GST", DbType.Decimal, flightGds.Child_Gst);
// else
// db.AddInParameter(dbCmd, "@CHILD_GST", DbType.Decimal, DBNull.Value);
// if (flightGds.Infant_Amt != 0)
db.AddInParameter(dbCmd, "@INFANT_AMT", DbType.Decimal, flightGds.Infant_Amt);
// else
// db.AddInParameter(dbCmd, "@INFANT_AMT", DbType.Decimal, DBNull.Value);
// if (flightGds.Infant_Tax != 0)
db.AddInParameter(dbCmd, "@INFANT_TAX", DbType.Decimal, flightGds.Infant_Tax);
// else
// db.AddInParameter(dbCmd, "@INFANT_TAX", DbType.Decimal, DBNull.Value);
// if (flightGds.Infant_Gst != 0)
db.AddInParameter(dbCmd, "@INFANT_GST", DbType.Decimal, flightGds.Infant_Gst);
// else
// db.AddInParameter(dbCmd, "@INFANT_GST", DbType.Decimal, DBNull.Value);
db.AddOutParameter(dbCmd, "@ISEXIST", DbType.Int32, 1);
int r = db.ExecuteNonQuery(dbCmd);
Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@ISEXIST"));
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;
}