static string DefaultCurrency = "USD"; // Use for cross conversion public static decimal Convert(IPTV2Entities context, string baseCurrency, string targetCurrency, decimal amount) { decimal newAmount = amount; if (baseCurrency == targetCurrency) return amount; var thisRate = context.Forexes.Find(new string[] { baseCurrency, targetCurrency }); if (thisRate != null) { return (decimal)((double)amount * thisRate.ExchangeRate); } else { thisRate = context.Forexes.Find(new string[] { targetCurrency, baseCurrency }); if (thisRate != null) { return (decimal)((double)amount / thisRate.ExchangeRate); } else { // convert baseCurrency to DefaultCurrency first thisRate = context.Forexes.Find(new string[] { DefaultCurrency, baseCurrency }); if (thisRate == null) throw new Exception("Cannot convert from base currency."); newAmount = (decimal)((double)amount / thisRate.ExchangeRate); // convert DefaultCurrency to targetCurrency thisRate = context.Forexes.Find(new string[] { DefaultCurrency, targetCurrency }); if (thisRate == null) throw new Exception("Cannot convert to target currency."); newAmount = (decimal)((double)newAmount * thisRate.ExchangeRate); } } return (newAmount); }
public static void TestProducts() { var context = new IPTV2Entities(); var lite1M = context.Products.Find(5); var lite3M = context.Products.Find(6); var lite12M = context.Products.Find(7); var is1MUsAllowed = lite1M.IsAllowed("US"); // false var is3MUsAllowed = lite3M.IsAllowed("US"); // false var is12MUsAllowed = lite12M.IsAllowed("US"); //false var is1MJpAllowed = lite1M.IsAllowed("JP"); // true var is3MJpAllowed = lite3M.IsAllowed("JP"); // true var is12MJpAllowed = lite12M.IsAllowed("JP"); //true var prem1M = context.Products.Find(1); var prem3M = context.Products.Find(3); var prem12M = context.Products.Find(4); var prem10D = context.Products.Find(2); var isPrem1M = prem1M.IsAllowed("US"); // true var isPrem3M = prem3M.IsAllowed("US"); // true var isPrem12M = prem12M.IsAllowed("US"); // true var isPrem10D = prem10D.IsAllowed("US"); // true var ae = context.Countries.Find("AE"); var aePricePrem1M = prem1M.GetPrice(ae); var us = context.Countries.Find("US"); var usPriceLite1M = lite1M.GetPrice(us); }
public ActionResult Verify(string id) { if (String.IsNullOrEmpty(id)) return new HttpNotFoundResult(); System.Guid g; if (!System.Guid.TryParse(id, out g)) return new HttpNotFoundResult(); var context = new IPTV2Entities(); var tester = context.BetaTesters.FirstOrDefault(b => b.InvitationKey == new System.Guid(id) && b.DateClaimed == null); if (tester != null) { //tester.DateClaimed = DateTime.Now; //tester.IpAddress = Request.GetUserHostAddressFromCloudflare(); //if (context.SaveChanges() > 0) //{ // HttpCookie cookie = new HttpCookie("testerid"); // cookie.Value = id; // cookie.Expires = DateTime.Now.AddYears(10); // this.ControllerContext.HttpContext.Response.SetCookie(cookie); // //return RedirectToAction("Index", "Home"); // return RedirectToAction("Register", "User"); //} HttpCookie cookie = new HttpCookie("testerid"); cookie.Value = id; cookie.Expires = DateTime.Now.AddYears(10); this.ControllerContext.HttpContext.Response.SetCookie(cookie); return RedirectToAction("Register", "User", new { iid = id }); } else return Content("Key already used.", "text/html"); //return new HttpNotFoundResult(); }
public PartialViewResult GetPlayList(int? id) { var context = new IPTV2Entities(); if (id == null) { id = GlobalConfig.FreeTVPlayListId; } var feature = context.Features.FirstOrDefault(f => f.FeatureId == id && f.StatusId == GlobalConfig.Visible); if (feature == null) return null; List<FeatureItem> featureItems = context.FeatureItems.Where(f => f.FeatureId == id && f.StatusId == GlobalConfig.Visible).ToList(); List<JsonFeatureItem> jfi = new List<JsonFeatureItem>(); foreach (EpisodeFeatureItem f in featureItems) { if (f is EpisodeFeatureItem) { Episode ep = context.Episodes.Find(f.EpisodeId); if (ep != null) { Show show = ep.EpisodeCategories.FirstOrDefault(e => e.CategoryId != GlobalConfig.FreeTvCategoryId).Show; if (show != null) { string img = String.IsNullOrEmpty(ep.ImageAssets.ImageVideo) ? GlobalConfig.AssetsBaseUrl + GlobalConfig.BlankGif : String.Format("{0}{1}/{2}", GlobalConfig.EpisodeImgPath, ep.EpisodeId.ToString(), ep.ImageAssets.ImageVideo); string showImg = String.IsNullOrEmpty(show.ImagePoster) ? GlobalConfig.AssetsBaseUrl + GlobalConfig.BlankGif : String.Format("{0}{1}/{2}", GlobalConfig.ShowImgPath, show.CategoryId.ToString(), show.ImagePoster); JsonFeatureItem j = new JsonFeatureItem() { EpisodeId = ep.EpisodeId, EpisodeDescription = ep.Description, EpisodeName = ep.EpisodeName, EpisodeAirDate = (ep.DateAired != null) ? ep.DateAired.Value.ToString("MMMM d, yyyy") : "", ShowId = show.CategoryId, ShowName = show.CategoryName, EpisodeImageUrl = img, ShowImageUrl = showImg, Blurb = MyUtility.Ellipsis(ep.Synopsis, 80) }; jfi.Add(j); } } } } ViewBag.FeaturedId = id; return PartialView("_GetPlayList", jfi); }
public ActionResult List(int id = 1) { int page = id; var context = new IPTV2Entities(); var episodeIds = context.EpisodeCategories1.Where(e => e.CategoryId == GlobalConfig.KwentoNgPaskoCategoryId && e.Episode.OnlineStatusId == GlobalConfig.Visible).OrderByDescending(e => e.Episode.AuditTrail.CreatedOn) .Skip((page - 1) * pageSize) .Take(pageSize) .Select(e => e.EpisodeId); var totalCount = context.EpisodeCategories1.Count(e => e.CategoryId == GlobalConfig.KwentoNgPaskoCategoryId && e.Episode.OnlineStatusId == GlobalConfig.Visible); ViewBag.CurrentPage = page; ViewBag.PageSize = pageSize; var totalPage = Math.Ceiling((double)totalCount / pageSize); ViewBag.TotalPages = totalPage; ViewBag.TotalCount = totalCount; var maxCount = page * pageSize > totalCount ? totalCount : page * pageSize; ViewBag.OutOf = String.Format("{0} - {1}", (page * pageSize) + 1 - pageSize, maxCount); var episodes = context.Episodes.Where(e => episodeIds.Contains(e.EpisodeId) && e.OnlineStatusId == GlobalConfig.Visible); ViewBag.Previous = page == 1 ? String.Empty : (page - 1) == 1 ? String.Empty : (page - 1).ToString(); ViewBag.Next = page == (int)totalPage ? (int)totalPage : page + 1; if ((page * pageSize) + 1 - pageSize > totalCount) return RedirectToAction("List", "KuwentongPasko", new { id = String.Empty }); if (episodes != null) return View(episodes); return RedirectToAction("Index", "Home"); }
public static void EntitlePackage() { var context = new IPTV2Entities(); var user = context.Users.First(u => u.EMail == "*****@*****.**"); var product = context.Products.Find(5); // user.Entitle((PackageSubscriptionProduct)product); }
public ActionResult Migration(string start, string end) { DateTime StartDate = Convert.ToDateTime(start); DateTime EndDate = Convert.ToDateTime(end); var context = new IPTV2Entities(); foreach (DateTime day in MyUtility.EachDay(StartDate, EndDate)) { DateTime startDt = Convert.ToDateTime(String.Format("{0} {1}", day.ToString("yyyy/MM/dd"), "00:00:00")); DateTime endDt = Convert.ToDateTime(String.Format("{0} {1}", day.ToString("yyyy/MM/dd"), "23:59:59")); var report = context.Users .Join(context.Countries, userdetails => userdetails.CountryCode, country => country.Code, (userdetails, country) => new { userdetails, country }) .Join(context.GomsSubsidiaries, user => user.country.GomsSubsidiaryId, subsidiary => subsidiary.GomsSubsidiaryId, (user, subsidiary) => new { user, subsidiary }) .Where(result => result.user.userdetails.RegistrationDate >= @startDt && result.user.userdetails.RegistrationDate <= @endDt && result.user.userdetails.TfcNowUserName != null) .GroupBy(result => result.subsidiary.Description) .Select(result => new { description = result.Key, count = result.Count() }) .OrderByDescending(result => result.count).ToList(); string filePath = @"C:\bin\global dropbox\Audie\Migration\"; string fileName = startDt.ToString("yyyyMMdd") + ".csv"; using (StreamWriter writer = new StreamWriter(filePath + fileName)) { var csv = new CsvWriter(writer); csv.WriteRecords(report); } } return null; }
public void FillCache(IPTV2Entities context, int offeringId, RightsType rightsType, TimeSpan cacheDuration) { var packageList = context.PackageTypes.Where(p => p.OfferingId == offeringId).ToList(); var countries = context.Countries.ToList(); // fill cache of all packages long totalSize = 0; foreach (var p in packageList) { foreach (var c in countries) { // loop and fill cache for 1 hour // fill show IDs var shows = p.GetAllShowIds(c.Code, rightsType, false); var cacheKey = p.GetCacheKey(c.Code, rightsType); DataCache.Cache.Put(cacheKey, shows, cacheDuration); totalSize += GetObjectSize(shows); // fill channel IDs cacheKey = p.GetChannelsCacheKey(c.Code, rightsType); var channels = p.GetAllChannelIds(c.Code, rightsType, false); DataCache.Cache.Put(cacheKey, channels, cacheDuration); } } }
public static bool CheckUser_Entitlement(Show model) { if (!HttpContext.Current.User.Identity.IsAuthenticated) { return false; } else { using (IPTV2Entities context = new IPTV2Entities()) { Guid userID = new Guid(HttpContext.Current.User.Identity.Name); var user = context.Users.FirstOrDefault(u => u.UserId == userID); var off = context.Offerings.Find(GlobalConfig.offeringId); if (user.IsShowEntitled(off, model, RightsType.Online)) { if (user.Entitlements.Where(t => t.OfferingId == GlobalConfig.offeringId && t.EndDate >= DateTime.Now).Count() > 0) { return true; } } } } return false; }
public override void Run() { // This is a sample worker implementation. Replace with your logic. Trace.WriteLine("$projectname$ entry point called", "Information"); int waitDuration = Convert.ToInt32(RoleEnvironment.GetConfigurationSettingValue("LoopWaitDurationInSeconds")); int fillCacheDurationInMinutes = Convert.ToInt32(RoleEnvironment.GetConfigurationSettingValue("FillCacheDurationInMinutes")); bool fillCache = Convert.ToBoolean(RoleEnvironment.GetConfigurationSettingValue("FillCache")); while (true) { try { Thread.Sleep(TimeSpan.FromSeconds(waitDuration)); int offeringId = 2; var service = new GomsTfcTv(); var context = new IPTV2Entities(); var offering = context.Offerings.Find(offeringId); Trace.WriteLine("Process start."); // Update Forex // service.GetExchangeRates(context, "USD"); // Process Transactions // service.ProcessAllPendingTransactionsInGoms(context, offering); Trace.WriteLine("Process finish."); } catch (Exception ex) { Trace.TraceError("fail in Run", ex); } } }
public ActionResult Index() { var ReturnCode = new TransactionReturnType() { StatusCode = (int)ErrorCodes.NotAuthenticated, StatusMessage = String.Empty, info = "IT&E Validation", TransactionType = "Validation" }; if (User.Identity.IsAuthenticated) { DateTime registDt = DateTime.Now; IPTV2Entities context = new IPTV2Entities(); var promo = context.Promos.FirstOrDefault(p => p.PromoId == GlobalConfig.ITEPromoId && p.StartDate < registDt && registDt < p.EndDate && p.StatusId == GlobalConfig.Visible); if (promo != null) return View(); else { ReturnCode.StatusCode = (int)ErrorCodes.UnauthorizedCountry; } } ReturnCode.StatusMessage = MyUtility.getErrorMessage((ErrorCodes)ReturnCode.StatusCode); if (!String.IsNullOrEmpty(ReturnCode.StatusMessage)) { TempData["ErrorMessage"] = ReturnCode; } return RedirectToAction("Index", "Home"); }
private static void ExtendTFCnowLicenses() { DateTime registDt = DateTime.Now; var absnow_context = new ABSNowEntities(); var context = new IPTV2Entities(); var migrated_users = context.Users.Where(i => !String.IsNullOrEmpty(i.TfcNowUserName)).OrderBy(i => i.EMail); Console.WriteLine(String.Format("Total migrated users: {0}", migrated_users.Count())); int ctr = 1; foreach (var user in migrated_users) { //Get Entitlements Console.WriteLine(String.Format("{1} TFC.tv Email Address: {0}", user.EMail, ctr)); Console.WriteLine(String.Format("TFCnow Email Address: {0}", user.TfcNowUserName)); ctr++; var entitlements = user.PackageEntitlements.Where(i => i.EndDate > registDt); if (entitlements != null) { foreach (var item in entitlements) { Console.WriteLine(String.Format("Package Id: {0}", item.PackageId)); Console.WriteLine(String.Format("Expiration Date: {0}", item.EndDate)); int TFCnowPackageId = GetTFCnowPackageId(item.PackageId); absnow_context.TFCnowExtendLicense(user.TfcNowUserName, TFCnowPackageId, item.EndDate); } } //absnow_context.SaveChanges(); } }
public override IEnumerable<DynamicNode> GetDynamicNodeCollection() { List<DynamicNode> returnValue = null; var cache = DataCache.Cache; string cacheKey = "SMAPCELEB:O:00"; returnValue = (List<DynamicNode>)cache[cacheKey]; // Build value if (returnValue == null) { try { returnValue = new List<DynamicNode>(); var context = new IPTV2_Model.IPTV2Entities(); // Create a node for each celebrity var celebs = context.Celebrities.ToList(); foreach (var celeb in celebs) { DynamicNode node = new DynamicNode(); node.Key = "Celebrity-" + celeb.CelebrityId; node.Title = "Celebrity - " + celeb.FullName; //node.Controller = "Celebrity"; //node.Action = "Profile"; node.RouteValues.Add("id", celeb.CelebrityId); returnValue.Add(node); } var cacheDuration = new TimeSpan(2, 0, 0); cache.Put(cacheKey, returnValue, cacheDuration); } catch (Exception) { returnValue = new List<DynamicNode>(); } } // Return return returnValue; }
public static void ProcessAllGomsPendingTransactions() { var context = new IPTV2Entities(); var service = new GomsTfcTv(); var offering = context.Offerings.Find(2); service.ProcessAllPendingTransactionsInGoms(context, offering); }
public void FillCache(IPTV2Entities context, int offeringId, int serviceId, IEnumerable<int> categoryIds, RightsType rightsType, TimeSpan cacheDuration) { var countries = context.Countries; var offering = context.Offerings.FirstOrDefault(o => o.OfferingId == offeringId); var service = offering.Services.FirstOrDefault(s => s.PackageId == serviceId); // fill cache of all categories foreach (int categoryId in categoryIds) { try { var cat = context.CategoryClasses.FirstOrDefault(c => c.CategoryId == categoryId && c is Category); if (cat != null) { var category = (Category)cat; foreach (var c in countries) { try { // loop and fill cache for 1 hour var shows = service.GetAllShowIds(c.Code, category, rightsType, false); var cacheKey = service.GetCacheKey(c.Code, category, rightsType); DataCache.Cache.Put(cacheKey, shows, cacheDuration); } catch (Exception) { } } } } catch (Exception) { } } }
static public void CreditCardReload() { var context = new IPTV2_Model.IPTV2Entities(); var gomsService = new GomsTfcTv(); var user = context.Users.FirstOrDefault(u => u.EMail == "*****@*****.**"); if (user != null) { // create transaction var transaction = new IPTV2_Model.CreditCardReloadTransaction { Amount = 10, Currency = user.Country.CurrencyCode, Date = DateTime.Now, }; var resp = gomsService.ReloadWalletViaCreditCard(context, user.UserId, transaction, GetCreditCard()); if (resp.IsSuccess) { // YEY } } }
public ActionResult ContenderDetails(int? id) { if (id != null) { var context = new IPTV2Entities(); var celebrity = context.Celebrities.FirstOrDefault(c => c.CelebrityId == id); var socialContext = new EngagementsEntities(); if (celebrity != null) { if (String.IsNullOrEmpty(celebrity.Description)) celebrity.Description = "No description yet."; if (String.IsNullOrEmpty(celebrity.ImageUrl)) celebrity.ImageUrl = String.Format("{0}/{1}", GlobalConfig.AssetsBaseUrl, "content/images/celebrity/unknown.jpg"); else celebrity.ImageUrl = String.Format("{0}{1}/{2}", GlobalConfig.CelebrityImgPath, celebrity.CelebrityId, celebrity.ImageUrl); if (MyUtility.isUserLoggedIn() && ContextHelper.HasSocialEngagement(new System.Guid(User.Identity.Name), GlobalConfig.SOCIAL_LOVE, (int)id, EngagementContentType.Celebrity)) ViewBag.Loved = true; var lovesCountSummary = socialContext.CelebrityReactionSummaries.FirstOrDefault(i => i.CelebrityId == celebrity.CelebrityId && i.ReactionTypeId == GlobalConfig.SOCIAL_LOVE); int love = (int)(lovesCountSummary == null ? 0 : lovesCountSummary.Total); celebrity.Weight = love.ToString(); if (!String.IsNullOrEmpty(celebrity.Birthday)) ViewBag.BirthDate = celebrity.Birthday; if (!String.IsNullOrEmpty(celebrity.Birthplace)) { ViewBag.BirthPlace = celebrity.Birthplace; celebrity.Birthplace = "<p>" + celebrity.FirstName + " VS " + celebrity.Birthplace.Replace(",", "</p><p>" + celebrity.FirstName + " VS ") + "</p>"; celebrity.Birthplace = celebrity.Birthplace.Replace(":", "<br />"); } return View(celebrity); } } return RedirectToAction("Index", "Home"); }
private static void mytest() { using (var context = new IPTV2Entities()) { var offering = context.Offerings.Find(2); var show = (Show)context.CategoryClasses.Find(333); var packageProductIds = show.GetPackageProductIds(offering, "US", RightsType.Online); var showProductIds = show.GetShowProductIds(offering, "US", RightsType.Online); var subscriptionProducts = SubscriptionProductC.LoadAll(context, offering.OfferingId, true) .Where(p => p.IsAllowed("US")); var packageProducts = from products in subscriptionProducts join id in packageProductIds on products.ProductId equals id select products; var showProducts = from products in subscriptionProducts join id in showProductIds on products.ProductId equals id select products; } }
public JsonResult GetStore(string id) { var context = new IPTV2Entities(); var result = context.StoreFronts.Where(s => (s.BusinessName.Contains(id) || s.Address1.Contains(id) || s.City.Contains(id)) && s.StatusId == GlobalConfig.Visible && s.OfferingId == GlobalConfig.offeringId); List<StoreFront> list = new List<StoreFront>(); foreach (var item in result) { list.Add(new StoreFront() { StoreFrontId = item.StoreFrontId, BusinessName = item.BusinessName, ContactPerson = item.ContactPerson, Address1 = item.Address1, Address2 = item.Address2, City = item.City, State = item.State, ZipCode = item.ZipCode, CountryCode = item.CountryCode, BusinessPhone = item.BusinessPhone, EMailAddress = item.EMailAddress, WebSiteUrl = item.WebSiteUrl, MobilePhone = item.MobilePhone, Latitude = item.Latitude, Longitude = item.Longitude }); } return this.Json(list, JsonRequestBehavior.AllowGet); }
public ActionResult Index() { var context = new IPTV2Entities(); var faq = (Category)context.CategoryClasses.FirstOrDefault(c => c.CategoryId == GlobalConfig.FAQ && c.StatusId == GlobalConfig.Visible); var categories = faq.CategoryClassSubCategories.Where(c => c.SubCategory.StatusId == GlobalConfig.Visible).ToList(); //Get Top 5 string Top5 = GlobalConfig.FaqTop5; var Top5Ids = MyUtility.StringToIntList(Top5); var category = context.CategoryClasses.Where(c => Top5Ids.Contains(c.CategoryId) && c.StatusId == GlobalConfig.Visible).ToList(); ViewBag.Top5Q = category; if (!Request.Cookies.AllKeys.Contains("version")) { try { if (User.Identity.IsAuthenticated) { var UserId = new Guid(User.Identity.Name); var user = context.Users.FirstOrDefault(u => u.UserId == UserId); if (user != null) ViewBag.EmailAddress = user.EMail; } } catch (Exception) { } return View("Index2", categories); } return View(categories); }
public ActionResult Process() { if (User.Identity.IsAuthenticated) { var context = new IPTV2Entities(); System.Guid userId = new System.Guid(User.Identity.Name); User user = context.Users.FirstOrDefault(u => u.UserId == userId); if (user != null) { var offering = context.Offerings.Find(GlobalConfig.offeringId); var registDt = DateTime.Now; if (user.HasPendingGomsChangeCountryTransaction(offering)) return PartialView("PaymentTemplates/_BuyPendingChangeCountryErrorPartial"); if (user.HasExceededMaximumReloadTransactionsForTheDay(GlobalConfig.reloadTransactionMaximumThreshold, registDt)) return PartialView("PaymentTemplates/_BuyErrorExceededMaximumThresholdPartial"); } UserWallet wallet = user.UserWallets.FirstOrDefault(w => w.Currency == MyUtility.GetCurrencyOrDefault(user.CountryCode)); string CurrencyCode = MyUtility.GetCurrencyOrDefault(user.CountryCode); Currency currency = context.Currencies.FirstOrDefault(c => c.Code == CurrencyCode); if (currency.IsLeft) ViewBag.currentBalance = String.Format("{0}{1}", currency.Symbol, wallet.Balance.ToString("F")); else ViewBag.currentBalance = String.Format("{0}{1}", wallet.Balance.ToString("F"), currency.Symbol); ViewBag.currentBalance = String.Format("{0} {1}", currency.Code, wallet.Balance.ToString("F")); //ViewBag.CreditCardList = user.Country.GetGomsCreditCardTypes(); //UPDATED 05/07/2013 if (GlobalConfig.IsMECreditCardEnabled) { try { if (user.Country.GomsSubsidiaryId != GlobalConfig.MiddleEastGomsSubsidiaryId) ViewBag.CreditCardList = user.Country.GetGomsCreditCardTypes(); else { var listOfMiddleEastAllowedCountries = GlobalConfig.MECountriesAllowedForCreditCard.Split(','); //get list of middle east countries allowed for credit card payment if (listOfMiddleEastAllowedCountries.Contains(user.Country.Code)) ViewBag.CreditCardList = user.Country.GetGomsCreditCardTypes(); else ViewBag.CreditCardList = null; } } catch (Exception) { ViewBag.CreditCardList = null; } } else ViewBag.CreditCardList = user.Country.GetGomsCreditCardTypes(); ViewBag.IsPayPalSupported = currency.IsPayPalSupported; return PartialView("_ReloadProcessPartial"); } else { //return RedirectToAction("Index", "Home"); return PartialView("PaymentTemplates/_BuyAuthenticationErrorPartial"); } }
public static void PpcTypeTester() { var context = new IPTV2Entities(); var regularPpc = (SubscriptionPpc)context.Ppcs.FirstOrDefault(p => p.PpcProductId == 1002); var trialPpc = (SubscriptionPpc)context.Ppcs.FirstOrDefault(p => p.PpcProductId == 1090); var compensatoryPpc = (SubscriptionPpc)context.Ppcs.FirstOrDefault(p => p.PpcProductId == 1093); var complimentaryPpc = (SubscriptionPpc)context.Ppcs.FirstOrDefault(p => p.PpcProductId == 1094); }
public static void GetEntitlement() { var context = new IPTV2Entities(); var user = context.Users.First(u => u.EMail == "*****@*****.**"); var entitlement1 = Entitlement.GetUserProductEntitlement(context, user.UserId, 1); var entitlement2 = Entitlement.GetUserProductEntitlement(context, user.UserId, 2); }
// // GET: /Ajax/ public int CheckEmail(string email) { if (String.IsNullOrEmpty(email)) return 0; var context = new IPTV2Entities(); var count = context.Users.Count(item => item.EMail.ToLower() == email.ToLower()); return count; }
public static void TestGroup() { var context = new IPTV2Entities(); var productGroup = context.ProductGroups.Find(1); var upgradeableFromPGs = productGroup.UpgradeableFromProductGroups(); var packageIds = productGroup.GetPackageIds(false); var showIds = productGroup.GetShowIds(false); }
private void Send(EmailInformation information) { var context = new IPTV2Entities(); context.Database.Connection.ConnectionString = RoleEnvironment.GetConfigurationSettingValue("Iptv2Entities"); Trace.WriteLine(context.Database.Connection.ConnectionString); try { if (information.isRecurring) { var usersWithRecurring = EmailReminder.GetRecurringUsers(context, information.numberOfDays, offeringId); if (usersWithRecurring != null) { var emailTemplateHTML = information.Template; foreach (var item in usersWithRecurring) { var template = emailTemplateHTML; var textBody = template.Replace("[firstname]", item.User.FirstName); textBody = textBody.Replace("[productname]", item.Product.Description); if (item.Product is SubscriptionProduct) { var sproduct = (SubscriptionProduct)item.Product; textBody = textBody.Replace("[newexpiry]", GetEntitlementEndDate(sproduct.Duration, sproduct.DurationType, item.EndDate.Value).ToString("MMMM dd, yyyy")); } Trace.TraceInformation("Trying to send email to " + item.User.EMail); EmailReminder.SendEmailViaSendGrid(item.User.EMail, fromEmail, information.Subject, String.Empty, TFCtv_EMail_Reminder.MailType.TextOnly, textBody, SendGridUsername, SendGridPassword, SendGridSmtpHost, SendGridSmtpPort); } } } else { var users = EmailReminder.GetUsers(context, information.numberOfDays, offeringId); if (users != null) { var emailTemplateHTML = information.Template; foreach (var user in users) { var template = emailTemplateHTML; var htmlBody = template.Replace("[firstname]", user.FirstName); var dealers = EmailReminder.GetDealerNearUser(context, user, offeringId); htmlBody = htmlBody.Replace("[dealers]", dealers); Trace.TraceInformation("Trying to send email to " + user.EMail); //Trace.WriteLine(htmlBody); EmailReminder.SendEmailViaSendGrid(user.EMail, fromEmail, information.Subject, htmlBody, TFCtv_EMail_Reminder.MailType.HtmlOnly, String.Empty, SendGridUsername, SendGridPassword, SendGridSmtpHost, SendGridSmtpPort); } } } } catch (Exception e) { Trace.TraceInformation("Error: " + e.Message); Trace.TraceInformation("Inner Exception: " + e.InnerException.Message); } }
public ActionResult Subscription() { var context = new IPTV2Entities(); var products = context.Products.Where(item => item.GomsProductId > 0 && item.GomsProductId != null && item.GomsProductQuantity == 1); ViewBag.Currencies = context.Currencies; if (products != null) return View(products); return RedirectToAction("Index"); }
public static void ProcessAllGomsPendingTransactionsForUser() { var context = new IPTV2Entities(); var service = new GomsTfcTv(); var offering = context.Offerings.Find(2); var user = context.Users.FirstOrDefault(u => u.EMail == "*****@*****.**"); service.ProcessAllPendingTransactionsInGoms(context, offering, user); }
public static void ChannelTest() { var context = new IPTV2Entities(); var offering = context.Offerings.Find(2); var channels = context.Channels.Find(1); var packages = channels.GetPackageProductIds(offering, "US", RightsType.Online, false); var packagesCached = channels.GetPackageProductIds(offering, "US", RightsType.Online, true); var onlinePackages = channels.GetPackageProductIds(offering, "US", RightsType.Online, true); }
public static void PpcReload() { var context = new IPTV2Entities(); var service = new GomsTfcTv(); // get transaction // List<PpcReloadTransaction> ts = context.Transactions.Where(t => t is PpcReloadTransaction && t.GomsTransactionId == null).ToList(); var trans = context.Transactions.OfType<PpcReloadTransaction>().FirstOrDefault(t => t.GomsTransactionId == null && t.ReloadPpc.PpcType.GomsSubsidiaryId == t.User.GomsSubsidiaryId); var resp = service.ReloadWallet(context, trans.User.UserId, trans.TransactionId); }