private static HHTAffordance AssignFields([NotNull] DataReader dr, [NotNull] string connectionString, bool ignoreMissingFields, [NotNull] AllItemCollections aic) { var hhdevlocID = dr.GetIntFromLong("ID"); var householdTraitID = dr.GetIntFromLong("HouseholdTraitID"); var affID = dr.GetIntFromLong("AffordanceID"); var weight = dr.GetIntFromLong("Weight", false, ignoreMissingFields, 100); var locationID = dr.GetIntFromLong("LocationID"); var timeLimitID = dr.GetIntFromLong("TimeLimitID", false, ignoreMissingFields); var aff = aic.Affordances.FirstOrDefault(myaff => myaff.ID == affID); var startMinusMinutes = dr.GetIntFromLong("StartMinusMinutes", false, ignoreMissingFields); var startPlusMinutes = dr.GetIntFromLong("StartPlusMinutes", false, ignoreMissingFields); var endMinusMinutes = dr.GetIntFromLong("EndMinusMinutes", false, ignoreMissingFields); var endPlusMinutes = dr.GetIntFromLong("EndPlusMinutes", false, ignoreMissingFields); var hht = aic.HouseholdTraits.FirstOrDefault(myhouseholdtrait => myhouseholdtrait.ID == householdTraitID); HHTLocation hhtloc = null; if (hht != null) { hhtloc = hht.Locations.FirstOrDefault(myhhtl => myhhtl.Location.ID == locationID); } var affname = "(no name)"; if (aff != null) { affname = aff.Name; } var hhlName = "(no name)"; if (hhtloc != null) { hhlName = hhtloc.Name; } var householdName = affname + " - " + hhlName; TimeLimit timeLimit = aic.TimeLimits.FirstOrDefault(x => x.ID == timeLimitID); var guid = GetGuid(dr, ignoreMissingFields); var hhdl = new HHTAffordance(hhdevlocID, aff, hhtloc, householdTraitID, connectionString, householdName, timeLimit, weight, startMinusMinutes, startPlusMinutes, endMinusMinutes, endPlusMinutes, guid); hhtloc?.AffordanceLocations.Add(hhdl); return(hhdl); }
public HHTAffordance([CanBeNull] int?pID, [CanBeNull] Affordance affv, [CanBeNull] HHTLocation hhtLocation, int householdTraitID, [NotNull] string connectionString, [NotNull] string hhaffName, [CanBeNull] TimeLimit timeLimit, int weight , int startMinusMinutes, int startPlusMinutes, int endMinusMinutes, int endPlusMinutes, StrGuid guid) : base(hhaffName, TableName, connectionString, guid) { _timeLimit = timeLimit; _weight = weight; _startMinusMinutes = startMinusMinutes; _startPlusMinutes = startPlusMinutes; _endMinusMinutes = endMinusMinutes; _endPlusMinutes = endPlusMinutes; ID = pID; _affordance = affv; _hhtLocation = hhtLocation; _householdTraitID = householdTraitID; TypeDescription = "Household Trait Affordance Location"; }
private static HHTLocation AssignFields([NotNull] DataReader dr, [NotNull] string connectionString, bool ignoreMissingFields, [NotNull] AllItemCollections aic) { var hhlID = dr.GetIntFromLong("ID"); var locationID = dr.GetIntFromLong("LocationID"); var householdID = dr.GetNullableIntFromLong("HouseholdTraitID", false, ignoreMissingFields); var loc = aic.Locations.FirstOrDefault(myloc => myloc.ID == locationID); var name = "(no name)"; if (loc != null) { name = loc.Name; } var guid = GetGuid(dr, ignoreMissingFields); var hhl = new HHTLocation(hhlID, loc, householdID, name, connectionString, guid); return(hhl); }