public static List <DayCarePL.ChildDataProperties> GetAllActiveChildListForImport(Guid CurrentSchoolYearId, Guid SchoolId) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildSchoolYear, "GetAllActiveChildListForImport", "Execute GetAllActiveChildListForImport Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildSchoolYear, "GetAllActiveChildListForImport", "Debug GetAllActiveChildListForImport Method", DayCarePL.Common.GUID_DEFAULT); var Data = db.spGetAllActiveChildListForImport(CurrentSchoolYearId, SchoolId); DayCarePL.ChildDataProperties objChildData; List <DayCarePL.ChildDataProperties> lstChildData = new List <DayCarePL.ChildDataProperties>(); foreach (var d in Data) { objChildData = new DayCarePL.ChildDataProperties(); objChildData.ChildDataId = d.ChildDataId; objChildData.FullName = d.FullName; objChildData.FamilyName = d.FamilyName; objChildData.ChildFamilyId = d.ChildFamilyId; objChildData.ImportedCount = d.ImportedCount == null ? 0 : d.ImportedCount.Value; lstChildData.Add(objChildData); } return(lstChildData);; } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildSchoolYear, "GetAllActiveChildListForImport", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(new List <DayCarePL.ChildDataProperties>()); } }