public int CountEmail(RedeemPoint redeemPoint) { int totalEmail = 0; using (var db = Factory.DbEntities) { try { ////OBSOLET //totalEmail = db.RedeemPoint.Where(x => x.Email.ToLower().Contains(redeemPoint.Email.ToLower())) // .Where(x => x.ItemId.ToLower().Contains(redeemPoint.ItemId.ToLower())) // .Where(x => x.SubmitedDate == DateTime.Today) // .Count(); totalEmail = redeemPoint.Get(db).Count(); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.AppendLine(ex.Message); //lg.LogWrite(sb.ToString()); } } return(totalEmail); }
public bool SubmitData(RedeemPoint redeemPoint, int MaxSubmit) { int countEmail = CountEmail(redeemPoint); if (countEmail >= MaxSubmit) { return(false); } else { //methodsendEmail Sitecore.Data.Items.Item items = Sitecore.Context.Database.GetItem(redeemPoint.ItemId); EmailContent EmailToCustomer = GetEmailContent(Sitecore.Feature.Library.Helper.Variables._emailTemplatetoCustomer); //Email Template Redeem Point To Customer EmailToCustomer.EmailBody = EmailToCustomer.EmailBody.Replace("[CustomerName]", redeemPoint.Fullname); EmailToCustomer.EmailBody = EmailToCustomer.EmailBody.Replace("[ItemName]", redeemPoint.ItemName); EmailToCustomer.EmailBody = EmailToCustomer.EmailBody.Replace("[Points]", items.Fields[Sitecore.Feature.Library.Templates.TreatsPointItem.Fields.Price].Value); LibraryHelpers.SendEmail(redeemPoint.Email, EmailToCustomer.EmailFrom, EmailToCustomer.Subject, EmailToCustomer.EmailBody); //Get Email To Customer EmailContent EmailToCustomerCare = GetEmailContent(Sitecore.Feature.Library.Helper.Variables._emailTemplatetoCustomerCare); //Email Template Redeem Point To Customer Care EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[ItemName]", redeemPoint.ItemName); EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[Points]", items.Fields[Sitecore.Feature.Library.Templates.TreatsPointItem.Fields.Price].Value); EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[CustomerName]", redeemPoint.Fullname); EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[CCNumber]", redeemPoint.CreditCardNumber); EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[PhoneNumber]", redeemPoint.MobileNumber); EmailToCustomerCare.EmailBody = EmailToCustomerCare.EmailBody.Replace("[Email]", redeemPoint.Email); LibraryHelpers.SendEmail(GetUserEmailTo(Sitecore.Feature.Library.Helper.Variables._emailCustomerCareTreatsPoint), EmailToCustomerCare.EmailFrom, EmailToCustomerCare.Subject, EmailToCustomerCare.EmailBody); //Get Customer Care Email Add(redeemPoint); return(true); } }
public ActionResult SubmitReedemPoint(FormCollection formCollection) { if (System.Web.HttpContext.Current.Session[Variables._varEncryptedKey] == null) { return(SessionExpired()); } var formData = DecryptObject(formCollection[PAYLOAD]); // decrypt from js string randomKey = System.Web.HttpContext.Current.Session[Variables._varEncryptedKey].ToString(); string itemId = AESEncrytDecry.DecryptStringAES(randomKey, formData["itemId"]); string name = AESEncrytDecry.DecryptStringAES(randomKey, formData["name"]); string creditcard = AESEncrytDecry.DecryptStringAES(randomKey, formData["creditcard"]); string mobilenumber = AESEncrytDecry.DecryptStringAES(randomKey, formData["mobilenumber"]); string email = AESEncrytDecry.DecryptStringAES(randomKey, formData["email"]); int maxsubmit = Convert.ToInt32(AESEncrytDecry.DecryptStringAES(randomKey, formData["maxsubmit"])); RedeemPoint entity = new RedeemPoint(); var culture = new System.Globalization.CultureInfo(SC.Context.Language.Name); var properties = entity.GetType().GetProperties(); for (int i = 0; i < properties.Length; i++) { try { if (!string.IsNullOrWhiteSpace(AESEncrytDecry.DecryptStringAES(randomKey, formData[properties[i].Name]))) { properties[i].SetValue(entity, Convert.ChangeType(AESEncrytDecry.DecryptStringAES(randomKey, formData[properties[i].Name]), properties[i].PropertyType, culture), null); } } catch { /* just continue ignore this error */ } } entity.ID = Guid.NewGuid(); entity.ItemId = itemId; entity.ItemName = Repository.GetItemName(itemId); entity.Fullname = name; entity.CreditCardNumber = creditcard; entity.MobileNumber = mobilenumber; entity.Email = email; entity.SubmitedDate = DateTime.Now; bool result = Repository.SubmitData(entity, maxsubmit); return(Json(result, JsonRequestBehavior.AllowGet)); }
public void Add(RedeemPoint redeemPoint) { using (var db = Factory.DbEntities) { try { ////OBSOLET //db.RedeemPoint.Add(redeemPoint); //db.SaveChanges(); redeemPoint.Insert(db); } catch (Exception ex) { StringBuilder sb = new StringBuilder(); sb.AppendLine(ex.Message); //lg.LogWrite(sb.ToString()); } } }