Exemplo n.º 1
0
        /// <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;
        }
Exemplo n.º 2
0
        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;
        }