public static SelectList GatewayGatewayAccountList() { List <string> list = CMSDataContext.Create(HttpContextFactory.Current).GatewayAccount .Select(g => g.GatewayAccountName).ToList(); list.Insert(0, ""); return(new SelectList(list)); }
private static void _logActivity(string host, string activity, int?orgId, int?peopleId, int?datumId, int?userId, string pageUrl = null, string clientIp = null) { var ip = HttpContextFactory.Current?.Request.UserHostAddress; using (var db = CMSDataContext.Create(host)) { if (!userId.HasValue || userId == 0) { userId = db.UserId; } if (userId == 0) { userId = null; } if (orgId.HasValue && !db.PeopleIdOk(peopleId)) { peopleId = null; } if (peopleId.HasValue && !db.OrgIdOk(orgId)) { orgId = null; } var a = new ActivityLog { ActivityDate = Util.Now, UserId = userId, Activity = activity.Truncate(200), Machine = Environment.MachineName, OrgId = orgId, PeopleId = peopleId, DatumId = datumId, PageUrl = pageUrl, ClientIp = clientIp ?? ip }; db.ActivityLogs.InsertOnSubmit(a); db.SubmitChanges(); } }
public static CMSDataContext Create(string connstr, string host) { return(CMSDataContext.Create(connstr, host)); }
public static CMSDataContext Create(string host) { return(CMSDataContext.Create(Util.GetConnectionString(host), host)); }
private CMSDataContext NewDataContext() { return(CMSDataContext.Create(db.Host)); }
public PythonModel(string dbname, Dictionary <string, object> dict) { dictionary = dict; Data = new DynamicData(dictionary); db = CMSDataContext.Create(dbname); }
// this will run replacements in a new dataContext // public string DoReplacements(int pid, EmailQueueTo emailqueueto) { using (db = CMSDataContext.Create(connStr, host)) { if (currentOrgId.HasValue) { db.SetCurrentOrgId(currentOrgId); } var p = db.LoadPersonById(pid); person = p; pi = GetPayInfo(emailqueueto.OrgId ?? currentOrgId ?? db.CurrentSessionOrgId, p.PeopleId); var aa = db.GetAddressList(p); if (emailqueueto.EmailQueue.FinanceOnly == true) { var contributionemail = (from ex in db.PeopleExtras where ex.PeopleId == p.PeopleId where ex.Field == "ContributionEmail" select ex.Data).SingleOrDefault(); if (contributionemail.HasValue()) { contributionemail = contributionemail.trim(); } if (!Util.ValidEmail(contributionemail)) { contributionemail = p.FromEmail; } aa.Clear(); aa.Add(Util.TryGetMailAddress(contributionemail)); } if (OptOuts != null && emailqueueto.EmailQueue.CCParents == true) { var pp = OptOuts.SingleOrDefault(vv => vv.PeopleId == emailqueueto.PeopleId); if (pp != null) { if (pp.HhPeopleId.HasValue && Util.ValidEmail(pp.HhEmail)) { aa.Add(new MailAddress(pp.HhEmail, pp.HhName)); emailqueueto.Parent1 = pp.HhPeopleId; } if (pp.HhSpPeopleId.HasValue && Util.ValidEmail(pp.HhSpEmail)) { aa.Add(new MailAddress(pp.HhSpEmail, pp.HhSpName)); emailqueueto.Parent2 = pp.HhSpPeopleId; } } } if (emailqueueto.AddEmail.HasValue()) { foreach (var ad in emailqueueto.AddEmail.SplitStr(",")) { Util.AddGoodAddress(aa, ad); } } if (emailqueueto.OrgId.HasValue && pi != null) { Util.AddGoodAddress(aa, Util.FullEmail(pi.RegisterMail, p.Name)); } ListAddresses = aa.DistinctEmails(); var noreplacements = emailqueueto.EmailQueue.NoReplacements ?? false; var texta = new List <string>(stringlist); for (var i = 1; i < texta.Count; i += 2) { if (noreplacements && !texta[i].StartsWith("<style")) { texta[i] = ""; } else { texta[i] = DoReplaceCode(texta[i], emailqueueto); } } db.SubmitChanges(); return(string.Join("", texta)); } }
// this will run replacements in a new dataContext // public string DoReplacements(int pid, EmailQueueTo emailqueueto) { using (db = CMSDataContext.Create(connStr, host)) { if (currentOrgId.HasValue) { db.SetCurrentOrgId(currentOrgId); } var p = db.LoadPersonById(pid); person = p; var pi = emailqueueto.OrgId.HasValue ? (from m in db.OrganizationMembers let ts = db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == m.TranId && tt.PeopleId == m.PeopleId) where m.PeopleId == emailqueueto.PeopleId && m.OrganizationId == emailqueueto.OrgId select new PayInfo { PayLink = m.PayLink2(db), Amount = ts.IndAmt, AmountPaid = ts.IndPaid, AmountDue = ts.IndDue, RegisterMail = m.RegisterEmail }).SingleOrDefault() : null; var aa = db.GetAddressList(p); if (emailqueueto.EmailQueue.CCParents ?? false) { aa.AddRange(db.GetCcList(p, emailqueueto)); } if (emailqueueto.AddEmail.HasValue()) { foreach (var ad in emailqueueto.AddEmail.SplitStr(",")) { Util.AddGoodAddress(aa, ad); } } if (emailqueueto.OrgId.HasValue && pi != null) { Util.AddGoodAddress(aa, Util.FullEmail(pi.RegisterMail, p.Name)); } ListAddresses = aa.DistinctEmails(); var noreplacements = emailqueueto.EmailQueue.NoReplacements ?? false; var texta = new List <string>(stringlist); for (var i = 1; i < texta.Count; i += 2) { if (noreplacements) { texta[i] = ""; } else { texta[i] = DoReplaceCode(texta[i], p, pi, emailqueueto); } } db.SubmitChanges(); return(string.Join("", texta)); } }
public QueryFunctions(string dbname) { db = CMSDataContext.Create(dbname); }