public TableStructure()
{
//sub table structure for additional records attached to main record
ChildTables = new List <TableStructure>();
//rows
Inserts = new RowStrucure();
Updates = new RowStrucure();
Deletes = new RowStrucure();
}
/// <summary>
/// allows for easy creation of a rec structure from within the recs structure
/// </summary>
/// <param name="table"></param>
/// <param name="name"></param>
/// <param name="alias"></param>
/// <param name="keys"></param>
/// <param name="inserts">a list of key value parameters for insert rows</param>
/// <param name="updates">a list of key value parameters for update rows</param>
/// <param name="deletes">a list of key value parameters for delete rows</param>
/// <returns></returns>
public TableStructure AddTable(string table, string name, string alias, string keys,
RowStrucure inserts = null, RowStrucure updates = null, RowStrucure deletes = null)
{
TableStructure tbl = new TableStructure()
{
Table = table, Name = name, Alias = alias, Keys = keys
};
if (inserts != null)
{
tbl.Inserts = inserts;
}
if (updates != null)
{
tbl.Updates = updates;
}
if (deletes != null)
{
tbl.Deletes = deletes;
}
Tables.Add(tbl);
return(tbl);
}
/// <summary>
/// adds a predefined employee table struct
/// </summary>
/// <param name="recs"></param>
/// <param name="inserts"></param>
/// <param name="updates"></param>
/// <param name="deletes"></param>
/// <returns></returns>
public static TableStructure AddEmployeeTable(this RecordStructure recs, RowStrucure inserts = null, RowStrucure updates = null, RowStrucure deletes = null)
{
return(recs.AddTable("EM", "EM", "EM", "Employee", inserts, updates, deletes));
}
/// <summary>
/// adds a prededfined contacts table struct
/// </summary>
/// <param name="recs"></param>
/// <param name="inserts"></param>
/// <param name="updates"></param>
/// <param name="deletes"></param>
/// <returns></returns>
public static TableStructure AddContactTable(this RecordStructure recs, RowStrucure inserts = null, RowStrucure updates = null, RowStrucure deletes = null)
{
return(recs.AddTable("Contacts", "Contacts", "Contacts", "ContactId", inserts, updates, deletes));
}
/// <summary>
/// adds a predefined project table struct
/// </summary>
/// <param name="recs"></param>
/// <param name="inserts"></param>
/// <param name="updates"></param>
/// <param name="deletes"></param>
/// <returns></returns>
public static TableStructure AddProjectTable(this RecordStructure recs, RowStrucure inserts = null, RowStrucure updates = null, RowStrucure deletes = null)
{
return(recs.AddTable("PR", "PR", "PR", "WBS1,WBS2,WBS3", inserts, updates, deletes));
}
