public override List<Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { // Since there is only one list we dont care about the myCoolList-value that will be passed in the listItemValue-parameter. var list = new List<Receiver>(); // Downloads this webpage where each email is on one row. string page = NewsletterStudio.Helper.DownloadWebPage("http://localhost/email.html"); // Spliting the list on every new line string[] arrEmails = page.Split(new[] {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries); foreach (var email in arrEmails) { if(NewsletterStudio.Common.IsValidEmail(email)) { list.Add(new Receiver() { DataProviderKey = email, Fullname = "", Email = email }); } } return list; }
public override List<Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var list = new List<Receiver>(); IRecordsReader dr; dr = Application.SqlHelper.ExecuteReader("Select CustomerId, EmailAddress, Firstname, Lastname from uCommerce_Customer"); while (dr.Read()) { var dataProviderKey = dr.Get<int>("CustomerId").ToString(); var email = dr.Get<string>("EmailAddress"); var fullname = string.Format("{0} {1}", dr.Get<string>("Firstname"), dr.Get<string>("Lastname")); if (Common.IsValidEmail(email) && list.Count(x => x.Email == email) == 0) list.Add(new Receiver() { DataProviderKey = dataProviderKey, Email = email, Fullname = fullname }); } dr.Close(); return list; }
public override List<Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var list = new List<Receiver>(); var db = ApplicationContext.Current.DatabaseContext.Database; var uCommerceCustomers = db.Fetch<UCommerceCustomer>("SELECT CustomerId, EmailAddress, Firstname, Lastname FROM uCommerce_Customer"); foreach (var customer in uCommerceCustomers) { if (Common.IsValidEmail(customer.EmailAddress) && !list.Any(x => x.Email == customer.EmailAddress)) list.Add(new Receiver() { DataProviderKey = customer.CustomerId.ToString(), Email = customer.EmailAddress, Fullname = string.Format("{0} {1}", customer.Firstname, customer.Lastname) }); } return list; }
public override List<Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var listAll = new List<TeaReceiver>(); IRecordsReader dr; dr = Application.SqlHelper.ExecuteReader("select Id, Firstname, Lastname, Email, DateFinalized FROM TeaCommerce_Order WHERE Email is not null AND DateFinalized != ''"); while (dr.Read()) { var dataProviderKey = dr.Get<int>("Id").ToString(); var email = dr.Get<string>("Email"); var fullname = string.Format("{0} {1}", dr.Get<string>("Firstname"), dr.Get<string>("Lastname")); var orderDate = dr.Get<DateTime>("DateFinalized"); // Not in the list? if (Common.IsValidEmail(email) && listAll.Count(x => x.Email == email) == 0) { var newReciver = new TeaReceiver() { DataProviderKey = dataProviderKey, Email = email, Fullname = fullname, OrderDate = orderDate }; listAll.Add(newReciver); } } dr.Close(); // Filter list if only no order in last 3 months if (listItemValue == "1") { var delList = listAll.Where(x => x.OrderDate < DateTime.Now.AddMonths(-3)); foreach (var item in delList) { listAll.Remove(item); } } return (from item in listAll select new Receiver() {DataProviderKey = item.DataProviderKey, Email = item.Email, Fullname = item.Fullname}).ToList(); }
public override List<Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var listAll = new List<TeaReceiver>(); var db = ApplicationContext.Current.DatabaseContext.Database; var listOfCustomers = db.Fetch<TeaCustomer>("select Id, Firstname, Lastname, Email, DateFinalized FROM TeaCommerce_Order WHERE Email is not null AND DateFinalized != ''"); foreach (var customer in listOfCustomers) { // Not in the list? if (Common.IsValidEmail(customer.Email) && listAll.Any(x => x.Email == customer.Email)) { var newReciver = new TeaReceiver() { DataProviderKey = customer.Id.ToString(), Email = customer.Email, Fullname = string.Format("{0} {1}", customer.Firstname, customer.Lastname), OrderDate = customer.DateFinalized }; listAll.Add(newReciver); } } // Filter list if only no order in last 3 months if (listItemValue == "1") { var delList = listAll.Where(x => x.OrderDate < DateTime.Now.AddMonths(-3)); foreach (var item in delList) { listAll.Remove(item); } } return (from item in listAll select new Receiver() {DataProviderKey = item.DataProviderKey, Email = item.Email, Fullname = item.Fullname}).ToList(); }
public override List <Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var listAll = new List <TeaReceiver>(); IRecordsReader dr; dr = Application.SqlHelper.ExecuteReader("select Id, Firstname, Lastname, Email, DateFinalized FROM TeaCommerce_Order WHERE Email is not null AND DateFinalized != ''"); while (dr.Read()) { var dataProviderKey = dr.Get <int>("Id").ToString(); var email = dr.Get <string>("Email"); var fullname = string.Format("{0} {1}", dr.Get <string>("Firstname"), dr.Get <string>("Lastname")); var orderDate = dr.Get <DateTime>("DateFinalized"); // Not in the list? if (Common.IsValidEmail(email) && listAll.Count(x => x.Email == email) == 0) { var newReciver = new TeaReceiver() { DataProviderKey = dataProviderKey, Email = email, Fullname = fullname, OrderDate = orderDate }; listAll.Add(newReciver); } } dr.Close(); // Filter list if only no order in last 3 months if (listItemValue == "1") { var delList = listAll.Where(x => x.OrderDate < DateTime.Now.AddMonths(-3)); foreach (var item in delList) { listAll.Remove(item); } } return((from item in listAll select new Receiver() { DataProviderKey = item.DataProviderKey, Email = item.Email, Fullname = item.Fullname }).ToList()); }
public override List <Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var listAll = new List <TeaReceiver>(); var db = ApplicationContext.Current.DatabaseContext.Database; var listOfCustomers = db.Fetch <TeaCustomer>("select Id, Firstname, Lastname, Email, DateFinalized FROM TeaCommerce_Order WHERE Email is not null AND DateFinalized != ''"); foreach (var customer in listOfCustomers) { // Not in the list? if (Common.IsValidEmail(customer.Email) && listAll.Any(x => x.Email == customer.Email)) { var newReciver = new TeaReceiver() { DataProviderKey = customer.Id.ToString(), Email = customer.Email, Fullname = string.Format("{0} {1}", customer.Firstname, customer.Lastname), OrderDate = customer.DateFinalized }; listAll.Add(newReciver); } } // Filter list if only no order in last 3 months if (listItemValue == "1") { var delList = listAll.Where(x => x.OrderDate < DateTime.Now.AddMonths(-3)); foreach (var item in delList) { listAll.Remove(item); } } return((from item in listAll select new Receiver() { DataProviderKey = item.DataProviderKey, Email = item.Email, Fullname = item.Fullname }).ToList()); }
public override List <Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { // Since there is only one list we dont care about the myCoolList-value that will be passed in the listItemValue-parameter. var list = new List <Receiver>(); // Downloads this webpage where each email is on one row. string page = NewsletterStudio.Helper.DownloadWebPage("http://localhost/email.html"); // Spliting the list on every new line string[] arrEmails = page.Split(new[] { Environment.NewLine }, StringSplitOptions.RemoveEmptyEntries); foreach (var email in arrEmails) { if (NewsletterStudio.Common.IsValidEmail(email)) { list.Add(new Receiver() { DataProviderKey = email, Fullname = "", Email = email }); } } return(list); }
public override List <Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var list = new List <Receiver>(); var db = ApplicationContext.Current.DatabaseContext.Database; var uCommerceCustomers = db.Fetch <UCommerceCustomer>("SELECT CustomerId, EmailAddress, Firstname, Lastname FROM uCommerce_Customer"); foreach (var customer in uCommerceCustomers) { if (Common.IsValidEmail(customer.EmailAddress) && !list.Any(x => x.Email == customer.EmailAddress)) { list.Add(new Receiver() { DataProviderKey = customer.CustomerId.ToString(), Email = customer.EmailAddress, Fullname = string.Format("{0} {1}", customer.Firstname, customer.Lastname) }); } } return(list); }
public override List <Receiver> GetSubscribersForSendOut(string listItemValue, SendOutParams parameters) { var list = new List <Receiver>(); IRecordsReader dr; dr = Application.SqlHelper.ExecuteReader("Select CustomerId, EmailAddress, Firstname, Lastname from uCommerce_Customer"); while (dr.Read()) { var dataProviderKey = dr.Get <int>("CustomerId").ToString(); var email = dr.Get <string>("EmailAddress"); var fullname = string.Format("{0} {1}", dr.Get <string>("Firstname"), dr.Get <string>("Lastname")); if (Common.IsValidEmail(email) && list.Count(x => x.Email == email) == 0) { list.Add(new Receiver() { DataProviderKey = dataProviderKey, Email = email, Fullname = fullname }); } } dr.Close(); return(list); }