public bool SaveSubscription(CustomerSubscription subscription)
        {
            using (SqlConnection connection = GetOpenConnection())
            {
                int rowsAffected = connection.Execute("spCustomerSubscriptionSaveSubscription", param: subscription.GetParametersForSave(), commandType: CommandType.StoredProcedure);

                return rowsAffected > 0;
            }
        }
        private void Instantiate(CustomerSubscription subscriptionDl)
        {
            this.HasData = false;

            if (subscriptionDl != null)
            {
                this.HasData = true;
                this.SubscriptionId = subscriptionDl.CustomerSubscriptionId;
                this.CustomerId = subscriptionDl.CustomerId;
                this.ComicBookSeriesId = subscriptionDl.ComicBookSeriesId;

                this.PublisherName = subscriptionDl.PublisherName;
                this.SeriesTitle = subscriptionDl.SeriesTitle;

                this.EffectiveDate = subscriptionDl.EffectiveDate;
                this.ExpiresDate = subscriptionDl.ExpiresDate;

                this.CreateDate = subscriptionDl.CreateDate;
                this.CreateUserId = subscriptionDl.CreateUserId;
                this.ChangeUserId = subscriptionDl.ChangeUserId;
                this.ChangeDate = subscriptionDl.ChangeDate;
                this.DeleteDate = subscriptionDl.DeleteDate;
            }
        }
 public Subscription(CustomerSubscription subscriptionDl)
 {
     Instantiate(subscriptionDl);
 }