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());
}
