public DonationSubscription GetDonationSubscription(string subscriptionId)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.GetDonationSubscription");
db.AddInputParameter("@SubscriptionId", subscriptionId);
try
{
var subscription = new DonationSubscription();
db.ReadInto(subscription);
return subscription;
}
catch (Exception ex)
{
Log.Error("Error while gettng subscription.", ex);
throw;
}
}
}
public DonationSubscription CreateDonationSubscription(DonationSubscription subscription)
{
using (var db = new DataAccess())
{
db.CreateStoredProcCommand("dbo.CreateDonationSubscription");
db.AddInputParameter("@StartDate", subscription.StartDate);
db.AddInputParameter("@EndDate", subscription.EndDate);
db.AddInputParameter("@RecurrenceTimes", subscription.RecurrenceTimes);
db.AddInputParameter("@SubscriptionId", subscription.SubscriptionId);
db.AddInputParameter("@UserId", subscription.UserId);
db.AddInputParameter("@Username", subscription.Username);
db.AddInputParameter("@Password", subscription.Password);
db.AddInputParameter("@ProviderData", subscription.ProviderXml);
db.AddOutputParameter("@DonationSubscriptionId", DbType.Int32);
try
{
db.ExecuteNonQuery();
subscription.DonationSubscriptionId = db.GetParameterValue<int>("@DonationSubscriptionId");
}
catch (Exception ex)
{
Log.Error("Error while crating subscription.", ex);
throw;
}
}
return subscription;
}