private static Subscription Fetch(int? id, string customField)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn,
"FetchSubscription", id, customField);
if (reader.Read())
{
Subscription subscription = new Subscription();
subscription.id = (int) reader["ID"];
subscription.username = (string) reader["Username"];
subscription.planID = (int) reader["PlanID"];
subscription.orderDate = (DateTime) reader["OrderDate"];
subscription.renewDate = (DateTime) reader["RenewDate"];
subscription.confirmed = (bool) reader["Confirmed"];
subscription.cancelled = (bool) reader["Cancelled"];
subscription.cancellationRequested = (bool) reader["CancellationRequested"];
subscription.paymentProcessor = (string)reader["PaymentProcessor"];
subscription.custom = reader["Custom"] as string;
return subscription;
}
else return null;
}
}
public static List<Subscription> FetchActiveElapsedSubscriptions(DateTime fromDate, DateTime toDate)
{
var subscriptions = new List<Subscription>();
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn,
"FetchActiveElapsedSubscriptions",
fromDate, toDate);
while (reader.Read())
{
Subscription subscription = new Subscription();
subscription.id = (int) reader["ID"];
subscription.username = (string) reader["Username"];
subscription.planID = (int) reader["PlanID"];
subscription.orderDate = (DateTime) reader["OrderDate"];
subscription.renewDate = (DateTime) reader["RenewDate"];
subscription.confirmed = (bool) reader["Confirmed"];
subscription.cancelled = false;
subscription.cancellationRequested = (bool) reader["CancellationRequested"];
subscription.paymentProcessor = (string)reader["PaymentProcessor"];
subscription.custom = reader["Custom"] as string;
subscriptions.Add(subscription);
}
return subscriptions;
}
}
