<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="SearchBatch.aspx.cs" Inherits="SearchBatch" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="Server">
<style type="text/css">
.style5
{
width: 143px;
}
.style10
{
width: 219px;
}
.style14
{
width: 250px;
}
.style15
{
width: 66%;
}
.style54
{
width: 101px;
}
.style68
{
width: 251px;
}
.style70
{
width: 100%;
height: 172px;
}
.style72
{
width: 320px;
height: 272px;
}
.style77
{
width: 99px;
height: 66px;
}
.style78
{
height: 66px;
width: 337px;
}
.style80
{
height: 17px;
width: 337px;
}
.style82
{
font-family: "Helvetica Neue" , "Lucida Grande" , "Segoe UI" , Arial, Helvetica, Verdana, sans-serif;
}
.style86
{
width: 337px;
}
.style89
{
width: 251px;
height: 272px;
}
.style90
{
height: 17px;
}
.style96
{
width: 251px;
height: 10px;
}
.style98
{
width: 320px;
}
.style99
{
height: 10px;
width: 320px;
}
.style101
{
width: 424px;
height: 10px;
}
.style102
{
width: 424px;
height: 272px;
}
.style105
{
width: 424px;
}
.style106
{
width: 99px;
height: 32px;
}
.style107
{
height: 32px;
width: 337px;
}
.style110
{
width: 99px;
height: 17px;
}
.style111
{
width: 99px;
}
</style>
<script type="text/javascript">
function ValidateSearchFields(source, args) {
var varAccountID = document.getElementById('<%= txtBoxAccountID.ClientID %>');
var varLastName = document.getElementById('<%= txtBoxLastName.ClientID %>');
var varFirstName = document.getElementById('<%= txtBoxFirstName.ClientID %>');
if ((varLastName.value != '') || (varFirstName.value != '')) {
args.IsValid = true;
}
else if (varAccountID.value != '') {
args.IsValid = true;
}
else {
args.IsValid = false;
}
}
function ValidateChequeNumber(source2, args2) {
var varChequeAmount = document.getElementById('<%= txtBoxAmountPaidByCheque.ClientID %>');
var varChequeNumber = document.getElementById('<%= txtBoxChequeNumber.ClientID %>');
if ((varChequeAmount.value != 0) && (varChequeNumber.value == '')) {
args2.IsValid = false;
}
else {
args2.IsValid = true;
}
}
function ValidateBatchAdjustmentAmount(source3, args3) {
var varCashAmount = document.getElementById('<%= txtBoxAmountPaidByCash.ClientID %>');
var varChequeAmount = document.getElementById('<%= txtBoxAmountPaidByCheque.ClientID %>');
var temp = document.getElementById('<%= lblBatchAmount.ClientID %>');
var varBatchAmount = temp.innerHTML.toString();
if ((Number(varChequeAmount.value) + Number(varCashAmount.value)) == 0) {
args3.IsValid = false;
}
else if (Number(varChequeAmount.value) < 0) {
args3.IsValid = false;
}
else if (Number(varCashAmount.value) < 0) {
args3.IsValid = false;
}
else if ((Number(varChequeAmount.value) + Number(varCashAmount.value)) > Number(varBatchAmount)) {
args3.IsValid = false;
}
else {
args3.IsValid = true;
}
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
<%-- <asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>--%>
<div style="float:left; width:"50%">
<h2>
Batch Renewal Search</h2>
<p>
Please enter at least one search criteria.</p>
<%-- <asp:Panel ID="Panel1" runat="server" GroupingText="Account Search Criteria"
Width="270px" DefaultButton="btnSearch">--%>
<table class="style14">
<tr>
<td class="style5">
Last Name:
</td>
<td class="style10" colspan="2">
<asp:TextBox ID="txtBoxLastName" runat="server" AutoCompleteType="Disabled"
Width="150px" Height="18px"
TabIndex="1" CssClass="eitField"></asp:TextBox>
<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="Please enter at least one search criteria."
OnServerValidate="CustomValidator1_ServerValidate" ClientValidationFunction="ValidateSearchFields"
Display="Dynamic" ValidationGroup="SearchCriteria" Font-Bold="True" ForeColor="Red">*</asp:CustomValidator>
</td>
</tr>
<tr>
<td class="style5">
First Name:
</td>
<td class="style10" colspan="2">
<asp:TextBox ID="txtBoxFirstName" runat="server" AutoCompleteType="Disabled"
Width="150px" Height="18px"
TabIndex="2" CssClass="eitField"></asp:TextBox>
</td>
</tr>
<tr>
<td class="style5">
Jamatkhana:
</td>
<td class="style10" colspan="2">
<asp:DropDownList ID="ddlJamatkhana" runat="server" AppendDataBoundItems="True" DataSourceID="adsJK"
DataTextField="JKName" DataValueField="JKID" Width="155px" Height="20px"
TabIndex="3" CssClass="eitField">
<asp:ListItem Value="0">- Select Jamatkhana -</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<%-- <tr>
<td class="style5">
Telephone:
</td>
<td class="style10" colspan="2">
<asp:TextBox ID="txtBoxTelephone" runat="server" Width="150px" AutoCompleteType="Disabled" Height="18px"
TabIndex="4"></asp:TextBox>
</td>
</tr>--%>
<tr>
<td class="style5">
Account ID:
</td>
<td class="style10" colspan="2">
<asp:TextBox ID="txtBoxAccountID" runat="server" AutoCompleteType="Disabled"
Width="150px" Height="18px"
TabIndex="5" CssClass="eitField"></asp:TextBox>
</td>
</tr>
<tr>
<td class="style5">
</td>
<td class="style54">
<asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_Click" Text="Search"
Width="65px" TabIndex="6" CssClass="eitField" />
</td>
<td class="style10" align="center">
<asp:Button ID="btnClear" runat="server" Text="Clear" Width="65px" OnClick="btnClear_Click"
TabIndex="7" CssClass="eitField" />
</td>
</tr>
<tr>
<td colspan="3">
<asp:ValidationSummary ID="ValidationSummary2" runat="server" CssClass="failureNotification" ValidationGroup="SearchCriteria" />
</td>
</tr>
</table>
<%-- </asp:Panel>--%>
</div>
<div style="float:left; width:"100%">
<table class="style15">
<tr>
<td>
<h2>
Batch Renewal Search Results:</h2>
</td>
<td>
</td>
</tr>
<tr>
<td>
<asp:GridView ID="gvBatchSearch" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataKeyNames="AccountID" DataSourceID="adsSearchBatch" ForeColor="#333333"
GridLines="None"
EmptyDataText="No accounts matching your search criteria were found." SelectedIndex="0"
OnPageIndexChanging="gvBatchSearch_PageIndexChanging" Width="680px"
onselectedindexchanged="gvBatchSearch_SelectedIndexChanged"
onselectedindexchanging="gvBatchSearch_SelectedIndexChanging" PageSize="6">
<AlternatingRowStyle BackColor="#D0FFFF" ForeColor="#284775" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="AccountID" HeaderText="ID" InsertVisible="False" SortExpression="AccountID"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="MemberLastName" HeaderText="Last" SortExpression="MemberLastName"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="MemberMiddleName" HeaderText="Middle" SortExpression="MemberFirstName"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="MemberFirstName" HeaderText="First" SortExpression="MemberFirstName"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="AccountRenewalYear" HeaderText="Renewal Year" SortExpression="Renewal Year"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="JKName" HeaderText="JK" SortExpression="JKName" HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
<asp:CheckBoxField DataField="MemberPrimary" HeaderText="Primary" SortExpression="MemberPrimary"
ItemStyle-HorizontalAlign="Center">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:CheckBoxField>
<asp:BoundField DataField="AccountStatus" HeaderText="Account Status" SortExpression="AccountStatus"
HeaderStyle-HorizontalAlign="Left">
<HeaderStyle HorizontalAlign="Left"></HeaderStyle>
</asp:BoundField>
</Columns>
<EditRowStyle BackColor="#DDDDDD" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerSettings PageButtonCount="5" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
</td>
<td>
</td>
</tr>
</table>
</div>
<div style="clear:both; width:"100%">
<table style="width: 75%;">
<tr>
<td class="style98" valign="top">
</td>
<td valign="top" class="style105">
</td>
<td valign="top" class="style68">
</td>
</tr>
<tr>
<td class="style98" valign="top">
<asp:GridView ID="gvAccountBatches" runat="server" AutoGenerateColumns="False"
CellPadding="4" DataSourceID="adsAccountBatches"
ForeColor="#333333" GridLines="None" DataKeyNames="BatchID"
onselectedindexchanged="gvAccountBatches_SelectedIndexChanged"
Caption="RECENT BATCH MATCHING THE SELECTED ACCOUNT" Width="675px"
CaptionAlign="Left" AllowPaging="True" PageSize="3">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" >
<ItemStyle HorizontalAlign="Left" Width="25px" />
</asp:CommandField>
<asp:BoundField DataField="BatchID" HeaderText="Batch ID"
SortExpression="BatchID" >
<HeaderStyle HorizontalAlign="Left" Width="25px" />
<ItemStyle HorizontalAlign="Left" Width="25px" />
</asp:BoundField>
<asp:BoundField DataField="AccountID" HeaderText="Account ID"
SortExpression="AccountID" >
<HeaderStyle HorizontalAlign="Left" Width="25px" />
<ItemStyle HorizontalAlign="Left" Width="25px" />
</asp:BoundField>
<asp:BoundField DataField="JKName" HeaderText="Jamatkhana"
SortExpression="JKName" >
<HeaderStyle HorizontalAlign="Left" Width="60px" />
<ItemStyle HorizontalAlign="Left" Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="BatchCreationDate" HeaderText="Date Created"
SortExpression="BatchCreationDate" DataFormatString="{0:dd MMM yyyy}">
<HeaderStyle HorizontalAlign="Left" Width="90px" />
<ItemStyle HorizontalAlign="Left" Width="90px" />
</asp:BoundField>
<asp:BoundField DataField="UserName" HeaderText="Created By"
SortExpression="UserName" >
<HeaderStyle HorizontalAlign="Left" Width="60px" />
<ItemStyle HorizontalAlign="Left" Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="BatchTotal" HeaderText="Batch Total"
SortExpression="BatchTotal" DataFormatString="{0:C}">
<HeaderStyle HorizontalAlign="Left" Width="60px" />
<ItemStyle HorizontalAlign="Left" Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="BatchComments" HeaderText="Comments"
SortExpression="BatchComments">
<HeaderStyle HorizontalAlign="Left" Width="200px" />
<ItemStyle HorizontalAlign="Left" Width="200px" />
</asp:BoundField>
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
</td>
<td valign="top" class="style105">
<asp:GridView ID="gvBatchAdjustments" runat="server"
AutoGenerateColumns="False" CellPadding="4" DataSourceID="adsBatchAdjustments"
ForeColor="#333333" GridLines="None" Width="550px"
Caption="BATCH ADJUSTMENTS" CaptionAlign="Left" PageSize="3"
AllowPaging="True">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="BatchAdjustmentBatchID" HeaderText="Batch ID"
SortExpression="BatchAdjustmentBatchID">
<HeaderStyle HorizontalAlign="Left" Width="25px" />
<ItemStyle HorizontalAlign="Left" Width="25px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentAccountID" HeaderText="Account ID"
SortExpression="BatchAdjustmentAccountID">
<HeaderStyle HorizontalAlign="Left" Width="25px" />
<ItemStyle HorizontalAlign="Left" Width="25px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentCashAmount" DataFormatString="{0:C}"
HeaderText="Cash" SortExpression="BatchAdjustmentCashAmount">
<HeaderStyle HorizontalAlign="Left" Width="30px" />
<ItemStyle HorizontalAlign="Left" Width="30px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentChequeAmount" DataFormatString="{0:C}"
HeaderText="Cheque" SortExpression="BatchAdjustmentChequeAmount">
<HeaderStyle HorizontalAlign="Left" Width="30px" />
<ItemStyle HorizontalAlign="Left" Width="30px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentChequeNumber"
HeaderText="Cheque Number" SortExpression="BatchAdjustmentChequeNumber">
<HeaderStyle HorizontalAlign="Left" Width="20px" />
<ItemStyle HorizontalAlign="Left" Width="20px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentCreatedBy" HeaderText="Entered By"
SortExpression="BatchAdjustmentCreatedBy">
<HeaderStyle HorizontalAlign="Left" Width="65px" />
<ItemStyle HorizontalAlign="Left" Width="65px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentCreatedDate"
DataFormatString="{0:dd MMM yyyy}" HeaderText="Date Entered"
SortExpression="BatchAdjustmentCreatedDate">
<HeaderStyle HorizontalAlign="Left" Width="90px" />
<ItemStyle HorizontalAlign="Left" Width="90px" />
</asp:BoundField>
<asp:BoundField DataField="BatchAdjustmentComments" HeaderText="Comments"
SortExpression="BatchAdjustmentComments">
<HeaderStyle HorizontalAlign="Left" Width="300px" />
<ItemStyle HorizontalAlign="Left" Width="300px" />
</asp:BoundField>
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
</td>
<td valign="top" class="style68">
</td>
</tr>
<tr>
<td class="style99" valign="top">
</td>
<td class="style101" valign="top">
</td>
<td class="style96" valign="top">
</td>
</tr>
<tr>
<td class="style72" valign="top">
<asp:GridView ID="gvBatchDetails" runat="server" AllowPaging="True"
AutoGenerateColumns="False" CellPadding="4" DataKeyNames="BatchID,AccountID"
DataSourceID="adsBatchDetails" ForeColor="#333333" GridLines="None"
onselectedindexchanged="gvBatchDetails_SelectedIndexChanged" Width="675px"
Caption="BATCH DETAILS" CaptionAlign="Left"
onrowdatabound="gvBatchDetails_RowDataBound">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:CommandField ShowSelectButton="True" SelectText="Adjust" >
<HeaderStyle Width="25px" />
<ItemStyle Width="25px" />
</asp:CommandField>
<asp:BoundField DataField="BatchID" HeaderText="Batch ID"
SortExpression="BatchID">
<HeaderStyle HorizontalAlign="Left" Width="20px" />
<ItemStyle HorizontalAlign="Left" Width="20px" />
</asp:BoundField>
<asp:BoundField DataField="AccountID" HeaderText="Account ID"
SortExpression="AccountID">
<HeaderStyle HorizontalAlign="Left" Width="20px" />
<ItemStyle HorizontalAlign="Left" Width="20px" />
</asp:BoundField>
<%-- <asp:BoundField DataField="MemberLastName" HeaderText="Last Name"
SortExpression="MemberLastName">
<HeaderStyle HorizontalAlign="Left" Width="60px" />
<ItemStyle HorizontalAlign="Left" Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="MemberMiddleName" HeaderText="Middle"
SortExpression="MemberMiddleName" Visible="False" />
<asp:BoundField DataField="MemberFirstName" HeaderText="First Name"
SortExpression="MemberFirstName">
<HeaderStyle HorizontalAlign="Left" Width="60px" />
<ItemStyle HorizontalAlign="Left" Width="60px" />
</asp:BoundField>--%>
<asp:BoundField DataField="MemberFullName" HeaderText="Last, First Name"
SortExpression="MemberFullName">
<HeaderStyle HorizontalAlign="Left" Width="90px" />
<ItemStyle HorizontalAlign="Left" Width="90px" />
</asp:BoundField>
<%-- <asp:TemplateField HeaderText="Last, First Name">
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# String.Format("{0}, {1}", FormatLastNameToUpper( Eval("MemberLastName")), Eval("MemberFirstName")) %>'></asp:Label>
</ItemTemplate>
<HeaderStyle Width="100px" HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" Width="100px" />
</asp:TemplateField>--%>
<asp:BoundField DataField="AmountDue" DataFormatString="{0:C}"
HeaderText="Amount Due" SortExpression="AmountDue">
<HeaderStyle HorizontalAlign="Left" Width="40px" />
<ItemStyle HorizontalAlign="Left" Width="40px" />
</asp:BoundField>
<asp:BoundField DataField="AmountPaid" DataFormatString="{0:C}"
HeaderText="Amount Paid" SortExpression="AmountPaid">
<HeaderStyle HorizontalAlign="Left" Width="40px" />
<ItemStyle HorizontalAlign="Left" Width="40px" />
</asp:BoundField>
<asp:BoundField DataField="BatchPaymentType" HeaderText="Paid by"
SortExpression="BatchPaymentType">
<HeaderStyle HorizontalAlign="Left" Width="40px" />
<ItemStyle HorizontalAlign="Left" Width="40px" />
</asp:BoundField>
<asp:BoundField DataField="BatchDetailsChequeNumber" HeaderText="Cheque Number"
SortExpression="BatchDetailsChequeNumber">
<HeaderStyle HorizontalAlign="Left" Width="40px" />
<ItemStyle HorizontalAlign="Left" Width="40px" />
</asp:BoundField>
<asp:CheckBoxField DataField="MemberPrimary" HeaderText="Primary"
SortExpression="MemberPrimary" Visible="False" />
<asp:BoundField DataField="BatchDetailsComments" HeaderText="Comments"
SortExpression="BatchDetailsComments">
<HeaderStyle HorizontalAlign="Left" Width="200px" />
<ItemStyle HorizontalAlign="Left" Width="200px" />
</asp:BoundField>
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
<br />
<asp:Label ID="lblError" runat="server" CssClass="failureNotification"></asp:Label>
</td>
<td class="style102" valign="top">
<asp:Panel ID="pnlAdjustments" runat="server" BackColor="#FFFFD5"
Height="399px" Width="440px">
<table class="style70" border="1">
<tr>
<td align="center" class="style90" colspan="2">
<asp:Label ID="lblHeader" runat="server" Font-Bold="True"
Text="ADD BATCH ADJUSTMENT"></asp:Label>
</td>
</tr>
<tr>
<td class="style110">
<asp:Label ID="lblHeaderBatchID" runat="server" Font-Bold="True"
Text="BATCH ID:"></asp:Label>
</td>
<td class="style80">
<asp:Label ID="lblBatchID" runat="server" Text="2081"></asp:Label>
</td>
</tr>
<tr>
<td class="style110">
<asp:Label ID="lblHeaderAccountID" runat="server" Font-Bold="True"
Text="ACCOUNT ID:"></asp:Label>
</td>
<td class="style80">
<asp:Label ID="lblAccountID" runat="server" Text="2405"></asp:Label>
</td>
</tr>
<tr>
<td class="style110">
<asp:Label ID="lblHeaderFullName" runat="server" Font-Bold="True"
Text="FULL NAME:"></asp:Label>
</td>
<td class="style80">
<asp:Label ID="lblFullName" runat="server" Text="Full name"></asp:Label>
</td>
</tr>
<tr>
<td class="style110">
<asp:Label ID="lblHeaderBatchAmount" runat="server" Font-Bold="True"
Text="BATCH AMOUNT:"></asp:Label>
</td>
<td class="style80">
<asp:Label ID="lblBatchAmount" runat="server" Text="230"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2">
<span class="bold">PAYMENT:</span>
</td>
</tr>
<tr>
<td class="style111">
Cash amount:</td>
<td class="style68">
<asp:TextBox ID="txtBoxAmountPaidByCash" runat="server" Width="50px"
AutoCompleteType="Disabled" TabIndex="14" CssClass="eitField"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatorPaidByCash" runat="server" ControlToValidate="txtBoxAmountPaidByCash"
CssClass="failureNotification" Display="Dynamic" ErrorMessage="Adjustment Amount is required. Enter 0 for full payment by cheque."
ValidationGroup="ValidationGroupAdjustment" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style111">
Cheque amount:</td>
<td class="style68">
<asp:TextBox ID="txtBoxAmountPaidByCheque" runat="server" Width="50px"
AutoCompleteType="Disabled" TabIndex="15" CssClass="eitField"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatorPaidByCheque" runat="server" ControlToValidate="txtBoxAmountPaidByCheque"
CssClass="failureNotification" Display="Dynamic" ErrorMessage="Adjustment Amount is required. Enter 0 for full payment by cash."
ValidationGroup="ValidationGroupAdjustment" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style111">
Cheque number:</td>
<td class="style68">
<asp:TextBox ID="txtBoxChequeNumber" runat="server" Width="50px"
AutoCompleteType="Disabled" TabIndex="16" CssClass="eitField"></asp:TextBox>
<asp:CustomValidator ID="CustomChequeNumberValidator" runat="server" CssClass="failureNotification"
ErrorMessage="Cheque number is required if adjustment by cheque." OnServerValidate="ChequeNumberCustomValidator_ServerValidate"
ValidationGroup="ValidationGroupAdjustment" ClientValidationFunction="ValidateChequeNumber"
Display="Dynamic">*</asp:CustomValidator>
</td>
</tr>
<%-- <tr>
<td class="style79">
<asp:Label ID="lblHeaderAdjustmentAmount" runat="server" Font-Bold="True"
Text="ADJUSTMENT AMOUNT:"></asp:Label>
</td>
<td class="style80">
<asp:TextBox ID="txtboxAmount" runat="server" AutoCompleteType="Disabled"
CssClass="eitField" Width="75px"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvAdjustmentAmount" runat="server"
ControlToValidate="txtboxAmount" CssClass="failureNotification"
Display="Dynamic" ErrorMessage="Adjustment amount is required." Text="*"
ValidationGroup="ValidationGroupAdjustment"></asp:RequiredFieldValidator>
<asp:CustomValidator ID="CustomValidatorAdjustmentAmount" runat="server"
ClientValidationFunction="ValidateBatchAdjustmentAmount"
CssClass="failureNotification" Display="Dynamic"
ErrorMessage="Adjustment amount must be greater than 0 and less than the batch amount."
onservervalidate="CustomValidatorAdjustmentAmount_ServerValidate" Text="*"
ValidationGroup="ValidationGroupAdjustment"></asp:CustomValidator>
</td>
</tr>--%>
<tr>
<td class="style77">
<span class="bold">TYPE OF ADJUSTMENT:</span></td>
<td class="style78">
<asp:RadioButtonList ID="rblAdjustmentType" runat="server">
<asp:ListItem Selected="True" Value="1">Refunds, Stop payments, etc. (Batch reduction)</asp:ListItem>
<asp:ListItem Value="2">Payment received (Batch increased)</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td class="style106">
<asp:Label ID="lblReason" runat="server" Font-Bold="True"
Text="REASON FOR ADJUSTMENT:"></asp:Label>
</td>
<td class="style107">
<asp:TextBox ID="txtboxReason" runat="server" AutoCompleteType="Disabled"
CssClass="style82" Height="40px" TextMode="MultiLine" Width="289px"></asp:TextBox>
<asp:TextBoxWatermarkExtender ID="txtboxReason_TextBoxWatermarkExtender"
runat="server" Enabled="True" TargetControlID="txtboxReason"
WatermarkCssClass="watermarked"
WatermarkText="Please enter detailed comments for the batch adjustment.">
</asp:TextBoxWatermarkExtender>
<asp:RequiredFieldValidator ID="rfvAdjustmentReason" runat="server"
ControlToValidate="txtboxReason" CssClass="failureNotification"
Display="Dynamic"
ErrorMessage="Detailed comments for the adjustment are required." Text="*"
ValidationGroup="ValidationGroupAdjustment"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style111">
</td>
<td class="style86">
<asp:Button ID="btnAddAdjustment" runat="server" CssClass="eitField"
onclick="btnAddAdjustment_Click" Text="Adjust Batch"
ValidationGroup="ValidationGroupAdjustment" Width="89px" />
<asp:CustomValidator ID="CustomValidatorAdjustmentAmount" runat="server"
ClientValidationFunction="ValidateBatchAdjustmentAmount"
CssClass="failureNotification" Display="Dynamic"
ErrorMessage="Adjustment amount must be greater than 0 and less than the batch amount."
onservervalidate="CustomValidatorAdjustmentAmount_ServerValidate" Text="*"
ValidationGroup="ValidationGroupAdjustment"></asp:CustomValidator>
</td>
</tr>
</table>
</asp:Panel>
</td>
<td class="style89" valign="top">
</td>
</tr>
<tr>
<td class="style98" valign="top">
</td>
<td class="style105" valign="top">
<asp:ValidationSummary ID="ValidationSummaryBatchAdjustment" runat="server"
CssClass="failureNotification" HeaderText="Batch Adjustment Validation Errors:"
ValidationGroup="ValidationGroupAdjustment" />
</td>
<td class="style68" valign="top">
</td>
</tr>
<tr>
<td class="style98" valign="top">
</td>
<td valign="top" class="style105">
</td>
<td valign="top" class="style68">
</td>
</tr>
</table>
<br />
</div>
<div>
<br />
</div>
<asp:AccessDataSource ID="adsJK" runat="server" DataFile="~/App_Data/Burial.mdb"
SelectCommand="SELECT [JKID], [JKName] FROM [Jamatkhana]"></asp:AccessDataSource>
<asp:AccessDataSource ID="adsSearchBatch" runat="server" DataFile="~/App_Data/Burial.mdb"
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"
CancelSelectOnNullParameter="False" OnSelecting="adsSearchBatch_Selecting">
<SelectParameters>
<asp:ControlParameter ControlID="txtBoxLastName" Name="MemberLastName" Type="String" />
<asp:ControlParameter ControlID="txtBoxFirstName" Name="MemberFirstName" Type="String" />
<asp:ControlParameter ControlID="ddlJamatkhana" Name="AccountJamatkhanaID" Type="Int32" />
<asp:ControlParameter ControlID="txtBoxAccountID" Name="AccountID" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="adsAccountBatches" runat="server" DataFile="~/App_Data/Burial.mdb"
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">
<SelectParameters>
<asp:ControlParameter ControlID="gvBatchSearch" Name="?" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="adsBatchDetails" runat="server"
DataFile="~/App_Data/Burial.mdb"
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">
<SelectParameters>
<asp:ControlParameter ControlID="gvAccountBatches" Name="?"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
<%-- <asp:AccessDataSource ID="adsBatchSummary" runat="server" DataFile="~/App_Data/Burial.mdb"
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 = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="gvAccountBatches" Name="?" PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>--%>
<asp:AccessDataSource ID="adsBatchAdjustments" runat="server"
DataFile="~/App_Data/Burial.mdb"
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">
<SelectParameters>
<asp:ControlParameter ControlID="gvAccountBatches" Name="?"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
<%-- </ContentTemplate>
</asp:UpdatePanel>
<asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="200" AssociatedUpdatePanelID="UpdatePanel1">
<ProgressTemplate>
<div class="PleaseWait">
Please wait ...
</div>
</ProgressTemplate>
</asp:UpdateProgress>--%>
</asp:Content>