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