public SubscriptionService(int id) { CDB DB = new CDB("GetActiveServices"); SqlDataReader reader = (SqlDataReader)DB.Execute("SUB_GetActiveSubscriptionService " + id, CDB.exmReturnTypes.RETURN_READER); if (reader.Read()) { var 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)); _ID = service.ID; _Description = service.Description; _GroupID = service.GroupID; _BillingFrequency = service.BillingFrequency; _BillingTime = service.BillingTime; _BillingAmount = service.BillingAmount; _BillingDayOfMonth = service.BillingDayOfMonth; _PaymentSystemClientID = service.PaymentSystemClientID; _ResponseQueue = new CQueueWrapper(service.ResponseQueue.QueueName); _Status = service.Status; } reader.Close(); reader = null; DB.Close(); DB = null; }
public SubscriptionService(int id, string description, int groupID, BillingFrequencies billingFrequency, BillingTimes billingTime, decimal billingAmount, int billingDatOfMonth, int paymentSystemClientID, string responseQueue, Statuses status) { _ID = id; _Description = description; _GroupID = groupID; _BillingFrequency = billingFrequency; _BillingTime = billingTime; _BillingAmount = billingAmount; _BillingDayOfMonth = billingDatOfMonth; _PaymentSystemClientID = paymentSystemClientID; _ResponseQueue = new CQueueWrapper(responseQueue); _Status = status; }