private static void AddTfcEverywhereEntitlement(IPTV2Entities context, int GomsProductId, string expiryDate, int serviceId, User user, int GomsTransactionId = 0)
{
DateTime registDt = DateTime.Now;
var product = context.Products.FirstOrDefault(p => p.GomsProductId == GomsProductId && p.GomsProductQuantity == 1);
if (product != null)
{
ProductPrice productPrice;
try
{
productPrice = product.ProductPrices.FirstOrDefault(i => i.CurrencyCode == user.Country.CurrencyCode);
}
catch (Exception)
{
productPrice = product.ProductPrices.FirstOrDefault(i => i.CurrencyCode == GlobalConfig.DefaultCurrency);
}
//Create Purchase
Purchase purchase = ContextHelper.CreatePurchase(registDt, "TFC Everywhere");
//Create Purchase Item
PurchaseItem purchaseItem = ContextHelper.CreatePurchaseItem(user.UserId, product, productPrice);
var productPackage = context.ProductPackages.FirstOrDefault(p => p.ProductId == product.ProductId);
//Create Entitlement & EntitlementRequest
Entitlement entitlement = user.PackageEntitlements.FirstOrDefault(i => i.PackageId == productPackage.PackageId);
user.Purchases.Add(purchase);
user.PurchaseItems.Add(purchaseItem);
if (entitlement != null)
{
entitlement.EndDate = Convert.ToDateTime(expiryDate);
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
StartDate = registDt,
EndDate = entitlement.EndDate,
Product = productPackage.Product,
Source = "TFC Everywhere",
ReferenceId = GomsTransactionId.ToString()
};
user.EntitlementRequests.Add(request);
entitlement.LatestEntitlementRequest = request;
purchaseItem.EntitlementRequest = request;
}
else
{
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
StartDate = registDt,
EndDate = Convert.ToDateTime(expiryDate),
Product = productPackage.Product,
Source = "TFC Everywhere",
ReferenceId = GomsTransactionId.ToString()
};
PackageEntitlement pkg_entitlement = new PackageEntitlement()
{
EndDate = Convert.ToDateTime(expiryDate),
Package = (IPTV2_Model.Package)productPackage.Package,
OfferingId = GlobalConfig.offeringId,
LatestEntitlementRequest = request
};
user.PackageEntitlements.Add(pkg_entitlement);
user.EntitlementRequests.Add(request);
purchaseItem.EntitlementRequest = request;
}
}
}
private static PackageEntitlement CreatePackageEntitlement(EntitlementRequest request, PackageSubscriptionProduct subscription, ProductPackage package, DateTime registDt)
{
var currentDt = registDt;
if (subscription.BreakingDate != null)
registDt = (DateTime)subscription.BreakingDate > currentDt ? (DateTime)subscription.BreakingDate : currentDt;
PackageEntitlement entitlement = new PackageEntitlement()
{
EndDate = MyUtility.getEntitlementEndDate(subscription.Duration, subscription.DurationType, registDt),
Package = (Package)package.Package,
OfferingId = GlobalConfig.offeringId,
LatestEntitlementRequest = request
};
return entitlement;
}
private static PackageEntitlement CreatePackageEntitlement(EntitlementRequest request, PackageSubscriptionProduct subscription, ProductPackage package, DateTime registDt)
{
PackageEntitlement entitlement = new PackageEntitlement()
{
EndDate = GetEntitlementEndDate(subscription.Duration, subscription.DurationType, registDt),
Package = (Package)package.Package,
OfferingId = offeringId,
LatestEntitlementRequest = request
};
return entitlement;
}
private static bool Upgrade(IPTV2Entities context, System.Guid userId, Product product, System.Guid recipientUserId, int? cpId)
{
if (userId == recipientUserId)
{
if (product is PackageSubscriptionProduct)
{
PackageSubscriptionProduct subscription = (PackageSubscriptionProduct)product;
DateTime registDt = DateTime.Now;
User user = context.Users.FirstOrDefault(u => u.UserId == new Guid(HttpContext.Current.User.Identity.Name));
string CurrencyCode = MyUtility.GetCurrencyOrDefault(user.Country != null ? user.Country.Code : GlobalConfig.DefaultCountry);
var offering = context.Offerings.FirstOrDefault(o => o.OfferingId == GlobalConfig.offeringId);
var currentSubscription = user.GetSubscribedProducts(offering).FirstOrDefault(s => s.ProductId == cpId);
if (currentSubscription == null)
return false;
//Check if its upgrade to the product being bought
if (currentSubscription.ProductGroup.UpgradeableToProductGroups().Contains(subscription.ProductGroup))
{
//if true, deactivate the package based on product
//Get all product Id inside the current subscription
var list = currentSubscription.ProductGroup.SubscriptionProducts.Select(e => e.ProductId);
//Get the Packagea
var productPackage = context.ProductPackages.FirstOrDefault(p => list.Contains(p.ProductId));
//Get Package Entitlement based on the Package Id
var packageEntitlement = user.PackageEntitlements.Where(e => e.PackageId == productPackage.PackageId);
foreach (var entitlement in packageEntitlement)
{
//Compute for remaining days.
var remainingDaysToBeAdded = GetEquivalentPremiumDuration(context, CurrencyCode, entitlement);
//Deactivate the package
DateTime originalExpirationDate = entitlement.EndDate;
entitlement.EndDate = registDt;
//DateTime newExpirationDate = MyUtility.getEntitlementEndDate((int)remainingDaysToBeAdded, "d", registDt);
DateTime newExpirationDate = MyUtility.getEntitlementEndDate((int)remainingDaysToBeAdded, "d", GetPackageEndDateIfAvailable(user, subscription, registDt));
//Create an UpgradeTransaction
UpgradeTransaction transaction = CreateUpgradeTransaction(originalExpirationDate, currentSubscription.ProductId, newExpirationDate, product.ProductId, CurrencyCode, registDt);
user.Transactions.Add(transaction);
//Add the new package
foreach (var package in subscription.Packages)
{
PackageEntitlement currentPackage = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == package.PackageId);
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
EndDate = newExpirationDate,
Product = product,
Source = "SUBSCRIPTION UPGRADE",
ReferenceId = "SUBSCRIPTION UPGRADE"
};
if (currentPackage != null)
{
currentPackage.LatestEntitlementRequest = request;
currentPackage.EndDate = newExpirationDate;
request.EndDate = newExpirationDate;
}
else
{
PackageEntitlement pkgEntitlement = new PackageEntitlement()
{
EndDate = newExpirationDate,
Package = (Package)package.Package,
OfferingId = GlobalConfig.offeringId,
LatestEntitlementRequest = request
};
request.EndDate = pkgEntitlement.EndDate;
user.PackageEntitlements.Add(pkgEntitlement);
}
user.EntitlementRequests.Add(request);
}
}
}
if (context.SaveChanges() > 0)
return true;
}
return false;
}
return false;
}
private static decimal GetEquivalentPremiumDuration(IPTV2Entities context, string CurrenyCode, PackageEntitlement entitlement)
{
DateTime registDt = DateTime.Now;
if (entitlement != null)
{
//Get remaining hours of current LITE subscription (LD)
var remainingTs = entitlement.EndDate.Subtract(registDt);
var remainingDuration = remainingTs.Hours;
remainingDuration = remainingTs.Days;
//Get price of 1 month LITE subscription (1ML)
var Lite1Month = context.ProductPackages.FirstOrDefault(p => p.PackageId == GlobalConfig.LitePackageId && p.Product.OfferingId == GlobalConfig.offeringId && p.Product.Duration == 1 && p.Product.DurationType == "m");
if (Lite1Month == null)
return 0;
var LiteProductPrice = Lite1Month.Product.ProductPrices.FirstOrDefault(p => p.CurrencyCode == CurrenyCode);
if (LiteProductPrice == null)
return 0;
//Lite Daily Rate (LDR)
var LiteDailyRate = LiteProductPrice.Amount / 30;
//Balance in Currency (BIC) = LDR * LD
var BalanceInCurrency = LiteDailyRate * remainingDuration;
//Get price of 1 month PREMIUM (1MP)
var Premium1Month = context.ProductPackages.FirstOrDefault(p => p.PackageId == GlobalConfig.PremiumPackageId && p.Product.OfferingId == GlobalConfig.offeringId && p.Product.Duration == 1 && p.Product.DurationType == "m");
if (Premium1Month == null)
return 0;
var PremiumProductPrice = Premium1Month.Product.ProductPrices.FirstOrDefault(p => p.CurrencyCode == CurrenyCode);
if (PremiumProductPrice == null)
return 0;
//Premium Daily Rate (PDR)
var PremiumDailyRate = PremiumProductPrice.Amount / 30;
//Equivalent Premium Duration
return BalanceInCurrency / PremiumDailyRate;
}
return 0;
}
private static PackageEntitlement CreatePackageEntitlement(EntitlementRequest request, PackageSubscriptionProduct subscription, ProductPackage package, DateTime endDate, int offeringId)
{
PackageEntitlement entitlement = new PackageEntitlement()
{
EndDate = endDate,
Package = (IPTV2_Model.Package)package.Package,
OfferingId = offeringId,
LatestEntitlementRequest = request
};
return entitlement;
}
public TFCtvResponse CreateTFCtvEverywhereEntitlement(ReqCreateTFCtvEverywhereEntitlement req)
{
TFCtvResponse resp = null;
DateTime registDt = DateTime.Now;
string ip = ConfigurationManager.AppSettings["IpWhiteList"];
string[] IpAddresses = ip.Split(';');
bool isWhitelisted = IpAddresses.Contains(HttpContext.Current.Request.UserHostAddress);
if (!isWhitelisted)
{
resp = new TFCtvResponse() { Code = -3001, Message = "Ip address is unauthorized." }; return resp;
}
if (!HttpContext.Current.Request.IsLocal)
{
//Check SoapHeader
if (Credentials.Username.ToLower() != SoapHeaderUsername || Credentials.Password != SoapHeaderPassword)
{ resp = new TFCtvResponse() { Code = -3002, Message = "Call is unauthorized." }; return resp; }
}
if (req == null)
resp = new TFCtvResponse() { Code = -3003, Message = "Request parameter is empty." };
else
{
if (req.GomsCustomerId == null || req.GomsTransactionDate == null || req.GomsTransactionId == null || req.GomsProductId == null || req.GomsProductQuantity == null || req.GomsTFCEverywhereEndDate == null || req.GomsTFCEverywhereStartDate == null || req.EmailAddress == null)
{
resp = new TFCtvResponse() { Code = -3004, Message = "Missing required fields." };
return resp;
}
if (req.GomsProductId != null)
if (req.GomsProductId <= 0)
{
resp = new TFCtvResponse() { Code = -1000, Message = "GomsProductId is not applicable." };
return resp;
}
var context = new IPTV2Entities();
if (isProduction)
context.Database.Connection.ConnectionString = IPTV2EntitiesAzureConnectionString;
var product = context.Products.FirstOrDefault(p => p.GomsProductId == req.GomsProductId && p.GomsProductQuantity == req.GomsProductQuantity);
if (product == null)
{
resp = new TFCtvResponse() { Code = -1007, Message = "Product does not exist." };
return resp;
}
var user = context.Users.FirstOrDefault(u => u.GomsCustomerId == req.GomsCustomerId && String.Compare(u.EMail, req.EmailAddress, true) == 0);
if (user == null)
{
resp = new TFCtvResponse() { Code = -1001, Message = "User does not exist." };
return resp;
}
//if (String.Compare(user.EMail, req.EmailAddress, true) != 0)
//{
// resp = new TFCtvResponse() { Code = -1001, Message = "User does not exist." };
// return resp;
//}
if (user.Country == null)
{
resp = new TFCtvResponse() { Code = -1002, Message = "User country is not valid." };
return resp;
}
//else // Do we need to check for Japan/US only?
//{
// var countries = TVECountryWhitelist.Split(',');
// if (!countries.Contains(user.Country.Code))
// {
// resp = new TFCtvResponse() { Code = -1002, Message = "User country is not valid." };
// return resp;
// }
//}
if (user.IsTVEverywhere == null)
{
resp = new TFCtvResponse() { Code = -1003, Message = "User is not applicable for TVEverywhere." };
return resp;
}
else
{
if (user.IsTVEverywhere == false)
{
resp = new TFCtvResponse() { Code = -1003, Message = "User is not applicable for TVEverywhere." };
return resp;
}
}
var match = System.Text.RegularExpressions.Regex.Match(req.Reference, "Update|Deactivate|Activate|Change Plan", System.Text.RegularExpressions.RegexOptions.IgnoreCase);
if (!match.Success)
{
if (user.Transactions.Count(t => t.GomsTransactionId == req.GomsTransactionId) > 0)
{
resp = new TFCtvResponse() { Code = -1006, Message = "Transaction already exists in TFC.tv." };
return resp;
}
}
if (user != null)
{
//user.LastUpdated = registDt;
user.LastUpdated = (DateTime)req.GomsTransactionDate;
if (user.IsTVEverywhere != null) // Check if set to true
if (user.IsTVEverywhere == false)
user.IsTVEverywhere = true;
ProductPrice productPrice;
try
{
productPrice = product.ProductPrices.FirstOrDefault(i => i.CurrencyCode == user.Country.CurrencyCode);
}
catch (Exception)
{
productPrice = product.ProductPrices.FirstOrDefault(i => i.CurrencyCode == DefaultCurrencyCode);
}
//Create Purchase
Purchase purchase = CreatePurchase((DateTime)req.GomsTransactionDate, "TFC Everywhere");
//Create Purchase Item
PurchaseItem purchaseItem = CreatePurchaseItem(user.UserId, product, productPrice);
var productPackage = context.ProductPackages.FirstOrDefault(p => p.ProductId == product.ProductId);
//Create Entitlement & EntitlementRequest
Entitlement entitlement = user.PackageEntitlements.FirstOrDefault(i => i.PackageId == productPackage.PackageId);
//DateTime endDate = registDt;
DateTime endDate = (DateTime)req.GomsTFCEverywhereEndDate;
if (entitlement != null)
{
//if (entitlement.EndDate > registDt)
// entitlement.EndDate = entitlement.EndDate.Add(difference);
//else
// entitlement.EndDate = registDt.Add(difference);
entitlement.EndDate = (DateTime)req.GomsTFCEverywhereEndDate;
EntitlementRequest request = new EntitlementRequest()
{
//DateRequested = registDt,
DateRequested = (DateTime)req.GomsTransactionDate,
StartDate = (DateTime)req.GomsTFCEverywhereStartDate,
EndDate = entitlement.EndDate,
Product = productPackage.Product,
Source = "TFC Everywhere",
ReferenceId = req.Reference
};
endDate = entitlement.EndDate;
user.EntitlementRequests.Add(request);
entitlement.LatestEntitlementRequest = request;
}
else
{
EntitlementRequest request = new EntitlementRequest()
{
//DateRequested = registDt,
DateRequested = (DateTime)req.GomsTransactionDate,
StartDate = (DateTime)req.GomsTFCEverywhereStartDate,
EndDate = (DateTime)req.GomsTFCEverywhereEndDate,
Product = productPackage.Product,
Source = "TFC Everywhere",
ReferenceId = req.Reference
};
PackageEntitlement pkg_entitlement = new PackageEntitlement()
{
EndDate = (DateTime)req.GomsTFCEverywhereEndDate,
Package = (IPTV2_Model.Package)productPackage.Package,
OfferingId = offeringId,
LatestEntitlementRequest = request
};
//endDate = item.LicenseEndDate;
user.PackageEntitlements.Add(pkg_entitlement);
}
//Create TFCtvEverywhereTransaction
TfcEverywhereTransaction transaction = new TfcEverywhereTransaction()
{
GomsTFCEverywhereEndDate = (DateTime)req.GomsTFCEverywhereEndDate,
GomsTFCEverywhereStartDate = (DateTime)req.GomsTFCEverywhereStartDate,
GomsTFCEverywhereSubscriptionId = "N/A",
GomsTFCEverywhereServiceId = "N/A",
GomsTransactionDate = req.GomsTransactionDate,
GomsTransactionId = req.GomsTransactionId,
Amount = productPrice.Amount,
Currency = productPrice.CurrencyCode,
//Date = registDt,
Date = (DateTime)req.GomsTransactionDate,
Reference = req.Reference,
OfferingId = offeringId,
StatusId = 1
};
user.Transactions.Add(transaction);
}
try
{
if (context.SaveChanges() > 0)
resp = new TFCtvResponse() { Code = 0, Message = String.Format("Successfully created entitlement ending {0} to GomsCustomerId {1}.", req.GomsTFCEverywhereEndDate, req.GomsCustomerId) };
else
resp = new TFCtvResponse() { Code = -1005, Message = "Unable to create TFC.tv Everywhere entitlement." };
}
catch (Exception e)
{
resp = new TFCtvResponse() { Code = -3000, Message = e.InnerException.Message };
}
}
return resp;
}
private static void RunThis()
{
DateTime registDt = DateTime.Now;
var absnow_context = new ABSNowEntities();
var context = new IPTV2Entities();
var processed_licenses = absnow_context.LicensePurchasedProcesseds.ToList();
Console.WriteLine(String.Format("Processed Licenses: {0}", processed_licenses.Count()));
//var platinum_users = absnow_context.CustomerLicensePurchased1.Where(i => i.PackageID == TFCnowPlatinumProductId && i.LicenseEndDate > registDt) // && i.EmailAddress == "*****@*****.**")
// .OrderByDescending(i => i.LicenseEndDate)
// .AsEnumerable()
// .GroupBy(i => i.EmailAddress)
// .Select(i => new
// {
// EmailAddress = i.Key,
// PackageID = i.Max(ii => ii.PackageID),
// CustomerID = i.Max(ii => ii.CustomerID),
// LicenseEndDate = i.Max(ii => ii.LicenseEndDate)
// }).ToList();
var processedLicenses = processed_licenses.Select(i => i.LicensePurchasedID).ToArray();
absnow_context.CommandTimeout = 120;
var platinum_users = absnow_context.vwCustomerLicensePurchaseds.Where(i => !processedLicenses.Contains(i.LicensePurchasedID)).ToList();
Console.WriteLine(String.Format("Platinum Users: {0}", platinum_users.Count()));
var productPlatinum = context.Products.FirstOrDefault(i => i.ProductId == PlatinumProductId);
var PremiumPackage = context.ProductPackages.FirstOrDefault(i => i.PackageId == PremiumPackageId);
ProductPrice productPrice;
if (platinum_users != null)
{
int counter = 1;
foreach (var item in platinum_users)
{
Console.WriteLine(String.Format("{1}. PROCESSING {0}", item.EmailAddress, counter));
//var purchaseId = absnow_context.CustomerLicensePurchased1.Where(i => i.EmailAddress.ToLower() == item.EmailAddress.ToLower() && i.PackageID == TFCnowPlatinumProductId).OrderByDescending(i => i.LicenseEndDate).First();
Console.WriteLine(String.Format("LicensePurchase ID: {0}", item.LicensePurchasedID));
counter++;
//if (!processed_licenses.Select(i => i.LicensePurchasedID).Contains(purchaseId.LicensePurchasedID))
//{
var difference = item.LicenseEndDate.Subtract(registDt);
var user = context.Users.FirstOrDefault(i => i.TfcNowUserName.ToLower() == item.EmailAddress.ToLower());
if (user != null)
{
Console.WriteLine(String.Format("TAGGED TFCnow {0} TO TFCtv {1}", item.EmailAddress, user.EMail));
try
{
productPrice = productPlatinum.ProductPrices.FirstOrDefault(i => i.CurrencyCode == user.Country.CurrencyCode);
}
catch (Exception)
{
productPrice = productPlatinum.ProductPrices.FirstOrDefault(i => i.CurrencyCode == DefaultCurrencyCode);
}
user.LastUpdated = registDt;
//Create Purchase
Purchase purchase = CreatePurchase(registDt, "TFC.tv Everywhere");
//Create Purchase Item
PurchaseItem purchaseItem = CreatePurchaseItem(user.UserId, productPlatinum, productPrice);
//Create Entitlement & EntitlementRequest
Entitlement entitlement = user.PackageEntitlements.FirstOrDefault(i => i.PackageId == PremiumPackageId);
DateTime endDate = registDt;
if (entitlement != null)
{
if (entitlement.EndDate > registDt)
entitlement.EndDate = entitlement.EndDate.Add(difference);
else
entitlement.EndDate = registDt.Add(difference);
//entitlement.EndDate = item.LicenseEndDate;
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
EndDate = entitlement.EndDate,
Product = PremiumPackage.Product,
Source = "TFC.tv Everywhere",
ReferenceId = String.Format("{0}", item.LicensePurchasedID)
//ReferenceId = String.Format("{0}", String.Empty)
};
endDate = entitlement.EndDate;
user.EntitlementRequests.Add(request);
}
else
{
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
EndDate = item.LicenseEndDate,
Product = PremiumPackage.Product,
Source = "TFC.tv Everywhere",
ReferenceId = String.Format("{0}", item.LicensePurchasedID)
//ReferenceId = String.Format("{0}", String.Empty)
};
PackageEntitlement pkg_entitlement = new PackageEntitlement()
{
EndDate = item.LicenseEndDate,
Package = (IPTV2_Model.Package)PremiumPackage.Package,
OfferingId = OfferingId,
LatestEntitlementRequest = request
};
//endDate = item.LicenseEndDate;
user.PackageEntitlements.Add(pkg_entitlement);
}
//Create TFCtvEverywhereTransaction
TfcEverywhereTransaction transaction = new TfcEverywhereTransaction()
{
GomsTFCEverywhereEndDate = endDate,
GomsTFCEverywhereStartDate = registDt,
GomsTFCEverywhereSubscriptionId = "N/A",
GomsTFCEverywhereServiceId = "N/A",
Amount = productPrice.Amount,
Currency = productPrice.CurrencyCode,
Date = registDt,
Reference = String.Format("TVE-{0}", item.TransactionID),
OfferingId = OfferingId,
StatusId = 1
};
user.Transactions.Add(transaction);
//Console.WriteLine(String.Format("TFCtv {0} LICENSE END DATE UPDATED", user.EMail));
if (context.SaveChanges() > 0)
{
Console.WriteLine(String.Format("TFCtv {0} LICENSE END DATE UPDATED", user.EMail));
LicensePurchasedProcessed receipt = new LicensePurchasedProcessed();
receipt.LicensePurchasedID = item.LicensePurchasedID;
receipt.CreateDate = registDt;
absnow_context.LicensePurchasedProcesseds.AddObject(receipt);
absnow_context.SaveChanges();
}
}
else
Console.WriteLine(String.Format("{0} NOT FOUND. SKIPPING.", item.EmailAddress));
//}
}
//absnow_context.SaveChanges();
}
}
public ActionResult _Subscription(FormCollection f)
{
Dictionary<string, object> collection = new Dictionary<string, object>();
collection = MyUtility.SetError(ErrorCode.UnidentifiedError, String.Empty);
var email = f["EmailAddress"];
var pId = f["Product"];
var payment_mode = f["PaymentMode"];
var reference = f["Reference"];
var amt = f["Amount"];
var currency = f["Currency"];
var edt = f["EndDate"];
var OverrideDuration = MyUtility.GetCheckBoxValue(Request, "OverrideDuration");
var isRefund = MyUtility.GetCheckBoxValue(Request, "IsRefund");
var IncludeWalletLoad = MyUtility.GetCheckBoxValue(Request, "IncludeWalletLoad");
var registDt = DateTime.Now;
try
{
int Duration = 0;
string DurationType = String.Empty;
DateTime endDt = registDt;
if (String.IsNullOrEmpty(email) || String.IsNullOrEmpty(pId) || String.IsNullOrEmpty(payment_mode) || String.IsNullOrEmpty(reference) || String.IsNullOrEmpty(amt) || String.IsNullOrEmpty(currency))
throw new TFCtvMissingRequiredFields();
if (isRefund && OverrideDuration)
throw new TFCtvUnidentifiedError("Is this a refund & Override product's duration can't be checked at the same time.");
currency = currency.ToUpper();
reference = reference.ToUpper();
var context = new IPTV2Entities();
var user = context.Users.FirstOrDefault(item => item.EMail.ToLower() == email.ToLower());
if (user == null)
throw new TFCtvUserDoesNotExist();
decimal amount;
bool amt_result = decimal.TryParse(amt, out amount);
if (!amt_result)
throw new TFCtvUnidentifiedError("Unable to convert Amount to decimal. User input was invalid.");
int productId;
bool pId_result = Int32.TryParse(pId, out productId);
if (!pId_result)
throw new TFCtvUnidentifiedError("Unable to convert ProductId to Int32. User input was invalid.");
if (OverrideDuration)
{
DateTime overridingEndDate;
bool overrideDuration_result = DateTime.TryParse(edt, out overridingEndDate);
if (!overrideDuration_result)
throw new TFCtvUnidentifiedError("Unable to convert End Date to DateTime. User input was invalid.");
}
var currency_count = context.Currencies.Count(item => item.Code.ToUpper() == currency);
if (currency_count == 0)
throw new TFCtvUnidentifiedError("Currency does not exist on our list. User input was invalid.");
if (currency != Global.TrialCurrency)
if (user.Country.CurrencyCode.ToUpper() != currency)
throw new TFCtvUnidentifiedError("Currency does not match current user's currency.");
var offering = context.Offerings.Find(Global.OfferingId);
if (user.HasPendingGomsChangeCountryTransaction(offering))
throw new TFCtvUnidentifiedError("Change in location transaction found. Please retry later.");
var product = context.Products.FirstOrDefault(item => item.ProductId == productId);
if (product == null)
throw new TFCtvProductDoesNotExist();
if (product is SubscriptionProduct)
{
bool insertTransaction = false;
if (product is PackageSubscriptionProduct)
{
var package_subscription = (PackageSubscriptionProduct)product;
Duration = package_subscription.Duration;
DurationType = package_subscription.DurationType;
if (isRefund) //Refunding a subscription
Duration *= -1;
//Get Package
var package = package_subscription.Packages.FirstOrDefault();
if (package == null)
throw new TFCtvObjectIsNull("Package");
PackageEntitlement entitlement = null;
//Check entitlement for package
var package_entitlement = user.PackageEntitlements.FirstOrDefault(item => item.PackageId == package.PackageId);
if (isRefund) //Refunding a subscription
registDt = package_entitlement.EndDate;
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, registDt);
if (package_entitlement != null)
{
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, package_entitlement.EndDate > registDt ? package_entitlement.EndDate : registDt);
package_entitlement.EndDate = endDt;
}
else
{
entitlement = new PackageEntitlement()
{
EndDate = endDt,
Package = (Package)package.Package,
OfferingId = Global.OfferingId,
};
user.PackageEntitlements.Add(entitlement);
}
EntitlementRequest request = CreateEntitlementRequest(registDt, endDt, package.Product, "cPanel Settlement", reference);
if (request != null)
{
if (entitlement != null)
entitlement.LatestEntitlementRequest = request;
else
user.EntitlementRequests.Add(request);
insertTransaction = true;
}
}
else if (product is ShowSubscriptionProduct)
{
var show_subscription = (ShowSubscriptionProduct)product;
Duration = show_subscription.Duration;
DurationType = show_subscription.DurationType;
if (isRefund) //Refuding a subscription
Duration *= -1;
//Get Show
var category = show_subscription.Categories.FirstOrDefault();
if (category == null)
throw new TFCtvObjectIsNull("Category");
ShowEntitlement entitlement = null;
//Check entitlement for Category/Show
var show_entitlement = user.ShowEntitlements.FirstOrDefault(item => item.CategoryId == category.CategoryId);
if (isRefund) //Refunding a subscription
registDt = show_entitlement.EndDate;
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, registDt);
if (show_entitlement != null)
{
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, show_entitlement.EndDate > registDt ? show_entitlement.EndDate : registDt);
show_entitlement.EndDate = endDt;
}
else
{
entitlement = new ShowEntitlement()
{
EndDate = endDt,
Show = category.Show,
OfferingId = Global.OfferingId,
};
user.ShowEntitlements.Add(entitlement);
}
EntitlementRequest request = CreateEntitlementRequest(registDt, endDt, category.Product, "cPanel Settlement", reference);
if (request != null)
{
if (entitlement != null)
entitlement.LatestEntitlementRequest = request;
else
user.EntitlementRequests.Add(request);
insertTransaction = true;
}
}
else if (product is EpisodeSubscriptionProduct)
{
var episode_subscription = (EpisodeSubscriptionProduct)product;
Duration = episode_subscription.Duration;
DurationType = episode_subscription.DurationType;
if (isRefund) //Refuding a subscription
Duration *= -1;
//Get Episode
var episode = episode_subscription.Episodes.FirstOrDefault();
if (episode == null)
throw new TFCtvObjectIsNull("Episode");
EpisodeEntitlement entitlement = null;
//Check entitlement for Category/Show
var episode_entitlement = user.EpisodeEntitlements.FirstOrDefault(item => item.EpisodeId == episode.EpisodeId);
if (isRefund) //Refunding a subscription
registDt = episode_entitlement.EndDate;
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, registDt);
if (episode_entitlement != null)
{
endDt = MyUtility.GetEntitlementEndDate(Duration, DurationType, episode_entitlement.EndDate > registDt ? episode_entitlement.EndDate : registDt);
episode_entitlement.EndDate = endDt;
}
else
{
entitlement = new EpisodeEntitlement()
{
EndDate = endDt,
Episode = episode.Episode,
OfferingId = Global.OfferingId,
};
user.EpisodeEntitlements.Add(entitlement);
}
EntitlementRequest request = CreateEntitlementRequest(registDt, endDt, episode.Product, "cPanel Settlement", reference);
if (request != null)
{
if (entitlement != null)
entitlement.LatestEntitlementRequest = request;
else
user.EntitlementRequests.Add(request);
insertTransaction = true;
}
}
//Create Purchase & Purchase Items
Purchase purchase = null; //CreatePurchase(registDt, "Settlement");
PurchaseItem purchase_item = null; //CreatePurchaseItem(user.UserId, product, amount, currency);
//user.Purchases.Add(purchase);
//user.PurchaseItems.Add(purchase_item);
//Insert transaction
if (insertTransaction)
{
switch (Convert.ToInt32(payment_mode))
{
case 1: // Prepaid Card
purchase = CreatePurchase(registDt, "Settlement via Prepaid Card");
user.Purchases.Add(purchase);
purchase_item = CreatePurchaseItem(user.UserId, product, amount, currency);
purchase.PurchaseItems.Add(purchase_item);
Ppc Ppc = context.Ppcs.FirstOrDefault(item => item.SerialNumber.ToUpper() == reference);
if (Ppc == null)
throw new TFCtvObjectIsNull("Prepaid Card");
if (!(Ppc is SubscriptionPpc))
throw new TFCtvEntityFrameworkError("Prepaid Card is not of type: Subscription.");
PpcPaymentTransaction pTransaction = new PpcPaymentTransaction()
{
Currency = currency,
Reference = reference,
Amount = Convert.ToDecimal(amount),
Product = product,
Purchase = purchase,
SubscriptionPpc = (SubscriptionPpc)Ppc,
Date = registDt,
OfferingId = Global.OfferingId
};
user.Transactions.Add(pTransaction);
break;
case 2: // E-Wallet
purchase = CreatePurchase(registDt, "Settlement via Wallet");
user.Purchases.Add(purchase);
purchase_item = CreatePurchaseItem(user.UserId, product, amount, currency);
purchase.PurchaseItems.Add(purchase_item);
var wallet = user.UserWallets.FirstOrDefault(item => item.IsActive == true);
if (IncludeWalletLoad)
wallet.Balance += amount;
WalletPaymentTransaction wTransaction = new WalletPaymentTransaction()
{
Currency = currency,
Reference = reference,
Amount = Convert.ToDecimal(amount),
Date = registDt,
User = user,
OfferingId = Global.OfferingId
};
user.Transactions.Add(wTransaction);
wallet.WalletPaymentTransactions.Add(wTransaction);
break;
case 3: // Credit Card
purchase = CreatePurchase(registDt, "Settlement via Credit Card");
user.Purchases.Add(purchase);
purchase_item = CreatePurchaseItem(user.UserId, product, Convert.ToDecimal(amount), currency);
purchase.PurchaseItems.Add(purchase_item);
CreditCardPaymentTransaction cTransaction = new CreditCardPaymentTransaction()
{
Amount = Convert.ToDecimal(amount),
Currency = currency,
Reference = reference,
Date = registDt,
Purchase = purchase,
OfferingId = Global.OfferingId
};
user.Transactions.Add(cTransaction);
break;
case 4: // Paypal
purchase = CreatePurchase(registDt, "Settlement via Paypal");
user.Purchases.Add(purchase);
purchase_item = CreatePurchaseItem(user.UserId, product, Convert.ToDecimal(amount), currency);
purchase.PurchaseItems.Add(purchase_item);
PaypalPaymentTransaction ppTransaction = new PaypalPaymentTransaction()
{
Currency = currency,
Reference = reference,
Amount = Convert.ToDecimal(amount),
User = user,
Date = registDt,
OfferingId = Global.OfferingId
};
user.Transactions.Add(ppTransaction);
break;
case 5: // Migration
MigrationTransaction mTransaction = new MigrationTransaction()
{
};
user.Transactions.Add(mTransaction);
break;
default: break;
}
if (context.SaveChanges() > 0)
{
collection = MyUtility.SetError(ErrorCode.Success, "You have successfully settled a complaint.");
// Success
}
}
}
}
catch (TFCtvException e)
{
collection = MyUtility.SetError(e.StatusCode, e.StatusMessage);
}
catch (Exception e)
{
collection = MyUtility.SetError(ErrorCode.UnidentifiedError, e.Message);
}
return Content(MyUtility.BuildJSON(collection), "application/json");
}
public ActionResult Migrate()
{
if (GlobalConfig.IsTVERegistrationEnabled)
return RedirectToAction("Index", "Home");
Dictionary<string, object> collection = new Dictionary<string, object>();
ErrorCodes errorCode = ErrorCodes.UnknownError;
string errorMessage = MyUtility.getErrorMessage(ErrorCodes.UnknownError);
DateTime registDt = DateTime.Now;
collection = MyUtility.setError(errorCode, errorMessage);
if (TempData["TFCnowCustomer"] == null)
return RedirectToAction("Index", "Home");
if (!MyUtility.isUserLoggedIn())
return RedirectToAction("Index", "Home");
Customer customer = (Customer)TempData["TFCnowCustomer"];
var absnow_context = new ABSNowEntities();
string TFCnowPackageIds = GlobalConfig.TFCnowPackageIds;
var packageids = MyUtility.StringToIntList(TFCnowPackageIds);
var context = new IPTV2Entities();
var userId = new Guid(User.Identity.Name);
User user = context.Users.FirstOrDefault(u => u.UserId == userId);
if (user == null)
return RedirectToAction("Index", "Migration");
//Tag account
user.TfcNowUserName = customer.EmailAddress;
user.LastUpdated = registDt;
context.SaveChanges();
bool isLicenseMigrated = false;
bool isWalletMigrated = false;
//Migrate Wallet
var balance = absnow_context.NCashWalletBalanceTables.FirstOrDefault(u => u.userId.ToLower() == customer.EmailAddress.ToLower());
if (balance != null)
{
if (balance.cashBalance > 0)
{
var transfer_amount = Forex.Convert(context, GlobalConfig.DefaultCurrency, user.Country.CurrencyCode, balance.cashBalance);
var userWallet = user.UserWallets.FirstOrDefault(u => u.Currency == user.Country.CurrencyCode && u.IsActive == true);
if (userWallet == null)
{
userWallet = new UserWallet()
{
Balance = transfer_amount,
IsActive = true,
Currency = user.Country.CurrencyCode,
};
user.UserWallets.Add(userWallet);
}
else
userWallet.Balance += transfer_amount;
//Create Paypal transaction
var ppTransaction = new PaypalReloadTransaction()
{
Amount = transfer_amount,
Currency = user.Country.CurrencyCode,
Date = registDt,
Reference = String.Format("M-{0}", customer.CustomerID),
OfferingId = GlobalConfig.offeringId,
UserWallet = userWallet,
StatusId = GlobalConfig.Visible
};
user.Transactions.Add(ppTransaction);
if (context.SaveChanges() > 0)
isWalletMigrated = true;
}
}
var licenses = absnow_context.LicensePurchaseds.Where(l => l.CustomerID == customer.CustomerID && packageids.Contains(l.PackageID) && l.LicenseEndDate > registDt).OrderByDescending(l => l.LicenseEndDate);
//Migrate Licenses
if (licenses.Count() == 0)
{
if (isWalletMigrated)
{
user.TfcNowUserName = customer.EmailAddress;
context.SaveChanges();
}
// return RedirectToAction("Complete", "Migration");
//collection = MyUtility.setError(ErrorCodes.UnknownError, "No licenses to migrate.");
}
else
{
bool isPremiumProcessed = false;
bool isLiteProcessed = false;
bool isMovieChannelProcessed = false;
bool isLiveStreamProcessed = false;
var TFCnowPremium = MyUtility.StringToIntList(GlobalConfig.TFCnowPremium);
var TFCnowLite = MyUtility.StringToIntList(GlobalConfig.TFCnowLite);
var TFCnowMovieChannel = MyUtility.StringToIntList(GlobalConfig.TFCnowMovieChannel);
var TFCnowLiveStream = MyUtility.StringToIntList(GlobalConfig.TFCnowLiveStream);
List<LicenseDisplay> display = new List<LicenseDisplay>();
var premiumLicense = GetLicense(absnow_context, TFCnowPremium, licenses, 1427);
display.Add(premiumLicense);
display.Add(GetLicense(absnow_context, TFCnowLite, licenses, 1425));
display.Add(GetLicense(absnow_context, TFCnowMovieChannel, licenses, 45));
if (premiumLicense == null)
display.Add(GetLicense(absnow_context, TFCnowLiveStream, licenses, 1427));
display.RemoveAll(item => item == null);
foreach (var item in display)
{
int TFCtvPackageId = 0;
int TFCtvProductId = 0;
if (item.LicenseEndDate > registDt)
{
var difference = item.LicenseEndDate.Subtract(registDt);
PackageEntitlement entitlement = null;
if (TFCnowPremium.Contains(item.PackageId))
{
if (!isPremiumProcessed)
{
entitlement = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == GlobalConfig.premiumId);
isPremiumProcessed = true;
TFCtvPackageId = GlobalConfig.premiumId;
}
}
else if (TFCnowLite.Contains(item.PackageId))
{
if (!isLiteProcessed)
{
if (user.CountryCode == GlobalConfig.DefaultCountry)
{
entitlement = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == GlobalConfig.premiumId);
TFCtvPackageId = GlobalConfig.premiumId;
}
else
{
entitlement = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == GlobalConfig.liteId);
TFCtvPackageId = GlobalConfig.liteId;
}
isLiteProcessed = true;
}
}
else if (TFCnowMovieChannel.Contains(item.PackageId))
{
if (!isMovieChannelProcessed)
{
entitlement = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == GlobalConfig.movieId);
isMovieChannelProcessed = true;
TFCtvPackageId = GlobalConfig.movieId;
}
}
else if (TFCnowLiveStream.Contains(item.PackageId))
{
if (!isLiveStreamProcessed)
{
if (!isPremiumProcessed)
{
entitlement = user.PackageEntitlements.FirstOrDefault(p => p.PackageId == GlobalConfig.premiumId);
isLiveStreamProcessed = true;
TFCtvPackageId = GlobalConfig.premiumId;
}
}
}
else
{
//Provide load
}
if (TFCtvPackageId > 0)
{
ProductPackage package = context.ProductPackages.FirstOrDefault(p => p.PackageId == TFCtvPackageId);
TFCtvProductId = package.Product.ProductId;
if (entitlement != null)
{
if (entitlement.EndDate > registDt)
entitlement.EndDate = entitlement.EndDate.Add(difference);
else
entitlement.EndDate = registDt.Add(difference);
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
StartDate = item.LicenseStartDate,
EndDate = entitlement.EndDate,
Product = package.Product,
Source = "Entitlement Transfer",
ReferenceId = item.LicensePurchaseId.ToString()
};
entitlement.LatestEntitlementRequest = request; // ADDED DECEMBER 06, 2012
user.EntitlementRequests.Add(request);
}
else
{
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
StartDate = item.LicenseStartDate,
EndDate = item.LicenseEndDate,
Product = package.Product,
Source = "Entitlement Transfer",
ReferenceId = item.LicensePurchaseId.ToString()
};
user.EntitlementRequests.Add(request);
PackageEntitlement pkg_entitlement = new PackageEntitlement()
{
EndDate = item.LicenseEndDate,
Package = (IPTV2_Model.Package)package.Package,
OfferingId = GlobalConfig.offeringId,
LatestEntitlementRequest = request
};
user.PackageEntitlements.Add(pkg_entitlement);
}
}
}
if (TFCtvProductId > 0)
{
MigrationTransaction transaction = new MigrationTransaction()
{
Amount = 0,
Currency = GlobalConfig.DefaultCurrency,
Date = registDt,
OfferingId = GlobalConfig.offeringId,
Reference = item.LicensePurchaseId.ToString(),
MigratedProductId = TFCtvProductId,
StatusId = GlobalConfig.Visible
};
user.Transactions.Add(transaction);
}
}
if (context.SaveChanges() > 0)
isLicenseMigrated = true;
}
bool isTingiMigrated = false;
var tingi = absnow_context.TFCNowRetailMigrationIDs.Select(i => new { i.TFCnowPackageID, i.GOMSInternalID });
var tingi_licenses = absnow_context.LicensePurchaseds.Where(l => l.CustomerID == customer.CustomerID && tingi.Select(i => i.TFCnowPackageID).Contains(l.PackageID) && l.LicenseEndDate > registDt).OrderByDescending(l => l.LicenseEndDate);
if (tingi_licenses.Count() == 0)
{
if (isLicenseMigrated || isWalletMigrated)
{
user.TfcNowUserName = customer.EmailAddress;
context.SaveChanges();
}
return RedirectToAction("Complete", "Migration");
}
else
{
foreach (var item in tingi_licenses)
{
var diff = item.LicenseEndDate.Subtract(registDt);
var GomsProductId = tingi.FirstOrDefault(t => t.TFCnowPackageID == item.PackageID);
var TFCtvProduct = context.Products.FirstOrDefault(p => p.GomsProductId == GomsProductId.GOMSInternalID);
if (TFCtvProduct != null)
{
if (TFCtvProduct is ShowSubscriptionProduct)
{
var showSubscription = (ShowSubscriptionProduct)TFCtvProduct;
ShowEntitlement se = user.ShowEntitlements.FirstOrDefault(s => s.Show.CategoryId == showSubscription.Categories.First().CategoryId);
if (se != null)
{
if (se.EndDate > registDt)
se.EndDate = showSubscription.ALaCarteSubscriptionTypeId == 2 ? se.EndDate.AddYears(1) : se.EndDate.Add(diff);
else
se.EndDate = showSubscription.ALaCarteSubscriptionTypeId == 2 ? registDt.AddYears(1) : registDt.Add(diff);
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
EndDate = se.EndDate,
Product = TFCtvProduct,
Source = "Entitlement Transfer",
ReferenceId = item.LicensePurchasedID.ToString()
};
user.EntitlementRequests.Add(request);
}
else
{
EntitlementRequest request = new EntitlementRequest()
{
DateRequested = registDt,
EndDate = showSubscription.ALaCarteSubscriptionTypeId == 2 ? registDt.AddYears(1) : registDt.Add(diff),
Product = TFCtvProduct,
Source = "Entitlement Transfer",
ReferenceId = item.LicensePurchasedID.ToString()
};
user.EntitlementRequests.Add(request);
ShowEntitlement show_entitlement = new ShowEntitlement()
{
EndDate = showSubscription.ALaCarteSubscriptionTypeId == 2 ? registDt.AddYears(1) : registDt.Add(diff),
Show = showSubscription.Categories.First().Show,
OfferingId = GlobalConfig.offeringId,
LatestEntitlementRequest = request
};
user.ShowEntitlements.Add(show_entitlement);
}
MigrationTransaction transaction = new MigrationTransaction()
{
Amount = 0,
Currency = GlobalConfig.DefaultCurrency,
Date = registDt,
OfferingId = GlobalConfig.offeringId,
Reference = item.LicensePurchasedID.ToString(),
MigratedProductId = TFCtvProduct.ProductId,
StatusId = GlobalConfig.Visible
};
user.Transactions.Add(transaction);
}
}
}
if (context.SaveChanges() > 0)
isTingiMigrated = true;
}
if (isLicenseMigrated || isWalletMigrated || isTingiMigrated)
{
user.TfcNowUserName = customer.EmailAddress;
user.LastUpdated = registDt;
}
else
{
user.TfcNowUserName = customer.EmailAddress;
user.LastUpdated = registDt;
}
if (context.SaveChanges() > 0)
{
return RedirectToAction("Complete", "Migration");
}
return Content(MyUtility.buildJson(collection), "application/json");
}