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)); }