Exemplo n.º 1
0
        public static RecRegInfo GetRecRegInfo(int id)
        {
            var q = from r in DbUtil.Db.RecRegs
                    where r.PeopleId == id
                    orderby r.Id descending
                    select new RecRegInfo
            {
                PeopleId    = id,
                Comments    = r.Comments,
                coaching    = r.Coaching,
                docphone    = r.Docphone,
                emcontact   = r.Emcontact,
                doctor      = r.Doctor,
                emphone     = r.Emphone,
                fname       = r.Fname,
                insurance   = r.Insurance,
                medical     = r.MedicalDescription,
                tylenol     = r.Tylenol,
                advil       = r.Advil,
                robitussin  = r.Robitussin,
                maalox      = r.Maalox,
                member      = r.Member ?? false,
                mname       = r.Mname,
                otherchurch = r.ActiveInAnotherChurch ?? false,
                policy      = r.Policy,
                shirtsize   = r.ShirtSize,
                custody     = r.Person.CustodyIssue,
                transport   = r.Person.OkTransport,
            };
            var rr = q.FirstOrDefault();

            if (rr == null)
            {
                rr = new RecRegInfo {
                    PeopleId = id
                }
            }
            ;
            return(rr);
        }
Exemplo n.º 2
0
 public static RecRegInfo GetRecRegInfo(int id)
 {
     var q = from r in DbUtil.Db.RecRegs
             where r.PeopleId == id
             orderby r.Id descending
             select new RecRegInfo
             {
                 PeopleId = id,
                 Comments = r.Comments,
                 coaching = r.Coaching,
                 docphone = r.Docphone,
                 emcontact = r.Emcontact,
                 doctor = r.Doctor,
                 emphone = r.Emphone,
                 fname = r.Fname,
                 insurance = r.Insurance,
                 medical = r.MedicalDescription,
                 tylenol = r.Tylenol,
                 advil = r.Advil,
                 robitussin = r.Robitussin,
                 maalox = r.Maalox,
                 member = r.Member ?? false,
                 mname = r.Mname,
                 otherchurch = r.ActiveInAnotherChurch ?? false,
                 policy = r.Policy,
                 shirtsize = r.ShirtSize,
                 custody = r.Person.CustodyIssue,
                 transport = r.Person.OkTransport,
             };
     var rr = q.FirstOrDefault();
     if (rr == null)
         rr = new RecRegInfo { PeopleId = id };
     return rr;
 }