Here is the aspx page:
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<div class="container-fluid">
<asp:UpdatePanel ID="up_1" runat="server">
<ContentTemplate>
<%--Vendor Dropdown List--%>
<div class="row">
<h4>Step 1: Choose a Vendor</h4>
Choose a vendor from the following dropdown list:<br />
<asp:DropDownList ID="vendor_ddl" runat="server" DataSourceID="sdc_vendor_ddl" DataTextField="vendor_nm" DataValueField="vendor_id_pk" AutoPostBack="true" AppendDataBoundItems="true" OnSelectedIndexChanged="vendor_ddl_SelectedIndexChanged"><asp:ListItem Value="">Please Select</asp:ListItem></asp:DropDownList>
<asp:SqlDataSource ID="sdc_vendor_ddl" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [vendor_id_pk], [vendor_nm] FROM [tbl_vendor] ORDER BY [vendor_nm]"></asp:SqlDataSource>
</div>
<%--Vendor Details Gridview--%>
<div class="row">
<h4>Step 2: Vendor Clarification</h4>
</div>
<asp:SqlDataSource ID="sdc_gv_vendor_details" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [vendor_id_pk], [vendor_nm], [vendor_st_dir_list], [vendor_st_add], [vendor_st_type_list], [vendor_city], [vendor_state_list], [vendor_zip] FROM [tbl_vendor] WHERE ([vendor_id_pk] = @vendor_id_pk) ORDER BY [vendor_id_pk]">
<SelectParameters>
<asp:ControlParameter ControlID="vendor_ddl" PropertyName="SelectedValue" Name="vendor_id_pk" Type="Int32"></asp:ControlParameter>
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="gv_vendor_details" runat="server" AutoGenerateColumns="False" DataKeyNames="vendor_id_pk" DataSourceID="sdc_gv_vendor_details" AllowPaging="True" AllowSorting="True" CssClass="gv_padding" CellPadding="4" GridLines="Both" ForeColor="#333333" PageSize="5" OnSelectedIndexChanged="gv_vendor_details_SelectedIndexChanged" Caption='<table width="100%" cellpadding="0" cellspacing="0"><tr><td style="background-color: #04478A;text-align: center;"><h5 style="color: #ffffff; font-weight: bold;">Vendor Details</h3></td></tr></table>' CaptionAlign="Top">
<Columns>
<asp:BoundField DataField="vendor_id_pk" HeaderText="Vendor ID" ReadOnly="True" InsertVisible="False" SortExpression="vendor_id_pk"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_nm" HeaderText="Name" SortExpression="vendor_nm"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_st_dir_list" HeaderText="Direction" SortExpression="vendor_st_dir_list"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_st_add" HeaderText="Address" SortExpression="vendor_st_add"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_st_type_list" HeaderText="Type" SortExpression="vendor_st_type_list"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_city" HeaderText="City" SortExpression="vendor_city"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_state_list" HeaderText="State" SortExpression="vendor_state_list"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:BoundField DataField="vendor_zip" HeaderText="Zip" SortExpression="vendor_zip"><HeaderStyle CssClass="gv_hdr_style" /><ItemStyle HorizontalAlign="Center" /></asp:BoundField>
<asp:CommandField ShowSelectButton="True" />
</Columns>
<EditRowStyle BackColor="#BCC7D9" Font-Bold="true" HorizontalAlign="Center" />
<FooterStyle BackColor="#044C92" Font-Bold="True" ForeColor="#000000" />
<HeaderStyle BackColor="#044C92" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#BCC7D9" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<%--Vendor Document Gridview--%>
<div class="row">
<h4>Step 3: Vendor Documents</h4>
</div>
<asp:SqlDataSource
ID="sdc_gv_vendor_doc"
runat="server"
ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>"
SelectCommand="SELECT td.doc_id_pk, td.doc_title,td.doc_type_list,tdl.doc_type,td.doc_org_list,tol.org,td.doc_dept_list,tdeptl.dept,td.doc_desc,td.prior_contract_cd,td.legal_comp_contract_id,td.doc_upld_dt,td.doc_path,td.crnt_doc_stat_list,tstatl.rvw_status,td.vendor_id_fk,tv.vendor_nm FROM tbl_doc td LEFT JOIN tbl_doc_type_list tdl ON td.doc_type_list=tdl.doc_type_id_pk LEFT JOIN tbl_vendor tv ON td.vendor_id_fk=tv.vendor_id_pk LEFT JOIN tbl_org_list tol ON td.doc_org_list=tol.org_id_pk LEFT JOIN tbl_dept_list tdeptl ON td.doc_dept_list=tdeptl.dept_id_pk LEFT JOIN tbl_status_list tstatl ON td.crnt_doc_stat_list=tstatl.rvw_status_id_pk WHERE ([vendor_id_fk] = @vendor_id_fk)">
<SelectParameters>
<asp:ControlParameter
ControlID="gv_vendor_details"
Name="vendor_id_fk"
PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView
ID="gv_vendor_doc"
runat="server"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
CellPadding="4"
DataKeyNames="doc_id_pk"
DataSourceID="sdc_gv_vendor_doc"
GridLines="Both"
ForeColor="#333333"
OnSelectedIndexChanged="gv_vendor_doc_SelectedIndexChanged"
Caption='<table width="100%" cellpadding="0" cellspacing="0"><tr><td style="background-color: #04478A;text-align: center;"><h5 style="color: #ffffff; font-weight: bold;">Vendor Documents(s)</h3></td></tr></table>' CaptionAlign="Top">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField ItemStyle-HorizontalAlign="Center" AccessibleHeaderText="Document ID" DataField="doc_id_pk" HeaderText="ID" HeaderStyle-CssClass="gv_hdr_style" InsertVisible="False" ReadOnly="True" SortExpression="doc_id_pk">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField AccessibleHeaderText="Document Type" DataField="doc_type" HeaderText="Type" HeaderStyle-CssClass="gv_hdr_style" SortExpression="doc_type">
<HeaderStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField AccessibleHeaderText="Document Title" DataField="doc_title" HeaderText="Title" HeaderStyle-CssClass="gv_hdr_style" SortExpression="doc_title"></asp:BoundField>
<asp:BoundField ItemStyle-HorizontalAlign="Center" AccessibleHeaderText="Organization" DataField="org" HeaderText="Organization" HeaderStyle-CssClass="gv_hdr_style" SortExpression="org">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ItemStyle-HorizontalAlign="Center" AccessibleHeaderText="Department" DataField="dept" HeaderText="Department" HeaderStyle-CssClass="gv_hdr_style" SortExpression="dept">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField AccessibleHeaderText="Document Description" DataField="doc_desc" HeaderText="Description" HeaderStyle-CssClass="gv_hdr_style" SortExpression="doc_desc" />
<asp:BoundField ItemStyle-HorizontalAlign="Center" AccessibleHeaderText="Vendor ID" DataField="vendor_nm" HeaderText="Vendor ID" HeaderStyle-CssClass="gv_hdr_style" SortExpression="vendor_nm" Visible="false">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ItemStyle-HorizontalAlign="Center" AccessibleHeaderText="Status" DataField="rvw_status" HeaderText="Status" HeaderStyle-CssClass="gv_hdr_style" SortExpression="rvw_status">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkDownload" Text="Download" CommandArgument='<%# Eval("doc_path") %>' runat="server" OnClick="lnkDownload_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowSelectButton="True" />
</Columns>
<EditRowStyle BackColor="#BCC7D9" Font-Bold="true" HorizontalAlign="Center" />
<FooterStyle BackColor="#044C92" Font-Bold="True" ForeColor="#000000" />
<HeaderStyle BackColor="#044C92" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#BCC7D9" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<%--Create A New Document Review--%>
<div class="row">
<asp:Button ID="btn_open_new_rvw_frm" runat="server" Text="Initiate A New Document Review" CssClass="frm_btn_style" Visible="false" /><br /><br />
</div>
<div class="row">
<asp:Panel ID="new_rvw_frm_panel" runat="server" style="overflow: hidden;">
<fieldset>
<div id="new_rvw_form" runat="server" style="background-color: rgba(128, 202, 255, 0.61);">
<div class="row">
<div class="col-md-3 col-sm-3">
<strong>Review Type</strong><br />
<asp:DropDownList ID="rvw_type_list" runat="server" DataSourceID="sdc_rvw_type_list" DataTextField="rvw_type_list" DataValueField="rvw_type_id_pk" AppendDataBoundItems="true">
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList><br /><br />
</div>
<div class="col-md-3 col-sm-3">
<strong>Contract Type</strong><br />
<asp:DropDownList ID="contract_type_list_ddl" runat="server" DataSourceID="sdc_contract_type_list" DataTextField="contract_type" DataValueField="contract_type_id_pk" AppendDataBoundItems="true">
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList><br /><br />
</div>
<div class="col-md-3 col-sm-3">
<strong>Administrative Oversight Required</strong><br />
<asp:DropDownList ID="aor_reqd_yn_list" runat="server" DataSourceID="sdc_aor_reqd_yn_list" DataTextField="yn" DataValueField="yn_id_pk" AppendDataBoundItems="true" AutoPostBack="true" OnSelectedIndexChanged="aor_reqd_yn_list_SelectedIndexChanged">
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList><br /><br />
</div>
<div class="col-md-3 col-sm-3">
<strong>Date Submitted to TDI</strong><br />
<asp:TextBox ID="sub_tdi_dt" runat="server" Enabled="true"></asp:TextBox>
<asp:ImageButton ID="sub_tdi_dt_cal_popup" Enabled="false" ImageUrl="Images/calendar.png" ImageAlign="Bottom" runat="server" />
<ajaxToolkit:CalendarExtender runat="server" BehaviorID="sub_tdi_dt_CalendarExtender" PopupButtonID="sub_tdi_dt_cal_popup" TargetControlID="sub_tdi_dt" ID="sub_tdi_dt_CalendarExtender"></ajaxToolkit:CalendarExtender>
</div>
</div>
<div class="row">
<div class="col-md-3 col-sm-3">
<strong>Approved by TDI?</strong><br />
<asp:DropDownList ID="apprvd_tdi_yn_list" runat="server" DataSourceID="sdc_apprvd_tdi_yn_list" DataTextField="yn" DataValueField="yn_id_pk" AppendDataBoundItems="true" Enabled="false">
<asp:ListItem Value="" Enabled="false">Please Select</asp:ListItem>
</asp:DropDownList><br /><br />
</div>
<div class="col-md-3 col-sm-3">
<strong>Date Approved by TDI</strong><br />
<asp:TextBox ID="apprvd_tdi_dt" runat="server" Enabled="false"></asp:TextBox>
<asp:ImageButton ID="apprvd_tdi_dt_cal_popup" Enabled="false" ImageUrl="Images/calendar.png" ImageAlign="Bottom" runat="server" />
<ajaxToolkit:CalendarExtender runat="server" BehaviorID="apprvd_tdi_dt_CalendarExtender" PopupButtonID="apprvd_tdi_dt_cal_popup" TargetControlID="apprvd_tdi_dt" ID="apprvd_tdi_dt_CalendarExtender"></ajaxToolkit:CalendarExtender>
</div>
<div class="col-md-3 col-sm-3"></div>
<div class="col-md-3 col-sm-3"></div>
</div>
<br />
<div class="row">
<div class="col-md-12">
<div class="btn_style">
<asp:Button ID="submit_new_rvw_form_btn" runat="server" Text="Submit" OnClick="submit_new_rvw_form_btn_Click" />
<asp:Button ID="clr_new_rvw_form_btn" CausesValidation="false" runat="server" Text="Clear Form" />
</div>
</div>
</div>
</div>
</fieldset>
</asp:Panel>
</div>
<ajaxToolkit:CollapsiblePanelExtender
runat="server"
BehaviorID="new_rvw_frm_panel_CollapsiblePanelExtender"
TargetControlID="new_rvw_frm_panel"
ID="new_rvw_frm_panel_CollapsiblePanelExtender"
CollapseControlID="btn_open_new_rvw_frm"
ExpandControlID="btn_open_new_rvw_frm"
ExpandDirection="Vertical"
ScrollContents="false"
Collapsed="true"
CollapsedSize="0">
</ajaxToolkit:CollapsiblePanelExtender>
<ajaxToolkit:AnimationExtender
ID="AnimationExtender1"
runat="server"
TargetControlID="new_rvw_frm_panel">
</ajaxToolkit:AnimationExtender>
<div>
<%--Created date and doc id--%>
<asp:HiddenField ID="hdn_doc_rvw_dt" runat="server" />
<asp:HiddenField ID="HiddenField1" runat="server" />
<asp:SqlDataSource ID="sdc_rvw_type_list" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [rvw_type_id_pk], [rvw_type_list], [rvw_type_active_yn] FROM [tbl_rvw_type_list] WHERE rvw_type_active_yn = 3" />
<asp:SqlDataSource ID="sdc_aor_reqd_yn_list" runat="server" ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>" SelectCommand="SELECT [yn_id_pk], [yn] FROM [tbl_yn_list] WHERE yn_id_pk <> 1"></asp:SqlDataSource>
<asp:SqlDataSource ID="sdc_apprvd_tdi_yn_list" runat="server" ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>" SelectCommand="SELECT [yn_id_pk], [yn] FROM [tbl_yn_list]"></asp:SqlDataSource>
<asp:SqlDataSource ID="sdc_contract_type_list" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [contract_type_id_pk], [contract_type] FROM [tbl_contract_type_list] WHERE [contract_type_active_yn] = '3'"></asp:SqlDataSource>
</div>
<%--Document Review Gridview--%>
<div class="row">
<h4>Step 4: Review a Vendor Document</h4>
<p><strong><em>NOTE:</em></strong>There may be multiple "submissions" for a review. Use the "Document Submission(s)" section below to route the selected document for the specified review.</p>
</div>
<asp:SqlDataSource
ID="sdc_gv_doc_rvw" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>" DeleteCommand="DELETE FROM [tbl_doc_rvw] WHERE [doc_rvw_id_pk] = @original_doc_rvw_id_pk AND (([doc_rvw_dt] = @original_doc_rvw_dt) OR ([doc_rvw_dt] IS NULL AND @original_doc_rvw_dt IS NULL)) AND (([rvw_type_list] = @original_rvw_type_list) OR ([rvw_type_list] IS NULL AND @original_rvw_type_list IS NULL)) AND [aor_reqd_yn_list] = @original_aor_reqd_yn_list AND (([sub_tdi_dt] = @original_sub_tdi_dt) OR ([sub_tdi_dt] IS NULL AND @original_sub_tdi_dt IS NULL)) AND (([apprvd_tdi_yn_list] = @original_apprvd_tdi_yn_list) OR ([apprvd_tdi_yn_list] IS NULL AND @original_apprvd_tdi_yn_list IS NULL)) AND (([apprvd_tdi_dt] = @original_apprvd_tdi_dt) OR ([apprvd_tdi_dt] IS NULL AND @original_apprvd_tdi_dt IS NULL)) AND [doc_id_fk] = @original_doc_id_fk" InsertCommand="INSERT INTO [tbl_doc_rvw] ([doc_rvw_dt], [rvw_type_list], [aor_reqd_yn_list], [sub_tdi_dt], [apprvd_tdi_yn_list], [apprvd_tdi_dt], [doc_id_fk]) VALUES (@doc_rvw_dt, @rvw_type_list, @aor_reqd_yn_list, @sub_tdi_dt, @apprvd_tdi_yn_list, @apprvd_tdi_dt, @doc_id_fk)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT tdr.doc_rvw_id_pk, tdr.doc_rvw_dt, trtl.rvw_type_list, tdr.aor_reqd_yn_list, tynl.yn AS aorrqdyn, tdr.sub_tdi_dt, tdr.apprvd_tdi_yn_list, tynl2.yn AS tdiapprvdyn, tdr.apprvd_tdi_dt, tdr.doc_id_fk, tdr.contract_type_list, tctl.contract_type FROM tbl_doc_rvw tdr LEFT JOIN tbl_rvw_type_list trtl ON tdr.rvw_type_list=trtl.rvw_type_id_pk LEFT JOIN tbl_yn_list tynl ON tdr.aor_reqd_yn_list=tynl.yn_id_pk LEFT JOIN tbl_yn_list tynl2 ON tdr.apprvd_tdi_yn_list=tynl2.yn_id_pk LEFT JOIN tbl_contract_type_list tctl ON tdr.contract_type_list=tctl.contract_type_id_pk WHERE (tdr.doc_id_fk = @doc_id_fk)"
UpdateCommand="UPDATE [tbl_doc_rvw] SET [aor_reqd_yn_list] = @aor_reqd_yn_list, [sub_tdi_dt] = @sub_tdi_dt, [apprvd_tdi_yn_list]=@apprvd_tdi_yn_list, [apprvd_tdi_dt]=@apprvd_tdi_dt WHERE [doc_rvw_id_pk] = @original_doc_rvw_id_pk AND [doc_id_fk] = @original_doc_id_fk">
<SelectParameters>
<asp:ControlParameter ControlID="gv_vendor_doc" Name="doc_id_fk" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="original_aor_reqd_yn_list" Type="Int32" />
<asp:Parameter Name="original_sub_tdi_dt" Type="DateTime" />
<asp:Parameter Name="original_apprvd_tdi_yn_list" Type="String" />
<asp:Parameter Name="original_apprvd_tdi_dt" Type="DateTime" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView
ID="gv_doc_rvw" runat="server" AutoGenerateColumns="False" DataSourceID="sdc_gv_doc_rvw" DataKeyNames="doc_rvw_id_pk" AllowPaging="True" AllowSorting="True" ForeColor="#333333" CellPadding="4" PageSize="5" PagerSettings-Mode="NextPreviousFirstLast" PagerSettings-FirstPageImageUrl="Images/first_nav.png" PagerSettings-LastPageImageUrl="Images/last_nav.png" PagerSettings-PreviousPageImageUrl="Images/previous_nav.png" PagerSettings-NextPageImageUrl="Images/next_nav.png" OnSelectedIndexChanged="gv_doc_rvw_SelectedIndexChanged" Caption='<table width="100%" cellpadding="0" cellspacing="0"><tr><td style="background-color: #04478A;text-align: center;"><h5 style="color: #ffffff; font-weight: bold;">Document Review(s)</h3></td></tr></table>' CaptionAlign="Top">
<AlternatingRowStyle
BackColor="White" />
<Columns>
<asp:BoundField AccessibleHeaderText="Document Review ID" DataField="doc_rvw_id_pk" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="doc_rvw_id_pk" />
<asp:BoundField AccessibleHeaderText="Review Date" DataField="doc_rvw_dt" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Review Date" HeaderStyle-CssClass="gv_hdr_style" SortExpression="doc_rvw_dt" ReadOnly="true" ItemStyle-HorizontalAlign="Center">
<HeaderStyle CssClass="gv_hdr_style"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField AccessibleHeaderText="Review Type" DataField="rvw_type_list" HeaderText="Review Type" HeaderStyle-CssClass="gv_hdr_style" SortExpression="rvw_type_list" ReadOnly="True" ItemStyle-HorizontalAlign="Center">
<HeaderStyle CssClass="gv_hdr_style"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField AccessibleHeaderText="Administrative Oversight Required Yes or No" HeaderText="AO Required" SortExpression="aorrqdyn">
<EditItemTemplate>
<asp:DropDownList
ID="aor_rqd_ddl_edit"
runat="server"
DataSourceID="sdc_aor_reqd_yn_list"
DataTextField="yn"
DataValueField="yn_id_pk"
AppendDataBoundItems="true"
SelectedValue='<%# Bind("aor_reqd_yn_list")%>'>
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("aorrqdyn") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField AccessibleHeaderText="Date Submitted to TDI" HeaderText="Date Submitted to TDI" SortExpression="sub_tdi_dt">
<EditItemTemplate>
<asp:TextBox ID="edit_sub_tdi_dt" runat="server" Text='<%# Bind("sub_tdi_dt", "{0:MM/dd/yyyy}") %>'></asp:TextBox>
<ajaxToolkit:CalendarExtender ID="edit_sub_tdi_dt_CalendarExtender" runat="server" BehaviorID="edit_sub_tdi_dt_CalendarExtender" TargetControlID="edit_sub_tdi_dt" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbl_sub_tdi_dt" runat="server" Text='<%# Bind("sub_tdi_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField AccessibleHeaderText="Approved by TDI Yes or No" HeaderText="TDI Approved" SortExpression="tdiapprvdyn">
<EditItemTemplate>
<asp:DropDownList
ID="edit_tdi_apprvd_yn_list"
runat="server"
DataSourceID="sdc_apprvd_tdi_yn_list"
DataTextField="yn"
DataValueField="yn_id_pk"
AppendDataBoundItems="true"
SelectedValue='<%# Bind("apprvd_tdi_yn_list") %>'>
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("tdiapprvdyn") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField AccessibleHeaderText="Date Approved by TDI" HeaderText="TDI Approval Date" SortExpression="apprvd_tdi_dt">
<EditItemTemplate>
<asp:TextBox ID="edit_tdi_apprvd_dt" runat="server" Text='<%# Bind("apprvd_tdi_dt", "{0:MM/dd/yyyy}") %>'></asp:TextBox>
<ajaxToolkit:CalendarExtender ID="edit_tdi_apprvd_dt_CalendarExtender" runat="server" BehaviorID="edit_tdi_apprvd_dt_CalendarExtender" TargetControlID="edit_tdi_apprvd_dt" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("apprvd_tdi_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField AccessibleHeaderText="Document ID Foreign Key" DataField="doc_id_fk" HeaderText="Document ID" HeaderStyle-CssClass="gv_hdr_style" SortExpression="doc_id_fk" ItemStyle-HorizontalAlign="Center" ReadOnly="true">
<HeaderStyle CssClass="gv_hdr_style"></HeaderStyle>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField AccessibleHeaderText="Contract Type" DataField="contract_type_list" HeaderText="Contract Type" HeaderStyle-CssClass="gv_hdr_style" SortExpression="contract_type_list" ItemStyle-HorizontalAlign="Center" ReadOnly="true" Visible="false">
<HeaderStyle CssClass="gv_hdr_style"></HeaderStyle><ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowDeleteButton="False" ShowEditButton="True" ShowSelectButton="True" ShowInsertButton="False" />
</Columns>
<EditRowStyle BackColor="#BCC7D9" Font-Bold="true" HorizontalAlign="Center" />
<FooterStyle BackColor="#044C92" Font-Bold="True" ForeColor="#000000" />
<HeaderStyle BackColor="#044C92" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#BCC7D9" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [rvw_type_id_pk], [rvw_type_list], [rvw_type_active_yn] FROM [tbl_rvw_type_list] WHERE rvw_type_active_yn = 3" />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>" SelectCommand="SELECT [yn_id_pk], [yn] FROM [tbl_yn_list] WHERE yn_id_pk <> 1"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:idrfConnectionString %>" SelectCommand="SELECT [yn_id_pk], [yn] FROM [tbl_yn_list]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [contract_type_id_pk], [contract_type] FROM [tbl_contract_type_list] WHERE [contract_type_active_yn] = '3'"></asp:SqlDataSource>
</div>
<%--Add A New Review Submission--%>
<div class="row">
<asp:Button ID="btn_open_new_sub_frm" runat="server" Text="Submit A Document For Review" CssClass="frm_btn_style" Visible="false" /><br /><br />
</div>
<div class="row">
<asp:Panel ID="new_sub_frm_panel" runat="server" style="overflow: hidden;">
<fieldset>
<div id="div_add_rvw_sub" runat="server" style="background-color: rgba(128, 202, 255, 0.61);">
<div class="row side_margins">
Rows must be selected in "Step 1", "Step 2", "Step 3" and "Step 4" prior to adding a new submission. Submissions created here will be added to the table in "Step 7". <em>Note: If the Due Date is left blank, it will default to 3 business days from the date submitted.</em>
</div>
<div class="row" runat="server">
<div class="col-md-3">
<strong>Submit To</strong><br />
<asp:DropDownList ID="doc_rvw_sub_recip_list" runat="server" DataSourceID="sdc_ad_user_list" DataTextField="name" DataValueField="email_address" AppendDataBoundItems="true" AutoPostBack="true" OnSelectedIndexChanged="doc_rvw_sub_recip_list_SelectedIndexChanged">
<asp:ListItem Value="">Please Select</asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="sdc_ad_user_list" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [name], [email_address] FROM [tbl_ad_users] ORDER BY [name]"></asp:SqlDataSource>
</div>
<div class="col-md-3">
<strong>Email Address</strong><br />
<asp:DropDownList ID="user_email_add_ddl" runat="server" DataSourceID="sdc_user_email_add_ddl" DataTextField="email_address" DataValueField="email_address" AutoPostBack="true"></asp:DropDownList>
<asp:SqlDataSource ID="sdc_user_email_add_ddl" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [email_address] FROM [tbl_ad_users] WHERE ([email_address] = @email_address)">
<SelectParameters>
<asp:ControlParameter ControlID="doc_rvw_sub_recip_list" PropertyName="SelectedValue" Name="email_address" Type="String"></asp:ControlParameter>
</SelectParameters>
</asp:SqlDataSource>
</div>
<div class="col-md-3">
<strong>Username</strong><br />
<asp:DropDownList ID="domain_user_ddl" runat="server" DataSourceID="sdc_domain_user_ddl" DataTextField="domain_user" DataValueField="domain_user" AutoPostBack="true"></asp:DropDownList>
<asp:SqlDataSource ID="sdc_domain_user_ddl" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [domain_user] FROM [tbl_ad_users] WHERE ([email_address] = @email_address)">
<SelectParameters>
<asp:ControlParameter ControlID="doc_rvw_sub_recip_list" PropertyName="SelectedValue" Name="email_address" Type="String"></asp:ControlParameter>
</SelectParameters>
</asp:SqlDataSource>
</div>
<div class="col-md-3">
<strong>Due Date</strong><br />
<asp:TextBox ID="doc_sub_due_dt" runat="server"></asp:TextBox>
<asp:ImageButton ID="doc_sub_due_dt_cal_popup" Enabled="false" ImageUrl="Images/calendar.png" ImageAlign="Bottom" runat="server" />
<ajaxToolkit:CalendarExtender runat="server" BehaviorID="doc_sub_due_dt_CalendarExtender" TargetControlID="doc_sub_due_dt" ID="doc_sub_due_dt_CalendarExtender"></ajaxToolkit:CalendarExtender>
</div>
<asp:HiddenField ID="hdn_doc_rvw_sub_by" runat="server" />
<asp:HiddenField ID="HiddenField2" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_sub_dt" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_sub_status" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_domain_user" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_sub_status_set_by" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_sub_status_dt_set" runat="server" />
<asp:HiddenField ID="hdn_doc_rvw_sub_id_fk" runat="server" />
</div>
<div class="row">
<div class="col-md-12">
<br />
<asp:Button CssClass="btn_style" ID="add_rvw_sub_btn" runat="server" Text="Add" OnClick="add_rvw_sub_btn_Click" />
</div>
</div>
</div>
</fieldset>
</asp:Panel>
</div>
<ajaxToolkit:CollapsiblePanelExtender
runat="server"
BehaviorID="cpe_new_sub_frm_panel"
TargetControlID="new_sub_frm_panel"
ID="cpe_new_sub_frm_panel"
CollapseControlID="btn_open_new_sub_frm"
ExpandControlID="btn_open_new_sub_frm"
Collapsed="true"
CollapsedSize="0">
</ajaxToolkit:CollapsiblePanelExtender>
<%--Review Submission Gridview--%>
<div class="row">
<h4>Step 5: Review A Submission</h4>
</div>
<div class="row top-marg">
Choose "Edit" to update the "Status" field in the <strong>Review Submission</strong> table below.
</div>
<asp:GridView ID="gv_rvw_sub" runat="server" AutoGenerateColumns="False" DataKeyNames="doc_rvw_sub_id_pk" OnRowEditing="gv_rvw_sub_RowEditing" OnRowUpdating="gv_rvw_sub_RowUpdating" OnRowCancelingEdit="gv_rvw_sub_RowCancelingEdit" Caption='<table width="100%" cellpadding="0" cellspacing="0"><tr><td style="background-color: #04478A;text-align: center;"><h5 style="color: #ffffff; font-weight: bold;">Submission Review(s)</h3></td></tr></table>' CaptionAlign="Top">
<Columns>
<asp:TemplateField HeaderText="Sub ID">
<EditItemTemplate>
<asp:Label ID="sub_id_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_id_pk") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sub_id_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_id_pk") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub By">
<EditItemTemplate>
<asp:Label ID="sub_by_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_by") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sub_by_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_by") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle CssClass="gv_hdr_style" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Sub To">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="sub_to_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_recip_list") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sub_to_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_recip_list") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date Submitted">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="sub_dt_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sub_dt_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Due Date">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="sub_due_dt_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_due_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="sub_due_dt_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_due_dt", "{0:MM/dd/yyyy}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Status" SortExpression="doc_rvw_sub_status_list">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<%--<asp:Label ID="status_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_status_list") %>'></asp:Label>--%>
<asp:DropDownList ID="doc_rvw_sub_status_list_ddl" runat="server" DataSourceID="sdc_doc_rvw_sub_status_list_ddl" DataTextField="rvw_status" DataValueField="rvw_status_id_pk" AppendDataBoundItems="true" SelectedValue='<%# Bind("doc_rvw_sub_status_list") %>'><asp:ListItem Value="">Please Select</asp:ListItem></asp:DropDownList>
<asp:SqlDataSource ID="sdc_doc_rvw_sub_status_list_ddl" runat="server" ConnectionString='<%$ ConnectionStrings:idrfConnectionString %>' SelectCommand="SELECT [rvw_status_id_pk], [rvw_status] FROM tbl_status_list WHERE [rvw_status_active_yn] = '3'" />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="status_item_lbl" runat="server" Text='<%# Bind("rvw_status") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Status Set By">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="stat_set_by_edit_txt" runat="server" Text='<%# Bind("doc_rvw_sub_status_set_by") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="stat_set_by_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_status_set_by") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date Status Set">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="stat_dt_set_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_status_dt_set", "{0:MM/dd/yyyy}") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="stat_dt_set_item_lbl" runat="server" Text='<%# Bind("doc_rvw_sub_status_dt_set", "{0:MM/dd/yyyy}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Doc Review ID">
<HeaderStyle CssClass="gv_hdr_style" />
<EditItemTemplate>
<asp:Label ID="doc_rvw_id_fk_edit_lbl" runat="server" Text='<%# Bind("doc_rvw_id_fk") %>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="doc_rvw_id_fk_item_lbl" runat="server" Text='<%# Bind("doc_rvw_id_fk") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" ShowSelectButton="true" />
</Columns>
<EditRowStyle BackColor="#BCC7D9" Font-Bold="true" HorizontalAlign="Center" />
<FooterStyle BackColor="#044C92" Font-Bold="True" ForeColor="#000000" />
<HeaderStyle BackColor="#044C92" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#BCC7D9" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<%--Send Email Notification--%>
<div>
<h4>Step 6: Send An Email Notification</h4>
<p>Send an email notification regarding the selected review submission to the recipient specified in "Step 7".</p>
<asp:Button ID="btn_send_email_notification" runat="server" Text="Send" OnClick="btn_send_email_notification_Click" /><asp:Label ID="lbl_em_success_notification" runat="server" ForeColor="#009933" Font-Bold="true"></asp:Label>
</div>
<div>
<%--Email Fields--%>
<asp:HiddenField ID="hdn_email_doc_id_pk" runat="server" />
<asp:HiddenField ID="hdn_email_doc_title" runat="server" />
<asp:HiddenField ID="hdn_email_vendor_nm" runat="server" />
<asp:HiddenField ID="hdn_email_recipient_nm" runat="server" />
<asp:HiddenField ID="hdn_email_doc_rvw_id" runat="server" />
<asp:HiddenField ID="hdn_email_doc_sub_id" runat="server" />
<asp:HiddenField ID="doc_rvw_id_fk" runat="server" />
</div>
<%--Other Fields--%>
<asp:HiddenField ID="hdn_doc_id_fk" runat="server" />
</ContentTemplate>
</asp:UpdatePanel>
</div>
</asp:Content>
Here is the .cs page:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;
using System.IO.Compression;
using System.DirectoryServices;
using System.DirectoryServices.ActiveDirectory;
using System.DirectoryServices.AccountManagement;
using System.Net.Mail;
using System.Text;
using System.IO;
using System.Drawing;
namespace idrf
{
public partial class frm_new_doc_rvw_3 : System.Web.UI.Page
{
private String strConnString = ConfigurationManager.ConnectionStrings["idrfConnectionString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
private void BindData()
{
string strQuery = "SELECT doc_rvw_sub_id_pk, doc_rvw_sub_by, doc_rvw_sub_recip_list, doc_rvw_sub_dt, doc_rvw_sub_due_dt, doc_rvw_sub_status_list, doc_rvw_sub_status_set_by, doc_rvw_sub_status_dt_set, doc_rvw_id_fk, tsl.rvw_status FROM tbl_doc_rvw_sub LEFT JOIN tbl_status_list tsl ON tbl_doc_rvw_sub.doc_rvw_sub_status_list=tsl.rvw_status_id_pk WHERE doc_rvw_id_fk = @drfk ";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.Parameters.AddWithValue("@drfk", gv_doc_rvw.SelectedRow.Cells[0].Text);
gv_rvw_sub.DataSource = GetData(cmd);
gv_rvw_sub.DataBind();
}
private DataTable GetData(SqlCommand cmd)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(strConnString);
SqlDataAdapter sda = new SqlDataAdapter();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
sda.SelectCommand = cmd;
sda.Fill(dt);
return dt;
}
protected void gv_rvw_sub_RowEditing(object sender, GridViewEditEventArgs e)
{
gv_rvw_sub.EditIndex = e.NewEditIndex;
BindData();
}
protected void gv_rvw_sub_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string subId = ((Label)gv_rvw_sub.Rows[e.RowIndex].FindControl("sub_id_edit_lbl")).Text;
string statSetBy = HttpContext.Current.User.Identity.Name;
string statSetDt = DateTime.Now.ToString();
string subStat = ((DropDownList)gv_rvw_sub.Rows[e.RowIndex].FindControl("doc_rvw_sub_status_list_ddl")).Text;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "UPDATE tbl_doc_rvw_sub SET doc_rvw_sub_status_set_by = @doc_rvw_sub_status_set_by, doc_rvw_sub_status_dt_set = @doc_rvw_sub_status_dt_set, doc_rvw_sub_status_list = @doc_rvw_sub_status_list WHERE doc_rvw_sub_id_pk=@doc_rvw_sub_id_pk";
cmd.Parameters.Add("@doc_rvw_sub_status_list", SqlDbType.Int).Value = subStat;
cmd.Parameters.Add("@doc_rvw_sub_status_set_by", SqlDbType.VarChar).Value = statSetBy;
cmd.Parameters.Add("@doc_rvw_sub_status_dt_set", SqlDbType.VarChar).Value = statSetDt;
cmd.Parameters.Add("@doc_rvw_sub_id_pk", SqlDbType.Int).Value = subId;
gv_rvw_sub.EditIndex = -1;
gv_rvw_sub.DataSource = GetData(cmd);
gv_rvw_sub.DataBind();
BindData();
}
protected void gv_rvw_sub_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
gv_rvw_sub.EditIndex = -1;
BindData();
}
protected void add_rvw_sub_btn_Click(object sender, EventArgs e)
{
hdn_doc_rvw_sub_dt.Value = DateTime.Now.ToString();
hdn_doc_rvw_sub_by.Value = System.Web.HttpContext.Current.User.Identity.Name;
hdn_doc_rvw_sub_status.Value = "4";
hdn_doc_rvw_sub_status_dt_set.Value = DateTime.Now.ToString();
hdn_doc_rvw_sub_status_set_by.Value = System.Web.HttpContext.Current.User.Identity.Name;
DayOfWeek today = DateTime.Today.DayOfWeek;
if (String.IsNullOrEmpty(doc_sub_due_dt.Text))
{
if (today == DayOfWeek.Wednesday)
{
doc_sub_due_dt.Text = DateTime.Now.AddDays(5).ToString();
}
else if (today == DayOfWeek.Thursday)
{
doc_sub_due_dt.Text = DateTime.Now.AddDays(5).ToString();
}
else if (today == DayOfWeek.Friday)
{
doc_sub_due_dt.Text = DateTime.Now.AddDays(5).ToString();
}
else if (today == DayOfWeek.Saturday)
{
doc_sub_due_dt.Text = DateTime.Now.AddDays(4).ToString();
}
else
{
doc_sub_due_dt.Text = DateTime.Now.AddDays(3).ToString();
}
}
//The following is a flat 2 days from the date submitted
//if (String.IsNullOrEmpty(doc_sub_due_dt.Text))
//{ doc_sub_due_dt.Text = DateTime.Now.AddDays(2).ToString(); }
SqlConnection idrf_cnxn = new SqlConnection("Data Source=WDBSVCPRD01\\SVCDB;Initial Catalog=idrf;Integrated Security=True");
{
SqlCommand new_sub_cmd = new SqlCommand("Insert Into tbl_doc_rvw_sub(doc_rvw_sub_by, doc_rvw_sub_recip_list, doc_rvw_sub_domain_user, doc_rvw_sub_dt, doc_rvw_sub_status_list, doc_rvw_id_fk, doc_rvw_sub_due_dt, doc_rvw_sub_status_set_by, doc_rvw_sub_status_dt_set) Values(LTRIM(RTRIM(@doc_rvw_sub_by)), LTRIM(RTRIM(@doc_rvw_sub_recip_list)), LTRIM(RTRIM(@doc_rvw_sub_domain_user)), LTRIM(RTRIM(@doc_rvw_sub_dt)), LTRIM(RTRIM(@doc_rvw_sub_status_list)), LTRIM(RTRIM(@doc_rvw_id_fk)), LTRIM(RTRIM(@doc_rvw_sub_due_dt)), LTRIM(RTRIM(@doc_rvw_sub_status_set_by)), LTRIM(RTRIM(@doc_rvw_sub_status_dt_set)))", idrf_cnxn);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_by", hdn_doc_rvw_sub_by.Value);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_recip_list", doc_rvw_sub_recip_list.Text);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_domain_user", domain_user_ddl.Text);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_dt", hdn_doc_rvw_sub_dt.Value);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_status_list", hdn_doc_rvw_sub_status.Value);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_id_fk", doc_rvw_id_fk.Value);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_due_dt", doc_sub_due_dt.Text);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_status_set_by", hdn_doc_rvw_sub_status_set_by.Value);
new_sub_cmd.Parameters.AddWithValue("@doc_rvw_sub_status_dt_set", hdn_doc_rvw_sub_status_dt_set.Value);
idrf_cnxn.Open();
new_sub_cmd.ExecuteNonQuery();
idrf_cnxn.Close();
if (IsPostBack)
{
hdn_doc_rvw_sub_by.Value = "";
doc_rvw_sub_recip_list.Text = "";
hdn_doc_rvw_domain_user.Value = "";
doc_rvw_id_fk.Value = "";
hdn_doc_rvw_sub_status.Value = "";
doc_rvw_id_fk.Value = "";
doc_sub_due_dt.Text = "";
hdn_doc_rvw_sub_status_set_by.Value = "";
hdn_doc_rvw_sub_status_dt_set.Value = "";
BindData();
}
}
}
protected void gv_vendor_doc_SelectedIndexChanged(object sender, EventArgs e)
{
hdn_doc_id_fk.Value = gv_vendor_doc.SelectedRow.Cells[1].Text;
hdn_email_doc_id_pk.Value = gv_vendor_doc.SelectedRow.Cells[1].Text;
hdn_email_doc_title.Value = gv_vendor_doc.SelectedRow.Cells[3].Text;
if (gv_vendor_doc.SelectedValue != null)
{
btn_open_new_sub_frm.Visible = true;
}
else
{
btn_open_new_sub_frm.Visible = false;
}
gv_rvw_sub.DataBind();
}
protected void gv_vendor_details_SelectedIndexChanged(object sender, EventArgs e)
{
hdn_email_vendor_nm.Value = gv_vendor_details.SelectedRow.Cells[2].Text;
if (gv_vendor_details.SelectedValue != null)
{
btn_open_new_rvw_frm.Visible = true;
}
else
{
btn_open_new_rvw_frm.Visible = false;
}
gv_vendor_details.DataBind();
}
protected void lnkDownload_Click(object sender, EventArgs e)
{
string filePath = (sender as LinkButton).CommandArgument;
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
Response.WriteFile(filePath);
Response.End();
}
protected void aor_reqd_yn_list_SelectedIndexChanged(object sender, EventArgs e)
{
if (aor_reqd_yn_list.Text == "3")
{
sub_tdi_dt.Enabled = true;
apprvd_tdi_yn_list.Enabled = true;
apprvd_tdi_dt.Enabled = true;
sub_tdi_dt_cal_popup.Enabled = true;
apprvd_tdi_dt_cal_popup.Enabled = true;
}
else
{
sub_tdi_dt.Enabled = false;
apprvd_tdi_yn_list.Enabled = false;
apprvd_tdi_dt.Enabled = false;
sub_tdi_dt_cal_popup.Enabled = false;
apprvd_tdi_dt_cal_popup.Enabled = false;
}
}
protected void submit_new_rvw_form_btn_Click(object sender, EventArgs e)
{
hdn_doc_rvw_dt.Value = DateTime.Now.ToString();
if (string.IsNullOrEmpty(aor_reqd_yn_list.Text))
{
aor_reqd_yn_list.Text = "2";
apprvd_tdi_yn_list.Text = "1";
}
if (string.IsNullOrEmpty(rvw_type_list.SelectedValue))
{ rvw_type_list.Text = "1"; }
else
{ rvw_type_list.SelectedValue.ToString(); }
if (string.IsNullOrEmpty(contract_type_list_ddl.SelectedValue))
{ contract_type_list_ddl.Text = "6"; }
else
{ contract_type_list_ddl.SelectedValue.ToString(); }
SqlConnection idrf_cnxn = new SqlConnection("Data Source=WDBSVCPRD01\\SVCDB;Initial Catalog=idrf;Integrated Security=True");
{
SqlCommand new_rvw_cmd = new SqlCommand("Insert Into tbl_doc_rvw(doc_rvw_dt, rvw_type_list, aor_reqd_yn_list, sub_tdi_dt, apprvd_tdi_yn_list, apprvd_tdi_dt, doc_id_fk, contract_type_list) Values(LTRIM(RTRIM(@doc_rvw_dt)), LTRIM(RTRIM(@rvw_type_list)), LTRIM(RTRIM(@aor_reqd_yn_list)), LTRIM(RTRIM(@sub_tdi_dt)), LTRIM(RTRIM(@apprvd_tdi_yn_list)), LTRIM(RTRIM(@apprvd_tdi_dt)), LTRIM(RTRIM(@doc_id_fk)), LTRIM(RTRIM(@contract_type_list)))", idrf_cnxn);
new_rvw_cmd.Parameters.AddWithValue("@doc_rvw_dt", hdn_doc_rvw_dt.Value);
new_rvw_cmd.Parameters.AddWithValue("@rvw_type_list", rvw_type_list.Text);
new_rvw_cmd.Parameters.AddWithValue("@aor_reqd_yn_list", aor_reqd_yn_list.Text);
new_rvw_cmd.Parameters.AddWithValue("@sub_tdi_dt", !string.IsNullOrEmpty(sub_tdi_dt.Text) ? sub_tdi_dt.Text : (object)DBNull.Value);
new_rvw_cmd.Parameters.AddWithValue("@apprvd_tdi_yn_list", apprvd_tdi_yn_list.Text);
new_rvw_cmd.Parameters.AddWithValue("@apprvd_tdi_dt", !string.IsNullOrEmpty(apprvd_tdi_dt.Text) ? apprvd_tdi_dt.Text : (object)DBNull.Value);
new_rvw_cmd.Parameters.AddWithValue("@doc_id_fk", hdn_doc_id_fk.Value);
new_rvw_cmd.Parameters.AddWithValue("@contract_type_list", contract_type_list_ddl.Text);
idrf_cnxn.Open();
new_rvw_cmd.ExecuteNonQuery();
idrf_cnxn.Close();
if (IsPostBack)
{
hdn_doc_rvw_dt.Value = "";
rvw_type_list.Text = "";
aor_reqd_yn_list.Text = "";
sub_tdi_dt.Text = "";
apprvd_tdi_yn_list.Text = "";
apprvd_tdi_dt.Text = "";
hdn_doc_id_fk.Value = "";
contract_type_list_ddl.Text = "";
gv_doc_rvw.DataBind();
}
}
}
protected void gv_doc_rvw_SelectedIndexChanged(object sender, EventArgs e)
{
doc_rvw_id_fk.Value = gv_doc_rvw.SelectedRow.Cells[0].Text;
hdn_email_doc_rvw_id.Value = gv_doc_rvw.SelectedRow.Cells[0].Text;
BindData();
}
protected void doc_rvw_sub_recip_list_SelectedIndexChanged(object sender, EventArgs e)
{
hdn_doc_rvw_domain_user.Value = domain_user_ddl.Text;
}
protected void btn_send_email_notification_Click(object sender, EventArgs e)
{
MailMessage msg = new MailMessage();
msg.From = new MailAddress("do_not_reply@twia.org");
msg.To.Add(new MailAddress(hdn_email_recipient_nm.Value));
msg.Subject = "A document has been submitted for your review";
msg.Body = "A review for document number " + gv_vendor_doc.SelectedRow.Cells[1].Text + " " + "titled " + gv_vendor_doc.SelectedRow.Cells[3].Text + " " + "for vendor " + gv_vendor_details.SelectedRow.Cells[2].Text + " (" + "Vendor ID " + gv_vendor_details.SelectedRow.Cells[1].Text + ")" + " has been submitted for your review." + " Please, visit your <a href='http://idra/frm_task_queue'>queue.</a>";
msg.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "mail.twia.org";
System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential("do_not_reply@twia.org", "");
smtp.UseDefaultCredentials = false;
smtp.Credentials = NetworkCred;
smtp.Port = 25;
smtp.EnableSsl = true;
smtp.Send(msg);
if (IsPostBack)
{
hdn_email_doc_id_pk.Value = "";
hdn_email_doc_title.Value = "";
hdn_email_vendor_nm.Value = "";
hdn_email_recipient_nm.Value = "";
hdn_email_doc_rvw_id.Value = "";
hdn_email_doc_sub_id.Value = "";
lbl_em_success_notification.Text = ("Email sent successfully.");
}
}
protected void vendor_ddl_SelectedIndexChanged(object sender, EventArgs e)
{
if (vendor_ddl.SelectedItem.Text == "Please Select") { Response.Redirect(Request.RawUrl); }
if (vendor_ddl.SelectedItem.Text == "Please Select")
{
btn_open_new_rvw_frm.Visible = false;
btn_open_new_sub_frm.Visible = false;
}
gv_vendor_details.DataBind();
gv_rvw_sub.DataBind();
}
}
}
For a quick test I created another page and dropped two panels on it with buttons for each and collapsiblepanelexternder controls for each. They work just fine, each loads collapsed.
