VideoRentalService.SakilaEntities.GetRewardsReport C# (CSharp) Method

GetRewardsReport() public method

No Metadata Documentation available.
public GetRewardsReport ( Nullable min_monthly_purchases, Nullable min_dollar_amount_purchased, System.Data.Objects.ObjectParameter count_rewardees ) : ObjectResult
min_monthly_purchases Nullable No Metadata Documentation available.
min_dollar_amount_purchased Nullable No Metadata Documentation available.
count_rewardees System.Data.Objects.ObjectParameter No Metadata Documentation available.
return ObjectResult
        public ObjectResult<customer> GetRewardsReport(Nullable<global::System.SByte> min_monthly_purchases, Nullable<global::System.Decimal> min_dollar_amount_purchased, ObjectParameter count_rewardees)
        {
            ObjectParameter min_monthly_purchasesParameter;
            if (min_monthly_purchases.HasValue)
            {
                min_monthly_purchasesParameter = new ObjectParameter("min_monthly_purchases", min_monthly_purchases);
            }
            else
            {
                min_monthly_purchasesParameter = new ObjectParameter("min_monthly_purchases", typeof(global::System.SByte));
            }
    
            ObjectParameter min_dollar_amount_purchasedParameter;
            if (min_dollar_amount_purchased.HasValue)
            {
                min_dollar_amount_purchasedParameter = new ObjectParameter("min_dollar_amount_purchased", min_dollar_amount_purchased);
            }
            else
            {
                min_dollar_amount_purchasedParameter = new ObjectParameter("min_dollar_amount_purchased", typeof(global::System.Decimal));
            }
    
            return base.ExecuteFunction<customer>("GetRewardsReport", min_monthly_purchasesParameter, min_dollar_amount_purchasedParameter, count_rewardees);
        }
        /// <summary>

Same methods

SakilaEntities::GetRewardsReport ( Nullable min_monthly_purchases, Nullable min_dollar_amount_purchased, System.Data.Objects.ObjectParameter count_rewardees, MergeOption mergeOption ) : ObjectResult

Usage Example

Exemplo n.º 1
0
        public override SCustomer[] GetRewardsReport(
                                            Nullable<global::System.SByte> min_monthly_purchases,
                                            Nullable<global::System.Decimal> min_dollar_amount_purchased,
                                            int count_rewardees)
        {
            List<SCustomer> scustomerList = new List<SCustomer>();
            using (SakilaEntities entitities = new SakilaEntities())
            {
                ObjectParameter cntRewardees = new ObjectParameter("count_rewardees", count_rewardees);
                List<customer> contactList = entitities.GetRewardsReport(min_monthly_purchases.Value, min_dollar_amount_purchased.Value, cntRewardees).ToList<customer>();
                count_rewardees = (int)cntRewardees.Value;

                simulator.PerformanceSimulation();

                for (int i = 0; i < contactList.Count; i++)
                {
                    SCustomer scustomer = new SCustomer();
                    scustomer = scustomer.Createcustomer(
                                                        contactList[i].customer_id,
                                                        contactList[i].store_id,
                                                        contactList[i].first_name,
                                                        contactList[i].last_name,
                                                        contactList[i].address_id,
                                                        contactList[i].active,
                                                        contactList[i].create_date,
                                                        contactList[i].last_update,
                                                        contactList[i].email
                                                        );
                    scustomerList.Add(scustomer);
                }
            }
            return scustomerList.ToArray();
        }