Example #1
0
        private void SendUpdate(SubscriptionService service, int subscriptionID, DateTime expiryDateTime, Statuses status, int reference, CSubscriptionEngineCapsule.RequestResults result, bool initialBilling)
        {
            Statuses actualStatus         = status;
            DateTime actualExpiryDateTime = expiryDateTime;

            if (actualStatus == Statuses.DoesNotExist)
            {
                actualStatus = GetSubscriptionStatus(subscriptionID);
            }

            if (actualExpiryDateTime == DateTime.MinValue)
            {
                actualExpiryDateTime = GetSubscriptionExpiryDateTime(subscriptionID);
            }

            CXMLCapsule capsule = CSubscriptionEngineCapsule.CreateSubscriptionUpdateCapsule(service.ID, subscriptionID, actualExpiryDateTime, (int)actualStatus, reference, result, initialBilling);

            service.ResponseQueue.Send(capsule);
            capsule = null;
        }
Example #2
0
        public static Hashtable GetActiveServices()
        {
            Hashtable hashtable = new Hashtable();

            CDB           DB     = new CDB("GetActiveServices");
            SqlDataReader reader = (SqlDataReader)DB.Execute("SUB_GetActiveSubscriptionServices", CDB.exmReturnTypes.RETURN_READER);

            while (reader.Read())
            {
                SubscriptionService service = new SubscriptionService(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), (BillingFrequencies)reader.GetInt32(3), (BillingTimes)reader.GetInt32(4), reader.GetDecimal(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetString(8), (Statuses)reader.GetInt32(9));
                hashtable.Add(service.ID, service);
            }

            reader.Close();
            reader = null;

            DB.Close();
            DB = null;

            return(hashtable);
        }
Example #3
0
        private DateTime CalculateAndUpdateSubscriptionDateTimes(int subscriptionID, SubscriptionService service)
        {
            DateTime expiryDateTime      = DateTime.MinValue;
            DateTime lastBillingDateTime = DateTime.MinValue;
            DateTime nextBillingDateTime = DateTime.MinValue;

            CDB           DB     = new CDB("Get Subscription Date - ");
            SqlDataReader reader = (SqlDataReader)DB.Execute("SUB_GetSubscriptionDateTimes " + subscriptionID.ToString(), CDB.exmReturnTypes.RETURN_READER);

            if (reader.Read())
            {
                expiryDateTime      = reader.IsDBNull(0) ? DateTime.MinValue : reader.GetDateTime(0);
                lastBillingDateTime = reader.IsDBNull(1) ? DateTime.MinValue : reader.GetDateTime(1);
                nextBillingDateTime = reader.IsDBNull(2) ? DateTime.MinValue : reader.GetDateTime(2);
            }

            reader.Close();
            reader = null;

            DB.Close();
            DB = null;

            if (expiryDateTime < DateTime.Now)
            {
                expiryDateTime = DateTime.Now;
            }

            switch (service.BillingFrequency)
            {
            case BillingFrequencies.Daily:
                expiryDateTime = expiryDateTime.AddDays(1D);
                break;

            case BillingFrequencies.Weekly:
                expiryDateTime = expiryDateTime.AddDays(7D);
                break;

            case BillingFrequencies.Monthly:
                expiryDateTime = expiryDateTime.AddMonths(1);
                break;
            }

            nextBillingDateTime = expiryDateTime;

            switch (service.BillingFrequency)
            {
            case BillingFrequencies.Weekly:
            case BillingFrequencies.Monthly:
                nextBillingDateTime = expiryDateTime.AddHours(-48D);
                break;

            default:
                nextBillingDateTime = expiryDateTime;
                break;
            }

            //	This has been added to set all future billings @ 1AM
            nextBillingDateTime = new DateTime(nextBillingDateTime.Year, nextBillingDateTime.Month, nextBillingDateTime.Day, 00, 01, 01);

            UpdateSubscriptionDateTimes(subscriptionID, expiryDateTime, nextBillingDateTime, trackId);

            return(expiryDateTime);
        }
Example #4
0
 public SubscriptionHandler(int subscriptionServiceID)
 {
     this.service = new SubscriptionService(subscriptionServiceID);
 }