/// <summary>
/// Insert customer detail.
/// </summary>
/// <param name="customer">CustomerBDto object that customer data to insert.</param>
/// <returns>Returns 1 and 0; 1 indicates successfull operation.</returns>
public int UpdateFareCruiseMaster(CruiseBDto CruiseBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_CRUISE_SCHEDULE_MASTER_UPDATE);
db.AddInParameter(dbCmd, "@CRUISE_ID", DbType.Int32, CruiseBDto.CruiseId);
db.AddInParameter(dbCmd, "@CRUISE_NAME", DbType.String, CruiseBDto.CruiseName);
db.AddInParameter(dbCmd, "@DESTINATION_PORT_NAME", DbType.String, CruiseBDto.DestinationPortName);
db.AddInParameter(dbCmd, "@SOURCE_PORT_NAME", DbType.String, CruiseBDto.SourcePortName);
db.AddInParameter(dbCmd, "@SOURCE_CITY_ID", DbType.Int32, CruiseBDto.SourceCity);
db.AddInParameter(dbCmd, "@DESTINATION_CITY_ID", DbType.Int32, CruiseBDto.DestinationCity);
db.AddInParameter(dbCmd, "@DEPT_TIME", DbType.DateTime, CruiseBDto.DepTime);
db.AddInParameter(dbCmd, "@ARRIVAL_TIME", DbType.DateTime, CruiseBDto.ArrivalTime);
db.AddInParameter(dbCmd, "@SCHEDULE_DATE", DbType.DateTime, CruiseBDto.SecheduleDate);
db.AddInParameter(dbCmd, "@DURATION", DbType.Decimal, CruiseBDto.Duration);
Result = db.ExecuteNonQuery(dbCmd);
return Result;
}
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 UpdateBusCurrencyPriceDetails(CruiseBDto flightGds)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_CRUISE_CURRENCY_PRICE_UPDATE);
db.AddInParameter(dbCmd, "@CURRENCY_PRICE_ID", DbType.Int32, flightGds.CurrancyPriceId);
db.AddInParameter(dbCmd, "@CRUISE_ID", DbType.Int32, flightGds.CruiseId);
db.AddInParameter(dbCmd, "@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;
}