public IQueryable<MonthlyAttendanceSummary> GetFamilyAttendance(int personId, int monthCount) { List<MonthlyAttendanceSummary> attendanceSummary = new List<MonthlyAttendanceSummary>(); Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("PersonId", personId); parameters.Add("MonthCount", monthCount); var table = DbService.GetDataTable( "spCheckin_BadgeAttendance", System.Data.CommandType.StoredProcedure, parameters ); if (table != null) { foreach (DataRow row in table.Rows) { MonthlyAttendanceSummary item = new MonthlyAttendanceSummary(); item.AttendanceCount = row["AttendanceCount"].ToString().AsInteger(); item.SundaysInMonth = row["SundaysInMonth"].ToString().AsInteger(); item.Month = row["Month"].ToString().AsInteger(); item.Year = row["Year"].ToString().AsInteger(); attendanceSummary.Add(item); } } return attendanceSummary.AsQueryable(); }
public IQueryable <MonthlyAttendanceSummary> GetFamilyAttendance(int personId, int monthCount) { List <MonthlyAttendanceSummary> attendanceSummary = new List <MonthlyAttendanceSummary>(); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("PersonId", personId); parameters.Add("MonthCount", monthCount); var table = DbService.GetDataTable("spCheckin_BadgeAttendance", System.Data.CommandType.StoredProcedure, parameters); if (table != null) { foreach (DataRow row in table.Rows) { MonthlyAttendanceSummary item = new MonthlyAttendanceSummary(); item.AttendanceCount = row["AttendanceCount"].ToString().AsInteger(); item.SundaysInMonth = row["SundaysInMonth"].ToString().AsInteger(); item.Month = row["Month"].ToString().AsInteger(); item.Year = row["Year"].ToString().AsInteger(); attendanceSummary.Add(item); } } return(attendanceSummary.AsQueryable()); }
public IQueryable <MonthlyAttendanceSummary> GetFamilyAttendanceForGroupType(int personId, int monthCount, string idList, bool recursive) { //If recursive, id list is a list of group IDs, else it's a list of group type ids var attendanceSummary = new List <MonthlyAttendanceSummary>(); if (recursive) { var groupTypeIds = idList.SplitDelimitedValues().AsIntegerList(); var groupIds = new ChildCheckInGroupGenerator().Get(groupTypeIds).Select(g => g.Id).ToList(); idList = string.Join(",", groupIds); } Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("PersonId", personId); parameters.Add("MonthCount", monthCount); parameters.Add("idList", idList); //Tell the SQL if it's dealing with groups or grouptypes parameters.Add("groups", recursive); var table = DbService.GetDataTable("spBricksandMortarStudio_BadgeAttendanceWithGroupType", CommandType.StoredProcedure, parameters); if (table != null) { foreach (DataRow row in table.Rows) { var item = new MonthlyAttendanceSummary(); item.AttendanceCount = row["AttendanceCount"].ToString().AsInteger(); item.SundaysInMonth = row["SundaysInMonth"].ToString().AsInteger(); item.Month = row["Month"].ToString().AsInteger(); item.Year = row["Year"].ToString().AsInteger(); attendanceSummary.Add(item); } } return(attendanceSummary.AsQueryable()); }