public DataTable DepositIntPayable(double Branch, string strAbbr, string strdate)
{
DataTable dtData = new DataTable();
try
{
SingletonConn objDataFetch = new SingletonConn();
OracleConnection oraConn = new OracleConnection();
OracleCommand cmd = new OracleCommand();
oraConn = objDataFetch.getSingletonConnectionInstance();
cmd.Parameters.Clear();
cmd.Connection = oraConn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "INTPAYABLE";
cmd.Parameters.Add("ABBR", OracleType.VarChar).Value = strAbbr;
cmd.Parameters.Add("ONDATE", OracleType.DateTime).Value = String.Format("{0:dd-MMM-yyyy}", strdate);
cmd.Parameters.Add("BRANCH", OracleType.Number).Value = Branch;
cmd.Parameters.Add("ITCUR", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output;
OracleDataAdapter odaLOrpt = new OracleDataAdapter(cmd);
odaLOrpt.Fill(dtData);
objlog.WriteLog("INTPAYABLE" + "" + "Executed Sucessfully");
//objLog.WriteLog("CBSILODNEWFORMAT.CBS_ILODREPORT : ds2.Rows.Count:" + dtLOrpt.Rows.Count);
}
catch (Exception ex)
{
string g;
g = ex.Message;
g = Regex.Replace(g, "[^a-zA-Z0-9_]+", " ");
objlog.WriteLog("DepositIntPayableReport.aspx: Exception in DepositIntPayable() : " + g);
ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('" + g + "')</script>");
}
finally
{
objlog.WriteLog("DepositIntPayableReport.aspx: DepositIntPayable():finally block reached..");
}
return(dtData);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string strFromDate = "", strAbbr = "", abbrCount = "", strBranch = "", abbrSno = "", sDate = string.Empty;
double dblBal = 0.0, dblDiffAmt = 0.0;
DataTable dtResult = new DataTable();
DataTable dtAllDetails = new DataTable();
DataRow row;
int iLength = 0;
try
{
SingletonConn objDataFetch = new SingletonConn();
OracleConnection oraConn = new OracleConnection();
oraConn = objDataFetch.getSingletonConnectionInstance();
lblBank.Visible = true;
lblBranch.Visible = true;
lblBank.Text = global.BankName();
lblBranch.Text = ddlBranch.SelectedItem.Text;
strBranch = ddlBranch.SelectedValue;
strFromDate = txtAsDate.Text;
for (int i = 0; i < chkList.Items.Count; i++)
{
if (chkList.Items[i].Selected)
{
strAbbr += chkList.Items[i].Value.Trim() + ",";
abbrCount = abbrCount + 1;
}
}
if (strAbbr != "")
{
iLength = strAbbr.Length - 1;
abbrSno = strAbbr.Substring(0, iLength);
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Select a Scheme and then Proceed...!') </script>");
return;
}
strFromDate = String.Format("{0:dd-MMM-yyyy}", Convert.ToDateTime(txtAsDate.Text));
objlog.WriteLog("DepositIntPayableReport .aspx: Before calling the procedur");
dtAllDetails = DepositIntPayable(Convert.ToInt32(ddlBranch.SelectedValue), strAbbr, strFromDate);
if (dtAllDetails.Rows.Count > 0)
{
dtResult.Columns.Add(new DataColumn("SL No", typeof(string)));
dtResult.Columns.Add(new DataColumn("Client No", typeof(string)));
dtResult.Columns.Add(new DataColumn("Abbr", typeof(string)));
dtResult.Columns.Add(new DataColumn("Acno", typeof(string)));
dtResult.Columns.Add(new DataColumn("Name", typeof(string)));
dtResult.Columns.Add(new DataColumn("Balance", typeof(string)));
dtResult.Columns.Add(new DataColumn("Int Payable", typeof(string)));
//ADDED BY ROOPA ON 14032018
dtResult.Columns.Add(new DataColumn("Deposit Date", typeof(string)));
dtResult.Columns.Add(new DataColumn("Maturity Date", typeof(string)));
dtResult.Columns.Add(new DataColumn("Rate of Int(%)", typeof(string)));
dtResult.Columns.Add(new DataColumn("No. of Days Int Calu", typeof(string)));
//END
int i = 1;
foreach (DataRow dr in dtAllDetails.Rows)
{
row = dtResult.NewRow();
row["SL No"] = i;
row["Abbr"] = dr["ABBR"];
row["Acno"] = dr["ACC_NO"];
row["Client No"] = dr["CLIENT"];
row["Name"] = dr["CLIENT_NAME"];
row["Balance"] = string.Format("{0:0.00}", dr["ACC_BAL"]);
if (!DBNull.Value.Equals(dr["ACC_BAL"]))
{
dblBal = dblBal + Convert.ToDouble(dr["ACC_BAL"]);
}
row["Int Payable"] = string.Format("{0:0.00}", dr["DIFFAMT"]);
if (!DBNull.Value.Equals(dr["DIFFAMT"]))
{
dblDiffAmt = dblDiffAmt + Convert.ToDouble(dr["DIFFAMT"]);
}
//ADDED BY ROOPA ON 14032018
if (!DBNull.Value.Equals(dr["DEPDATE"]))
{
row["Deposit Date"] = String.Format("{0:dd/MM/yyyy}", dr["DEPDATE"]);
}
else
{
row["Deposit Date"] = "";
}
if (!DBNull.Value.Equals(dr["MATDATE"]))
{
row["Maturity Date"] = String.Format("{0:dd/MM/yyyy}", dr["MATDATE"]);
}
else
{
row["Maturity Date"] = "";
}
if (!DBNull.Value.Equals(dr["INTRATE"]))
{
row["Rate of Int(%)"] = dr["INTRATE"];
}
if (!DBNull.Value.Equals(dr["NOOFDAYS"]))
{
row["No. of Days Int Calu"] = dr["NOOFDAYS"];;
}
else
{
row["No. of Days Int Calu"] = 0;
}
//END
dtResult.Rows.Add(row);
i++;
}
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Data not found') </script>");
return;
}
row = dtResult.NewRow();
row["Name"] = "Total";
row["Balance"] = string.Format("{0:0.00}", dblBal);
row["Int Payable"] = string.Format("{0:0.00}", dblDiffAmt);
dtResult.Rows.Add(row);
gvRptDisp.DataSource = dtResult;
gvRptDisp.DataBind();
(ViewState["Details"]) = dtResult;
}
catch (Exception ex)
{
string g = ex.Message;
g = Regex.Replace(g, "[^a-zA-Z0-9_]+", " ");
objlog.WriteLog("DepositIntPayableReport .aspx: Exception in btnSubmit_Click():" + g);
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('" + g + "')</script>");
return;
}
finally
{
objlog.WriteLog("DepositIntPayableReport .aspx: btnSubmit_Click-->btnSubmit_Click events Finally block Executed ");
}
}
