public static DayCarePL.ChildFamilyProperties LoadChildFamilyById(Guid Id, Guid CurrentSchoolyearId) { clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", "Execute LoadChildFamilyById Method", DayCarePL.Common.GUID_DEFAULT); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", "Debug LoadChildFamilyById Method", DayCarePL.Common.GUID_DEFAULT); DayCarePL.ChildFamilyProperties objChildFamilyId = null; SortedList sl = new SortedList(); sl.Add("@Id", Id); sl.Add("@CurrentSchoolyearId", CurrentSchoolyearId); objChildFamilyId = new DayCarePL.ChildFamilyProperties(); objChildFamilyId.lstFamily = new List <DayCarePL.FamilyDataProperties>(); DayCarePL.FamilyDataProperties objFamilyData; var data = db.spGetChildFamilyById(Id, CurrentSchoolyearId); foreach (var d in data) { if (objChildFamilyId.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { objChildFamilyId.Id = d.ChildFamilyId; objChildFamilyId.SchoolId = d.SchoolId; objChildFamilyId.FamilyTitle = d.FamilyTitle; objChildFamilyId.UserName = d.UserName; objChildFamilyId.Password = d.Password; objChildFamilyId.Code = d.Code; objChildFamilyId.Address1 = d.Address1; objChildFamilyId.Address2 = d.Address2; objChildFamilyId.City = d.City; objChildFamilyId.StateId = d.StateId; objChildFamilyId.Zip = d.Zip; objChildFamilyId.HomePhone = d.HomePhone; objChildFamilyId.Comments = d.Comments; objChildFamilyId.Active = d.Active; objChildFamilyId.MsgDisplayed = d.MsgDisplayed; objChildFamilyId.MsgStartDate = d.MsgStartDate; objChildFamilyId.MsgEndDate = d.MsgEndDate; objChildFamilyId.MsgActive = d.MsgActive; objChildFamilyId.CreatedById = d.ChildFamilyCreatedById; objChildFamilyId.CreatedDateTime = d.ChildFamilyCreateDateTime; objChildFamilyId.LastModifiedById = d.ChildFamilyLastModifiedById; objChildFamilyId.LastModifiedDatetime = d.ChildFamilyLastModifiedDateTime; } objFamilyData = new DayCarePL.FamilyDataProperties(); objFamilyData.Id = d.FamilyDataId; objFamilyData.RelationShipId = d.RelationShipId; objFamilyData.FirstName = d.FamilyFirstName; objFamilyData.LastName = d.FamilyLastName; objFamilyData.Email = d.Email; objFamilyData.Phone1Type = d.FamilyPhone1Type; objFamilyData.Phone1 = d.FamilyPhone1; objFamilyData.Phone2Type = d.FamilyPhone2Type; objFamilyData.Phone2 = d.FamilyPhone2; objFamilyData.Photo = d.Photo; objFamilyData.GuardianIndex = d.Guardian; objFamilyData.CreatedById = d.FamilyCreatedById; objFamilyData.CreatedDateTime = d.FamilyCreateDateTime; objFamilyData.LastModifiedById = d.FamilyLastModifiedById; objFamilyData.LastModifiedDatetime = d.FamilyLastModifiedDateTime; objChildFamilyId.lstFamily.Add(objFamilyData); } return(objChildFamilyId); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildFamily, "LoadChildFamilyById", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(null); } }