public ActionResult Index() { LoyaltyDetailRewardOptIn optInRecord = new LoyaltyDetailRewardOptIn(); optInRecord.LoyaltyDetailRewardSKUGroupIDs = Request.QueryString["utm_source"]; optInRecord.LinkSource = Request.QueryString["utm_medium"]; optInRecord.Campaign = Request.QueryString["utm_campaign"]; optInRecord.VendorPromoCode = Request.QueryString["promoCode"]; if (optInRecord.LoyaltyDetailRewardSKUGroupIDs == null) { optInRecord.LoyaltyDetailRewardSKUGroupIDs = "1017372,1017370,1017371,1017555,1017556,1017539,1017538,1017537,1017540,1017541"; } if (optInRecord.Campaign == null) { optInRecord.Campaign = "none"; } if (optInRecord.VendorPromoCode == null) { optInRecord.VendorPromoCode = "none"; } Session["LDROptIn"] = optInRecord; return(View()); }
// check LoyaltyDetailRewardsOptIn_T_EC for MobileNumber to check for prior optin public int CheckForLDROptIn(Card card) { using (LoyayContext context = new LoyayContext()) { var priorOptIn = new LoyaltyDetailRewardOptIn(); priorOptIn = context.LoyaltyDetailRewardOptIns .Where(o => o.MobilePhone == card.CH_MPHONE) .Where(o => o.LoyaltyDetailRewardSKUGroupID == 1017372 || o.LoyaltyDetailRewardSKUGroupID == 1017370 || o.LoyaltyDetailRewardSKUGroupID == 1017371 || o.LoyaltyDetailRewardSKUGroupID == 1017555 || o.LoyaltyDetailRewardSKUGroupID == 1017556 || o.LoyaltyDetailRewardSKUGroupID == 1017539 || o.LoyaltyDetailRewardSKUGroupID == 1017538 || o.LoyaltyDetailRewardSKUGroupID == 1017537 || o.LoyaltyDetailRewardSKUGroupID == 1017540 || o.LoyaltyDetailRewardSKUGroupID == 1017541) .FirstOrDefault(); if (priorOptIn == null) { return(0); } else { return(-1); } } }
// Enrolls in either FSR or the combo-club for Reward Spot members public void EnrollFreshSpotRewards(Card card) { try { LoyaltyDetailRewardOptIn optIn = new LoyaltyDetailRewardOptIn(); if (Session["LDROptIn"] != null) { optIn = Session["LDROptIn"] as LoyaltyDetailRewardOptIn; } using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "LoyaltyDetailRewardOptIn_S_EC"; cmd.Parameters.Add("@LoyaltyDetailRewardSKUGroupIDs", SqlDbType.VarChar).Value = optIn.LoyaltyDetailRewardSKUGroupIDs; cmd.Parameters.Add("@CardID", SqlDbType.VarChar).Value = card.CardID.ToString(); cmd.Parameters.Add("@LinkSource", SqlDbType.VarChar).Value = "FSRWebsite"; cmd.Parameters.Add("@Campaign", SqlDbType.VarChar).Value = optIn.Campaign.ToString(); cmd.Parameters.Add("@PromoCode", SqlDbType.VarChar).Value = optIn.VendorPromoCode.ToString(); conn.Open(); cmd.CommandTimeout = 240; cmd.ExecuteNonQuery(); } } } catch (Exception ex) { new HomeController().LogError(ex); } }