Inserting from DetailsView and associated Child Records

12-07-2007

CASE NUMBER: SRX071207601166

To preface, all data access is done through ObjectDatasounces that are bound
to StronglyTyped Datasets (VS.NET generated). All UI controls are bound to
those ObjectDataSources through standard UI binding techniques (point/click).

I have a DetailsView used for inserting records (Companies). Inside that
DetailsView I have added a new column template, this template is going to be
used to add Officers of the company.

Behind the scenes there is a Companies table and a Officers table. The
relationships are N number of Officers to a single company.

My problem is that if I add a DataView in the template to show a list of
Officers, and a DetailsView to that template to allow inserting of new
Officers how do I allow users to insert new Officers of the Company, before
the Company record is actually inserted into the database? I need the
Officers associated with this company, and the user workflow would be
burdened if users had to first create a company, and then move to another
screen to enter Officers and other attributes.

==================CODE==================

<asp

etailsView CssClass="CompanyInsertContainer" ID="CompanyDetailsView"
runat="server" AutoGenerateRows="False" DataSourceID="CompanyInfoDS"
DefaultMode="Insert" HeaderText="Add Company" Height="50px"
Width="500px" DataKeyNames="CompanyID" GridLines="Vertical"
HorizontalAlign="Left" OnItemCommand="CompanyDetailsView_ItemCommand"
OnItemInserted="CompanyDetailsView_ItemInserted" Visible="False">
<Fields>
<asp:BoundField DataField="ID" HeaderText="ID"
InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:TemplateField HeaderText="Officers">
<InsertItemTemplate>
<asp:GridView ID="OfficersGridView" runat="server"
AutoGenerateColumns="False" DataKeyNames="OfficerID"
DataSourceID="OfficerDS" EmptyDataText="No
Officers Defined" GridLines="None" ShowFooter="True">
<Columns>
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" />
<asp:BoundField DataField="OfficerID"
HeaderText="OfficerID" InsertVisible="False"
ReadOnly="True"
SortExpression="OfficerID" Visible="False" />
<asp:BoundField DataField="CompanyID"
HeaderText="CompanyID" SortExpression="CompanyID"
Visible="False" />
<asp:BoundField DataField="Name"
HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="OfficerTitle"
HeaderText="OfficerTitle" SortExpression="OfficerTitle" />
<asp:BoundField DataField="MailingAddr1"
HeaderText="MailingAddr1" SortExpression="MailingAddr1" />
<asp:BoundField DataField="MailingAddr2"
HeaderText="MailingAddr2" SortExpression="MailingAddr2" />
<asp:BoundField DataField="MailingAddr3"
HeaderText="MailingAddr3" SortExpression="MailingAddr3" />
<asp:BoundField DataField="City"
HeaderText="City" SortExpression="City" />
<asp:TemplateField HeaderText="StateID"
SortExpression="StateID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1"
runat="server" Text='<%# Bind("StateID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1"
runat="server" Text='<%# Bind("StateID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PostalCode"
HeaderText="PostalCode" SortExpression="PostalCode" />
<asp:TemplateField HeaderText="CountryID"
SortExpression="CountryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox2"
runat="server" Text='<%# Bind("CountryID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2"
runat="server" Text='<%# Bind("CountryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#5D7B9D"
ForeColor="White" />
</asp:GridView>
<asp:ObjectDataSource ID="OfficerDS" runat="server"
DeleteMethod="Delete" InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}"
SelectMethod="GetDataByOfficer"
TypeName="DataObjects.CompanyDataSetTableAdapters. OfficerTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp

arameter Name="Original_OfficerID"
Type="Int32" />
<asp

arameter Name="Original_CompanyID"
Type="Int32" />
<asp

arameter Name="Original_Name"
Type="String" />
<asp

arameter Name="Original_OfficerTitle"
Type="String" />
<asp

arameter Name="Original_MailingAddr1"
Type="String" />
<asp

arameter Name="Original_MailingAddr2"
Type="String" />
<asp

arameter Name="Original_MailingAddr3"
Type="String" />
<asp

arameter Name="Original_City"
Type="String" />
<asp

arameter Name="Original_StateID"
Type="Int32" />
<asp

arameter Name="Original_PostalCode"
Type="String" />
<asp

arameter Name="Original_CountryID"
Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp

arameter Name="CompanyID" Type="Int32"
/>
<asp

arameter Name="Name" Type="String" />
<asp

arameter Name="OfficerTitle"
Type="String" />
<asp

arameter Name="MailingAddr1"
Type="String" />
<asp

arameter Name="MailingAddr2"
Type="String" />
<asp

arameter Name="MailingAddr3"
Type="String" />
<asp

arameter Name="City" Type="String" />
<asp

arameter Name="StateID" Type="Int32" />
<asp

arameter Name="PostalCode"
Type="String" />
<asp

arameter Name="CountryID" Type="Int32"
/>
<asp

arameter Name="Original_OfficerID"
Type="Int32" />
<asp

arameter Name="Original_CompanyID"
Type="Int32" />
<asp

arameter Name="Original_Name"
Type="String" />
<asp

arameter Name="Original_OfficerTitle"
Type="String" />
<asp

arameter Name="Original_MailingAddr1"
Type="String" />
<asp

arameter Name="Original_MailingAddr2"
Type="String" />
<asp

arameter Name="Original_MailingAddr3"
Type="String" />
<asp

arameter Name="Original_City"
Type="String" />
<asp

arameter Name="Original_StateID"
Type="Int32" />
<asp

arameter Name="Original_PostalCode"
Type="String" />
<asp

arameter Name="Original_CountryID"
Type="Int32" />
<asp

arameter Name="OfficerID" Type="Int32"
/>
</UpdateParameters>
<InsertParameters>
<asp

arameter Name="CompanyID" Type="Int32"
/>
<asp

arameter Name="Name" Type="String" />
<asp

arameter Name="OfficerTitle"
Type="String" />
<asp

arameter Name="MailingAddr1"
Type="String" />
<asp

arameter Name="MailingAddr2"
Type="String" />
<asp

arameter Name="MailingAddr3"
Type="String" />
<asp

arameter Name="City" Type="String" />
<asp

arameter Name="StateID" Type="Int32" />
<asp

arameter Name="PostalCode"
Type="String" />
<asp

arameter Name="CountryID" Type="Int32"
/>
</InsertParameters>
<SelectParameters>
<asp:ControlParameter
ControlID="OfficersGridView" Name="OfficerID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
<asp

etailsView ID="OfficersDetailsView"
runat="server" AutoGenerateRows="False"
DataKeyNames="OfficerID"
DataSourceID="OfficerDS" DefaultMode="Insert" Height="50px"
Width="125px">
<Fields>
<asp:BoundField DataField="OfficerID"
HeaderText="OfficerID" InsertVisible="False"
ReadOnly="True"
SortExpression="OfficerID" />
<asp:BoundField DataField="CompanyID"
HeaderText="CompanyID" SortExpression="CompanyID" />
<asp:BoundField DataField="Name"
HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="OfficerTitle"
HeaderText="OfficerTitle" SortExpression="OfficerTitle" />
<asp:BoundField DataField="MailingAddr1"
HeaderText="MailingAddr1" SortExpression="MailingAddr1" />
<asp:BoundField DataField="MailingAddr2"
HeaderText="MailingAddr2" SortExpression="MailingAddr2" />
<asp:BoundField DataField="MailingAddr3"
HeaderText="MailingAddr3" SortExpression="MailingAddr3" />
<asp:BoundField DataField="City"
HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="StateID"
HeaderText="StateID" SortExpression="StateID" />
<asp:BoundField DataField="PostalCode"
HeaderText="PostalCode" SortExpression="PostalCode" />
<asp:BoundField DataField="CountryID"
HeaderText="CountryID" SortExpression="CountryID" />
<asp:CommandField ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</asp

etailsView>
<asp:ImageButton ID="ImageButton1" runat="server"
ImageUrl="~/images/add.png" OnClick="ImageButton1_Click" />
</InsertItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" ShowInsertButton="True" />
</Fields>
<RowStyle BackColor="#F7F6F3" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True"
ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BorderStyle="None" Font-Bold="True" />
</asp

etailsView>

<asp:ObjectDataSource ID="CompanyInfoDS" runat="server"
DeleteMethod="Delete" InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"

TypeName="DataObjects.CompanyDataSetTableAdapters. CompanyTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp

arameter Name="Original_CompanyID" Type="Int32" />
<asp

arameter Name="Original_ClientID" Type="Int32" />
<asp

arameter Name="Original_FilerID" Type="Int32" />
<asp

arameter Name="Original_FileNumber" Type="Int32" />
<asp

arameter Name="Original_TaxType" Type="String" />
<asp

arameter Name="Original_FederalID" Type="Int32" />
<asp

arameter Name="Original_PhoneNumber" Type="String" />
<asp

arameter Name="Original_InactivityFromDate"
Type="DateTime" />
<asp

arameter Name="Original_InactivityToDate" Type="DateTime" />
<asp

arameter Name="Original_RegulatedInvestAssetJan1"
Type="Int64" />
<asp

arameter Name="Original_RegulatedInvestAssetDec31"
Type="Int64" />
<asp

arameter Name="Original_FranchiseTax" Type="Decimal" />
<asp

arameter Name="Original_Penalty" Type="Decimal" />
<asp

arameter Name="Original_Interest" Type="Decimal" />
<asp

arameter Name="Original_FilingFee" Type="Decimal" />
<asp

arameter Name="Original_CheckCharge" Type="Decimal" />
<asp

arameter Name="Original_CrOrPrePaid" Type="Decimal" />
<asp

arameter Name="Original_AmountDue" Type="Decimal" />
<asp

arameter Name="Original_AmountPaid" Type="Decimal" />
<asp

arameter Name="Original_TaxYear" Type="Int16" />
<asp

arameter Name="Original_NatureBusiness" Type="String" />
<asp

arameter Name="Original_PrincipalMailingAddr1"
Type="String" />
<asp

arameter Name="Original_PrincipalMailingAddr2"
Type="String" />
<asp

arameter Name="Original_PrincipalMailingAddr3"
Type="String" />
<asp

arameter Name="Original_PrincipalCity" Type="String" />
<asp

arameter Name="Original_PrincipalStateID" Type="Int32" />
<asp

arameter Name="Original_PrincipalPostalCode" Type="String"
/>
<asp

arameter Name="Original_PrincipalCountryID" Type="Int32" />
<asp

arameter Name="Original_PrincipalPhoneNumber"
Type="String" />
<asp

arameter Name="Original_PrincipalPhoneExt" Type="String" />
<asp

arameter Name="Original_PrincipalEMail" Type="String" />
<asp

arameter Name="Original_RealEstateInDelaware" Type="Int32"
/>
<asp

arameter Name="Original_TaxPaidOnRealEstate" Type="Int32" />
<asp

arameter Name="Original_NumDirectors" Type="Int16" />
<asp

arameter Name="Original_NoAppointedOfficer" Type="Boolean"
/>
<asp

arameter Name="Original_NoElectedDirectors" Type="Boolean"
/>
<asp

arameter Name="Original_DirectorsPDF" Type="String" />
<asp

arameter Name="Original_Mark" Type="String" />
<asp

arameter Name="Original_Title" Type="String" />
<asp

arameter Name="Original_MarkMailingAddr1" Type="String" />
<asp

arameter Name="Original_MarkMailingAddr2" Type="String" />
<asp

arameter Name="Original_MarkMailingAddr3" Type="String" />
<asp

arameter Name="Original_MarkCity" Type="String" />
<asp

arameter Name="Original_MarkStateID" Type="Int32" />
<asp

arameter Name="Original_MarkPostalCode" Type="String" />
<asp

arameter Name="Original_MarkCountryID" Type="Int32" />
<asp

arameter Name="Original_Date" Type="DateTime" />
</DeleteParameters>
<UpdateParameters>
<asp

arameter Name="ClientID" Type="Int32" />
<asp

arameter Name="FilerID" Type="Int32" />
<asp

arameter Name="FileNumber" Type="Int32" />
<asp

arameter Name="TaxType" Type="String" />
<asp

arameter Name="FederalID" Type="Int32" />
<asp

arameter Name="PhoneNumber" Type="String" />
<asp

arameter Name="InactivityFromDate" Type="DateTime" />
<asp

arameter Name="InactivityToDate" Type="DateTime" />
<asp

arameter Name="RegulatedInvestAssetJan1" Type="Int64" />
<asp

arameter Name="RegulatedInvestAssetDec31" Type="Int64" />
<asp

arameter Name="FranchiseTax" Type="Decimal" />
<asp

arameter Name="Penalty" Type="Decimal" />
<asp

arameter Name="Interest" Type="Decimal" />
<asp

arameter Name="FilingFee" Type="Decimal" />
<asp

arameter Name="CheckCharge" Type="Decimal" />
<asp

arameter Name="CrOrPrePaid" Type="Decimal" />
<asp

arameter Name="AmountDue" Type="Decimal" />
<asp

arameter Name="AmountPaid" Type="Decimal" />
<asp

arameter Name="TaxYear" Type="Int16" />
<asp

arameter Name="NatureBusiness" Type="String" />
<asp

arameter Name="PrincipalMailingAddr1" Type="String" />
<asp

arameter Name="PrincipalMailingAddr2" Type="String" />
<asp

arameter Name="PrincipalMailingAddr3" Type="String" />
<asp

arameter Name="PrincipalCity" Type="String" />
<asp

arameter Name="PrincipalStateID" Type="Int32" />
<asp

arameter Name="PrincipalPostalCode" Type="String" />
<asp

arameter Name="PrincipalCountryID" Type="Int32" />
<asp

arameter Name="PrincipalPhoneNumber" Type="String" />
<asp

arameter Name="PrincipalPhoneExt" Type="String" />
<asp

arameter Name="PrincipalEMail" Type="String" />
<asp

arameter Name="RealEstateInDelaware" Type="Int32" />
<asp

arameter Name="TaxPaidOnRealEstate" Type="Int32" />
<asp

arameter Name="NumDirectors" Type="Int16" />
<asp

arameter Name="NoAppointedOfficer" Type="Boolean" />
<asp

arameter Name="NoElectedDirectors" Type="Boolean" />
<asp

arameter Name="DirectorsPDF" Type="String" />
<asp

arameter Name="Mark" Type="String" />
<asp

arameter Name="Title" Type="String" />
<asp

arameter Name="MarkMailingAddr1" Type="String" />
<asp

arameter Name="MarkMailingAddr2" Type="String" />
<asp

arameter Name="MarkMailingAddr3" Type="String" />
<asp

arameter Name="MarkCity" Type="String" />
<asp

arameter Name="MarkStateID" Type="Int32" />
<asp

arameter Name="MarkPostalCode" Type="String" />
<asp

arameter Name="MarkCountryID" Type="Int32" />
<asp

arameter Name="Date" Type="DateTime" />
<asp