private List<RecurringBillingDisplay> GetRecurringBillingsForUser(User user, IPTV2Entities context)
{
List<RecurringBillingDisplay> list = null;
try
{
var recurringBillings = context.RecurringBillings.Where(r => r.UserId == user.UserId && r.StatusId == GlobalConfig.Visible);
if (recurringBillings != null)
{
list = new List<RecurringBillingDisplay>();
foreach (var item in recurringBillings)
{
RecurringBillingDisplay disp = new RecurringBillingDisplay()
{
EndDate = (DateTime)item.EndDate,
EndDateStr = item.EndDate.Value.ToShortDateString(),
NextRun = (DateTime)item.NextRun,
NextRunStr = item.NextRun.Value.ToShortDateString(),
PackageId = item.PackageId,
PackageName = item.Package.Description,
ProductId = item.ProductId,
ProductName = item.Product.Description,
RecurringBillingId = item.RecurringBillingId,
StatusId = item.StatusId,
UserId = item.UserId,
isDisabled = false,
PaymentType = item is CreditCardRecurringBilling ? "Credit Card" : "Paypal"
};
list.Add(disp);
}
}
}
catch (Exception) { }
return list;
}
private List<RecurringBillingDisplay> ShowRecurringBillings()
{
List<RecurringBillingDisplay> display = new List<RecurringBillingDisplay>();
if (MyUtility.isUserLoggedIn())
{
System.Guid userId = new System.Guid(User.Identity.Name);
var context = new IPTV2Entities();
User user = context.Users.FirstOrDefault(u => u.UserId == userId);
if (user != null)
{
var recurringBillings = context.RecurringBillings.Where(t => t.UserId == user.UserId && t.OfferingId == GlobalConfig.offeringId && t.StatusId == GlobalConfig.Visible).OrderByDescending(t => t.RecurringBillingId);
if (recurringBillings != null)
{
foreach (var item in recurringBillings)
{
RecurringBillingDisplay disp = new RecurringBillingDisplay()
{
EndDate = (DateTime)item.EndDate,
EndDateStr = item.EndDate.Value.ToShortDateString(),
NextRun = (DateTime)item.NextRun,
NextRunStr = item.NextRun.Value.ToShortDateString(),
PackageId = item.PackageId,
PackageName = item.Package.Description,
ProductId = item.ProductId,
ProductName = item.Product.Description,
RecurringBillingId = item.RecurringBillingId,
StatusId = item.StatusId,
UserId = item.UserId,
//isDisabled = ((DateTime)item.NextRun).Date.Subtract(DateTime.Now.Date).Days < 2 ? true : false
isDisabled = false,
PaymentType = item is CreditCardRecurringBilling ? "Credit Card" : "Paypal"
};
display.Add(disp);
}
}
}
}
return display;
}