public static List <DayCarePL.ChildEnrollmentStatusProperties> LoadChildEnrollmentStatus(Guid SchoolId, Guid ChildSchoolYearId)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", "Execute LoadChildEnrollmentStatus Method", DayCarePL.Common.GUID_DEFAULT);
            DayCareDataContext db = new DayCareDataContext();
            List <DayCarePL.ChildEnrollmentStatusProperties> lstChildEnrollmentStatus = new List <DayCarePL.ChildEnrollmentStatusProperties>();

            DayCarePL.ChildEnrollmentStatusProperties objChildEnrollmentStatus = null;
            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", "Debug LoadChildEnrollmentStatus Method", DayCarePL.Common.GUID_DEFAULT);
                var data = db.spGetChildEnrollmentStatus(SchoolId, ChildSchoolYearId);
                foreach (var d in data)
                {
                    objChildEnrollmentStatus    = new DayCarePL.ChildEnrollmentStatusProperties();
                    objChildEnrollmentStatus.Id = d.Id;
                    objChildEnrollmentStatus.EnrollmentStatusId = d.EnrollmentStatusId;
                    objChildEnrollmentStatus.EnrollmentStatus   = d.Status;
                    objChildEnrollmentStatus.ChildSchoolYearId  = d.ChildSchoolYearId;
                    objChildEnrollmentStatus.EnrollmentDate     = d.EnrollmentDate;
                    objChildEnrollmentStatus.Comments           = d.Comments;
                    lstChildEnrollmentStatus.Add(objChildEnrollmentStatus);
                    objChildEnrollmentStatus = null;
                }
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildEnrollmentStatus, "LoadChildEnrollmentStatus", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
            }
            return(lstChildEnrollmentStatus);
        }