Beispiel #1
0
        public ContentResult RecordAttend2(int PeopleId, int OrgId, bool Present, string hour, string kiosk)
        {
            if (!Authenticate())
            {
                return(Content("not authorized"));
            }

            DbUtil.LogActivity($"checkin {PeopleId}, {OrgId}, {(Present ? "attend" : "unattend")}");
            DateTime dt;

            if (Util.IsCultureUS())
            {
                if (!hour.DateTryParse(out dt))
                {
                    return(Content("date not parsed"));
                }
            }
            else
            {
                if (!hour.DateTryParseUS(out dt))
                {
                    return(Content("date not parsed"));
                }
            }
            Attend.RecordAttend(CurrentDatabase, PeopleId, OrgId, Present, dt);
            var r = new ContentResult();

            r.Content = "success";
            return(r);
        }
Beispiel #2
0
        public void recordAttendance(CMSDataContext dataContext)
        {
            foreach (Attendance attendance in attendances)
            {
                foreach (AttendanceGroup group in attendance.groups)
                {
                    Attend.RecordAttend(dataContext, attendance.peopleID, group.groupID, group.present, group.datetime);

                    Attend attend = dataContext.Attends.FirstOrDefault(a => a.PeopleId == attendance.peopleID && a.OrganizationId == group.groupID && a.MeetingDate == group.datetime);

                    if (attend == null)
                    {
                        continue;
                    }

                    if (group.present)
                    {
                        attend.SubGroupID   = group.subgroupID;
                        attend.SubGroupName = group.subgroupName;
                    }
                    else
                    {
                        attend.SubGroupID   = 0;
                        attend.SubGroupName = "";
                    }

                    if (group.join)
                    {
                        joinToOrg(dataContext, attendance.peopleID, group.groupID);
                    }
                }

                dataContext.SubmitChanges();
            }
        }
Beispiel #3
0
        public ContentResult RecordAttend2(int PeopleId, int OrgId, bool Present, DateTime hour, string kiosk)
        {
            if (!Authenticate())
            {
                return(Content("not authorized"));
            }
            DbUtil.LogActivity($"checkin {PeopleId}, {OrgId}, {(Present ? "attend" : "unattend")}");
            Attend.RecordAttend(DbUtil.Db, PeopleId, OrgId, Present, hour);
            var r = new ContentResult();

            r.Content = "success";
            return(r);
        }
Beispiel #4
0
        public void RecentAttendCount_Should_Work()
        {
            var code = "RecentAttendCount( Days=2, Org=36[App Testing Org] ) = 1";

            var org = 36;
            var pid = 2;
            var dt  = DateTime.Today.AddHours(-10);

            Attend.RecordAttend(db, pid, org, true, dt);
            db.SubmitChanges();
            var qb    = db.PeopleQuery2(code);
            var count = qb.Count();

            db.ExecuteCommand("DELETE dbo.attend where OrganizationId = {0} AND MeetingDate = {1}", org, dt);
            db.ExecuteCommand("DELETE dbo.meetings where OrganizationId = {0} AND MeetingDate = {1}", org, dt);

            count.ShouldBe(1);
        }
Beispiel #5
0
        public void RecentVisitNumberOrgs()
        {
            var code = "RecentVisitNumberOrgs( VisitNumber='2', Days=2, Org=36[App Testing Org] ) = 1";

            var org = 36;
            var pid = 2;
            var dt1 = DateTime.Today.AddHours(-10);
            var dt2 = dt1.AddDays(-1);

            Attend.RecordAttend(db, pid, org, true, dt1);
            Attend.RecordAttend(db, pid, org, true, dt2);
            db.SubmitChanges();
            var qb    = db.PeopleQuery2(code);
            var count = qb.Count();

            db.ExecuteCommand("DELETE dbo.attend where OrganizationId = {0} AND MeetingDate IN ({1}, {2})", org, dt1, dt2);
            db.ExecuteCommand("DELETE dbo.meetings where OrganizationId = {0} AND MeetingDate IN ({1}, {2})", org, dt1, dt2);

            count.ShouldBe(1);
        }
        public ActionResult RecordAttend(string data)
        {
            // Authenticate first
            if (!Auth())
            {
                return(CheckInMessage.createErrorReturn("Authentication failed, please try again", CheckInMessage.API_ERROR_INVALID_CREDENTIALS));
            }

            CheckInMessage dataIn = CheckInMessage.createFromString(data);
            CheckInAttend  cia    = JsonConvert.DeserializeObject <CheckInAttend>(dataIn.data);

            Meeting meeting = CurrentDatabase.Meetings.SingleOrDefault(m => m.OrganizationId == cia.orgID && m.MeetingDate == cia.datetime);

            if (meeting == null)
            {
                int meetingID = CurrentDatabase.CreateMeeting(cia.orgID, cia.datetime);

                meeting = CurrentDatabase.Meetings.SingleOrDefault(m => m.MeetingId == meetingID);
            }

            Attend.RecordAttend(CurrentDatabase, cia.peopleID, cia.orgID, cia.present, cia.datetime);

            CurrentDatabase.UpdateMeetingCounters(cia.orgID);
            DbUtil.LogActivity($"Check-In Record Attend Org ID:{cia.orgID} People ID:{cia.peopleID} User ID:{CurrentDatabase.UserPeopleId} Attended:{cia.present}");

            // Check Entry Point and replace if Check-In
            Person person = CurrentDatabase.People.FirstOrDefault(p => p.PeopleId == cia.peopleID);

            if (person != null && person.EntryPoint != null && person.EntryPoint.Code != null && person.EntryPoint.Code == "CHECKIN" && meeting != null)
            {
                person.EntryPoint = meeting.Organization.EntryPoint;
                CurrentDatabase.SubmitChanges();
            }

            CheckInMessage br = new CheckInMessage();

            br.setNoError();
            br.count = 1;

            return(br);
        }
Beispiel #7
0
        public ContentResult BuildingCheckin(int id, string location, int accesstype, int?guestof)
        {
            if (!Authenticate())
            {
                return(Content("not authorized"));
            }

            CheckInTime g = null;

            if (guestof != null)
            {
                g = (from e in DbUtil.Db.CheckInTimes
                     where e.Id == guestof
                     select e).FirstOrDefault();
            }

            var reader = new StreamReader(Request.InputStream);
            var s      = reader.ReadToEnd();

            if (!s.HasValue())
            {
                s = "<Activities />";
            }

            var xs         = new XmlSerializer(typeof(List <Activity>), new XmlRootAttribute("Activities"));
            var activities = xs.Deserialize(new StringReader(s)) as List <Activity>;

            var last = from e in DbUtil.Db.CheckInTimes
                       where e.PeopleId == id
                       where e.CheckInTimeX <= DateTime.Now
                       where e.CheckInTimeX >= DateTime.Now.AddHours(-1.5)
                       select e;

            if (guestof == null)
            {
                last = from f in last
                       where f.GuestOfId == null
                       select f;
            }
            else
            {
                last = from f in last
                       where f.GuestOfId == guestof
                       select f;
            }

            CheckInTime ac = null;

            if (last.Any())
            {
                ac = last.Single();

                foreach (var e in ac.CheckInActivities)
                {
                    DbUtil.Db.CheckInActivities.DeleteOnSubmit(e);
                }

                DbUtil.Db.SubmitChanges();

                foreach (var a in activities)
                {
                    ac.CheckInActivities.Add(new CheckInActivity {
                        Activity = a.Name
                    });
                }

                ac.AccessTypeID = accesstype;
            }
            else
            {
                ac = new CheckInTime
                {
                    PeopleId        = id,
                    Location        = location,
                    CheckInTimeX    = DateTime.Now,
                    GuestOfId       = guestof,
                    GuestOfPersonID = (g != null ? g.PeopleId ?? 0 : 0),
                    AccessTypeID    = accesstype
                };

                foreach (var a in activities)
                {
                    ac.CheckInActivities.Add(new CheckInActivity {
                        Activity = a.Name
                    });
                }

                DbUtil.Db.CheckInTimes.InsertOnSubmit(ac);
            }


            DbUtil.Db.SubmitChanges();

            foreach (var a in activities)
            {
                if (a.org > 0)
                {
                    Attend.RecordAttend(DbUtil.Db, id, a.org, true, DateTime.Today);
                }
            }

            return(Content(ac.Id.ToString()));
        }