public void AddTag([NotNull] HouseholdTag tag)
{
var stdt = new STHouseholdDistributionTag(null, tag, IntID, tag.Name,
ConnectionString, System.Guid.NewGuid().ToStrGuid());
Tags.Add(stdt);
stdt.SaveToDB();
}
public static void LoadFromDatabase([ItemNotNull][NotNull] ObservableCollection <STHouseholdDistribution> result,
[NotNull] string connectionString, bool ignoreMissingTables, [ItemNotNull][NotNull] ObservableCollection <HouseholdTag> tags)
{
var aic = new AllItemCollections();
LoadAllFromDatabase(result, connectionString, TableName, AssignFields, aic, ignoreMissingTables, false);
var stHouseholdDistributionTags =
new ObservableCollection <STHouseholdDistributionTag>();
STHouseholdDistributionTag.LoadFromDatabase(stHouseholdDistributionTags, connectionString, tags,
ignoreMissingTables);
SetSubitems(new List <DBBase>(result), new List <DBBase>(stHouseholdDistributionTags), IsCorrectParentHHDist,
ignoreMissingTables);
}
private static STHouseholdDistributionTag AssignFields([NotNull] DataReader dr, [NotNull] string connectionString,
bool ignoreMissingFields, [NotNull] AllItemCollections aic)
{
var id = dr.GetIntFromLong("ID");
var tagID = dr.GetIntFromLong("TagID", ignoreMissingField: ignoreMissingFields);
var tag = aic.HouseholdTags.FirstOrDefault(x => x.ID == tagID);
var householdID = dr.GetIntFromLong("STHouseholdDistributionID");
var name = "(no name)";
if (tag != null)
{
name = tag.Name;
}
var guid = GetGuid(dr, ignoreMissingFields);
var hhp = new STHouseholdDistributionTag(id, tag, householdID, name, connectionString, guid);
return(hhp);
}
