public void importSingleUser_Click(object sender, EventArgs e) { List<TransitCampaignAccountRecepient> recepients = new List<TransitCampaignAccountRecepient>(); foreach (string sid in importSingleUserIds.Text.Split(" ".ToCharArray())) { TransitCampaignAccountRecepient recepient = new TransitCampaignAccountRecepient(); recepient.AccountId = int.Parse(sid); recepient.CampaignId = RequestId; recepient.Sent = false; recepients.Add(recepient); } int count = SessionManager.MarketingService.ImportCampaignAccountRecepients(SessionManager.Ticket, recepients.ToArray()); GetData(sender, e); ReportInfo(string.Format("Successfully imported {0} recepients.", count)); }
public void importSingleUser_Click(object sender, EventArgs e) { List <TransitCampaignAccountRecepient> recepients = new List <TransitCampaignAccountRecepient>(); foreach (string sid in importSingleUserIds.Text.Split(" ".ToCharArray())) { TransitCampaignAccountRecepient recepient = new TransitCampaignAccountRecepient(); recepient.AccountId = int.Parse(sid); recepient.CampaignId = RequestId; recepient.Sent = false; recepients.Add(recepient); } int count = SessionManager.MarketingService.ImportCampaignAccountRecepients(SessionManager.Ticket, recepients.ToArray()); GetData(sender, e); ReportInfo(string.Format("Successfully imported {0} recepients.", count)); }
public int ImportCampaignAccountPropertyValues(string ticket, int campaign_id, int pid, string value, bool unset) { int userid = ManagedAccount.GetAccountIdFromTicket(ticket); using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); int count = 0; try { StringBuilder squery = new StringBuilder(); squery.Append( "SELECT {Account.*} FROM {Account} WHERE Account_Id IN (" + " SELECT Account.Account_Id FROM Account INNER JOIN AccountPropertyValue" + " ON Account.Account_Id = AccountPropertyValue.Account_Id" + " WHERE AccountPropertyValue.AccountProperty_Id = " + pid.ToString() + " AND AccountPropertyValue.Value LIKE '" + Renderer.SqlEncode(value) + "')"); if (unset) { squery.AppendFormat( " OR Account_Id NOT IN (" + " SELECT Account.Account_Id FROM Account INNER JOIN AccountPropertyValue" + " ON Account.Account_Id = AccountPropertyValue.Account_Id" + " AND AccountPropertyValue.AccountProperty_Id = {0}" + ")", pid); } ISQLQuery query = session.CreateSQLQuery(squery.ToString()) .AddEntity("Account", typeof(Account)); IList <Account> list = query.List <Account>(); foreach (Account account in list) { ManagedAccount ma = new ManagedAccount(session, account); if (!ma.HasVerifiedEmail(sec)) { continue; } CampaignAccountRecepient existing = (CampaignAccountRecepient)session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult(); if (existing != null) { continue; } ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return(count); } }
public int ImportCampaignAccountLocation(string ticket, int campaign_id, string country, string state, string city) { int userid = ManagedAccount.GetAccountIdFromTicket(ticket); using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); AccountActivityQueryOptions options = new AccountActivityQueryOptions(); options.City = city; options.Country = country; options.State = state; options.PicturesOnly = false; options.BloggersOnly = false; int count = 0; try { IQuery query = session.CreateQuery(options.CreateQuery()); IEnumerator <Account> enumerator = query.Enumerable <Account>().GetEnumerator(); while (enumerator.MoveNext()) { ManagedAccount ma = new ManagedAccount(session, enumerator.Current); if (!ma.HasVerifiedEmail(sec)) { continue; } CampaignAccountRecepient existing = session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult <CampaignAccountRecepient>(); if (existing != null) { continue; } ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return(count); } }
public int ImportCampaignAccountEmails(string ticket, int campaign_id, bool verified_emails, bool unverified_emails) { using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); int count = 0; try { ICriteria c = session.CreateCriteria(typeof(Account)); IList list = c.List(); foreach (Account account in list) { ManagedAccount ma = new ManagedAccount(session, account); if (ma.HasVerifiedEmail(sec)) { if (!verified_emails) { continue; } } else { if (!unverified_emails) { continue; } } CampaignAccountRecepient existing = (CampaignAccountRecepient)session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult(); if (existing != null) { continue; } ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return(count); } }
public int CreateOrUpdateCampaignAccountRecepient(string ticket, TransitCampaignAccountRecepient recepient) { return(WebServiceImpl <TransitCampaignAccountRecepient, ManagedCampaignAccountRecepient, CampaignAccountRecepient> .CreateOrUpdate( ticket, recepient)); }
public int ImportCampaignAccountPropertyValues(string ticket, int campaign_id, int pid, string value, bool unset) { int userid = ManagedAccount.GetAccountIdFromTicket(ticket); using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); int count = 0; try { StringBuilder squery = new StringBuilder(); squery.Append( "SELECT {Account.*} FROM {Account} WHERE Account_Id IN (" + " SELECT Account.Account_Id FROM Account INNER JOIN AccountPropertyValue" + " ON Account.Account_Id = AccountPropertyValue.Account_Id" + " WHERE AccountPropertyValue.AccountProperty_Id = " + pid.ToString() + " AND AccountPropertyValue.Value LIKE '" + Renderer.SqlEncode(value) + "')"); if (unset) { squery.AppendFormat( " OR Account_Id NOT IN (" + " SELECT Account.Account_Id FROM Account INNER JOIN AccountPropertyValue" + " ON Account.Account_Id = AccountPropertyValue.Account_Id" + " AND AccountPropertyValue.AccountProperty_Id = {0}" + ")", pid); } ISQLQuery query = session.CreateSQLQuery(squery.ToString()) .AddEntity("Account", typeof(Account)); IList<Account> list = query.List<Account>(); foreach (Account account in list) { ManagedAccount ma = new ManagedAccount(session, account); if (!ma.HasVerifiedEmail(sec)) continue; CampaignAccountRecepient existing = (CampaignAccountRecepient)session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult(); if (existing != null) continue; ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return count; } }
public int ImportCampaignAccountLocation(string ticket, int campaign_id, string country, string state, string city) { int userid = ManagedAccount.GetAccountIdFromTicket(ticket); using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); AccountActivityQueryOptions options = new AccountActivityQueryOptions(); options.City = city; options.Country = country; options.State = state; options.PicturesOnly = false; options.BloggersOnly = false; int count = 0; try { IQuery query = session.CreateQuery(options.CreateQuery()); IEnumerator<Account> enumerator = query.Enumerable<Account>().GetEnumerator(); while (enumerator.MoveNext()) { ManagedAccount ma = new ManagedAccount(session, enumerator.Current); if (!ma.HasVerifiedEmail(sec)) continue; CampaignAccountRecepient existing = session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult<CampaignAccountRecepient>(); if (existing != null) continue; ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return count; } }
public int ImportCampaignAccountEmails(string ticket, int campaign_id, bool verified_emails, bool unverified_emails) { using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); int count = 0; try { ICriteria c = session.CreateCriteria(typeof(Account)); IList list = c.List(); foreach (Account account in list) { ManagedAccount ma = new ManagedAccount(session, account); if (ma.HasVerifiedEmail(sec)) { if (!verified_emails) continue; } else { if (!unverified_emails) continue; } CampaignAccountRecepient existing = (CampaignAccountRecepient)session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", ma.Id)) .Add(Expression.Eq("Campaign.Id", campaign_id)) .UniqueResult(); if (existing != null) continue; ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); TransitCampaignAccountRecepient newtransitrecepient = new TransitCampaignAccountRecepient(); newtransitrecepient.AccountId = ma.Id; newtransitrecepient.CampaignId = campaign_id; newtransitrecepient.Created = newtransitrecepient.Modified = DateTime.UtcNow; newtransitrecepient.Sent = false; newrecepient.CreateOrUpdate(newtransitrecepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return count; } }
public int ImportCampaignAccountRecepients(string ticket, TransitCampaignAccountRecepient[] recepients) { using (SnCore.Data.Hibernate.Session.OpenConnection()) { ISession session = SnCore.Data.Hibernate.Session.Current; ManagedSecurityContext sec = new ManagedSecurityContext(session, ticket); ITransaction trans = session.BeginTransaction(); int count = 0; try { foreach (TransitCampaignAccountRecepient recepient in recepients) { CampaignAccountRecepient existing = (CampaignAccountRecepient)session.CreateCriteria(typeof(CampaignAccountRecepient)) .Add(Expression.Eq("Account.Id", recepient.AccountId)) .Add(Expression.Eq("Campaign.Id", recepient.CampaignId)) .UniqueResult(); if (existing != null) continue; ManagedCampaignAccountRecepient newrecepient = new ManagedCampaignAccountRecepient(session); newrecepient.CreateOrUpdate(recepient, sec); count++; } trans.Commit(); SnCore.Data.Hibernate.Session.Flush(); } catch { trans.Rollback(); throw; } return count; } }
public int CreateOrUpdateCampaignAccountRecepient(string ticket, TransitCampaignAccountRecepient recepient) { return WebServiceImpl<TransitCampaignAccountRecepient, ManagedCampaignAccountRecepient, CampaignAccountRecepient>.CreateOrUpdate( ticket, recepient); }