public static List <DayCarePL.ChildAttendenceHistoryProperties> LoadChildAttendanceHistoryList(Guid ChildSchoolYearId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildList, "LoadChildAttendanceHistoryList", "LoadChildAttendanceHistoryList method called", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); List <DayCarePL.ChildAttendenceHistoryProperties> lstChildAttendance = new List <DayCarePL.ChildAttendenceHistoryProperties>(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFamilyPayment, "LoadChildAttendanceHistoryList", "Debug LoadChildAttendanceHistoryList called", DayCarePL.Common.GUID_DEFAULT); DayCarePL.ChildAttendenceHistoryProperties objChildAttendanceHistory = null; var data = db.spChildAttendanceHistoryList(ChildSchoolYearId); foreach (var c in data) { objChildAttendanceHistory = new DayCarePL.ChildAttendenceHistoryProperties(); objChildAttendanceHistory.Id = c.id; objChildAttendanceHistory.CheckInCheckOutDateTime = Convert.ToDateTime(c.Date); if (c.CheckIn != null) { objChildAttendanceHistory.CheckInTime = Convert.ToDateTime(c.CheckIn); } if (c.CheckOut != null) { objChildAttendanceHistory.CheckOutTime = Convert.ToDateTime(c.CheckOut); } objChildAttendanceHistory.ChildName = c.Name; lstChildAttendance.Add(objChildAttendanceHistory); } return(lstChildAttendance); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildProgEnrollment, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }