コード例 #1
0
        // Basic

        public async Task <int> AddAsync(PaymentPlanEntity paymentPlanEntity)
        {
            int indicator = -1;

            try
            {
                var dynamicParameters = new DynamicParameters(paymentPlanEntity);
                dynamicParameters.Add("PaymentPlanId", DbType.Int32, direction: ParameterDirection.Output);

                using (var connection = new SqlConnection(_connectionString))
                {
                    indicator = await connection.ExecuteAsync(
                        _paymentCommandText.AddPaymentPlan,
                        dynamicParameters,
                        commandType : CommandType.StoredProcedure
                        );

                    paymentPlanEntity.PaymentPlanId = dynamicParameters.Get <int>("PaymentPlanId");
                }
            }
            catch (Exception exception)
            {
            }

            return(indicator);
        }
コード例 #2
0
        public async Task <PaymentPlanEntity> GetByIdAsync(int paymentPlanId)
        {
            var rs = new PaymentPlanEntity();

            try
            {
                using (var connection = new SqlConnection(_connectionString))
                {
                    rs = await connection.QueryFirstOrDefaultAsync <PaymentPlanEntity>(
                        _paymentCommandText.GetPaymentPlanById,
                        new { PaymentPlanId = paymentPlanId },
                        commandType : CommandType.StoredProcedure
                        );
                }
            }
            catch (Exception exception)
            {
            }

            return(rs);
        }
コード例 #3
0
        public async Task <int> UpdateAsync(PaymentPlanEntity paymentPlanEntity)
        {
            int indicator = -1;

            try
            {
                var dynamicParameters = new DynamicParameters(paymentPlanEntity);

                using (var connection = new SqlConnection(_connectionString))
                {
                    indicator = await connection.ExecuteAsync(
                        _paymentCommandText.UpdatePaymentPlan,
                        dynamicParameters,
                        commandType : CommandType.StoredProcedure
                        );
                }
            }
            catch (Exception exception)
            {
            }

            return(indicator);
        }
コード例 #4
0
 public async Task <int> UpdateAsync(PaymentPlanEntity paymentPlanEntity)
 {
     return(await _paymentPlanRepository.UpdateAsync(paymentPlanEntity));
 }