internal BranchPeoplePaginationAttendance GetPeoplesIndividualAttendance(BranchPeopleAttendance branchPeopleAttendance) { var tableResponse = _dbConnection.GetModelDetails(RawSQL.ReportsBranchIndividualAttendance(branchPeopleAttendance)); List <BranchPeopleAttendance> lst = new List <BranchPeopleAttendance>(); foreach (DataRow dataRow in tableResponse.AsEnumerable()) { var record = new BranchPeopleAttendance() { UidNo = dataRow.Field <string>("UID_No") ?? "", Name = dataRow.Field <string>("Name_Full"), RollNo = Convert.ToInt32(dataRow.Field <double>("Roll_No")), BrTitle = dataRow.Field <string>("INI_JIG_NON") == "INI" ? "Initiated" : dataRow.Field <string>("INI_JIG_NON") == "CHL" ? "Children" : dataRow.Field <string>("INI_JIG_NON") == "OTH" ? "Other" : dataRow.Field <string>("INI_JIG_NON") == "JIG" ? "Jigyasu" : "", AttendanceCount = dataRow.Field <int?>("AttendanceCount"), ActivityName = dataRow.Field <string>("Act_Name"), AttendanceDate = dataRow.Field <DateTime?>("Act_Date") }; lst.Add(record); } var finalLst = new BranchPeoplePaginationAttendance { BranchPeopleAttendance = lst, Count = 0 }; return(finalLst); }
internal BranchPeoplePaginationAttendance GetPeopleAttendance(BranchPeopleAttendance branchPeopleAttendance, int page) { var lst = new List <BranchPeopleAttendance>(); // Users Attendance var tableResponse = _dbConnection.GetModelDetails(RawSQL.ReportsBranchPeopleAttendance(branchPeopleAttendance)); foreach (DataRow dataRow in tableResponse.AsEnumerable()) { var record = new BranchPeopleAttendance { UidNo = dataRow.Field <string>("UID_No") ?? "", Name = dataRow.Field <string>("Name_Full"), RollNo = Convert.ToInt32(dataRow.Field <double>("Roll_No")), BrTitle = dataRow.Field <string>("INI_JIG_NON") == "INI" ? "Initiated" : dataRow.Field <string>("INI_JIG_NON") == "CHL" ? "Children" : dataRow.Field <string>("INI_JIG_NON") == "OTH" ? "Other" : dataRow.Field <string>("INI_JIG_NON") == "JIG" ? "Jigyasu" : "", AttendanceCount = dataRow.Field <int?>("AttendanceCount"), ActivityName = dataRow.Field <string>("Act_Name"), SingleActivityCode = dataRow.Field <string>("Act_cd"), AttendanceDate = dataRow.Field <DateTime?>("Act_Date"), MobileNum = dataRow.Field <string>("Mobile") }; lst.Add(record); } // Visitors Attendance Result var visitorsAttendance = _dbConnection.GetModelDetails(RawSQL.ReportsBranchVisitorsPeopleSummary(branchPeopleAttendance.ActivityCode, branchPeopleAttendance.StartDate, branchPeopleAttendance.EndDate)); foreach (DataRow dataRow in visitorsAttendance.AsEnumerable()) { var record = new BranchPeopleAttendance() { BrTitle = dataRow.Field <string>("Initiated").ToLower() == "yes".ToLower() ? "Initiated" : "Other", ActivityName = dataRow.Field <string>("Act_Name"), AttendanceDate = dataRow.Field <DateTime?>("Act_Date"), IsVisitors = true }; lst.Add(record); } // Voided Records var tableResponseVoidedRec = _dbConnection.GetModelDetails(RawSQL.ReportsBranchPeopleAttendanceVoided(branchPeopleAttendance.ActivityCode, branchPeopleAttendance.StartDate, branchPeopleAttendance.EndDate)); foreach (DataRow dataRow in tableResponseVoidedRec.AsEnumerable()) { var record = new BranchPeopleAttendance { UidNo = "NA", Name = "NA", RollNo = -1, BrTitle = "NA", AttendanceCount = -1, ActivityName = dataRow.Field <string>("Act_Name"), SingleActivityCode = dataRow.Field <string>("Act_cd"), AttendanceDate = dataRow.Field <DateTime?>("Act_Date"), MobileNum = "NA" }; lst.Add(record); } var count = lst.Count(); var finalLst = new BranchPeoplePaginationAttendance { BranchPeopleAttendance = lst.Skip((page - 1) * 500).Take(500).ToList(), Count = count }; return(finalLst); }