public static async Task <bool> IsWidgetOutofCallAsync(Widget wgt, MyDBContext context)
{
int calls = 0;
CallMeAPI.Models.Subscription subscription = context.Subscriptions.Find(wgt.subscriptionId);
int maxCalls = Subscription.GetPlanMaxCalls(subscription.PlanID);
List <Widget> widgets = await context.Widgets.Where(widget => widget.subscriptionId == wgt.subscriptionId).ToListAsync();
foreach (Widget widget in widgets)
{
calls += widget.CallsCountMonth;
}
return(calls >= maxCalls);
}
public async Task IndexAsync()
{
try
{
var json = new StreamReader(HttpContext.Request.Body).ReadToEnd();
StripeEventLog log = new StripeEventLog();
log.Event = json.ToString();
log.EventDateTime = DateTime.Now;
context.StripeEventLogs.Add(log);
await context.SaveChangesAsync();
var obj = JObject.Parse(json);
string type = (string)obj.SelectToken("type");
bool livemode = (bool)obj.SelectToken("livemode");
if (livemode != Program.StripeLiveMode)
{
return;
}
if (type == "customer.subscription.created")
{
string subscriptionID = (string)obj.SelectToken("data.object.id");
DateTime billing_cycle_anchor = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.billing_cycle_anchor")).DateTime;
bool cancel_at_period_end = (bool)obj.SelectToken("data.object.cancel_at_period_end");
string canceled_at = (string)obj.SelectToken("data.object.canceled_at");
DateTime created = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.created")).DateTime;
DateTime current_period_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_end")).DateTime;
DateTime current_period_start = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_start")).DateTime;
string customer = (string)obj.SelectToken("data.object.customer");
string planID = (string)obj.SelectToken("data.object.items.data[0].plan.id");
string status = (string)obj.SelectToken("data.object.status");
DateTime?trial_end = null;
try
{
trial_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.trial_end")).DateTime;
}
catch (Exception) { }
var newSubscription = new CallMeAPI.Models.Subscription();
newSubscription.ID = subscriptionID;
newSubscription.BillingCycleAnchor = billing_cycle_anchor;
newSubscription.Created = created;
newSubscription.CurrentPeriodStart = current_period_start;
newSubscription.CurrentPeriodEnd = current_period_end;
var user = context.Users.FirstOrDefault(u => u.CustomerID == customer);
newSubscription.CustomerEmail = user.UserID;
newSubscription.PlanID = planID;
newSubscription.Status = status;
newSubscription.TrialingUntil = trial_end;
context.Subscriptions.Add(newSubscription);
await context.SaveChangesAsync();
}
else if (type == "customer.subscription.updated")
{
string subscriptionID = (string)obj.SelectToken("data.object.id");
DateTime billing_cycle_anchor = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.billing_cycle_anchor")).DateTime;
bool cancel_at_period_end = (bool)obj.SelectToken("data.object.cancel_at_period_end");
string canceled_at = (string)obj.SelectToken("data.object.canceled_at");
DateTime?canceled_at_date = null;
if (!string.IsNullOrEmpty(canceled_at) && !canceled_at.Contains("null"))
{
canceled_at_date = DateTimeOffset.FromUnixTimeSeconds(long.Parse(canceled_at)).DateTime;
}
DateTime created = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.created")).DateTime;
DateTime current_period_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_end")).DateTime;
DateTime current_period_start = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_start")).DateTime;
string customer = (string)obj.SelectToken("data.object.customer");
string planID = (string)obj.SelectToken("data.object.items.data[0].plan.id");
string status = (string)obj.SelectToken("data.object.status");
DateTime?trial_end = null;
try
{
trial_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.trial_end")).DateTime;
}catch (Exception) {}
var subscription = context.Subscriptions.Find(subscriptionID);
subscription.CanceledAtDate = canceled_at_date;
subscription.Status = status;
subscription.PlanID = planID;
subscription.BillingCycleAnchor = billing_cycle_anchor;
subscription.CurrentPeriodEnd = current_period_end;
subscription.CurrentPeriodStart = current_period_start;
subscription.CancelAtPeriodEnd = cancel_at_period_end;
subscription.TrialingUntil = trial_end;
await context.SaveChangesAsync();
}
else if (type == "customer.subscription.deleted")
{
string subscriptionID = (string)obj.SelectToken("data.object.id");
DateTime billing_cycle_anchor = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.billing_cycle_anchor")).DateTime;
string canceled_at = (string)obj.SelectToken("data.object.canceled_at");
bool cancel_at_period_end = (bool)obj.SelectToken("data.object.cancel_at_period_end");
DateTime?canceled_at_date = null;
if (!string.IsNullOrEmpty(canceled_at) && !canceled_at.Contains("null"))
{
canceled_at_date = DateTimeOffset.FromUnixTimeSeconds(long.Parse(canceled_at)).DateTime;
}
DateTime created = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.created")).DateTime;
DateTime current_period_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_end")).DateTime;
DateTime current_period_start = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.current_period_start")).DateTime;
string customer = (string)obj.SelectToken("data.object.customer");
string planID = (string)obj.SelectToken("data.object.items.data[0].plan.id");
string status = (string)obj.SelectToken("data.object.status");
var subscription = context.Subscriptions.Find(subscriptionID);
subscription.CanceledAtDate = canceled_at_date;
subscription.Status = status;
subscription.PlanID = planID;
subscription.BillingCycleAnchor = billing_cycle_anchor;
subscription.CurrentPeriodEnd = current_period_end;
subscription.CurrentPeriodStart = current_period_start;
subscription.CancelAtPeriodEnd = cancel_at_period_end;
await context.SaveChangesAsync();
}
else if (type == "invoice.payment_succeeded")
{
string invoiceID = (string)obj.SelectToken("data.object.id");
decimal amount_paid = ((decimal)obj.SelectToken("data.object.amount_paid")) / 100;
string customer = (string)obj.SelectToken("data.object.customer");
DateTime finalized_at = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.finalized_at")).DateTime;
string invoice_pdf = (string)obj.SelectToken("data.object.invoice_pdf");
string description = (string)obj.SelectToken("data.object.lines.data[0].description");
DateTime period_start = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.lines.data[0].period.start")).DateTime;
DateTime period_end = DateTimeOffset.FromUnixTimeSeconds((long)obj.SelectToken("data.object.lines.data[0].period.end")).DateTime;
string plan_nickname = (string)obj.SelectToken("data.object.lines.data[0].plan.nickname");
string subscriptionID = (string)obj.SelectToken("data.object.lines.data[0].subscription");
if (amount_paid > 0)
{
Models.Invoice invoice = new Models.Invoice();
invoice.InvoiceID = invoiceID;
invoice.AmountPaid = amount_paid;
invoice.CustomerID = customer;
invoice.InvoiceDateTime = finalized_at;
invoice.InvoicePdf = invoice_pdf;
invoice.Description = description;
invoice.PlanName = plan_nickname;
invoice.SubscriptionID = subscriptionID;
context.Invoices.Add(invoice);
var subscription = context.Subscriptions.Find(subscriptionID);
if (subscription != null)
{
subscription.CurrentPeriodEnd = period_end;
subscription.CurrentPeriodStart = period_start;
}
List <Widget> widgets = await context.Widgets.Where(widget => widget.subscriptionId == subscriptionID).ToListAsync();
foreach (Widget widget in widgets)
{
widget.CallsCountMonth = 0;
}
await context.SaveChangesAsync();
}
}
}
catch (Exception ex)
{
AppException exception = new AppException();
exception.ErrorDateTime = DateTime.Now;
exception.Message = ex.Message;
exception.FullString = ex.ToString();
context.AppExceptions.Add(exception);
await context.SaveChangesAsync();
}
}
public static bool IsWidgetOutofSubscription(Widget wgt, MyDBContext context)
{
CallMeAPI.Models.Subscription subscription = context.Subscriptions.Find(wgt.subscriptionId);
return(subscription.Status.ToLower() == "canceled");
}