---
title: "Explain about Active X data object?"  
description: "Explain about Active X data object?"  
author: "Rajesh Goswami"  
published: 2010-10-23  
updated: 2020-09-17  
canonical: https://www.mindstick.com/interview/74/explain-about-active-x-data-object  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 23 minutes  

---

# Explain about Active X data object?

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace DDSolutionBE

{

public class ViewBankExceptionsBE

{

public int MasterDataID { get; set; }

public string ParticipantID { get; set; }

public string GroupNumber { get; set; }

public DateTime TransactionDate { get; set; }

public string CustFirstName { get; set; }

public string CustLastName { get; set; }

// public string CustomerName { get; set; }

public string AccountNumber { get; set; }

public string ExceptionType { get; set; }

public string ErrorCode { get; set; }

public string ErrorDescription { get; set; }

public string BankName { get; set; }

public int FileId { get; set; }

public double Amount { get; set; }

public int TotalRecords { get; set; }

public string FileName { get; set; }

public string FileType { get; set; }

public DateTime FileGenerationDateTime { get; set; }

public DateTime FileGenerationEndDateTime { get; set; }

public string FilePath { get; set; }

public bool isActive { get; set; }

public DateTime CreatedDateTime { get; set; }

public int UserID { get; set; }

public int ParentFileID { get; set; }

public string MasterData { get; set; }

public string Date { get; set; }

public string Adress1 { get; set; }

public string Adress2 { get; set; }

public string Adress3 { get; set; }

public string PostalCode { get; set; }

public string Parish { get; set; }

public string GrpName { get; set; }

}

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionDALC;

using DDSolutionBE;

namespace DDSolutionBO

{

public class ViewBankExceptionsBO

{

PolicyholderDAL dalPH = new PolicyholderDAL();

ViewBankExceptionsDAL vbedal = new ViewBankExceptionsDAL();

public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminx(string strFname, stringstrLname, string strMInit, string strParticID, string strGrpID)

{

try

{

return dalPH.GetPolicyholdersFromLuminx(strFname, strLname, strMInit, strParticID, strGrpID);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminxByGroup(string strGrpID, stringstrGrName)

{

try

{

return dalPH.GetPolicyholdersFromLuminxByGroup(strGrpID, strGrName);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public DataTable GetAllDDExceptionRecords(string BankName,string PHolder,string FromDate,stringToDate)

{

try

{

return vbedal.GetAllDDExceptionRecords(BankName, PHolder,FromDate, ToDate);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionByParticpants(string strBankName, stringstrFromDate, string strToDate)

{

return vbedal.GetExceptionByParticpants(strBankName, strFromDate, strToDate);

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionByGroup(string strBankName, string strFromDate,string strToDate)

{

return vbedal.GetExceptionByGroup(strBankName, strFromDate, strToDate);

}

public DataTable CheckFileGeneration(string IndorGrp)

{

return vbedal.CheckFileGeneration(IndorGrp);

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionsFileType()

{

try

{

return vbedal.GetExceptionsFileType();

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String InsertintoLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.InsertintoLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String InsertintoLuminXPaymentPostingDetails(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.InsertintoLuminXPaymentPostingDetails(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String UpdateLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.UpdateLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public void DeleteEntry(ViewBankExceptionsBE vbebe)

{

try

{

vbedal.DeleteEntry(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

}

}

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionBE;

namespace DDSolutionDALC

{

public class ViewDDExceptionsDAL

{

DDSolutionClassDataContext context = new DDSolutionClassDataContext();

GeneralDAL gnl = new GeneralDAL();

LoadOPPFileBE lopbe = new LoadOPPFileBE();

public DataTable GetDDExcepRecords(string FundType,string Fromdate, string Todate)

{

try

{

var Records = context.usp_GetACHExceptionsByDate(FundType, Fromdate, Todate);

return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public DataTable GetDDAS400ExcepRecords(string Fundtype, string Fromdate, string Todate)

{

try

{

var Records = context.usp_GetDDAS400ExcepionsByDate(Fundtype, Fromdate, Todate);

return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

}

}

using System;

using System.Collections.Generic;

using System.Globalization;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using DDSolutionBO;

using DDSolutionBE;

using System.Text;

using DDSolutionDALC;

using System.Configuration;

using System.IO;

public partial class UI_BankExceptionManagement : System.Web.UI.Page

{

PolicyholderBO boPH = new PolicyholderBO();

General gnl = new General();

DataTable dtMailingAddress = new DataTable();

DataTable dtGetdata = new DataTable();

ViewBankExceptionsBO vbebo = new ViewBankExceptionsBO();

ViewBankExceptionsBE vbebe = new ViewBankExceptionsBE();

string FilePath = "";

string fileDate = "";

string FilType = "";

int ParentID;

string rtnmsg = "";

int UserID;

string GeneratedFileId;

DateTime FilegeneratedDateTime;

double TotalAmt = 0.00;

int Recordcount;

string strFileName = "";

protected void Page_Load(object sender, EventArgs e)

{

// To Clear Cache

Response.Buffer = true;

Response.ExpiresAbsolute = DateTime.Now;

Response.CacheControl = "no-cache";

// To Clear Cache

//CE3.SelectedDate = DateTime.Today;

//CE4.SelectedDate = DateTime.Today;

try

{

if (Request.Cookies["UserInfo"] == null) Response.Redirect("Login.aspx");

if (!IsPostBack)

{

//txtFromDate.Text = gnl.GetASTDate().ToShortDateString();

//txtToDate.Text = gnl.GetASTDate().ToShortDateString();

//BindExceptions();

}

if(Request.Cookies["UserInfo"].Values["RoleName"].ToString().ToUpper().Trim().Contains("VIEWER"))

{

btnGenerateLetter.Enabled = false;

}

UserID = Convert.ToInt32(Request.Cookies["UserInfo"]["UserId"]);

}

catch (Exception ex)

{

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

}

}

protected void btnClose_Click(object sender, EventArgs e)

{

Response.Redirect("../UI/MainPage.aspx");

}

private void GenerateINDLetter()

{

try

{

StringBuilder sb = new StringBuilder();

IEnumerable<ViewBankExceptionsBE> ieGetExcepByParticip;

ieGetExcepByParticip = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

//dtGetdata = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

if (ieGetExcepByParticip.Count() > 0)

//if (dtGetdata.Rows.Count > 0)

{

Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

fileDate = gnl.GenerateFileName("");//.GetASTDate().ToString("MMddyyyy_HHmmss");// Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

InsertintoLuminXPaymentPostingHeader();

foreach (var item in ieGetExcepByParticip)

{

//vbebe.ParticipantID = drow[0].ToString();

//vbebe.GroupNumber = drow[1].ToString();

//vbebe.TransactionDate = Convert.ToDateTime(drow[2].ToString());

//vbebe.CustFirstName = drow[3].ToString();

//vbebe.CustLastName = drow[4].ToString();

//CustomerName = vbebe.CustFirstName + " " + vbebe.CustLastName;

//vbebe.AccountNumber = drow[5].ToString();

//vbebe.ErrorDescription = drow[6].ToString();

//TransactionDate1 = vbebe.TransactionDate;

//IEnumerable<LuminXParticipantsBE> ieLxParticips = null;

//ieLxParticips = vbebo.GetPolicyholdersFromLuminx(null, null, null, vbebe.ParticipantID, vbebe.GroupNumber);

//foreach (var item in ieLxParticips)

//{

//string str = item.MailingAddress;

//string[] words = str.Split('%');

//string Address1 = words[0].ToString();

//string Addressstr = words[1].ToString();

////string[] Addressstr2 = Addressstr.Split(',');

////string Address2 = Addressstr2[0].ToString();

////string Address3 = Addressstr2[1].ToString();

//// string Address4 = Addressstr2[2].ToString();

//string mainstr = null;

//string[] splitstr = Addressstr.Split(new Char[] { ',' });

//foreach (string line in splitstr)

//{

// //array for the measurement

// // string[] measurementArray = line.

// mainstr = mainstr + line;

// mainstr = mainstr + " ";

//}

sb.Append(item.Date.ToString().PadRight(10) + "|");

sb.Append(item.CustFirstName.ToString().PadRight(15) + "|");

sb.Append(item.CustLastName.ToString().PadRight(15) + "|");

sb.Append(item.Adress1.ToString().PadRight(25) + "|");

sb.Append(item.Adress2.ToString().PadRight(25) + "|");

sb.Append(item.Adress3.ToString().PadRight(25) + "|");

sb.Append(item.PostalCode.ToString().PadRight(9) + "|");

sb.Append(item.AccountNumber.ToString().PadRight(6) + "|");

sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

vbebe.ParticipantID = item.ParticipantID.ToString();

vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

vbebe.UserID = UserID;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

Recordcount++;

//sb.Append(vbebe.TransactionDate.ToString("MM-dd-yyyy").ToString().PadRight(10) + '|');

//sb.Append(CustomerName.ToString().PadRight(50) + '|');

//sb.Append(Address1.ToString().PadRight(50) + '|');

//sb.Append(mainstr.ToString().PadRight(100) + '|');

//// sb.Append(Address2.ToString().PadRight(15));

////sb.Append(Address3.ToString().PadRight(15));

//// sb.Append(Address4.ToString().PadRight(15) + '|');

//sb.Append(vbebe.AccountNumber.ToString().PadRight(20) + '|');

//sb.Append(vbebe.ErrorDescription.ToString().PadRight(250) + '|');

//sb.Append(TransactionDate1.ToString("dd-MMM-yyyy").ToString().PadRight(11));//.ToString("dd-MMM-yy");

sb.AppendLine();

//}

}

using (StreamWriter wtr = File.CreateText(FilePath))

{

UpdateDtls();

wtr.Write(sb.ToString());

//ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('File Generated Successfully');", true);

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = "File generated successfully. Please check LetterFeedFiles folder.";

}

}

else

{

//ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('Please Select Policyholder');", true);

errMsg.Attributes["class"] = "MsgBox warning";

errMsg.InnerHtml = " No records were found for given transaction date range";

//ddlPholder.Focus();

return;

}

}

catch (Exception ex)

{

DeleteEntry();

throw new Exception(ex.Message);

}

}

protected void btnGenerateLetter_Click(object sender, EventArgs e)

{

errMsg.Attributes["class"] = "";

errMsg.InnerHtml = "";

try

{

if (ddlPholder.SelectedValue == "Individual")

GenerateINDLetter();

else

GenerateGRPLetter();

}

catch (Exception ex)

{

//throw new Exception(ex.Message);

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

if (File.Exists(FilePath))

{

File.Delete(FilePath);

}

}

}

private void GenerateGRPLetter()

{

try

{

StringBuilder sb = new StringBuilder();

IEnumerable<ViewBankExceptionsBE> ieGetExcepByGRP;

ieGetExcepByGRP = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

//dtGetdata = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

if (ieGetExcepByGRP.Count() > 0)

{

Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

fileDate = gnl.GenerateFileName(""); //gnl.GetASTDate().ToString("MMddyyyy_HHmmss"); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

InsertintoLuminXPaymentPostingHeader();

foreach (var item in ieGetExcepByGRP)

{

sb.Append(item.Date.ToString().PadRight(10) + "|");

sb.Append(item.GrpName.ToString().PadRight(30) + "|");

sb.Append(item.Adress1.ToString().PadRight(25) + "|");

sb.Append(item.Adress2.ToString().PadRight(25) + "|");

sb.Append(item.Parish.ToString().PadRight(20) + "|");

sb.Append(item.PostalCode.ToString().PadRight(10) + "|");

sb.Append(item.GroupNumber.ToString().PadLeft(5, '0') + "|");

sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

vbebe.ParticipantID = item.ParticipantID.ToString();

vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

vbebe.UserID = UserID;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

Recordcount++;

sb.AppendLine();

}

using (StreamWriter wtr = File.CreateText(FilePath))

{

UpdateDtls();

wtr.Write(sb.ToString());

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = "File generated successfully..";

}

}

else

{

errMsg.Attributes["class"] = "MsgBox warning";

errMsg.InnerHtml = " No records were found for given date range";

return;

}

}

catch (Exception ex)

{

DeleteEntry();

throw new Exception(ex.Message);

}

}

protected void InsertintoLuminXPaymentPostingHeader()

{

try

{

// vbebe.FileName = fileName;

IEnumerable<ViewBankExceptionsBE> iegetfiletype;

iegetfiletype = vbebo.GetExceptionsFileType();

foreach (var ftype in iegetfiletype)

{

FilType = ftype.MasterData.ToString();

ParentID = ftype.ParentFileID;

}

// FileFenerateDateTime =Convert.ToDateTime( fileDate);

//FilePath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

vbebe.FileName = strFileName;

vbebe.FileType = FilType;

FilegeneratedDateTime = gnl.GetASTDate(); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime());

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

string spath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

string[] words = spath.Split('\\');

string spath1 = words[0].ToString();

string spath2 = words[1].ToString();

string spath3 = words[2].ToString();

//string Address1 = words[0].ToString();

vbebe.FilePath = spath1 + "\\" + spath3;

vbebe.ParentFileID = ParentID;

vbebe.isActive = true;

vbebe.UserID = UserID;

vbebe.CreatedDateTime = gnl.GetASTDate();

GeneratedFileId = vbebo.InsertintoLuminXPaymentPostingHeader(vbebe);

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = rtnmsg;

}

catch (Exception ex)

{

//throw new Exception(ex.Message);

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

return;

}

}

public void UpdateDtls()

{

try

{

vbebe.Amount = TotalAmt;

vbebe.TotalRecords = Recordcount;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebe.FileGenerationEndDateTime = gnl.GetASTDate();

vbebo.UpdateLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

public void DeleteEntry()

{

try

{

vbebo.DeleteEntry(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BankExceptionManagement.aspx.cs"

Inherits="UI_BankExceptionManagement" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Src="~/UserControls/HeaderControl.ascx" TagName="Header" TagPrefix="hdr" %>

<%@ Register Src="~/UserControls/FooterControl.ascx" TagName="Footer" TagPrefix="ftr" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<link rel="shortcut icon" href="../Images/favicon.ico" />

<title>Bank Exception Management</title>

<link href="~/Styles/Style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="../Scripts/jquery-1.4.1.min.js"></script>

<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>

<script language="javascript" type="text/javascript">

/* $(document).ready(function () {

// This code is used to validate the search on search button click.

// $('[id$=chkSelectAll]').click(function () {

// $("[id$='chkSelect']").attr('checked', this.checked);

// });

$("[id*=chkSelectAll]").live("click", function () {

var chkHeader = $(this);

var grid = $(this).closest("table");

$("input[type=checkbox]", grid).each(function () {

if (chkHeader.is(":checked")) {

$(this).attr("checked", "checked");

$("td", $(this).closest("tr")).addClass("selected");

} else {

$(this).removeAttr("checked");

$("td", $(this).closest("tr")).removeClass("selected");

}

});

});

$("[id*=chkSelect]").live("click", function () {

var grid = $(this).closest("table");

var chkHeader = $("[id*=chkSelectAll]", grid);

if (!$(this).is(":checked")) {

$("td", $(this).closest("tr")).removeClass("selected");

chkHeader.removeAttr("checked");

} else {

$("td", $(this).closest("tr")).addClass("selected");

if ($("[id*=chkSelect]", grid).length == $("[id*=chkSelect]:checked", grid).length) {

chkHeader.attr("checked", "checked");

}

}

});

});*/

function Close() {

var confrm = window.confirm("Are you sure, you want to close this window?");

if (confrm == true) {

return true;

}

else {

return false;

}

}

</script>

<style type="text/css">

.selected

{

background-color: #A1DCF2;

}

</style>

<script type="text/javascript">

$(document).ready(function () {

$('#btnGenerateLetter').click(function () {

document.getElementById("errMsg").style.visibility = "hidden";

if ($("#ddlBankName").val() == '-Select-') {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html("Select the BankName");

$('#ddlBankName').focus();

return false;

}

if ($("#ddlPholder").val() == '-Select-') {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Select the policyholder");

$('#ddlPholder').focus();

return false;

}

var FromDate = $.trim($(".txtFromDate").val());

if (FromDate.length == 0) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction From Date");

// $('#txtFromDate').focus();

return false;

}

// txtFromDate = document.getElementById('txtTranDate').value;

var txtFromDate = $.trim($(".txtFromDate").val());

var Datepattern = "^(0?[1-9]|1[012])[-/]?(0?[1-9]|[12][0-9]|3[01])[-/]?(19[\\d]{2}|20[\\d]{2}|2100)$";

if (!txtFromDate.match(Datepattern)) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction from date in 'MM/dd/yy' format");

// $('#txtFromDate').focus();

return false;

}

var ToDate = $.trim($(".txtToDate").val());

if (ToDate.length == 0) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction To Date");

//$('#txtToDate').focus();

return false;

}

var txtToDate = $.trim($(".txtToDate").val());

if (!txtToDate.match(Datepattern)) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction To Date 'MM/dd/yy' Format");

// $('#txtFromDate').focus();

return false;

}

// var startDate = $('#txtFromDate').val().replace('/', '-');

var startDate = $('#txtFromDate').val();

var endDate = $('#txtToDate').val();

date1 = new Date(startDate.split("/")[2], startDate.split("/")[0], startDate.split("/")[1]);

date2 = new Date(endDate.split("/")[2], endDate.split("/")[0], endDate.split("/")[1]);

if (date1 > date2) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" To Date Should be greater than From Date");

// $('#txtFromDate').focus();

return false;

}

ShowProgress();

return true;

});

$('.ddlBankName').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

// var value = $('.txtHidBankAccNo').val().length;

//var BankName = $("#ddlBankName").get(0).selectedIndex;}

});

$('.ddlPholder').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

// var value = $('.txtHidBankAccNo').val().length;

//var BankName = $("#ddlBankName").get(0).selectedIndex;}

});

$('.txtFromDate').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

var value = $('.txtFromDate').val().length;

});

$('.txtToDate').focusout(function () {

document.getElementById("errMsg").style.visibility = "hidden";

var value = $('.txtToDate').val().length;

});

});

</script>

<script type="text/javascript">

function ClearFields() {

// document.getElementById("ddlBankName").options[0].selected = true;

// document.getElementById("txtFromDate").value = "";

// document.getElementById("txtToDate").value = "";

// document.getElementById("errMsg").style.visibility = "hidden";

window.location.href = "BankExceptionManagement.aspx";

return true;

}

</script>

<script type="text/javascript">

//This javascript function is used to display Loader when page is submitting to server

function ShowProgress() {

setTimeout(function () {

var modal = $('<div />');

modal.addClass("modal");

$('body').append(modal);

var loading = $(".loading");

loading.show();

var top = Math.max($(window).height() / 2 - loading[0].offsetHeight / 2, 0);

var left = Math.max($(window).width() / 2 - loading[0].offsetWidth / 2, 0);

loading.css({ top: top, left: left });

}, 200);

}

</script>

</head>

<body>

<form id="form1" runat="server" defaultbutton="btnGenerateLetter">

<div>

<hdr:Header ID="headerMain" runat="server" />

<center>

<div id="content">

<div class="content_section">

<table width="70%" border="0" style="border-color: Blue">

<tr>

<td align="center">

<asp:Label ID="lblUserMgmnt" runat="server" Text="Bank Exception Management"Font-Bold="True"

Font-Size="Medium"></asp:Label>

</td>

</tr>

<tr>

<td align="center">

<%--<asp:Label ID="lblException" runat="server" ForeColor="Red"></asp:Label>--%>

<div id="errMsg" runat="server" style="width: 45%; height: auto">

</div>

</td>

</tr>

<tr>

<td align="center">

<table border="1" style="border-color: Blue" width="50%">

<tr>

<td>

<table>

<tr>

<td align="right">

<asp:Label ID="lblBankName" runat="server"Text="BankName"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:DropDownList ID="ddlBankName" runat="server"Width="76%" CssClass="StyleDrpDown">

<asp:ListItem Text="BNTB" Value="BNTB"Selected="True"></asp:ListItem>

<%--<asp:ListItem Text="HSBC" Value="HSBC"></asp:ListItem>--%>

<%--<asp:ListItem Text="BNTB" Value="BNTB"></asp:ListItem>--%>

<%-- <asp:ListItem Text="Capital-G" Value="Capital-G"></asp:ListItem>--%>

</asp:DropDownList>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblPholder" runat="server"Text="Policyholder"></asp:Label><span

style="color: Red">*</span>

</td>

<td align="left">

<asp:DropDownList ID="ddlPholder" runat="server"Width="76%" CssClass="StyleDrpDown">

<asp:ListItem Text="-Select-" Value="-Select-"Selected="True"></asp:ListItem>

<asp:ListItem Text="Group" Value="Group"></asp:ListItem>

<asp:ListItem Text="Individual"Value="Individual"></asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblFromDate" runat="server"Text="Transaction from date"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:TextBox ID="txtFromDate" CssClass="txtFromDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

<asp:CalendarExtender ID="CE3" runat="server"TargetControlID="txtFromDate" TodaysDateFormat="MMM dd, yyyy"

Enabled="True">

</asp:CalendarExtender>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblToDate" runat="server"Text="Transaction to date"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:TextBox ID="txtToDate" CssClass="txtToDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

<asp:CalendarExtender ID="CE4" runat="server"TargetControlID="txtToDate" TodaysDateFormat="MMM dd, yyyy"

Enabled="True">

</asp:CalendarExtender>

</td>

</tr>

<tr>

<td align="right">

<asp:Button ID="btnGenerateLetter"CssClass="btnGenerate" Text="Generate File" runat="server"

Width="105px" OnClick="btnGenerateLetter_Click"/>

</td>

<td align="left">

<input id="Reset1" type="reset" value="Reset"class="button" onclick="ClearFields()" />

<asp:Button ID="btnClose" Text="Close"CssClass="button" runat="server" Width="50px"

OnClick="btnClose_Click" />

</td>

</tr>

</table>

</td>

</tr>

</table>

<div class="loading" align="center">

Generating...<br />

<br />

<br />

<br />

<img src="../Images/loader.gif" alt="" />

</div>

</td>

</tr>

</table>

</div>

</div>

</center>

<ftr:Footer ID="footermain" runat="server" />

</div>

</form>

</body>

</html>

## Answers

### Answer by hanmandlu vasani

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace DDSolutionBE

{

public class ViewBankExceptionsBE

{

public int MasterDataID { get; set; }

public string ParticipantID { get; set; }

public string GroupNumber { get; set; }

public DateTime TransactionDate { get; set; }

public string CustFirstName { get; set; }

public string CustLastName { get; set; }

// public string CustomerName { get; set; }

public string AccountNumber { get; set; }

public string ExceptionType { get; set; }

public string ErrorCode { get; set; }

public string ErrorDescription { get; set; }

public string BankName { get; set; }

public int FileId { get; set; }

public double Amount { get; set; }

public int TotalRecords { get; set; }

public string FileName { get; set; }

public string FileType { get; set; }

public DateTime FileGenerationDateTime { get; set; }

public DateTime FileGenerationEndDateTime { get; set; }

public string FilePath { get; set; }

public bool isActive { get; set; }

public DateTime CreatedDateTime { get; set; }

public int UserID { get; set; }

public int ParentFileID { get; set; }

public string MasterData { get; set; }

public string Date { get; set; }

public string Adress1 { get; set; }

public string Adress2 { get; set; }

public string Adress3 { get; set; }

public string PostalCode { get; set; }

public string Parish { get; set; }

public string GrpName { get; set; }

}

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionDALC;

using DDSolutionBE;

namespace DDSolutionBO

{

public class ViewBankExceptionsBO

{

PolicyholderDAL dalPH = new PolicyholderDAL();

ViewBankExceptionsDAL vbedal = new ViewBankExceptionsDAL();

public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminx(string strFname, stringstrLname, string strMInit, string strParticID, string strGrpID)

{

try

{

return dalPH.GetPolicyholdersFromLuminx(strFname, strLname, strMInit, strParticID, strGrpID);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminxByGroup(string strGrpID, stringstrGrName)

{

try

{

return dalPH.GetPolicyholdersFromLuminxByGroup(strGrpID, strGrName);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public DataTable GetAllDDExceptionRecords(string BankName,string PHolder,string FromDate,stringToDate)

{

try

{

return vbedal.GetAllDDExceptionRecords(BankName, PHolder,FromDate, ToDate);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionByParticpants(string strBankName, stringstrFromDate, string strToDate)

{

return vbedal.GetExceptionByParticpants(strBankName, strFromDate, strToDate);

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionByGroup(string strBankName, string strFromDate,string strToDate)

{

return vbedal.GetExceptionByGroup(strBankName, strFromDate, strToDate);

}

public DataTable CheckFileGeneration(string IndorGrp)

{

return vbedal.CheckFileGeneration(IndorGrp);

}

public IEnumerable<ViewBankExceptionsBE> GetExceptionsFileType()

{

try

{

return vbedal.GetExceptionsFileType();

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String InsertintoLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.InsertintoLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String InsertintoLuminXPaymentPostingDetails(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.InsertintoLuminXPaymentPostingDetails(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public String UpdateLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

{

try

{

return vbedal.UpdateLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public void DeleteEntry(ViewBankExceptionsBE vbebe)

{

try

{

vbedal.DeleteEntry(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

}

}

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionBE;

namespace DDSolutionDALC

{

public class ViewDDExceptionsDAL

{

DDSolutionClassDataContext context = new DDSolutionClassDataContext();

GeneralDAL gnl = new GeneralDAL();

LoadOPPFileBE lopbe = new LoadOPPFileBE();

public DataTable GetDDExcepRecords(string FundType,string Fromdate, string Todate)

{

try

{

var Records = context.usp_GetACHExceptionsByDate(FundType, Fromdate, Todate);

return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

public DataTable GetDDAS400ExcepRecords(string Fundtype, string Fromdate, string Todate)

{

try

{

var Records = context.usp_GetDDAS400ExcepionsByDate(Fundtype, Fromdate, Todate);

return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

}

}

using System;

using System.Collections.Generic;

using System.Globalization;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using DDSolutionBO;

using DDSolutionBE;

using System.Text;

using DDSolutionDALC;

using System.Configuration;

using System.IO;

public partial class UI_BankExceptionManagement : System.Web.UI.Page

{

PolicyholderBO boPH = new PolicyholderBO();

General gnl = new General();

DataTable dtMailingAddress = new DataTable();

DataTable dtGetdata = new DataTable();

ViewBankExceptionsBO vbebo = new ViewBankExceptionsBO();

ViewBankExceptionsBE vbebe = new ViewBankExceptionsBE();

string FilePath = "";

string fileDate = "";

string FilType = "";

int ParentID;

string rtnmsg = "";

int UserID;

string GeneratedFileId;

DateTime FilegeneratedDateTime;

double TotalAmt = 0.00;

int Recordcount;

string strFileName = "";

protected void Page_Load(object sender, EventArgs e)

{

// To Clear Cache

Response.Buffer = true;

Response.ExpiresAbsolute = DateTime.Now;

Response.CacheControl = "no-cache";

// To Clear Cache

//CE3.SelectedDate = DateTime.Today;

//CE4.SelectedDate = DateTime.Today;

try

{

if (Request.Cookies["UserInfo"] == null) Response.Redirect("Login.aspx");

if (!IsPostBack)

{

//txtFromDate.Text = gnl.GetASTDate().ToShortDateString();

//txtToDate.Text = gnl.GetASTDate().ToShortDateString();

//BindExceptions();

}

if(Request.Cookies["UserInfo"].Values["RoleName"].ToString().ToUpper().Trim().Contains("VIEWER"))

{

btnGenerateLetter.Enabled = false;

}

UserID = Convert.ToInt32(Request.Cookies["UserInfo"]["UserId"]);

}

catch (Exception ex)

{

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

}

}

protected void btnClose_Click(object sender, EventArgs e)

{

Response.Redirect("../UI/MainPage.aspx");

}

private void GenerateINDLetter()

{

try

{

StringBuilder sb = new StringBuilder();

IEnumerable<ViewBankExceptionsBE> ieGetExcepByParticip;

ieGetExcepByParticip = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

//dtGetdata = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

if (ieGetExcepByParticip.Count() > 0)

//if (dtGetdata.Rows.Count > 0)

{

Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

fileDate = gnl.GenerateFileName("");//.GetASTDate().ToString("MMddyyyy_HHmmss");// Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

InsertintoLuminXPaymentPostingHeader();

foreach (var item in ieGetExcepByParticip)

{

//vbebe.ParticipantID = drow[0].ToString();

//vbebe.GroupNumber = drow[1].ToString();

//vbebe.TransactionDate = Convert.ToDateTime(drow[2].ToString());

//vbebe.CustFirstName = drow[3].ToString();

//vbebe.CustLastName = drow[4].ToString();

//CustomerName = vbebe.CustFirstName + " " + vbebe.CustLastName;

//vbebe.AccountNumber = drow[5].ToString();

//vbebe.ErrorDescription = drow[6].ToString();

//TransactionDate1 = vbebe.TransactionDate;

//IEnumerable<LuminXParticipantsBE> ieLxParticips = null;

//ieLxParticips = vbebo.GetPolicyholdersFromLuminx(null, null, null, vbebe.ParticipantID, vbebe.GroupNumber);

//foreach (var item in ieLxParticips)

//{

//string str = item.MailingAddress;

//string[] words = str.Split('%');

//string Address1 = words[0].ToString();

//string Addressstr = words[1].ToString();

////string[] Addressstr2 = Addressstr.Split(',');

////string Address2 = Addressstr2[0].ToString();

////string Address3 = Addressstr2[1].ToString();

//// string Address4 = Addressstr2[2].ToString();

//string mainstr = null;

//string[] splitstr = Addressstr.Split(new Char[] { ',' });

//foreach (string line in splitstr)

//{

// //array for the measurement

// // string[] measurementArray = line.

// mainstr = mainstr + line;

// mainstr = mainstr + " ";

//}

sb.Append(item.Date.ToString().PadRight(10) + "|");

sb.Append(item.CustFirstName.ToString().PadRight(15) + "|");

sb.Append(item.CustLastName.ToString().PadRight(15) + "|");

sb.Append(item.Adress1.ToString().PadRight(25) + "|");

sb.Append(item.Adress2.ToString().PadRight(25) + "|");

sb.Append(item.Adress3.ToString().PadRight(25) + "|");

sb.Append(item.PostalCode.ToString().PadRight(9) + "|");

sb.Append(item.AccountNumber.ToString().PadRight(6) + "|");

sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

vbebe.ParticipantID = item.ParticipantID.ToString();

vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

vbebe.UserID = UserID;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

Recordcount++;

//sb.Append(vbebe.TransactionDate.ToString("MM-dd-yyyy").ToString().PadRight(10) + '|');

//sb.Append(CustomerName.ToString().PadRight(50) + '|');

//sb.Append(Address1.ToString().PadRight(50) + '|');

//sb.Append(mainstr.ToString().PadRight(100) + '|');

//// sb.Append(Address2.ToString().PadRight(15));

////sb.Append(Address3.ToString().PadRight(15));

//// sb.Append(Address4.ToString().PadRight(15) + '|');

//sb.Append(vbebe.AccountNumber.ToString().PadRight(20) + '|');

//sb.Append(vbebe.ErrorDescription.ToString().PadRight(250) + '|');

//sb.Append(TransactionDate1.ToString("dd-MMM-yyyy").ToString().PadRight(11));//.ToString("dd-MMM-yy");

sb.AppendLine();

//}

}

using (StreamWriter wtr = File.CreateText(FilePath))

{

UpdateDtls();

wtr.Write(sb.ToString());

//ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('File Generated Successfully');", true);

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = "File generated successfully. Please check LetterFeedFiles folder.";

}

}

else

{

//ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('Please Select Policyholder');", true);

errMsg.Attributes["class"] = "MsgBox warning";

errMsg.InnerHtml = " No records were found for given transaction date range";

//ddlPholder.Focus();

return;

}

}

catch (Exception ex)

{

DeleteEntry();

throw new Exception(ex.Message);

}

}

protected void btnGenerateLetter_Click(object sender, EventArgs e)

{

errMsg.Attributes["class"] = "";

errMsg.InnerHtml = "";

try

{

if (ddlPholder.SelectedValue == "Individual")

GenerateINDLetter();

else

GenerateGRPLetter();

}

catch (Exception ex)

{

//throw new Exception(ex.Message);

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

if (File.Exists(FilePath))

{

File.Delete(FilePath);

}

}

}

private void GenerateGRPLetter()

{

try

{

StringBuilder sb = new StringBuilder();

IEnumerable<ViewBankExceptionsBE> ieGetExcepByGRP;

ieGetExcepByGRP = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

//dtGetdata = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

if (ieGetExcepByGRP.Count() > 0)

{

Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

fileDate = gnl.GenerateFileName(""); //gnl.GetASTDate().ToString("MMddyyyy_HHmmss"); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

InsertintoLuminXPaymentPostingHeader();

foreach (var item in ieGetExcepByGRP)

{

sb.Append(item.Date.ToString().PadRight(10) + "|");

sb.Append(item.GrpName.ToString().PadRight(30) + "|");

sb.Append(item.Adress1.ToString().PadRight(25) + "|");

sb.Append(item.Adress2.ToString().PadRight(25) + "|");

sb.Append(item.Parish.ToString().PadRight(20) + "|");

sb.Append(item.PostalCode.ToString().PadRight(10) + "|");

sb.Append(item.GroupNumber.ToString().PadLeft(5, '0') + "|");

sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

vbebe.ParticipantID = item.ParticipantID.ToString();

vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

vbebe.UserID = UserID;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

Recordcount++;

sb.AppendLine();

}

using (StreamWriter wtr = File.CreateText(FilePath))

{

UpdateDtls();

wtr.Write(sb.ToString());

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = "File generated successfully..";

}

}

else

{

errMsg.Attributes["class"] = "MsgBox warning";

errMsg.InnerHtml = " No records were found for given date range";

return;

}

}

catch (Exception ex)

{

DeleteEntry();

throw new Exception(ex.Message);

}

}

protected void InsertintoLuminXPaymentPostingHeader()

{

try

{

// vbebe.FileName = fileName;

IEnumerable<ViewBankExceptionsBE> iegetfiletype;

iegetfiletype = vbebo.GetExceptionsFileType();

foreach (var ftype in iegetfiletype)

{

FilType = ftype.MasterData.ToString();

ParentID = ftype.ParentFileID;

}

// FileFenerateDateTime =Convert.ToDateTime( fileDate);

//FilePath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

vbebe.FileName = strFileName;

vbebe.FileType = FilType;

FilegeneratedDateTime = gnl.GetASTDate(); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime());

vbebe.FileGenerationDateTime = FilegeneratedDateTime;

string spath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

string[] words = spath.Split('\\');

string spath1 = words[0].ToString();

string spath2 = words[1].ToString();

string spath3 = words[2].ToString();

//string Address1 = words[0].ToString();

vbebe.FilePath = spath1 + "\\" + spath3;

vbebe.ParentFileID = ParentID;

vbebe.isActive = true;

vbebe.UserID = UserID;

vbebe.CreatedDateTime = gnl.GetASTDate();

GeneratedFileId = vbebo.InsertintoLuminXPaymentPostingHeader(vbebe);

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

errMsg.Attributes["class"] = "MsgBox success";

errMsg.InnerHtml = rtnmsg;

}

catch (Exception ex)

{

//throw new Exception(ex.Message);

errMsg.Attributes["class"] = "MsgBox error";

errMsg.InnerHtml = ex.Message;

return;

}

}

public void UpdateDtls()

{

try

{

vbebe.Amount = TotalAmt;

vbebe.TotalRecords = Recordcount;

vbebe.FileId = Convert.ToInt32(GeneratedFileId);

vbebe.FileGenerationEndDateTime = gnl.GetASTDate();

vbebo.UpdateLuminXPaymentPostingHeader(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

public void DeleteEntry()

{

try

{

vbebo.DeleteEntry(vbebe);

}

catch (Exception ex)

{

throw ex;

}

}

}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BankExceptionManagement.aspx.cs"

Inherits="UI_BankExceptionManagement" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Src="~/UserControls/HeaderControl.ascx" TagName="Header" TagPrefix="hdr" %>

<%@ Register Src="~/UserControls/FooterControl.ascx" TagName="Footer" TagPrefix="ftr" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<link rel="shortcut icon" href="../Images/favicon.ico" />

<title>Bank Exception Management</title>

<link href="~/Styles/Style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="../Scripts/jquery-1.4.1.min.js"></script>

<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>

<script language="javascript" type="text/javascript">

/* $(document).ready(function () {

// This code is used to validate the search on search button click.

// $('[id$=chkSelectAll]').click(function () {

// $("[id$='chkSelect']").attr('checked', this.checked);

// });

$("[id*=chkSelectAll]").live("click", function () {

var chkHeader = $(this);

var grid = $(this).closest("table");

$("input[type=checkbox]", grid).each(function () {

if (chkHeader.is(":checked")) {

$(this).attr("checked", "checked");

$("td", $(this).closest("tr")).addClass("selected");

} else {

$(this).removeAttr("checked");

$("td", $(this).closest("tr")).removeClass("selected");

}

});

});

$("[id*=chkSelect]").live("click", function () {

var grid = $(this).closest("table");

var chkHeader = $("[id*=chkSelectAll]", grid);

if (!$(this).is(":checked")) {

$("td", $(this).closest("tr")).removeClass("selected");

chkHeader.removeAttr("checked");

} else {

$("td", $(this).closest("tr")).addClass("selected");

if ($("[id*=chkSelect]", grid).length == $("[id*=chkSelect]:checked", grid).length) {

chkHeader.attr("checked", "checked");

}

}

});

});*/

function Close() {

var confrm = window.confirm("Are you sure, you want to close this window?");

if (confrm == true) {

return true;

}

else {

return false;

}

}

</script>

<style type="text/css">

.selected

{

background-color: #A1DCF2;

}

</style>

<script type="text/javascript">

$(document).ready(function () {

$('#btnGenerateLetter').click(function () {

document.getElementById("errMsg").style.visibility = "hidden";

if ($("#ddlBankName").val() == '-Select-') {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html("Select the BankName");

$('#ddlBankName').focus();

return false;

}

if ($("#ddlPholder").val() == '-Select-') {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Select the policyholder");

$('#ddlPholder').focus();

return false;

}

var FromDate = $.trim($(".txtFromDate").val());

if (FromDate.length == 0) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction From Date");

// $('#txtFromDate').focus();

return false;

}

// txtFromDate = document.getElementById('txtTranDate').value;

var txtFromDate = $.trim($(".txtFromDate").val());

var Datepattern = "^(0?[1-9]|1[012])[-/]?(0?[1-9]|[12][0-9]|3[01])[-/]?(19[\\d]{2}|20[\\d]{2}|2100)$";

if (!txtFromDate.match(Datepattern)) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction from date in 'MM/dd/yy' format");

// $('#txtFromDate').focus();

return false;

}

var ToDate = $.trim($(".txtToDate").val());

if (ToDate.length == 0) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction To Date");

//$('#txtToDate').focus();

return false;

}

var txtToDate = $.trim($(".txtToDate").val());

if (!txtToDate.match(Datepattern)) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" Enter Transaction To Date 'MM/dd/yy' Format");

// $('#txtFromDate').focus();

return false;

}

// var startDate = $('#txtFromDate').val().replace('/', '-');

var startDate = $('#txtFromDate').val();

var endDate = $('#txtToDate').val();

date1 = new Date(startDate.split("/")[2], startDate.split("/")[0], startDate.split("/")[1]);

date2 = new Date(endDate.split("/")[2], endDate.split("/")[0], endDate.split("/")[1]);

if (date1 > date2) {

document.getElementById("errMsg").style.visibility = "visible";

document.getElementById("errMsg").className = "MsgBox warning";

$('#errMsg').html(" To Date Should be greater than From Date");

// $('#txtFromDate').focus();

return false;

}

ShowProgress();

return true;

});

$('.ddlBankName').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

// var value = $('.txtHidBankAccNo').val().length;

//var BankName = $("#ddlBankName").get(0).selectedIndex;}

});

$('.ddlPholder').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

// var value = $('.txtHidBankAccNo').val().length;

//var BankName = $("#ddlBankName").get(0).selectedIndex;}

});

$('.txtFromDate').focusout(function () {

//debugger;

document.getElementById("errMsg").style.visibility = "hidden";

var value = $('.txtFromDate').val().length;

});

$('.txtToDate').focusout(function () {

document.getElementById("errMsg").style.visibility = "hidden";

var value = $('.txtToDate').val().length;

});

});

</script>

<script type="text/javascript">

function ClearFields() {

// document.getElementById("ddlBankName").options[0].selected = true;

// document.getElementById("txtFromDate").value = "";

// document.getElementById("txtToDate").value = "";

// document.getElementById("errMsg").style.visibility = "hidden";

window.location.href = "BankExceptionManagement.aspx";

return true;

}

</script>

<script type="text/javascript">

//This javascript function is used to display Loader when page is submitting to server

function ShowProgress() {

setTimeout(function () {

var modal = $('<div />');

modal.addClass("modal");

$('body').append(modal);

var loading = $(".loading");

loading.show();

var top = Math.max($(window).height() / 2 - loading[0].offsetHeight / 2, 0);

var left = Math.max($(window).width() / 2 - loading[0].offsetWidth / 2, 0);

loading.css({ top: top, left: left });

}, 200);

}

</script>

</head>

<body>

<form id="form1" runat="server" defaultbutton="btnGenerateLetter">

<div>

<hdr:Header ID="headerMain" runat="server" />

<center>

<div id="content">

<div class="content_section">

<table width="70%" border="0" style="border-color: Blue">

<tr>

<td align="center">

<asp:Label ID="lblUserMgmnt" runat="server" Text="Bank Exception Management"Font-Bold="True"

Font-Size="Medium"></asp:Label>

</td>

</tr>

<tr>

<td align="center">

<%--<asp:Label ID="lblException" runat="server" ForeColor="Red"></asp:Label>--%>

<div id="errMsg" runat="server" style="width: 45%; height: auto">

</div>

</td>

</tr>

<tr>

<td align="center">

<table border="1" style="border-color: Blue" width="50%">

<tr>

<td>

<table>

<tr>

<td align="right">

<asp:Label ID="lblBankName" runat="server"Text="BankName"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:DropDownList ID="ddlBankName" runat="server"Width="76%" CssClass="StyleDrpDown">

<asp:ListItem Text="BNTB" Value="BNTB"Selected="True"></asp:ListItem>

<%--<asp:ListItem Text="HSBC" Value="HSBC"></asp:ListItem>--%>

<%--<asp:ListItem Text="BNTB" Value="BNTB"></asp:ListItem>--%>

<%-- <asp:ListItem Text="Capital-G" Value="Capital-G"></asp:ListItem>--%>

</asp:DropDownList>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblPholder" runat="server"Text="Policyholder"></asp:Label><span

style="color: Red">*</span>

</td>

<td align="left">

<asp:DropDownList ID="ddlPholder" runat="server"Width="76%" CssClass="StyleDrpDown">

<asp:ListItem Text="-Select-" Value="-Select-"Selected="True"></asp:ListItem>

<asp:ListItem Text="Group" Value="Group"></asp:ListItem>

<asp:ListItem Text="Individual"Value="Individual"></asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblFromDate" runat="server"Text="Transaction from date"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:TextBox ID="txtFromDate" CssClass="txtFromDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

<asp:CalendarExtender ID="CE3" runat="server"TargetControlID="txtFromDate" TodaysDateFormat="MMM dd, yyyy"

Enabled="True">

</asp:CalendarExtender>

</td>

</tr>

<tr>

<td align="right">

<asp:Label ID="lblToDate" runat="server"Text="Transaction to date"></asp:Label><span style="color: Red">*</span>

</td>

<td align="left">

<asp:TextBox ID="txtToDate" CssClass="txtToDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

<asp:CalendarExtender ID="CE4" runat="server"TargetControlID="txtToDate" TodaysDateFormat="MMM dd, yyyy"

Enabled="True">

</asp:CalendarExtender>

</td>

</tr>

<tr>

<td align="right">

<asp:Button ID="btnGenerateLetter"CssClass="btnGenerate" Text="Generate File" runat="server"

Width="105px" OnClick="btnGenerateLetter_Click"/>

</td>

<td align="left">

<input id="Reset1" type="reset" value="Reset"class="button" onclick="ClearFields()" />

<asp:Button ID="btnClose" Text="Close"CssClass="button" runat="server" Width="50px"

OnClick="btnClose_Click" />

</td>

</tr>

</table>

</td>

</tr>

</table>

<div class="loading" align="center">

Generating...<br />

<br />

<br />

<br />

<img src="../Images/loader.gif" alt="" />

</div>

</td>

</tr>

</table>

</div>

</div>

</center>

<ftr:Footer ID="footermain" runat="server" />

</div>

</form>

</body>

</html>


---

Original Source: https://www.mindstick.com/interview/74/explain-about-active-x-data-object

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.