Пример #1
0
        public ActionResult AddPerson(int id, PersonInfo m)
        {
            if (!Authenticate())
                return Content("not authorized");
            DbUtil.LogActivity("checkin AddPerson {0} {1} ({2})".Fmt(m.first, m.last, m.dob));

            CmsData.Family f;
            if (id > 0)
                f = DbUtil.Db.Families.Single(fam => fam.FamilyId == id);
            else
                f = new CmsData.Family();

            var position = PositionInFamily.Child;
            if (Util.Age0(m.dob) >= 18)
                if (f.People.Count(per =>
                     per.PositionInFamilyId == PositionInFamily.PrimaryAdult)
                     < 2)
                    position = PositionInFamily.PrimaryAdult;
                else
                    position = PositionInFamily.SecondaryAdult;

            var p = Person.Add(f, position,
                null, m.first, m.goesby, m.last, m.dob, false, m.gender,
                    OriginCode.Visit, null);

            UpdatePerson(p, m, isNew: true);
            return Content(f.FamilyId.ToString() + "." + p.PeopleId);
        }
Пример #2
0
        public ActionResult AddPerson(int id, PersonInfo m)
        {
            if (!AccountModel.AuthenticateMobile())
                return Content("not authorized");

            var f = m.addtofamilyid > 0
                ? DbUtil.Db.Families.First(fam => fam.People.Any(pp => pp.PeopleId == m.addtofamilyid))
                : new CmsData.Family();

            if (m.goesby == "(Null)")
                m.goesby = null;

            var position = DbUtil.Db.ComputePositionInFamily(m.dob.Age0(), m.marital == 20, f.FamilyId) ?? 10;

            var p = Person.Add(f, position,
                null, Trim(m.first), Trim(m.goesby), Trim(m.last), m.dob, false, m.gender,
                    OriginCode.Visit, null);

            DbUtil.LogActivity("iPhone AddPerson {0}".Fmt(p.PeopleId));
            UpdatePerson(p, m);
            var meeting = DbUtil.Db.Meetings.Single(mm => mm.MeetingId == id);
            Attend.RecordAttendance(p.PeopleId, id, true);
            DbUtil.Db.UpdateMeetingCounters(id);
            return new RollListResult(meeting, p.PeopleId);
        }
Пример #3
0
        public ActionResult AddPerson(int id, PersonInfo m)
        {
            if (!AccountModel.AuthenticateMobile())
                return Content("not authorized");

            CmsData.Family f;
            if (m.addtofamilyid > 0)
                f = DbUtil.Db.Families.First(fam => fam.People.Any(pp => pp.PeopleId == m.addtofamilyid));
            else
                f = new CmsData.Family();

            if (m.goesby == "(Null)")
                m.goesby = null;
            var position = PositionInFamily.Child;
            if (m.dob.Age0() >= 18)
                if (f.People.Count(per =>
                     per.PositionInFamilyId == PositionInFamily.PrimaryAdult)
                     < 2)
                    position = PositionInFamily.PrimaryAdult;
                else
                    position = PositionInFamily.SecondaryAdult;

            var p = Person.Add(f, position,
                null, Trim(m.first), Trim(m.goesby), Trim(m.last), m.dob, false, m.gender,
                    OriginCode.Visit, null);

            var z = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());
            if (!m.home.HasValue() && m.cell.HasValue())
                m.home = m.cell;

            if (m.addtofamilyid == 0)
            {
                p.Family.HomePhone = m.home.GetDigits();
                p.Family.AddressLineOne = m.addr;
                p.Family.CityName = z != null ? z.City : null;
                p.Family.StateCode = z != null ? z.State : null;
                p.Family.ZipCode = m.zip;
            }
            p.EmailAddress = Trim(m.email);
            if (m.cell.HasValue())
                p.CellPhone = m.cell.GetDigits();
            p.MaritalStatusId = m.marital;
            p.GenderId = m.gender;
            DbUtil.Db.SubmitChanges();
            DbUtil.LogActivity("iPhone AddPerson {0}".Fmt(p.PeopleId));
            var meeting = DbUtil.Db.Meetings.Single(mm => mm.MeetingId == id);
            Attend.RecordAttendance(p.PeopleId, id, true);
            DbUtil.Db.UpdateMeetingCounters(id);
            return new RollListResult(meeting, p.PeopleId);
        }
Пример #4
0
        public ActionResult AddPerson(int id, PersonInfo m)
        {
            if (!Authenticate())
                return Content("not authorized");
            DbUtil.LogActivity($"checkin AddPerson {m.first} {m.last} ({m.dob})");

            var f = id > 0
                ? DbUtil.Db.Families.Single(fam => fam.FamilyId == id)
                : new Family();

            var position = DbUtil.Db.ComputePositionInFamily(m.dob.Age0(), m.marital == 20, id) ?? 10;
            var p = Person.Add(f, position,
                null, m.first, m.goesby, m.last, m.dob, false, m.gender,
                OriginCode.Visit, null);

            UpdatePerson(p, m, true);
            return Content(f.FamilyId + "." + p.PeopleId);
        }
Пример #5
0
        private void UpdatePerson(Person p, PersonInfo m, bool isNew)
        {
            var psb = new List<ChangeDetail>();
            var fsb = new List<ChangeDetail>();
            var keys = Request.Form.AllKeys.ToList();

            if (!m.home.HasValue() && m.cell.HasValue())
                m.home = m.cell;

            if (keys.Contains("zip") || keys.Contains("addr"))
            {
                var result = AddressVerify.LookupAddress(m.addr, p.PrimaryAddress2, null, null, m.zip.Zip5());
                if (result.found != false && !result.error.HasValue() && result.Line1 != "error")
                {
                    UpdateField(fsb, p.Family, "AddressLineOne", result.Line1);
                    UpdateField(fsb, p.Family, "AddressLineTwo", result.Line2);
                    UpdateField(fsb, p.Family, "CityName", result.City);
                    UpdateField(fsb, p.Family, "StateCode", result.State);
                    UpdateField(fsb, p.Family, "ZipCode", result.Zip.GetDigits().Truncate(10));
                    var rc = DbUtil.Db.FindResCode(result.Zip, null);
                    UpdateField(fsb, p.Family, "ResCodeId", rc.ToString());
                }
                else
                {
                    if (keys.Contains("addr"))
                        UpdateField(fsb, p.Family, "AddressLineOne", m.addr);
                    UpdateField(fsb, p.Family, "ZipCode", m.zip.Zip5());
                    UpdateField(fsb, p.Family, "CityName", null);
                    UpdateField(fsb, p.Family, "StateCode", null);
                }
            }

            if (keys.Contains("home"))
                UpdateField(fsb, p.Family, "HomePhone", m.home.GetDigits());
            if (keys.Contains("goesby"))
                UpdateField(psb, p, "NickName", Trim(m.goesby));
            if (keys.Contains("first"))
                UpdateField(psb, p, "FirstName", Trim(m.first));
            if (keys.Contains("last"))
                UpdateField(psb, p, "LastName", Trim(m.last));
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                    UpdateField(psb, p, "DOB", m.dob);
            }
            if (keys.Contains("email"))
                UpdateField(psb, p, "EmailAddress", Trim(m.email));
            if (keys.Contains("cell"))
                UpdateField(psb, p, "CellPhone", m.cell.GetDigits());
            if (keys.Contains("marital"))
                UpdateField(psb, p, "MaritalStatusId", m.marital);
            if (keys.Contains("gender"))
                UpdateField(psb, p, "GenderId", m.gender);

            var rr = p.GetRecReg();
            if (keys.Contains("allergies"))
                if (m.allergies != rr.MedicalDescription)
                    p.SetRecReg().MedicalDescription = m.allergies;
            if (keys.Contains("grade"))
                if (m.AskGrade)
                    if (m.grade.ToInt2() != p.Grade)
                        p.Grade = m.grade.ToInt2();
            if (m.AskEmFriend)
            {
                if (keys.Contains("parent"))
                    if (m.parent != rr.Mname)
                        p.SetRecReg().Mname = m.parent;
                if (keys.Contains("emfriend"))
                    if (m.emfriend != rr.Emcontact)
                        p.SetRecReg().Emcontact = m.emfriend;
                if (keys.Contains("emphone"))
                    if (m.emphone != rr.Emphone)
                        p.SetRecReg().Emphone = m.emphone.Truncate(50);
            }
            if (isNew)
            {
                if (keys.Contains("campusid"))
                    if (m.campusid > 0)
                        UpdateField(psb, p, "CampusId", m.campusid);
            }
            if (m.AskChurch)
                if (keys.Contains("activeother"))
                    if (m.activeother.ToBool() != rr.ActiveInAnotherChurch)
                        p.SetRecReg().ActiveInAnotherChurch = m.activeother.ToBool();
            if (m.AskChurchName)
                if (keys.Contains("churchname"))
                    UpdateField(psb, p, "OtherPreviousChurch", Trim(m.churchname));

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() && (psb.Count > 0 || fsb.Count > 0))
            {
                var sb = new StringBuilder();
                foreach (var c in psb)
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                foreach (var c in fsb)
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                var np = DbUtil.Db.GetNewPeopleManagers();
                if (np != null)
                    DbUtil.Db.EmailRedacted(p.FromEmail, np,
                        "Basic Person Info Changed during checkin on " + Util.Host, $@"
<p><a href=""{DbUtil.Db.ServerLink("/Person2/" + p.PeopleId)}"">{Util.UserName} ({p.PeopleId})</a> changed the following information for {p.PreferredName} ({p.LastName}):</p>
<table>{sb}</table>");
            }
        }
Пример #6
0
 public ActionResult EditPerson(int id, PersonInfo m)
 {
     if (!Authenticate())
         return Content("not authorized");
     DbUtil.LogActivity($"checkin EditPerson {m.first} {m.last} ({m.dob})");
     var p = DbUtil.Db.LoadPersonById(id);
     UpdatePerson(p, m, false);
     return Content(p.FamilyId.ToString());
 }
Пример #7
0
        private void UpdatePerson(Person p, PersonInfo m)
        {
            var psb = new List<ChangeDetail>();
            var fsb = new List<ChangeDetail>();
            var z = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());

            if (!m.home.HasValue() && m.cell.HasValue())
                m.home = m.cell;

            if (m.home.HasValue())
                p.Family.UpdateValue(fsb, "HomePhone", m.home.GetDigits());

            if (m.addr.HasValue())
                p.Family.UpdateValue(fsb, "AddressLineOne", m.addr);

            if (m.zip.HasValue())
            {
                p.Family.UpdateValue(fsb, "CityName", z != null ? z.City : null);
                p.Family.UpdateValue(fsb, "StateCode", z != null ? z.State : null);
                p.Family.UpdateValue(fsb, "ZipCode", m.zip);
                var rc = DbUtil.Db.FindResCode(m.zip, null);
                p.Family.UpdateValue(fsb, "ResCodeId", rc.ToString());
            }

            if (m.email.HasValue())
                p.UpdateValue(psb, "EmailAddress", Trim(m.email));

            if (m.cell.HasValue())
                p.UpdateValue(psb, "CellPhone", m.cell.GetDigits());

            p.UpdateValue(psb, "MaritalStatusId", m.marital);

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (!DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() || (psb.Count <= 0 && fsb.Count <= 0))
                return;
            var sb = new StringBuilder();
            foreach (var c in psb)
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            foreach (var c in fsb)
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            var np = DbUtil.Db.GetNewPeopleManagers();
            if (np != null)
                DbUtil.Db.EmailRedacted(p.FromEmail, np,
                    "Basic Person Info Changed during checkin on " + Util.Host,
                    $"{Util.UserName} changed the following information for {p.PreferredName} ({p.LastName}):<br />\n<table>{sb}</table>");
        }
Пример #8
0
        public ActionResult AddPerson(int id, PersonInfo m)
        {
            if (!AccountModel.AuthenticateMobile())
            {
                return(Content("not authorized"));
            }

            CmsData.Family f;
            if (m.addtofamilyid > 0)
            {
                f = DbUtil.Db.Families.First(fam => fam.People.Any(pp => pp.PeopleId == m.addtofamilyid));
            }
            else
            {
                f = new CmsData.Family();
            }

            if (m.goesby == "(Null)")
            {
                m.goesby = null;
            }
            var position = PositionInFamily.Child;

            if (m.dob.Age0() >= 18)
            {
                if (f.People.Count(per =>
                                   per.PositionInFamilyId == PositionInFamily.PrimaryAdult)
                    < 2)
                {
                    position = PositionInFamily.PrimaryAdult;
                }
                else
                {
                    position = PositionInFamily.SecondaryAdult;
                }
            }

            var p = Person.Add(f, position,
                               null, Trim(m.first), Trim(m.goesby), Trim(m.last), m.dob, false, m.gender,
                               OriginCode.Visit, null);

            var z = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());

            if (!m.home.HasValue() && m.cell.HasValue())
            {
                m.home = m.cell;
            }

            if (m.addtofamilyid == 0)
            {
                p.Family.HomePhone      = m.home.GetDigits();
                p.Family.AddressLineOne = m.addr;
                p.Family.CityName       = z != null ? z.City : null;
                p.Family.StateCode      = z != null ? z.State : null;
                p.Family.ZipCode        = m.zip;
            }
            p.EmailAddress = Trim(m.email);
            if (m.cell.HasValue())
            {
                p.CellPhone = m.cell.GetDigits();
            }
            p.MaritalStatusId = m.marital;
            p.GenderId        = m.gender;
            DbUtil.Db.SubmitChanges();
            var meeting = DbUtil.Db.Meetings.Single(mm => mm.MeetingId == id);

            Attend.RecordAttendance(p.PeopleId, id, true);
            DbUtil.Db.UpdateMeetingCounters(id);
            return(new RollListResult(meeting, p.PeopleId));
        }
Пример #9
0
        private void UpdatePerson(Person p, PersonInfo m)
        {
            var psb = new List <ChangeDetail>();
            var fsb = new List <ChangeDetail>();
            var z   = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());

            if (!m.home.HasValue() && m.cell.HasValue())
            {
                m.home = m.cell;
            }

            if (m.home.HasValue())
            {
                p.Family.UpdateValue(fsb, "HomePhone", m.home.GetDigits());
            }

            if (m.addr.HasValue())
            {
                p.Family.UpdateValue(fsb, "AddressLineOne", m.addr);
            }

            if (m.zip.HasValue())
            {
                p.Family.UpdateValue(fsb, "CityName", z != null ? z.City : null);
                p.Family.UpdateValue(fsb, "StateCode", z != null ? z.State : null);
                p.Family.UpdateValue(fsb, "ZipCode", m.zip);
                var rc = DbUtil.Db.FindResCode(m.zip, null);
                p.Family.UpdateValue(fsb, "ResCodeId", rc.ToString());
            }

            if (m.email.HasValue())
            {
                p.UpdateValue(psb, "EmailAddress", Trim(m.email));
            }

            if (m.cell.HasValue())
            {
                p.UpdateValue(psb, "CellPhone", m.cell.GetDigits());
            }

            p.UpdateValue(psb, "MaritalStatusId", m.marital);

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (!DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() || (psb.Count <= 0 && fsb.Count <= 0))
            {
                return;
            }
            var sb = new StringBuilder();

            foreach (var c in psb)
            {
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            }
            foreach (var c in fsb)
            {
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            }
            var np = DbUtil.Db.GetNewPeopleManagers();

            if (np != null)
            {
                DbUtil.Db.EmailRedacted(p.FromEmail, np,
                                        "Basic Person Info Changed during checkin on " + Util.Host,
                                        $"{Util.UserName} changed the following information for {p.PreferredName} ({p.LastName}):<br />\n<table>{sb}</table>");
            }
        }
Пример #10
0
        private void UpdatePerson(Person p, PersonInfo m, bool isNew)
        {
            var psb  = new List <ChangeDetail>();
            var fsb  = new List <ChangeDetail>();
            var keys = Request.Form.AllKeys.ToList();

            if (!m.home.HasValue() && m.cell.HasValue())
            {
                m.home = m.cell;
            }

            if (keys.Contains("zip") || keys.Contains("addr"))
            {
                var result = AddressVerify.LookupAddress(m.addr, p.PrimaryAddress2, null, null, m.zip.Zip5());
                if (result.found != false && !result.error.HasValue() && result.Line1 != "error")
                {
                    UpdateField(fsb, p.Family, "AddressLineOne", result.Line1);
                    UpdateField(fsb, p.Family, "AddressLineTwo", result.Line2);
                    UpdateField(fsb, p.Family, "CityName", result.City);
                    UpdateField(fsb, p.Family, "StateCode", result.State);
                    UpdateField(fsb, p.Family, "ZipCode", result.Zip.GetDigits().Truncate(10));
                    var rc = DbUtil.Db.FindResCode(result.Zip, null);
                    UpdateField(fsb, p.Family, "ResCodeId", rc.ToString());
                }
                else
                {
                    if (keys.Contains("addr"))
                    {
                        UpdateField(fsb, p.Family, "AddressLineOne", m.addr);
                    }
                    UpdateField(fsb, p.Family, "ZipCode", m.zip.Zip5());
                    UpdateField(fsb, p.Family, "CityName", null);
                    UpdateField(fsb, p.Family, "StateCode", null);
                }
            }

            if (keys.Contains("home"))
            {
                UpdateField(fsb, p.Family, "HomePhone", m.home.GetDigits());
            }
            if (keys.Contains("goesby"))
            {
                UpdateField(psb, p, "NickName", Trim(m.goesby));
            }
            if (keys.Contains("first"))
            {
                UpdateField(psb, p, "FirstName", Trim(m.first));
            }
            if (keys.Contains("last"))
            {
                UpdateField(psb, p, "LastName", Trim(m.last));
            }
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                {
                    UpdateField(psb, p, "DOB", m.dob);
                }
            }
            if (keys.Contains("email"))
            {
                UpdateField(psb, p, "EmailAddress", Trim(m.email));
            }
            if (keys.Contains("cell"))
            {
                UpdateField(psb, p, "CellPhone", m.cell.GetDigits());
            }
            if (keys.Contains("marital"))
            {
                UpdateField(psb, p, "MaritalStatusId", m.marital);
            }
            if (keys.Contains("gender"))
            {
                UpdateField(psb, p, "GenderId", m.gender);
            }

            var rr = p.GetRecReg();

            if (keys.Contains("allergies"))
            {
                if (m.allergies != rr.MedicalDescription)
                {
                    p.SetRecReg().MedicalDescription = m.allergies;
                }
            }
            if (keys.Contains("grade"))
            {
                if (m.AskGrade)
                {
                    if (m.grade.ToInt2() != p.Grade)
                    {
                        p.Grade = m.grade.ToInt2();
                    }
                }
            }
            if (m.AskEmFriend)
            {
                if (keys.Contains("parent"))
                {
                    if (m.parent != rr.Mname)
                    {
                        p.SetRecReg().Mname = m.parent;
                    }
                }
                if (keys.Contains("emfriend"))
                {
                    if (m.emfriend != rr.Emcontact)
                    {
                        p.SetRecReg().Emcontact = m.emfriend;
                    }
                }
                if (keys.Contains("emphone"))
                {
                    if (m.emphone != rr.Emphone)
                    {
                        p.SetRecReg().Emphone = m.emphone.Truncate(50);
                    }
                }
            }
            if (isNew)
            {
                if (keys.Contains("campusid"))
                {
                    if (m.campusid > 0)
                    {
                        UpdateField(psb, p, "CampusId", m.campusid);
                    }
                }
            }
            if (m.AskChurch)
            {
                if (keys.Contains("activeother"))
                {
                    if (m.activeother.ToBool() != rr.ActiveInAnotherChurch)
                    {
                        p.SetRecReg().ActiveInAnotherChurch = m.activeother.ToBool();
                    }
                }
            }
            if (m.AskChurchName)
            {
                if (keys.Contains("churchname"))
                {
                    UpdateField(psb, p, "OtherPreviousChurch", Trim(m.churchname));
                }
            }

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() && (psb.Count > 0 || fsb.Count > 0))
            {
                var sb = new StringBuilder();
                foreach (var c in psb)
                {
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                }
                foreach (var c in fsb)
                {
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                }
                var np = DbUtil.Db.GetNewPeopleManagers();
                if (np != null)
                {
                    DbUtil.Db.EmailRedacted(p.FromEmail, np,
                                            "Basic Person Info Changed during checkin on " + Util.Host, $@"
<p><a href=""{DbUtil.Db.ServerLink("/Person2/" + p.PeopleId)}"">{Util.UserName} ({p.PeopleId})</a> changed the following information for {p.PreferredName} ({p.LastName}):</p>
<table>{sb}</table>");
                }
            }
        }
Пример #11
0
        private void UpdatePerson(Person p, PersonInfo m)
        {
            var psb = new List<ChangeDetail>();
            var fsb = new List<ChangeDetail>();
            var z = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());
            if (!m.home.HasValue() && m.cell.HasValue())
                m.home = m.cell;

            var keys = Request.Form.AllKeys.ToList();

            if (keys.Contains("home"))
                p.Family.UpdateValue(fsb, "HomePhone", m.home.GetDigits());
            if (keys.Contains("addr"))
                p.Family.UpdateValue(fsb, "AddressLineOne", m.addr);
            if (keys.Contains("zip"))
            {
                p.Family.UpdateValue(fsb, "CityName", z != null ? z.City : null);
                p.Family.UpdateValue(fsb, "StateCode", z != null ? z.State : null);
                p.Family.UpdateValue(fsb, "ZipCode", m.zip);
                var rc = DbUtil.Db.FindResCode(m.zip, null);
                p.Family.UpdateValue(fsb, "ResCodeId", rc.ToString());
            }
            if (keys.Contains("goesby"))
                p.UpdateValue(psb, "NickName", Trim(m.goesby));
            if (keys.Contains("first"))
                p.UpdateValue(psb, "FirstName", Trim(m.first));
            if (keys.Contains("last"))
                p.UpdateValue(psb, "LastName", Trim(m.last));
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                    p.UpdateValue(psb, "DOB", m.dob);
            }
            if (keys.Contains("email"))
                p.UpdateValue(psb, "EmailAddress", Trim(m.email));
            if (keys.Contains("cell"))
                p.UpdateValue(psb, "CellPhone", m.cell.GetDigits());
            if (keys.Contains("marital"))
                p.UpdateValue(psb, "MaritalStatusId", m.marital);
            if (keys.Contains("gender"))
                p.UpdateValue(psb, "GenderId", m.gender);

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (!DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() || (psb.Count <= 0 && fsb.Count <= 0))
                return;
            var sb = new StringBuilder();
            foreach (var c in psb)
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            foreach (var c in fsb)
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            DbUtil.Db.EmailRedacted(p.FromEmail, DbUtil.Db.GetNewPeopleManagers(),
                "Basic Person Info Changed during checkin on " + Util.Host,
                "{0} changed the following information for {1} ({2}):<br />\n<table>{3}</table>"
                    .Fmt(Util.UserName, p.PreferredName, p.LastName, sb.ToString()));
        }
Пример #12
0
        private void UpdatePerson(Person p, PersonInfo m, bool isNew)
        {
            var psb = new StringBuilder();
            var fsb = new StringBuilder();
            var z = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());
            if (!m.home.HasValue() && m.cell.HasValue())
                m.home = m.cell;

            var keys = Request.Form.AllKeys.ToList();

            if (keys.Contains("home"))
                UpdateField(fsb, p.Family, "HomePhone", m.home.GetDigits());
            if (keys.Contains("addr"))
                UpdateField(fsb, p.Family, "AddressLineOne", m.addr);
            if (keys.Contains("zip"))
            {
                UpdateField(fsb, p.Family, "CityName", z != null ? z.City : null);
                UpdateField(fsb, p.Family, "StateCode", z != null ? z.State : null);
                UpdateField(fsb, p.Family, "ZipCode", m.zip);
            }
            if (keys.Contains("goesby"))
                UpdateField(psb, p, "NickName", Trim(m.goesby));
            if (keys.Contains("first"))
                UpdateField(psb, p, "FirstName", Trim(m.first));
            if (keys.Contains("last"))
                UpdateField(psb, p, "LastName", Trim(m.last));
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                    UpdateField(psb, p, "DOB", m.dob);
            }
            if (keys.Contains("email"))
                UpdateField(psb, p, "EmailAddress", Trim(m.email));
            if (keys.Contains("cell"))
                UpdateField(psb, p, "CellPhone", m.cell.GetDigits());
            if (keys.Contains("marital"))
                UpdateField(psb, p, "MaritalStatusId", m.marital);
            if (keys.Contains("gender"))
                UpdateField(psb, p, "GenderId", m.gender);

            var rr = p.GetRecReg();
            if (keys.Contains("allergies"))
                if (m.allergies != rr.MedicalDescription)
                    p.SetRecReg().MedicalDescription = m.allergies;
            if (keys.Contains("grade"))
                if (m.AskGrade)
                    if (m.grade.ToInt2() != p.Grade)
                        p.Grade = m.grade.ToInt2();
            if (m.AskEmFriend)
            {
                if (keys.Contains("parent"))
                    if (m.parent != rr.Mname)
                        p.SetRecReg().Mname = m.parent;
                if (keys.Contains("emfriend"))
                    if (m.emfriend != rr.Emcontact)
                        p.SetRecReg().Emcontact = m.emfriend;
                if (keys.Contains("emphone"))
                    if (m.emphone != rr.Emphone)
                        p.SetRecReg().Emphone = m.emphone;
            }
            if (isNew)
            {
                if (keys.Contains("campusid"))
                    if (m.campusid > 0)
                        UpdateField(psb, p, "CampusId", m.campusid);
            }
            if (m.AskChurch)
                if (keys.Contains("activeother"))
                    if (m.activeother.ToBool() != rr.ActiveInAnotherChurch)
                        p.SetRecReg().ActiveInAnotherChurch = m.activeother.ToBool();
            if (m.AskChurchName)
                if (keys.Contains("churchname"))
                    UpdateField(psb, p, "OtherPreviousChurch", Trim(m.churchname));

            p.LogChanges(DbUtil.Db, psb, Util.UserPeopleId ?? 0);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() && (psb.Length > 0 || fsb.Length > 0))
            {
                DbUtil.Db.EmailRedacted(p.FromEmail, DbUtil.Db.GetNewPeopleManagers(),
                    "Basic Person Info Changed during checkin on " + Util.Host,
                    "{0} changed the following information for {1} ({2}):<br />\n<table>{3}{4}</table>"
                    .Fmt(Util.UserName, p.PreferredName, p.LastName, psb.ToString(), fsb.ToString()));
            }
        }
Пример #13
0
        private void UpdatePerson(Person p, PersonInfo m, bool isNew)
        {
            var psb = new List <ChangeDetail>();
            var fsb = new List <ChangeDetail>();
            var z   = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());

            if (!m.home.HasValue() && m.cell.HasValue())
            {
                m.home = m.cell;
            }

            var keys = Request.Form.AllKeys.ToList();

            if (keys.Contains("home"))
            {
                UpdateField(fsb, p.Family, "HomePhone", m.home.GetDigits());
            }
            if (keys.Contains("addr"))
            {
                UpdateField(fsb, p.Family, "AddressLineOne", m.addr);
            }
            if (keys.Contains("zip"))
            {
                UpdateField(fsb, p.Family, "CityName", z != null ? z.City : null);
                UpdateField(fsb, p.Family, "StateCode", z != null ? z.State : null);
                UpdateField(fsb, p.Family, "ZipCode", m.zip);
                var rc = DbUtil.Db.FindResCode(m.zip, null);
                UpdateField(fsb, p.Family, "ResCodeId", rc.ToString());
            }
            if (keys.Contains("goesby"))
            {
                UpdateField(psb, p, "NickName", Trim(m.goesby));
            }
            if (keys.Contains("first"))
            {
                UpdateField(psb, p, "FirstName", Trim(m.first));
            }
            if (keys.Contains("last"))
            {
                UpdateField(psb, p, "LastName", Trim(m.last));
            }
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                {
                    UpdateField(psb, p, "DOB", m.dob);
                }
            }
            if (keys.Contains("email"))
            {
                UpdateField(psb, p, "EmailAddress", Trim(m.email));
            }
            if (keys.Contains("cell"))
            {
                UpdateField(psb, p, "CellPhone", m.cell.GetDigits());
            }
            if (keys.Contains("marital"))
            {
                UpdateField(psb, p, "MaritalStatusId", m.marital);
            }
            if (keys.Contains("gender"))
            {
                UpdateField(psb, p, "GenderId", m.gender);
            }

            var rr = p.GetRecReg();

            if (keys.Contains("allergies"))
            {
                if (m.allergies != rr.MedicalDescription)
                {
                    p.SetRecReg().MedicalDescription = m.allergies;
                }
            }
            if (keys.Contains("grade"))
            {
                if (m.AskGrade)
                {
                    if (m.grade.ToInt2() != p.Grade)
                    {
                        p.Grade = m.grade.ToInt2();
                    }
                }
            }
            if (m.AskEmFriend)
            {
                if (keys.Contains("parent"))
                {
                    if (m.parent != rr.Mname)
                    {
                        p.SetRecReg().Mname = m.parent;
                    }
                }
                if (keys.Contains("emfriend"))
                {
                    if (m.emfriend != rr.Emcontact)
                    {
                        p.SetRecReg().Emcontact = m.emfriend;
                    }
                }
                if (keys.Contains("emphone"))
                {
                    if (m.emphone != rr.Emphone)
                    {
                        p.SetRecReg().Emphone = m.emphone;
                    }
                }
            }
            if (isNew)
            {
                if (keys.Contains("campusid"))
                {
                    if (m.campusid > 0)
                    {
                        UpdateField(psb, p, "CampusId", m.campusid);
                    }
                }
            }
            if (m.AskChurch)
            {
                if (keys.Contains("activeother"))
                {
                    if (m.activeother.ToBool() != rr.ActiveInAnotherChurch)
                    {
                        p.SetRecReg().ActiveInAnotherChurch = m.activeother.ToBool();
                    }
                }
            }
            if (m.AskChurchName)
            {
                if (keys.Contains("churchname"))
                {
                    UpdateField(psb, p, "OtherPreviousChurch", Trim(m.churchname));
                }
            }

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() && (psb.Count > 0 || fsb.Count > 0))
            {
                var sb = new StringBuilder();
                foreach (var c in psb)
                {
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                }
                foreach (var c in fsb)
                {
                    sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
                }
                var np = DbUtil.Db.GetNewPeopleManagers();
                if (np != null)
                {
                    DbUtil.Db.EmailRedacted(p.FromEmail, np,
                                            "Basic Person Info Changed during checkin on " + Util.Host,
                                            "{0} changed the following information for {1} ({2}):<br />\n<table>{3}</table>"
                                            .Fmt(Util.UserName, p.PreferredName, p.LastName, sb.ToString()));
                }
            }
        }
Пример #14
0
        private void UpdatePerson(Person p, PersonInfo m)
        {
            var psb = new List <ChangeDetail>();
            var fsb = new List <ChangeDetail>();
            var z   = DbUtil.Db.ZipCodes.SingleOrDefault(zc => zc.Zip == m.zip.Zip5());

            if (!m.home.HasValue() && m.cell.HasValue())
            {
                m.home = m.cell;
            }

            var keys = Request.Form.AllKeys.ToList();

            if (keys.Contains("home"))
            {
                p.Family.UpdateValue(fsb, "HomePhone", m.home.GetDigits());
            }
            if (keys.Contains("addr"))
            {
                p.Family.UpdateValue(fsb, "AddressLineOne", m.addr);
            }
            if (keys.Contains("zip"))
            {
                p.Family.UpdateValue(fsb, "CityName", z != null ? z.City : null);
                p.Family.UpdateValue(fsb, "StateCode", z != null ? z.State : null);
                p.Family.UpdateValue(fsb, "ZipCode", m.zip);
                var rc = DbUtil.Db.FindResCode(m.zip, null);
                p.Family.UpdateValue(fsb, "ResCodeId", rc.ToString());
            }
            if (keys.Contains("goesby"))
            {
                p.UpdateValue(psb, "NickName", Trim(m.goesby));
            }
            if (keys.Contains("first"))
            {
                p.UpdateValue(psb, "FirstName", Trim(m.first));
            }
            if (keys.Contains("last"))
            {
                p.UpdateValue(psb, "LastName", Trim(m.last));
            }
            if (keys.Contains("dob"))
            {
                DateTime dt;
                DateTime.TryParse(m.dob, out dt);
                if (p.BirthDate != dt)
                {
                    p.UpdateValue(psb, "DOB", m.dob);
                }
            }
            if (keys.Contains("email"))
            {
                p.UpdateValue(psb, "EmailAddress", Trim(m.email));
            }
            if (keys.Contains("cell"))
            {
                p.UpdateValue(psb, "CellPhone", m.cell.GetDigits());
            }
            if (keys.Contains("marital"))
            {
                p.UpdateValue(psb, "MaritalStatusId", m.marital);
            }
            if (keys.Contains("gender"))
            {
                p.UpdateValue(psb, "GenderId", m.gender);
            }

            p.LogChanges(DbUtil.Db, psb);
            p.Family.LogChanges(DbUtil.Db, fsb, p.PeopleId, Util.UserPeopleId ?? 0);
            DbUtil.Db.SubmitChanges();
            if (!DbUtil.Db.Setting("NotifyCheckinChanges", "true").ToBool() || (psb.Count <= 0 && fsb.Count <= 0))
            {
                return;
            }
            var sb = new StringBuilder();

            foreach (var c in psb)
            {
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            }
            foreach (var c in fsb)
            {
                sb.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>\n", c.Field, c.Before, c.After);
            }
            var np = DbUtil.Db.GetNewPeopleManagers();

            if (np != null)
            {
                DbUtil.Db.EmailRedacted(p.FromEmail, np,
                                        "Basic Person Info Changed during checkin on " + Util.Host,
                                        "{0} changed the following information for {1} ({2}):<br />\n<table>{3}</table>"
                                        .Fmt(Util.UserName, p.PreferredName, p.LastName, sb.ToString()));
            }
        }