예제 #1
0
		private int Update@Dynamic
		(
			IDictionary<object, object> workingObjects,
			RPComponents.IBusinessObjectTransaction bot,
			SqlConnection connection,
			SqlTransaction transaction,
			Hashtable parameters,
			I@ParentDB db
		)
		{
			String query = db.Update@Dynamic;
			db.SetNullParameters();
			db.SetParameters(query);
			int sequence = 0;

			sequence =
			HandleResponse
				(
				workingObjects
				, WorkingTypes.Response
				, bot
				, connection
				, transaction
				, query
				, parameters
				, db
				, "Unknown error while insert/update @Dynamic details."
				);
			return sequence;
		}
예제 #2
0
        /// <summary>
        /// Select Property Default Models method
        /// </summary>
        /// <param name="workingObjects"></param>
        /// <param name="bot"></param>
        /// <param name="connection"></param>
        /// <param name="transaction"></param>
        /// <param name="parameters"></param>
        /// <param name="db"></param>
        private void Selectpayments
        (
            IDictionary <object, object> workingObjects
            , RPComponents.IBusinessObjectTransaction bot
            , SqlConnection connection
            , SqlTransaction transaction
            , Hashtable parameters
            , IundefinedDB db
        )
        {
            db.SetNullParameters();
            db.SetParameters(db.Getpayment);

            using
            (
                SqlDataReader reader = ExecuteSqlDataReader
                                       (
                    db.Getpayment
                    , parameters
                    , connection
                    , transaction
                                       )
            )
            {
                IList <Ipayment> payment = new List <Ipayment>();
                while (reader.Read())
                {
                    Ipayment bob = (Ipayment)db.BuildObject(reader);
                    payment.Add(bob);
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
                workingObjects.Add(WorkingTypes.payment, payment);
                if (bot.Status.IsInitial)
                {
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
            }
        }
예제 #3
0
        /// <summary>
        /// Select Property Default Models method
        /// </summary>
        /// <param name="workingObjects"></param>
        /// <param name="bot"></param>
        /// <param name="connection"></param>
        /// <param name="transaction"></param>
        /// <param name="parameters"></param>
        /// <param name="db"></param>
        private void Select@Dynamics
        (
            IDictionary <object, object> workingObjects
            , RPComponents.IBusinessObjectTransaction bot
            , SqlConnection connection
            , SqlTransaction transaction
            , Hashtable parameters
            , I@ParentDB db
        )
        {
            db.SetNullParameters();
            db.SetParameters(db.Get@Dynamic);

            using
            (
                SqlDataReader reader = ExecuteSqlDataReader
                                       (
                    db.Get@Dynamic
                    , parameters
                    , connection
                    , transaction
                                       )
            )
            {
                IList <I@Dynamic> @Dynamic = new List <I@Dynamic>();
                while (reader.Read())
                {
                    I@Dynamic bob = (I@Dynamic)db.BuildObject(reader);
                    @Dynamic.Add(bob);
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
                workingObjects.Add(WorkingTypes.@Dynamic, @Dynamic);
                if (bot.Status.IsInitial)
                {
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
            }
        }
예제 #4
0
        /// <summary>
        /// Select Property Default Models method
        /// </summary>
        /// <param name="workingObjects"></param>
        /// <param name="bot"></param>
        /// <param name="connection"></param>
        /// <param name="transaction"></param>
        /// <param name="parameters"></param>
        /// <param name="db"></param>
        private void SelectDashBoards
        (
            IDictionary <object, object> workingObjects
            , RPComponents.IBusinessObjectTransaction bot
            , SqlConnection connection
            , SqlTransaction transaction
            , Hashtable parameters
            , IModelBuilderDB db
        )
        {
            db.SetNullParameters();
            db.SetParameters(db.GetDashBoard);

            using
            (
                SqlDataReader reader = ExecuteSqlDataReader
                                       (
                    db.GetDashBoard
                    , parameters
                    , connection
                    , transaction
                                       )
            )
            {
                IList <IDashBoard> DashBoard = new List <IDashBoard>();
                while (reader.Read())
                {
                    IDashBoard bob = (IDashBoard)db.BuildObject(reader);
                    DashBoard.Add(bob);
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
                workingObjects.Add(WorkingTypes.DashBoard, DashBoard);
                if (bot.Status.IsInitial)
                {
                    bot.Status = new TransactionStatus(TransactionStatus.Succeeded);
                }
            }
        }