Loading...
Helix SwarmHelix Swarm
Loading...

SearchBatch.aspx

  • //
  • guest/
  • Necqui/
  • Documents/
  • Projects/
  • vsDotNet/
  • TKN/
  • BERP/
  • SearchBatch.aspx #2
  • View
  • Commits
  • Open Download .zip Download (42 KB) 
  1. <%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
  2.    CodeFile="SearchBatch.aspx.cs" Inherits="SearchBatch" %>
  3.  
  4. <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
  5.  
  6. <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="Server">
  7.    <style type="text/css">
  8.       .style5
  9.       {
  10.          width: 143px;
  11.       }
  12.       .style10
  13.       {
  14.          width: 219px;
  15.       }
  16.       .style14
  17.       {
  18.          width: 250px;
  19.       }
  20.       .style15
  21.       {
  22.          width: 66%;
  23.       }
  24.       .style54
  25.       {
  26.          width: 101px;
  27.       }
  28.       .style68
  29.       {
  30.          width: 251px;
  31.       }
  32.       .style70
  33.       {
  34.          width: 100%;
  35.          height: 172px;
  36.       }
  37.       .style72
  38.       {
  39.          width: 320px;
  40.          height: 272px;
  41.       }
  42.       .style77
  43.       {
  44.          width: 99px;
  45.          height: 66px;
  46.       }
  47.       .style78
  48.       {
  49.          height: 66px;
  50.          width: 337px;
  51.       }
  52.       .style80
  53.       {
  54.          height: 17px;
  55.          width: 337px;
  56.       }
  57.       .style82
  58.       {
  59.          font-family: "Helvetica Neue" , "Lucida Grande" , "Segoe UI" , Arial, Helvetica, Verdana, sans-serif;
  60.       }
  61.       .style86
  62.       {
  63.          width: 337px;
  64.       }
  65.       .style89
  66.       {
  67.          width: 251px;
  68.          height: 272px;
  69.       }
  70.       .style90
  71.       {
  72.          height: 17px;
  73.       }
  74.       .style96
  75.       {
  76.          width: 251px;
  77.          height: 10px;
  78.       }
  79.       .style98
  80.       {
  81.          width: 320px;
  82.       }
  83.       .style99
  84.       {
  85.          height: 10px;
  86.          width: 320px;
  87.       }
  88.       .style101
  89.       {
  90.          width: 424px;
  91.          height: 10px;
  92.       }
  93.       .style102
  94.       {
  95.          width: 424px;
  96.          height: 272px;
  97.       }
  98.       .style105
  99.       {
  100.          width: 424px;
  101.       }
  102.       .style106
  103.       {
  104.          width: 99px;
  105.          height: 32px;
  106.       }
  107.       .style107
  108.       {
  109.          height: 32px;
  110.          width: 337px;
  111.       }
  112.       .style110
  113.       {
  114.          width: 99px;
  115.          height: 17px;
  116.       }
  117.       .style111
  118.       {
  119.          width: 99px;
  120.       }
  121.       </style>
  122.    <script type="text/javascript">
  123.       function ValidateSearchFields(source, args) {
  124.          var varAccountID = document.getElementById('<%= txtBoxAccountID.ClientID %>');
  125.          var varLastName = document.getElementById('<%= txtBoxLastName.ClientID %>');
  126.          var varFirstName = document.getElementById('<%= txtBoxFirstName.ClientID %>');
  127.  
  128.          if ((varLastName.value != '') || (varFirstName.value != '')) {
  129.             args.IsValid = true;
  130.          }
  131.          else if (varAccountID.value != '') {
  132.             args.IsValid = true;
  133.          }
  134.          else {
  135.             args.IsValid = false;
  136.          }
  137.       }
  138.  
  139.       function ValidateChequeNumber(source2, args2) {
  140.          var varChequeAmount = document.getElementById('<%= txtBoxAmountPaidByCheque.ClientID %>');
  141.          var varChequeNumber = document.getElementById('<%= txtBoxChequeNumber.ClientID %>');
  142.  
  143.          if ((varChequeAmount.value != 0) && (varChequeNumber.value == '')) {
  144.             args2.IsValid = false;
  145.          }
  146.          else {
  147.             args2.IsValid = true;
  148.          }
  149.       }
  150.       function ValidateBatchAdjustmentAmount(source3, args3) {
  151.          var varCashAmount = document.getElementById('<%= txtBoxAmountPaidByCash.ClientID %>');
  152.          var varChequeAmount = document.getElementById('<%= txtBoxAmountPaidByCheque.ClientID %>');
  153.          var temp = document.getElementById('<%= lblBatchAmount.ClientID %>');
  154.          var varBatchAmount = temp.innerHTML.toString();
  155.  
  156.          if ((Number(varChequeAmount.value) + Number(varCashAmount.value)) == 0) {
  157.             args3.IsValid = false;
  158.          }
  159.          else if (Number(varChequeAmount.value) < 0) {
  160.             args3.IsValid = false;
  161.          }
  162.          else if (Number(varCashAmount.value) < 0) {
  163.             args3.IsValid = false;
  164.          }
  165.          else if ((Number(varChequeAmount.value) + Number(varCashAmount.value)) > Number(varBatchAmount)) {
  166.             args3.IsValid = false;
  167.          }
  168.          else {
  169.             args3.IsValid = true;
  170.          }
  171.       }
  172.  
  173.    </script>
  174. </asp:Content>
  175. <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
  176.    
  177. <%--   <asp:UpdatePanel ID="UpdatePanel1" runat="server">
  178.    <ContentTemplate>--%>
  179.  
  180.    <div style="float:left; width:"50%">
  181.    <h2>
  182.       Batch Renewal Search</h2>
  183.    <p>
  184.       Please enter at least one search criteria.</p>
  185. <%--   <asp:Panel ID="Panel1" runat="server" GroupingText="Account Search Criteria" 
  186.          Width="270px" DefaultButton="btnSearch">--%>
  187.       <table class="style14">
  188.          <tr>
  189.             <td class="style5">
  190.                Last Name:
  191.             </td>
  192.             <td class="style10" colspan="2">
  193.                <asp:TextBox ID="txtBoxLastName" runat="server" AutoCompleteType="Disabled" 
  194.                   Width="150px" Height="18px"
  195.                   TabIndex="1" CssClass="eitField"></asp:TextBox>
  196.                <asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="Please enter at least one search criteria."
  197.                   OnServerValidate="CustomValidator1_ServerValidate" ClientValidationFunction="ValidateSearchFields"
  198.                   Display="Dynamic" ValidationGroup="SearchCriteria" Font-Bold="True" ForeColor="Red">*</asp:CustomValidator>
  199.             </td>
  200.          </tr>
  201.          <tr>
  202.             <td class="style5">
  203.                First Name:
  204.             </td>
  205.             <td class="style10" colspan="2">
  206.                <asp:TextBox ID="txtBoxFirstName" runat="server" AutoCompleteType="Disabled" 
  207.                   Width="150px" Height="18px"
  208.                   TabIndex="2" CssClass="eitField"></asp:TextBox>
  209.             </td>
  210.          </tr>
  211.          <tr>
  212.             <td class="style5">
  213.                Jamatkhana:
  214.             </td>
  215.             <td class="style10" colspan="2">
  216.                <asp:DropDownList ID="ddlJamatkhana" runat="server" AppendDataBoundItems="True" DataSourceID="adsJK"
  217.                   DataTextField="JKName" DataValueField="JKID" Width="155px" Height="20px" 
  218.                   TabIndex="3" CssClass="eitField">
  219.                   <asp:ListItem Value="0">- Select Jamatkhana -</asp:ListItem>
  220.                </asp:DropDownList>
  221.             </td>
  222.          </tr>
  223.  
  224. <%--         <tr>
  225.             <td class="style5">
  226.                Telephone:
  227.             </td>
  228.             <td class="style10" colspan="2">
  229.                <asp:TextBox ID="txtBoxTelephone" runat="server" Width="150px" AutoCompleteType="Disabled" Height="18px"
  230.                   TabIndex="4"></asp:TextBox>
  231.             </td>
  232.          </tr>--%>
  233.  
  234.          <tr>
  235.             <td class="style5">
  236.                Account ID:
  237.             </td>
  238.             <td class="style10" colspan="2">
  239.                <asp:TextBox ID="txtBoxAccountID" runat="server" AutoCompleteType="Disabled" 
  240.                   Width="150px" Height="18px"
  241.                   TabIndex="5" CssClass="eitField"></asp:TextBox>
  242.             </td>
  243.          </tr>
  244.  
  245.          <tr>
  246.             <td class="style5">
  247.             </td>
  248.             <td class="style54">
  249.                <asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_Click" Text="Search"
  250.                   Width="65px" TabIndex="6" CssClass="eitField" />
  251.             </td>
  252.             <td class="style10" align="center">
  253.                <asp:Button ID="btnClear" runat="server" Text="Clear" Width="65px" OnClick="btnClear_Click"
  254.                   TabIndex="7" CssClass="eitField" />
  255.             </td>
  256.          </tr>
  257.          <tr>
  258.             <td colspan="3">
  259.                 <asp:ValidationSummary ID="ValidationSummary2" runat="server" CssClass="failureNotification" ValidationGroup="SearchCriteria" />
  260.             </td>
  261.          </tr>
  262.       </table>
  263. <%--   </asp:Panel>--%>
  264.    </div>
  265.    <div style="float:left; width:"100%">
  266.    <table class="style15">
  267.       <tr>
  268.          <td>
  269.             <h2>
  270.                Batch Renewal Search Results:</h2>
  271.          </td>
  272.          <td>
  273.             &nbsp;
  274.          </td>
  275.       </tr>
  276.       <tr>
  277.          <td>
  278.             <asp:GridView ID="gvBatchSearch" runat="server" AllowPaging="True" AutoGenerateColumns="False"
  279.                CellPadding="4" DataKeyNames="AccountID" DataSourceID="adsSearchBatch" ForeColor="#333333"
  280.                GridLines="None" 
  281.                EmptyDataText="No accounts matching your search criteria were found." SelectedIndex="0"
  282.                OnPageIndexChanging="gvBatchSearch_PageIndexChanging" Width="680px" 
  283.                onselectedindexchanged="gvBatchSearch_SelectedIndexChanged" 
  284.                onselectedindexchanging="gvBatchSearch_SelectedIndexChanging" PageSize="6">
  285.                <AlternatingRowStyle BackColor="#D0FFFF" ForeColor="#284775" />
  286.                <Columns>
  287.                   <asp:CommandField ShowSelectButton="True" />
  288.                   <asp:BoundField DataField="AccountID" HeaderText="ID" InsertVisible="False" SortExpression="AccountID"
  289.                      HeaderStyle-HorizontalAlign="Left">
  290.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  291.                   </asp:BoundField>
  292.                   <asp:BoundField DataField="MemberLastName" HeaderText="Last" SortExpression="MemberLastName"
  293.                      HeaderStyle-HorizontalAlign="Left">
  294.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  295.                   </asp:BoundField>
  296.                   <asp:BoundField DataField="MemberMiddleName" HeaderText="Middle" SortExpression="MemberFirstName"
  297.                      HeaderStyle-HorizontalAlign="Left">
  298.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  299.                   </asp:BoundField>
  300.                   <asp:BoundField DataField="MemberFirstName" HeaderText="First" SortExpression="MemberFirstName"
  301.                      HeaderStyle-HorizontalAlign="Left">
  302.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  303.                   </asp:BoundField>
  304.                   <asp:BoundField DataField="AccountRenewalYear" HeaderText="Renewal Year" SortExpression="Renewal Year"
  305.                      HeaderStyle-HorizontalAlign="Left">
  306.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  307.                   </asp:BoundField>
  308.                   <asp:BoundField DataField="JKName" HeaderText="JK" SortExpression="JKName" HeaderStyle-HorizontalAlign="Left">
  309.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  310.                   </asp:BoundField>
  311.                   <asp:CheckBoxField DataField="MemberPrimary" HeaderText="Primary" SortExpression="MemberPrimary"
  312.                      ItemStyle-HorizontalAlign="Center">
  313.                      <ItemStyle HorizontalAlign="Center"></ItemStyle>
  314.                   </asp:CheckBoxField>
  315.                   <asp:BoundField DataField="AccountStatus" HeaderText="Account Status" SortExpression="AccountStatus"
  316.                      HeaderStyle-HorizontalAlign="Left">
  317.                      <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
  318.                   </asp:BoundField>
  319.                </Columns>
  320.                <EditRowStyle BackColor="#DDDDDD" />
  321.                <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  322.                <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  323.                <PagerSettings PageButtonCount="5" />
  324.                <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  325.                <RowStyle BackColor="#EFF3FB" />
  326.                <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  327.                <SortedAscendingCellStyle BackColor="#F5F7FB" />
  328.                <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  329.                <SortedDescendingCellStyle BackColor="#E9EBEF" />
  330.                <SortedDescendingHeaderStyle BackColor="#4870BE" />
  331.             </asp:GridView>
  332.          </td>
  333.          <td>
  334.             &nbsp;
  335.          </td>
  336.       </tr>
  337.    </table>
  338.    </div>
  339.    <div style="clear:both; width:"100%">
  340.       <table style="width: 75%;">
  341.          <tr>
  342.             <td class="style98" valign="top">
  343.                &nbsp;
  344.                </td>
  345.             <td valign="top" class="style105">
  346.                &nbsp;
  347.                </td>
  348.             <td valign="top" class="style68">
  349.                &nbsp;</td>
  350.          </tr>
  351.          <tr>
  352.             <td class="style98" valign="top">
  353.                <asp:GridView ID="gvAccountBatches" runat="server" AutoGenerateColumns="False" 
  354.                   CellPadding="4" DataSourceID="adsAccountBatches" 
  355.                   ForeColor="#333333" GridLines="None" DataKeyNames="BatchID" 
  356.                   onselectedindexchanged="gvAccountBatches_SelectedIndexChanged" 
  357.                   Caption="RECENT BATCH MATCHING THE SELECTED ACCOUNT" Width="675px" 
  358.                   CaptionAlign="Left" AllowPaging="True" PageSize="3">
  359.                   <AlternatingRowStyle BackColor="White" />
  360.                   <Columns>
  361.                      <asp:CommandField ShowSelectButton="True" >
  362.                      <ItemStyle HorizontalAlign="Left" Width="25px" />
  363.                      </asp:CommandField>
  364.                      <asp:BoundField DataField="BatchID" HeaderText="Batch ID" 
  365.                         SortExpression="BatchID" >
  366.                      <HeaderStyle HorizontalAlign="Left" Width="25px" />
  367.                      <ItemStyle HorizontalAlign="Left" Width="25px" />
  368.                      </asp:BoundField>
  369.                      <asp:BoundField DataField="AccountID" HeaderText="Account ID" 
  370.                         SortExpression="AccountID" >
  371.                      <HeaderStyle HorizontalAlign="Left" Width="25px" />
  372.                      <ItemStyle HorizontalAlign="Left" Width="25px" />
  373.                      </asp:BoundField>
  374.                      <asp:BoundField DataField="JKName" HeaderText="Jamatkhana" 
  375.                         SortExpression="JKName" >
  376.                      <HeaderStyle HorizontalAlign="Left" Width="60px" />
  377.                      <ItemStyle HorizontalAlign="Left" Width="60px" />
  378.                      </asp:BoundField>
  379.                      <asp:BoundField DataField="BatchCreationDate" HeaderText="Date Created" 
  380.                         SortExpression="BatchCreationDate" DataFormatString="{0:dd MMM yyyy}">
  381.                      <HeaderStyle HorizontalAlign="Left" Width="90px" />
  382.                      <ItemStyle HorizontalAlign="Left" Width="90px" />
  383.                      </asp:BoundField>
  384.                      <asp:BoundField DataField="UserName" HeaderText="Created By" 
  385.                         SortExpression="UserName" >
  386.                      <HeaderStyle HorizontalAlign="Left" Width="60px" />
  387.                      <ItemStyle HorizontalAlign="Left" Width="60px" />
  388.                      </asp:BoundField>
  389.                      <asp:BoundField DataField="BatchTotal" HeaderText="Batch Total" 
  390.                         SortExpression="BatchTotal" DataFormatString="{0:C}">
  391.                      <HeaderStyle HorizontalAlign="Left" Width="60px" />
  392.                      <ItemStyle HorizontalAlign="Left" Width="60px" />
  393.                      </asp:BoundField>
  394.                      <asp:BoundField DataField="BatchComments" HeaderText="Comments" 
  395.                         SortExpression="BatchComments">
  396.                      <HeaderStyle HorizontalAlign="Left" Width="200px" />
  397.                      <ItemStyle HorizontalAlign="Left" Width="200px" />
  398.                      </asp:BoundField>
  399.                   </Columns>
  400.                   <EditRowStyle BackColor="#2461BF" />
  401.                   <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  402.                   <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  403.                   <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  404.                   <RowStyle BackColor="#EFF3FB" />
  405.                   <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  406.                   <SortedAscendingCellStyle BackColor="#F5F7FB" />
  407.                   <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  408.                   <SortedDescendingCellStyle BackColor="#E9EBEF" />
  409.                   <SortedDescendingHeaderStyle BackColor="#4870BE" />
  410.                </asp:GridView>
  411.             </td>
  412.             <td valign="top" class="style105">
  413.                <asp:GridView ID="gvBatchAdjustments" runat="server" 
  414.                   AutoGenerateColumns="False" CellPadding="4" DataSourceID="adsBatchAdjustments" 
  415.                   ForeColor="#333333" GridLines="None" Width="550px" 
  416.                   Caption="BATCH ADJUSTMENTS" CaptionAlign="Left" PageSize="3" 
  417.                   AllowPaging="True">
  418.                   <AlternatingRowStyle BackColor="White" />
  419.                   <Columns>
  420.                      <asp:BoundField DataField="BatchAdjustmentBatchID" HeaderText="Batch ID" 
  421.                         SortExpression="BatchAdjustmentBatchID">
  422.                      <HeaderStyle HorizontalAlign="Left" Width="25px" />
  423.                      <ItemStyle HorizontalAlign="Left" Width="25px" />
  424.                      </asp:BoundField>
  425.                      <asp:BoundField DataField="BatchAdjustmentAccountID" HeaderText="Account ID" 
  426.                         SortExpression="BatchAdjustmentAccountID">
  427.                      <HeaderStyle HorizontalAlign="Left" Width="25px" />
  428.                      <ItemStyle HorizontalAlign="Left" Width="25px" />
  429.                      </asp:BoundField>
  430.                      <asp:BoundField DataField="BatchAdjustmentCashAmount" DataFormatString="{0:C}" 
  431.                         HeaderText="Cash" SortExpression="BatchAdjustmentCashAmount">
  432.                      <HeaderStyle HorizontalAlign="Left" Width="30px" />
  433.                      <ItemStyle HorizontalAlign="Left" Width="30px" />
  434.                      </asp:BoundField>
  435.                      <asp:BoundField DataField="BatchAdjustmentChequeAmount" DataFormatString="{0:C}" 
  436.                         HeaderText="Cheque" SortExpression="BatchAdjustmentChequeAmount">
  437.                      <HeaderStyle HorizontalAlign="Left" Width="30px" />
  438.                      <ItemStyle HorizontalAlign="Left" Width="30px" />
  439.                      </asp:BoundField>
  440.                      <asp:BoundField DataField="BatchAdjustmentChequeNumber" 
  441.                         HeaderText="Cheque Number" SortExpression="BatchAdjustmentChequeNumber">
  442.                      <HeaderStyle HorizontalAlign="Left" Width="20px" />
  443.                      <ItemStyle HorizontalAlign="Left" Width="20px" />
  444.                      </asp:BoundField>
  445.                      <asp:BoundField DataField="BatchAdjustmentCreatedBy" HeaderText="Entered By" 
  446.                         SortExpression="BatchAdjustmentCreatedBy">
  447.                      <HeaderStyle HorizontalAlign="Left" Width="65px" />
  448.                      <ItemStyle HorizontalAlign="Left" Width="65px" />
  449.                      </asp:BoundField>
  450.                      <asp:BoundField DataField="BatchAdjustmentCreatedDate" 
  451.                         DataFormatString="{0:dd MMM yyyy}" HeaderText="Date Entered" 
  452.                         SortExpression="BatchAdjustmentCreatedDate">
  453.                      <HeaderStyle HorizontalAlign="Left" Width="90px" />
  454.                      <ItemStyle HorizontalAlign="Left" Width="90px" />
  455.                      </asp:BoundField>
  456.                      <asp:BoundField DataField="BatchAdjustmentComments" HeaderText="Comments" 
  457.                         SortExpression="BatchAdjustmentComments">
  458.                      <HeaderStyle HorizontalAlign="Left" Width="300px" />
  459.                      <ItemStyle HorizontalAlign="Left" Width="300px" />
  460.                      </asp:BoundField>
  461.                   </Columns>
  462.                   <EditRowStyle BackColor="#2461BF" />
  463.                   <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  464.                   <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  465.                   <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  466.                   <RowStyle BackColor="#EFF3FB" />
  467.                   <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  468.                   <SortedAscendingCellStyle BackColor="#F5F7FB" />
  469.                   <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  470.                   <SortedDescendingCellStyle BackColor="#E9EBEF" />
  471.                   <SortedDescendingHeaderStyle BackColor="#4870BE" />
  472.                </asp:GridView>
  473.             </td>
  474.             <td valign="top" class="style68">               
  475.                &nbsp;</td>
  476.          </tr>
  477.          <tr>
  478.             <td class="style99" valign="top">
  479.                </td>
  480.             <td class="style101" valign="top">
  481.             </td>
  482.             <td class="style96" valign="top">
  483.                </td>
  484.          </tr>
  485.          <tr>
  486.             <td class="style72" valign="top">
  487.                <asp:GridView ID="gvBatchDetails" runat="server" AllowPaging="True" 
  488.                   AutoGenerateColumns="False" CellPadding="4" DataKeyNames="BatchID,AccountID" 
  489.                   DataSourceID="adsBatchDetails" ForeColor="#333333" GridLines="None" 
  490.                   onselectedindexchanged="gvBatchDetails_SelectedIndexChanged" Width="675px" 
  491.                   Caption="BATCH DETAILS" CaptionAlign="Left" 
  492.                   onrowdatabound="gvBatchDetails_RowDataBound">
  493.                   <AlternatingRowStyle BackColor="White" />
  494.                   <Columns>
  495.                      <asp:CommandField ShowSelectButton="True" SelectText="Adjust" >
  496.                      <HeaderStyle Width="25px" />
  497.                      <ItemStyle Width="25px" />
  498.                      </asp:CommandField>
  499.                      <asp:BoundField DataField="BatchID" HeaderText="Batch ID" 
  500.                         SortExpression="BatchID">
  501.                      <HeaderStyle HorizontalAlign="Left" Width="20px" />
  502.                      <ItemStyle HorizontalAlign="Left" Width="20px" />
  503.                      </asp:BoundField>
  504.                      <asp:BoundField DataField="AccountID" HeaderText="Account ID" 
  505.                         SortExpression="AccountID">
  506.                      <HeaderStyle HorizontalAlign="Left" Width="20px" />
  507.                      <ItemStyle HorizontalAlign="Left" Width="20px" />
  508.                      </asp:BoundField>
  509. <%--                     <asp:BoundField DataField="MemberLastName" HeaderText="Last Name" 
  510.                         SortExpression="MemberLastName">
  511.                      <HeaderStyle HorizontalAlign="Left" Width="60px" />
  512.                      <ItemStyle HorizontalAlign="Left" Width="60px" />
  513.                      </asp:BoundField>
  514.                      <asp:BoundField DataField="MemberMiddleName" HeaderText="Middle" 
  515.                         SortExpression="MemberMiddleName" Visible="False" />
  516.                      <asp:BoundField DataField="MemberFirstName" HeaderText="First Name" 
  517.                         SortExpression="MemberFirstName">
  518.                      <HeaderStyle HorizontalAlign="Left" Width="60px" />
  519.                      <ItemStyle HorizontalAlign="Left" Width="60px" />
  520.                      </asp:BoundField>--%>
  521.                      <asp:BoundField DataField="MemberFullName" HeaderText="Last, First Name" 
  522.                         SortExpression="MemberFullName">
  523.                      <HeaderStyle HorizontalAlign="Left" Width="90px" />
  524.                      <ItemStyle HorizontalAlign="Left" Width="90px" />
  525.                      </asp:BoundField>
  526. <%--                     <asp:TemplateField HeaderText="Last, First Name">
  527.                         <ItemTemplate>
  528.                            <asp:Label ID="Label5" runat="server" Text='<%# String.Format("{0}, {1}", FormatLastNameToUpper( Eval("MemberLastName")), Eval("MemberFirstName")) %>'></asp:Label>
  529.                         </ItemTemplate>
  530.                         <HeaderStyle Width="100px" HorizontalAlign="Left" />
  531.                         <ItemStyle HorizontalAlign="Left" Width="100px" />
  532.                      </asp:TemplateField>--%>
  533.                      <asp:BoundField DataField="AmountDue" DataFormatString="{0:C}" 
  534.                         HeaderText="Amount Due" SortExpression="AmountDue">
  535.                      <HeaderStyle HorizontalAlign="Left" Width="40px" />
  536.                      <ItemStyle HorizontalAlign="Left" Width="40px" />
  537.                      </asp:BoundField>
  538.                      <asp:BoundField DataField="AmountPaid" DataFormatString="{0:C}" 
  539.                         HeaderText="Amount Paid" SortExpression="AmountPaid">
  540.                      <HeaderStyle HorizontalAlign="Left" Width="40px" />
  541.                      <ItemStyle HorizontalAlign="Left" Width="40px" />
  542.                      </asp:BoundField>
  543.                      <asp:BoundField DataField="BatchPaymentType" HeaderText="Paid by" 
  544.                         SortExpression="BatchPaymentType">
  545.                      <HeaderStyle HorizontalAlign="Left" Width="40px" />
  546.                      <ItemStyle HorizontalAlign="Left" Width="40px" />
  547.                      </asp:BoundField>
  548.                      <asp:BoundField DataField="BatchDetailsChequeNumber" HeaderText="Cheque Number" 
  549.                         SortExpression="BatchDetailsChequeNumber">
  550.                      <HeaderStyle HorizontalAlign="Left" Width="40px" />
  551.                      <ItemStyle HorizontalAlign="Left" Width="40px" />
  552.                      </asp:BoundField>
  553.                      <asp:CheckBoxField DataField="MemberPrimary" HeaderText="Primary" 
  554.                         SortExpression="MemberPrimary" Visible="False" />
  555.                      <asp:BoundField DataField="BatchDetailsComments" HeaderText="Comments" 
  556.                         SortExpression="BatchDetailsComments">
  557.                      <HeaderStyle HorizontalAlign="Left" Width="200px" />
  558.                      <ItemStyle HorizontalAlign="Left" Width="200px" />
  559.                      </asp:BoundField>
  560.                         
  561.                   </Columns>
  562.                   <EditRowStyle BackColor="#2461BF" />
  563.                   <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  564.                   <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  565.                   <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  566.                   <RowStyle BackColor="#EFF3FB" />
  567.                   <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  568.                   <SortedAscendingCellStyle BackColor="#F5F7FB" />
  569.                   <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  570.                   <SortedDescendingCellStyle BackColor="#E9EBEF" />
  571.                   <SortedDescendingHeaderStyle BackColor="#4870BE" />
  572.                </asp:GridView>
  573.                <br />
  574.                <asp:Label ID="lblError" runat="server" CssClass="failureNotification"></asp:Label>
  575.             </td>
  576.             <td class="style102" valign="top">
  577.                &nbsp;
  578.                <asp:Panel ID="pnlAdjustments" runat="server" BackColor="#FFFFD5" 
  579.                   Height="399px" Width="440px">
  580.                   <table class="style70" border="1">
  581.                      <tr>
  582.                         <td align="center" class="style90" colspan="2">
  583.                            <asp:Label ID="lblHeader" runat="server" Font-Bold="True" 
  584.                               Text="ADD BATCH ADJUSTMENT"></asp:Label>
  585.                         </td>
  586.                      </tr>
  587.                      <tr>
  588.                         <td class="style110">
  589.                            <asp:Label ID="lblHeaderBatchID" runat="server" Font-Bold="True" 
  590.                               Text="BATCH ID:"></asp:Label>
  591.                         </td>
  592.                         <td class="style80">
  593.                            <asp:Label ID="lblBatchID" runat="server" Text="2081"></asp:Label>
  594.                         </td>
  595.                      </tr>
  596.                      <tr>
  597.                         <td class="style110">
  598.                            <asp:Label ID="lblHeaderAccountID" runat="server" Font-Bold="True" 
  599.                               Text="ACCOUNT ID:"></asp:Label>
  600.                         </td>
  601.                         <td class="style80">
  602.                            <asp:Label ID="lblAccountID" runat="server" Text="2405"></asp:Label>
  603.                         </td>
  604.                      </tr>
  605.                      <tr>
  606.                         <td class="style110">
  607.                            <asp:Label ID="lblHeaderFullName" runat="server" Font-Bold="True" 
  608.                               Text="FULL NAME:"></asp:Label>
  609.                         </td>
  610.                         <td class="style80">
  611.                            <asp:Label ID="lblFullName" runat="server" Text="Full name"></asp:Label>
  612.                         </td>
  613.                      </tr>
  614.                      <tr>
  615.                         <td class="style110">
  616.                            <asp:Label ID="lblHeaderBatchAmount" runat="server" Font-Bold="True" 
  617.                               Text="BATCH AMOUNT:"></asp:Label>
  618.                         </td>
  619.                         <td class="style80">
  620.                            <asp:Label ID="lblBatchAmount" runat="server" Text="230"></asp:Label>
  621.                         </td>
  622.                      </tr>
  623.                      <tr>
  624.                         <td colspan="2">
  625.                            <span class="bold">PAYMENT:</span>
  626.                         </td>
  627.                      </tr>
  628.                      <tr>
  629.                         <td class="style111">
  630.                            Cash amount:</td>
  631.                         <td class="style68">
  632.                            <asp:TextBox ID="txtBoxAmountPaidByCash" runat="server" Width="50px" 
  633.                               AutoCompleteType="Disabled" TabIndex="14" CssClass="eitField"></asp:TextBox>
  634.                               &nbsp;
  635.                            <asp:RequiredFieldValidator ID="RequiredFieldValidatorPaidByCash" runat="server" ControlToValidate="txtBoxAmountPaidByCash"
  636.                               CssClass="failureNotification" Display="Dynamic" ErrorMessage="Adjustment Amount is required. Enter 0 for full payment by cheque."
  637.                               ValidationGroup="ValidationGroupAdjustment" SetFocusOnError="True">*</asp:RequiredFieldValidator>
  638.                         </td>
  639.                      </tr>
  640.                      <tr>
  641.                         <td class="style111">
  642.                            Cheque amount:</td>
  643.                         <td class="style68">
  644.                            <asp:TextBox ID="txtBoxAmountPaidByCheque" runat="server" Width="50px" 
  645.                               AutoCompleteType="Disabled" TabIndex="15" CssClass="eitField"></asp:TextBox>
  646.                               &nbsp;
  647.                            <asp:RequiredFieldValidator ID="RequiredFieldValidatorPaidByCheque" runat="server" ControlToValidate="txtBoxAmountPaidByCheque"
  648.                               CssClass="failureNotification" Display="Dynamic" ErrorMessage="Adjustment Amount is required. Enter 0 for full payment by cash."
  649.                               ValidationGroup="ValidationGroupAdjustment" SetFocusOnError="True">*</asp:RequiredFieldValidator>
  650.                         </td>
  651.                      </tr>
  652.                      <tr>
  653.                         <td class="style111">
  654.                            Cheque number:</td>
  655.                         <td class="style68">
  656.                            <asp:TextBox ID="txtBoxChequeNumber" runat="server" Width="50px" 
  657.                               AutoCompleteType="Disabled" TabIndex="16" CssClass="eitField"></asp:TextBox>
  658.                               &nbsp;
  659.                            <asp:CustomValidator ID="CustomChequeNumberValidator" runat="server" CssClass="failureNotification"
  660.                               ErrorMessage="Cheque number is required if adjustment by cheque." OnServerValidate="ChequeNumberCustomValidator_ServerValidate"
  661.                               ValidationGroup="ValidationGroupAdjustment" ClientValidationFunction="ValidateChequeNumber"
  662.                               Display="Dynamic">*</asp:CustomValidator>
  663.                         </td>
  664.                      </tr>
  665. <%--                     <tr>
  666.                         <td class="style79">
  667.                            <asp:Label ID="lblHeaderAdjustmentAmount" runat="server" Font-Bold="True" 
  668.                               Text="ADJUSTMENT AMOUNT:"></asp:Label>
  669.                         </td>
  670.                         <td class="style80">
  671.                            <asp:TextBox ID="txtboxAmount" runat="server" AutoCompleteType="Disabled" 
  672.                               CssClass="eitField" Width="75px"></asp:TextBox>
  673.                            &nbsp;
  674.                            <asp:RequiredFieldValidator ID="rfvAdjustmentAmount" runat="server" 
  675.                               ControlToValidate="txtboxAmount" CssClass="failureNotification" 
  676.                               Display="Dynamic" ErrorMessage="Adjustment amount is required." Text="*" 
  677.                               ValidationGroup="ValidationGroupAdjustment"></asp:RequiredFieldValidator>
  678.  
  679.                            <asp:CustomValidator ID="CustomValidatorAdjustmentAmount" runat="server" 
  680.                               ClientValidationFunction="ValidateBatchAdjustmentAmount" 
  681.                               CssClass="failureNotification" Display="Dynamic" 
  682.                               ErrorMessage="Adjustment amount must be greater than 0 and less than the batch amount." 
  683.                               onservervalidate="CustomValidatorAdjustmentAmount_ServerValidate" Text="*" 
  684.                               ValidationGroup="ValidationGroupAdjustment"></asp:CustomValidator>
  685.                         </td>
  686.                      </tr>--%>
  687.                      <tr>
  688.                         <td class="style77">
  689.                            <span class="bold">TYPE OF ADJUSTMENT:</span></td>
  690.                         <td class="style78">
  691.                            <asp:RadioButtonList ID="rblAdjustmentType" runat="server">
  692.                               <asp:ListItem Selected="True" Value="1">Refunds, Stop payments, etc. (Batch reduction)</asp:ListItem>
  693.                               <asp:ListItem Value="2">Payment received (Batch increased)</asp:ListItem>
  694.                            </asp:RadioButtonList>
  695.                         </td>
  696.                      </tr>
  697.                      <tr>
  698.                         <td class="style106">
  699.                            <asp:Label ID="lblReason" runat="server" Font-Bold="True" 
  700.                               Text="REASON FOR ADJUSTMENT:"></asp:Label>
  701.                         </td>
  702.                         <td class="style107">
  703.                            <asp:TextBox ID="txtboxReason" runat="server" AutoCompleteType="Disabled" 
  704.                               CssClass="style82" Height="40px" TextMode="MultiLine" Width="289px"></asp:TextBox>
  705.                            <asp:TextBoxWatermarkExtender ID="txtboxReason_TextBoxWatermarkExtender" 
  706.                               runat="server" Enabled="True" TargetControlID="txtboxReason" 
  707.                               WatermarkCssClass="watermarked" 
  708.                               WatermarkText="Please enter detailed comments for the batch adjustment.">
  709.                            </asp:TextBoxWatermarkExtender>
  710.                            &nbsp;
  711.                            <asp:RequiredFieldValidator ID="rfvAdjustmentReason" runat="server" 
  712.                               ControlToValidate="txtboxReason" CssClass="failureNotification" 
  713.                               Display="Dynamic" 
  714.                               ErrorMessage="Detailed comments for the adjustment are required." Text="*" 
  715.                               ValidationGroup="ValidationGroupAdjustment"></asp:RequiredFieldValidator>
  716.                         </td>
  717.                      </tr>
  718.                      <tr>
  719.                         <td class="style111">
  720.                            &nbsp;</td>
  721.                         <td class="style86">
  722.                            <asp:Button ID="btnAddAdjustment" runat="server" CssClass="eitField" 
  723.                               onclick="btnAddAdjustment_Click" Text="Adjust Batch" 
  724.                               ValidationGroup="ValidationGroupAdjustment" Width="89px" />
  725.                            &nbsp;
  726.                            <asp:CustomValidator ID="CustomValidatorAdjustmentAmount" runat="server" 
  727.                               ClientValidationFunction="ValidateBatchAdjustmentAmount" 
  728.                               CssClass="failureNotification" Display="Dynamic" 
  729.                               ErrorMessage="Adjustment amount must be greater than 0 and less than the batch amount." 
  730.                               onservervalidate="CustomValidatorAdjustmentAmount_ServerValidate" Text="*" 
  731.                               ValidationGroup="ValidationGroupAdjustment"></asp:CustomValidator>
  732.                         </td>
  733.                      </tr>
  734.                   </table>
  735.                </asp:Panel>
  736.             </td>
  737.             <td class="style89" valign="top">
  738.             </td>
  739.          </tr>
  740.          <tr>
  741.             <td class="style98" valign="top">
  742.                &nbsp;</td>
  743.             <td class="style105" valign="top">
  744.                <asp:ValidationSummary ID="ValidationSummaryBatchAdjustment" runat="server" 
  745.                   CssClass="failureNotification" HeaderText="Batch Adjustment Validation Errors:" 
  746.                   ValidationGroup="ValidationGroupAdjustment" />
  747.             </td>
  748.             <td class="style68" valign="top">
  749.                &nbsp;</td>
  750.          </tr>
  751.          <tr>
  752.             <td class="style98" valign="top">
  753.                &nbsp;</td>
  754.             <td valign="top" class="style105"> 
  755.                &nbsp;</td>
  756.             <td valign="top" class="style68"> 
  757.                &nbsp;</td>
  758.          </tr>
  759.          </table>
  760.  
  761.       <br />
  762.  
  763.    </div>
  764.  
  765.    <div>
  766.       <br />
  767.    </div>
  768.    <asp:AccessDataSource ID="adsJK" runat="server" DataFile="~/App_Data/Burial.mdb"
  769.       SelectCommand="SELECT [JKID], [JKName] FROM [Jamatkhana]"></asp:AccessDataSource>
  770.  
  771.    <asp:AccessDataSource ID="adsSearchBatch" runat="server" DataFile="~/App_Data/Burial.mdb"
  772.       SelectCommand="SELECT Accounts.AccountID, Members.MemberLastName, Members.MemberMiddleName, Members.MemberFirstName, Accounts.AccountRenewalYear, AccountStatus.AccountStatus, Members.MemberPrimary, Jamatkhana.JKName FROM ((((Accounts INNER JOIN AccountStatus ON Accounts.AccountStatusID = AccountStatus.AccountStatusID) INNER JOIN Members ON Accounts.AccountID = Members.AccountID) INNER JOIN MemberStatus ON Members.MemberStatusID = MemberStatus.MemberStatusID) INNER JOIN Jamatkhana ON Accounts.AccountJamatkhanaID = Jamatkhana.JKID) WHERE (@TempLastName IS NULL OR Members.MemberLastName LIKE '%' + @TempLastName + '%') AND (@TempFirstName IS NULL OR Members.MemberFirstName LIKE '%' + @TempFirstName + '%') AND (@TempJamatkhanaID = 0 OR Accounts.AccountJamatkhanaID = @TempJamatkhanaID) AND (@TempAccountID IS NULL OR Accounts.AccountID LIKE '%' + @TempAccountID + '%') AND (Members.MemberPrimary = TRUE) AND (Accounts.AccountStatusID = 1) ORDER BY Accounts.AccountID"
  773.       CancelSelectOnNullParameter="False" OnSelecting="adsSearchBatch_Selecting">
  774.       <SelectParameters>
  775.          <asp:ControlParameter ControlID="txtBoxLastName" Name="MemberLastName" Type="String" />
  776.          <asp:ControlParameter ControlID="txtBoxFirstName" Name="MemberFirstName" Type="String" />
  777.          <asp:ControlParameter ControlID="ddlJamatkhana" Name="AccountJamatkhanaID" Type="Int32" />
  778.          <asp:ControlParameter ControlID="txtBoxAccountID" Name="AccountID" Type="String" />
  779.       </SelectParameters>
  780.    </asp:AccessDataSource>
  781.  
  782.    <asp:AccessDataSource ID="adsAccountBatches" runat="server" DataFile="~/App_Data/Burial.mdb"                        
  783.       
  784.       SelectCommand="SELECT TOP 1 Batch.BatchID, Batch.BatchCreationDate, Batch.UserName, Batch.BatchTotal, Batch.BatchComments, BatchDetails.AccountID, Jamatkhana.JKName FROM ((Batch INNER JOIN BatchDetails ON Batch.BatchID = BatchDetails.BatchID) INNER JOIN Jamatkhana ON Batch.JamatkhanaID = Jamatkhana.JKID) WHERE (BatchDetails.AccountID = ?) ORDER BY Batch.BatchID DESC">
  785.       <SelectParameters>
  786.          <asp:ControlParameter ControlID="gvBatchSearch" Name="?" PropertyName="SelectedValue"
  787.             Type="Int32" />
  788.       </SelectParameters>
  789.    </asp:AccessDataSource>
  790.  
  791.    <asp:AccessDataSource ID="adsBatchDetails" runat="server" 
  792.       DataFile="~/App_Data/Burial.mdb" 
  793.             
  794.       
  795.       SelectCommand="SELECT BatchDetails.BatchID, BatchDetails.AccountID, BatchDetails.AmountDue, BatchDetails.AmountPaid, BatchDetails.BatchDetailsChequeNumber, BatchDetails.BatchDetailsComments, BatchPaymentType.BatchPaymentType, Members.MemberLastName, Members.MemberMiddleName, Members.MemberFirstName, Members.MemberLastName+', '+Members.MemberFirstName AS MemberFullName, Members.MemberPrimary FROM ((BatchDetails INNER JOIN BatchPaymentType ON BatchDetails.BatchPaymentTypeID = BatchPaymentType.BatchPaymentTypeID) INNER JOIN Members ON BatchDetails.AccountID = Members.AccountID) WHERE (Members.MemberPrimary = TRUE) AND (BatchDetails.BatchID = ?) ORDER BY BatchDetails.AccountID">
  796.       <SelectParameters>
  797.          <asp:ControlParameter ControlID="gvAccountBatches" Name="?" 
  798.             PropertyName="SelectedValue" />
  799.       </SelectParameters>
  800.    </asp:AccessDataSource>
  801.  
  802. <%--   <asp:AccessDataSource ID="adsBatchSummary" runat="server" DataFile="~/App_Data/Burial.mdb"
  803.       SelectCommand="SELECT Batch.BatchID, Jamatkhana.JKName, Batch.BatchCreationDate, Batch.UserName, Batch.BatchComments, Batch.BatchTotal FROM (Batch INNER JOIN Jamatkhana ON Batch.JamatkhanaID = Jamatkhana.JKID) WHERE (Batch.BatchID = ?)">
  804.       <SelectParameters>
  805.          <asp:ControlParameter ControlID="gvAccountBatches" Name="?" PropertyName="SelectedValue" />
  806.       </SelectParameters>
  807.    </asp:AccessDataSource>--%>
  808.  
  809.       <asp:AccessDataSource ID="adsBatchAdjustments" runat="server" 
  810.          DataFile="~/App_Data/Burial.mdb" 
  811.          SelectCommand="SELECT BatchAdjustments.BatchAdjustmentBatchID, BatchAdjustments.BatchAdjustmentAccountID, BatchAdjustments.BatchAdjustmentCashAmount, BatchAdjustments.BatchAdjustmentChequeAmount, BatchAdjustments.BatchAdjustmentChequeNumber, BatchAdjustments.BatchAdjustmentCreatedBy, BatchAdjustments.BatchAdjustmentCreatedDate, BatchAdjustments.BatchAdjustmentComments FROM BatchAdjustments WHERE (BatchAdjustments.BatchAdjustmentBatchID = ?) ORDER BY BatchAdjustments.BatchAdjustmentAccountID">
  812.          <SelectParameters>
  813.          <asp:ControlParameter ControlID="gvAccountBatches" Name="?" 
  814.             PropertyName="SelectedValue" />
  815.       </SelectParameters>
  816.       </asp:AccessDataSource>
  817.  
  818. <%--      </ContentTemplate>
  819.    </asp:UpdatePanel>
  820.  
  821.    <asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="200" AssociatedUpdatePanelID="UpdatePanel1">
  822.       <ProgressTemplate>
  823.          <div class="PleaseWait">
  824.             Please wait ...
  825.          </div>
  826.       </ProgressTemplate>
  827.    </asp:UpdateProgress>--%>
  828.  
  829. </asp:Content>
# Change User Description Committed
#2 21431 Necqui Updates 8 years ago
#1 21430 Necqui TKN Initial 8 years ago