internal SavedAttendanceModal GetSavedAttendance(string actCode, DateTime actDate)
        {
            var tableResponse = _dbConnection.GetModelDetails(RawSQL.GetSavedAttendance(actCode, actDate));
            SavedAttendanceModal peopleList = new SavedAttendanceModal();
            List <SavedAttendancePeopleModal> attendPeopleList = new List <SavedAttendancePeopleModal>();

            foreach (DataRow dataRow in tableResponse.AsEnumerable())
            {
                var record = new SavedAttendancePeopleModal()
                {
                    BranchName   = "OD Branch",
                    Gender       = dataRow.Field <string>("Gender"),
                    Name         = dataRow.Field <string>("Name_Full"),
                    IniJigStatus = dataRow.Field <string>("INI_JIG_NON") == "INI" ? "Initiated"
                                    : dataRow.Field <string>("INI_JIG_NON") == "CHL" ? "Child"
                                    : dataRow.Field <string>("INI_JIG_NON") == "OTH" ? "Other"
                                    : dataRow.Field <string>("INI_JIG_NON") == "JIG" ? "Jigyasu" : "",
                    IsSantSu = dataRow.Field <string>("Sant_su") != null ? "Y": "N",
                    UidNo    = dataRow.Field <string>("UID_No") ?? "",
                    RollNo   = dataRow.Field <Int16>("Roll_No").ToString()
                };
                attendPeopleList.Add(record);
            }
            peopleList.SavedAttendancePeopleModals = attendPeopleList;
            peopleList.SavedAttendancePeopleModals.AddRange(GetSavedVisitorsAttendance(actCode, actDate));

            var actRes = _dbConnection.GetModelDetails(RawSQL.GetSingleActivity(actCode, actDate));

            peopleList.ActivityDate = actDate;
            peopleList.ActivityName = actRes.AsEnumerable().FirstOrDefault()?.Field <string>("ActName");
            return(peopleList);
        }
        private List <SavedAttendancePeopleModal> GetSavedVisitorsAttendance(string actCode, DateTime actDate)
        {
            var tableResponse = _dbConnection.GetModelDetails(RawSQL.GetSaveVisitorsAttendance(actCode, actDate));
            List <SavedAttendancePeopleModal> attendPeopleList = new List <SavedAttendancePeopleModal>();

            foreach (DataRow dataRow in tableResponse.AsEnumerable())
            {
                var record = new SavedAttendancePeopleModal()
                {
                    BranchName   = "Visitors Branch",
                    Gender       = dataRow.Field <string>("Gender"),
                    Name         = dataRow.Field <string>("VisitorName"),
                    IniJigStatus = dataRow.Field <string>("Initiated").ToLower() == "yes" ? "Initiated"
                                    : "Other"
                };
                attendPeopleList.Add(record);
            }
            return(attendPeopleList);
        }