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 btnOK_Click(object sender, EventArgs e) { DataTable dtDCB = new DataTable(); DataTable dtDetails = new DataTable(); DataRow row; globalSession.checkSession(); OraConn = objDataFetch.getSingletonConnectionInstance(); objCmdSave.Connection = OraConn; string abbr = "", sOD = "", sLoan = "", strFrmDate = "", strToDate = ""; int intRecount = 0; double dblSlNo = 0, dblTotErlierDemand = 0.00, dblTotPresentDemand = 0.00, dblTotPresentCollection = 0.00, dblGTotErlierCollection = 0.00, dblTotFutureCollection = 0.00, dblTotErlierBalance = 0.00, dblTotPresentBalance = 0.00, dblgrdTotdmd = 0.00, dblgrdTotColl = 0.00, dblgrdTotBal = 0.00, dblTotErDemand = 0.00, dblTotPrDemand = 0.00, dblgrdTotdemand = 0.00, dblGTotErCollection = 0.00, dblTotPrCollection = 0.00, dblTotFuCollection = 0.00, dblgrdTotCollection = 0.00, dblTotErBalance = 0.00, dblTotPrBalance = 0.00, dblgrdTotBalance = 0.00; DateTime temp; try { strFrmDate = txtFromDate.Text.ToString(); Session["strFrmDate"] = strFrmDate; strToDate = txtToDate.Text; Session["strToDate"] = strToDate; if (!(DateTime.TryParse(strFrmDate, out temp))) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Enter a Valid From Date') </script>"); return; } if (!(DateTime.TryParse(strToDate, out temp))) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Enter a Valid To Date') </script>"); return; } if ((Convert.ToDateTime(strFrmDate) > DateTime.Now) || (Convert.ToDateTime(strToDate) > DateTime.Now)) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Enter a Valid Date') </script>"); return; } if (Convert.ToDateTime(strFrmDate) > Convert.ToDateTime(strToDate)) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Check From and To Dates') </script>"); return; } if ((chkLoanScheme.SelectedValue == "") && (chkODScheme.SelectedValue == "")) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Select atleast one Scheme') </script>"); return; } for (int c = 0; c < chkODScheme.Items.Count; c++) { if (chkODScheme.Items[c].Selected) { abbr += chkODScheme.Items[c].Value.Trim() + ","; sOD += "" + chkODScheme.Items[c].Value.Trim() + ","; intRecount = intRecount + 1; } } objLog.WriteLog("DCBStatment sOD : " + sOD); for (int i = 0; i < chkLoanScheme.Items.Count; i++) { if (chkLoanScheme.Items[i].Selected) { abbr += chkLoanScheme.Items[i].Value.Trim() + ","; sLoan += "" + chkLoanScheme.Items[i].Value.Trim() + ","; intRecount = intRecount + 1; } } objLog.WriteLog("DCBStatment sLoan : " + sLoan); OracleCommand cmdProcExe = new OracleCommand("DCBSTAT.MENT", OraConn); cmdProcExe.CommandType = System.Data.CommandType.StoredProcedure; cmdProcExe.Parameters.Add("V_BRANCH", OracleType.Number).Value = ddlBranch.SelectedValue; cmdProcExe.Parameters.Add("V_LSCHEME", OracleType.VarChar).Value = sLoan; cmdProcExe.Parameters.Add("V_OSCHEME", OracleType.VarChar).Value = sOD; cmdProcExe.Parameters.Add("V_TYPE", OracleType.VarChar).Value = rblPriOrInt.SelectedValue; cmdProcExe.Parameters.Add("V_FDATE", OracleType.DateTime).Value = String.Format("{0:dd-MMM-yyyy}", strFrmDate); cmdProcExe.Parameters.Add("V_TDATE", OracleType.DateTime).Value = String.Format("{0:dd-MMM-yyyy}", strToDate); cmdProcExe.Parameters.Add("V_OUT", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output; OracleDataAdapter oDaExecution = new OracleDataAdapter(cmdProcExe); oDaExecution.Fill(dtDCB); if (dtDCB.Rows.Count <= 0) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('There is No Criteria') </script>"); return; } //objLog.WriteLog("DCBStatement - V_BRANCH INPUT to Stored Procedure " + ddlBranch.SelectedValue); //objLog.WriteLog("DCBStatement - V_LSCHEME INPUT to Stored Procedure " + sOD); //objLog.WriteLog("DCBStatement - V_OSCHEME INPUT to Stored Procedure " + sLoan); //objLog.WriteLog("DCBStatement - V_TYPE INPUT to Stored Procedure " + rblPriOrInt.SelectedValue); //objLog.WriteLog("DCBStatement - V_FDATE INPUT to Stored Procedure " + txtFromDate.Text); //objLog.WriteLog("DCBStatement - V_TDATE INPUT to Stored Procedure " + txtToDate.Text); //objLog.WriteLog("DCBStatment - dtDCB(Row Count)" + dtDCB.Rows.Count); objLog.WriteLog("DCBStatement - V_BRANCH:" + ddlBranch.SelectedValue + "V_LSCHEME :" + sOD + "V_OSCHEME:" + sLoan + "V_TYPE:" + rblPriOrInt.SelectedValue + "V_FDATE:" + txtFromDate.Text + "V_TDATE:" + txtToDate.Text); if (dtDCB.Rows.Count > 0) { dtDetails.Columns.Add(new DataColumn("SlNo", typeof(string))); dtDetails.Columns.Add(new DataColumn("LoanNo", typeof(string))); dtDetails.Columns.Add(new DataColumn("Name", typeof(string))); dtDetails.Columns.Add(new DataColumn("Arr Dmd", typeof(string))); dtDetails.Columns.Add(new DataColumn("Crnt Dmd", typeof(string))); dtDetails.Columns.Add(new DataColumn("Tot Dmd", typeof(string))); dtDetails.Columns.Add(new DataColumn("Arr Coln", typeof(string))); dtDetails.Columns.Add(new DataColumn("Crnt Coln", typeof(string))); dtDetails.Columns.Add(new DataColumn("Future Coln", typeof(string))); dtDetails.Columns.Add(new DataColumn("Tot Coln", typeof(string))); dtDetails.Columns.Add(new DataColumn("Arr Bal", typeof(string))); dtDetails.Columns.Add(new DataColumn("Cur Bal", typeof(string))); dtDetails.Columns.Add(new DataColumn("Tot Bal", typeof(string))); dtDetails.Columns.Add(new DataColumn("BrName", typeof(string))); } foreach (DataRow dr in dtDCB.Rows) { row = dtDetails.NewRow(); dblSlNo = dblSlNo + 1; row["SlNo"] = dblSlNo; if ((!DBNull.Value.Equals(dr["C_AccNo"])) || (!DBNull.Value.Equals(dr["C_AccNo"]))) { row["LoanNo"] = dr["C_ABBR"] + " " + dr["C_AccNo"]; } if (!DBNull.Value.Equals(dr["C_NAME"])) { row["Name"] = dr["C_NAME"]; } if (!DBNull.Value.Equals(dr["C_ERDEM"])) { row["Arr Dmd"] = String.Format("{0:0.00}", dr["C_ERDEM"]); dblTotErlierDemand = Convert.ToDouble(dr["C_ERDEM"]); dblTotErDemand += dblTotErlierDemand; } if (!DBNull.Value.Equals(dr["C_PRDEM"])) { row["Crnt Dmd"] = String.Format("{0:0.00}", dr["C_PRDEM"]); dblTotPresentDemand = Convert.ToDouble(dr["C_PRDEM"]); dblTotPrDemand += dblTotPresentDemand; } row["Tot Dmd"] = String.Format("{0:0.00}", dblTotErlierDemand + dblTotPresentDemand); dblgrdTotdmd = Convert.ToDouble(row["Tot Dmd"]); dblgrdTotdemand += dblgrdTotdmd; if (!DBNull.Value.Equals(dr["C_ERCOL"])) { row["Arr Coln"] = String.Format("{0:0.00}", dr["C_ERCOL"]); dblGTotErlierCollection = Convert.ToDouble(dr["C_ERCOL"]); dblGTotErCollection += dblGTotErlierCollection; } if (!DBNull.Value.Equals(dr["C_PRCOL"])) { row["Crnt Coln"] = String.Format("{0:0.00}", dr["C_PRCOL"]); dblTotPresentCollection = Convert.ToDouble(dr["C_PRCOL"]); dblTotPrCollection += dblTotPresentCollection; } if (!DBNull.Value.Equals(dr["C_ADVCOL"])) { row["Future Coln"] = String.Format("{0:0.00}", dr["C_ADVCOL"]); dblTotFutureCollection = Convert.ToDouble(dr["C_ADVCOL"]); dblTotFuCollection += dblTotFutureCollection; } row["Tot Coln"] = String.Format("{0:0.00}", dblGTotErlierCollection + dblTotPresentCollection + dblTotFutureCollection); dblgrdTotColl = Convert.ToDouble(row["Tot Coln"]); dblgrdTotCollection += dblgrdTotColl; if (!DBNull.Value.Equals(dr["C_ERBAL"])) { row["Arr Bal"] = String.Format("{0:0.00}", dr["C_ERBAL"]); dblTotErlierBalance = Convert.ToDouble(dr["C_ERBAL"]); dblTotErBalance += dblTotErlierBalance; } if (!DBNull.Value.Equals(dr["C_PRBAL"])) { row["Cur Bal"] = String.Format("{0:0.00}", dr["C_PRBAL"]); dblTotPresentBalance = Convert.ToDouble(dr["C_PRBAL"]); dblTotPrBalance += dblTotPresentBalance; } row["Tot Bal"] = String.Format("{0:0.00}", dblTotErlierBalance + dblTotPresentBalance); dblgrdTotBal = Convert.ToDouble(row["Tot Bal"]); dblgrdTotBalance += dblgrdTotBal; if (!DBNull.Value.Equals(dr["C_BNO"])) { row["BrName"] = dr["C_BNO"]; //DataTable dtBranch = new DataTable(); //string strSql = "", strbrnchname = ""; //strSql = " select * from branch where bran_sno= " + dr["C_BNO"]; //dtBranch = objDataFetch.DatatablePassSQL(strSql); //if (dtBranch.Rows.Count > 0) //{ // strbrnchname = dtBranch.Rows[0]["BRAN_NAME"].ToString(); //} //row["BrName"] = strbrnchname; } dtDetails.Rows.Add(row); } row = dtDetails.NewRow(); row["Name"] = "GRAND TOTAL"; row["Arr Dmd"] = (String.Format("{0:0.00}", dblTotErDemand)); row["Crnt Dmd"] = (String.Format("{0:0.00}", dblTotPrDemand)); row["Tot Dmd"] = (String.Format("{0:0.00}", dblgrdTotdemand)); row["Arr Coln"] = (String.Format("{0:0.00}", dblGTotErCollection)); row["Crnt Coln"] = (String.Format("{0:0.00}", dblTotPrCollection)); row["Future Coln"] = (String.Format("{0:0.00}", dblTotFuCollection)); row["Tot Coln"] = (String.Format("{0:0.00}", dblgrdTotCollection)); row["Arr Bal"] = (String.Format("{0:0.00}", dblTotErBalance)); row["Cur Bal"] = (String.Format("{0:0.00}", dblTotPrBalance)); row["Tot Bal"] = (String.Format("{0:0.00}", dblgrdTotBalance)); dtDetails.Rows.Add(row); lblBank.Visible = true; lblBranch.Visible = true; lblHeading.Visible = true; lblBank.Text = global.BankName(); lblBranch.Text = Session["LoginBranchName"].ToString().Trim(); lblHeading.Text = "DCB STATEMENT REPORT[CBS] From " + txtFromDate.Text + " TO " + txtToDate.Text + ""; gvDCB.DataSource = dtDetails; gvDCB.DataBind(); Session["dtDetails"] = dtDetails; objFrmPt.FormatGridView(gvDCB); GridPrint(gvDCB); ViewState["Pagename"] = "DCB STATEMENT REPORT"; imgxl0.Visible = true; } catch (Exception ex) { objLog.WriteLog(ex.Message); ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('" + ex.Message + "')</script>"); } finally { objLog.WriteLog("DCBStatment.aspx-->btnOK_Click() Event Reached finally block without any exceptions."); dtDCB.Dispose(); dtDetails.Dispose(); } }
protected void btnOK_Click(object sender, EventArgs e) { DataTable dtDetails = new DataTable(); DateTime temp; string sDeposit = ""; OracleConnection oraConn; oraConn = objDataFetch.getSingletonConnectionInstance(); OracleCommand cmd = new OracleCommand(); try { if (!(DateTime.TryParse(txtDate.Text, out temp))) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Enter a Valid Date.') </script>"); return; } if (txtBalance.Text == string.Empty) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Please enter the Balance and Proceed.') </script>"); return; } if (Convert.ToDouble(txtBalance.Text) == 0) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Balance Amount should be greater than Zero.') </script>"); return; } if (chkScheme.SelectedValue == "") { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Select atleast one Scheme and Proceed.') </script>"); return; } for (int i = 0; i < chkScheme.Items.Count; i++) { if (chkScheme.Items[i].Selected) { sDeposit += chkScheme.Items[i].Value.Trim() + ","; } } sDeposit = sDeposit.Remove(sDeposit.Length - 1, 1) + ""; cmd.Connection = oraConn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "HEAD.DICGC_REPORT"; // cmd.Parameters.Add(new OracleParameter("branch", OracleType.Number)).Value =Convert.ToInt16( ddlBranch.SelectedValue); if (rblBrnchConsol.SelectedValue.ToUpper().Trim() == "C") { cmd.Parameters.Add("branch", OracleType.Number).Value = DBNull.Value; } else { cmd.Parameters.Add("branch", OracleType.Number).Value = ddlBranch.SelectedValue; } cmd.Parameters.Add(new OracleParameter("schemes", OracleType.VarChar)).Value = sDeposit.Trim(); cmd.Parameters.Add(new OracleParameter("asdate", OracleType.DateTime)).Value = String.Format("{0:dd/MM/yyyy}", txtDate.Text); cmd.Parameters.Add(new OracleParameter("balance", OracleType.Number)).Value = Convert.ToDouble(txtBalance.Text); cmd.Parameters.Add(new OracleParameter("dicgccur", OracleType.Cursor)).Direction = ParameterDirection.Output; OracleDataAdapter adp = new OracleDataAdapter(cmd); adp.Fill(dtDetails); if (dtDetails.Rows.Count > 0) { pnlGrid.Visible = true; lblBank.Visible = true; lblBranch.Visible = true; lblHeading.Visible = true; lblBank.Text = global.BankName(); lblBranch.Text = Session["LoginBranchName"].ToString().Trim(); lblHeading.Text = "DICGC REPORT AS ON " + txtDate.Text + ""; gvDetails.DataSource = dtDetails; gvDetails.DataBind(); Session["dtDetails"] = dtDetails; objFrmPt.FormatGridView(gvDetails); GridPrint(gvDetails); ViewState["Pagename"] = "DICGCREPORT"; imgxl0.Visible = true; } else { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('Data Not Found.')</script>"); imgxl0.Visible = false; pnlGrid.Visible = false; return; } } catch (Exception ex) { string g = ex.Message + ex; g = Regex.Replace(g, "[^a-zA-Z0-9_]+", " "); objLog.WriteLog("DICGCRep.aspx-->Exception in btnOK_Click() Event" + g); ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('" + g + "')</script>"); return; } finally { dtDetails.Dispose(); objLog.WriteLog("DICGCRep.aspx-->btnOK_Click() Event Reached finally block without any exceptions."); } }
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 "); } }
protected void btnOK_Click(object sender, EventArgs e) { int Slno = 1, namecnt = 1, nCnt = 1, Count = 0; double dblTotAmt = 0.00, dblAmt = 0.00, dblcdAmt = 0.00, dblTotcdAmt = 0.00; string strDesc = ""; DataTable dtDetails = new DataTable(); DataTable dtDailyExp = new DataTable(); DateTime temp; DataRow grdmn1; OracleConnection oraConn; oraConn = objDataFetch.getSingletonConnectionInstance(); OracleCommand cmd = new OracleCommand(); try { if (!(DateTime.TryParse(txtAsonDate.Text, out temp))) { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert ('Enter a Valid Date.') </script>"); return; } //if (txtNoOfYears.Text == string.Empty) //{ // txtNoOfYears.Text = "0"; //} //cmd.Parameters.Clear(); //cmd.Connection = oraConn; //cmd.CommandType = System.Data.CommandType.StoredProcedure; //cmd.CommandText = "HEAD.DAILY_EXCEPTION"; //cmd.Parameters.Add(new OracleParameter("d_asondate", OracleType.DateTime)).Value = String.Format("{0:dd/MM/yyyy}", txtAsonDate.Text); //if (rblBrnConsol.SelectedValue.ToUpper().Trim() == "C") //{ // cmd.Parameters.Add(new OracleParameter("d_branch", OracleType.Number)).Value = DBNull.Value; //} //else //{ // cmd.Parameters.Add(new OracleParameter("d_branch", OracleType.Number)).Value =Convert.ToInt16(ddlBranch.SelectedValue); //} //cmd.Parameters.Add(new OracleParameter("d_detorsum", OracleType.VarChar)).Value ="'"+rblSumDet.SelectedItem.Text.Trim()+"'"; //cmd.Parameters.Add(new OracleParameter("c_out", OracleType.Cursor)).Direction = ParameterDirection.Output; //OracleDataAdapter adp = new OracleDataAdapter(cmd); //adp.Fill(dtDetails); cmd.Parameters.Clear(); cmd.Connection = oraConn; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "HEAD.DAILY_EXCEPTION_CONSOLIDATED"; cmd.Parameters.Add("d_asondate", OracleType.DateTime).Value = String.Format("{0:dd-MMM-yyyy}", txtAsonDate.Text); //if (rblBrnConsol.SelectedValue.ToUpper().Trim() == "C") //{ // cmd.Parameters.Add("d_branch", OracleType.Number).Value = DBNull.Value; //} //else //{ cmd.Parameters.Add("d_branch", OracleType.Number).Value = Convert.ToInt16(ddlBranch.SelectedValue); // } cmd.Parameters.Add("d_detorsum", OracleType.VarChar).Value = rblSumDet.SelectedItem.Text.Trim().ToUpper(); cmd.Parameters.Add("c_out", OracleType.Cursor).Direction = System.Data.ParameterDirection.Output; OracleDataAdapter adp = new OracleDataAdapter(cmd); adp.Fill(dtDetails); if (dtDetails.Rows.Count > 0) { if (rblSumDet.SelectedValue == "S") { dtDailyExp.Columns.Add(new DataColumn("SlNo", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("No of Accounts", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Description", typeof(string))); foreach (DataRow rgrd1 in dtDetails.Rows) { grdmn1 = dtDailyExp.NewRow(); grdmn1["SlNo"] = Slno; if (!DBNull.Value.Equals(rgrd1["NOACCOUNTS"])) { grdmn1["No of Accounts"] = rgrd1["NOACCOUNTS"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_DESCRIPTION"])) { grdmn1["Description"] = rgrd1["D_DESCRIPTION"].ToString(); } dtDailyExp.Rows.Add(grdmn1); Slno++; } } else { dtDailyExp.Columns.Add(new DataColumn("SlNo", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Name", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("PAN No", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("A/c No", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Branch", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Amount", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Debit/CreditAmt", typeof(string))); dtDailyExp.Columns.Add(new DataColumn("Debit/Credit", typeof(string))); // dtDailyExp.Columns.Add(new DataColumn("Description", typeof(string))); foreach (DataRow rgrd1 in dtDetails.Rows) { if ((strDesc != string.Empty) && (strDesc != rgrd1["D_DESCRIPTION"].ToString())) { grdmn1 = dtDailyExp.NewRow(); grdmn1["PAN No"] = "Total no. of Accounts"; grdmn1["A/c No"] = Count; grdmn1["Branch"] = "TOTAL"; grdmn1["Amount"] = String.Format("{0:0.00}", dblAmt); grdmn1["Debit/CreditAmt"] = String.Format("{0:0.00}", dblcdAmt); dblTotAmt += dblAmt; dblTotcdAmt += dblcdAmt; dtDailyExp.Rows.Add(grdmn1); dblAmt = 0.00; dblcdAmt = 0.00; Count = 0; //Slno++; namecnt = 1; grdmn1 = dtDailyExp.NewRow(); dtDailyExp.Rows.Add(grdmn1); } if (namecnt == 1) { grdmn1 = dtDailyExp.NewRow(); if (!DBNull.Value.Equals(rgrd1["D_DESCRIPTION"])) { grdmn1["Name"] = rgrd1["D_DESCRIPTION"].ToString(); } dtDailyExp.Rows.Add(grdmn1); grdmn1 = dtDailyExp.NewRow(); grdmn1["SlNo"] = Slno; Count++; if (!DBNull.Value.Equals(rgrd1["D_CNAME"])) { grdmn1["Name"] = rgrd1["D_CNAME"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_PAMNO"])) { grdmn1["PAN No"] = rgrd1["D_PAMNO"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_ABBR"])) { grdmn1["A/c No"] = rgrd1["D_ABBR"].ToString() + "-" + rgrd1["D_ACNO"]; } if (!DBNull.Value.Equals(rgrd1["D_BRANCH"])) { grdmn1["Branch"] = rgrd1["D_BRANCH"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_AMOUNT"])) { grdmn1["Amount"] = String.Format("{0:0.00}", rgrd1["D_AMOUNT"]); dblAmt = dblAmt + Convert.ToDouble(rgrd1["D_AMOUNT"]); //dblTotAmt = dblTotAmt + Convert.ToDouble(rgrd1["AMOUNT"]); } if (!DBNull.Value.Equals(rgrd1["D_DEBITORCREDITAMOUNT"])) { grdmn1["Debit/CreditAmt"] = String.Format("{0:0.00}", rgrd1["D_DEBITORCREDITAMOUNT"]); dblcdAmt = dblcdAmt + Convert.ToDouble(rgrd1["D_DEBITORCREDITAMOUNT"]); } if (!DBNull.Value.Equals(rgrd1["D_DRCR"])) { grdmn1["Debit/Credit"] = String.Format("{0:0.00}", rgrd1["D_DRCR"]); } //if (!DBNull.Value.Equals(rgrd1["D_DESCRIPTION"])) //{ // grdmn1["Description"] = rgrd1["D_DESCRIPTION"].ToString(); //} dtDailyExp.Rows.Add(grdmn1); } else if ((strDesc != string.Empty) && (strDesc == rgrd1["D_DESCRIPTION"].ToString())) { grdmn1 = dtDailyExp.NewRow(); grdmn1["SlNo"] = Slno; Count++; if (!DBNull.Value.Equals(rgrd1["D_CNAME"])) { grdmn1["Name"] = rgrd1["D_CNAME"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_PAMNO"])) { grdmn1["PAN No"] = rgrd1["D_PAMNO"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_ABBR"])) { grdmn1["A/c No"] = rgrd1["D_ABBR"].ToString() + "-" + rgrd1["D_ACNO"]; } if (!DBNull.Value.Equals(rgrd1["D_BRANCH"])) { grdmn1["Branch"] = rgrd1["D_BRANCH"].ToString(); } if (!DBNull.Value.Equals(rgrd1["D_AMOUNT"])) { grdmn1["Amount"] = String.Format("{0:0.00}", rgrd1["D_AMOUNT"]); // dblTotAmt = dblTotAmt + Convert.ToDouble(rgrd1["AMOUNT"]); dblAmt = dblAmt + Convert.ToDouble(rgrd1["D_AMOUNT"]); } if (!DBNull.Value.Equals(rgrd1["D_DEBITORCREDITAMOUNT"])) { grdmn1["Debit/CreditAmt"] = String.Format("{0:0.00}", rgrd1["D_DEBITORCREDITAMOUNT"]); dblcdAmt = dblcdAmt + Convert.ToDouble(rgrd1["D_DEBITORCREDITAMOUNT"]); } if (!DBNull.Value.Equals(rgrd1["D_DRCR"])) { grdmn1["Debit/Credit"] = String.Format("{0:0.00}", rgrd1["D_DRCR"]); } //if (!DBNull.Value.Equals(rgrd1["D_DESCRIPTION"])) //{ // grdmn1["Description"] = rgrd1["D_DESCRIPTION"].ToString(); //} dtDailyExp.Rows.Add(grdmn1); } if (!DBNull.Value.Equals(rgrd1["D_DESCRIPTION"])) { strDesc = rgrd1["D_DESCRIPTION"].ToString(); } Slno++; namecnt++; // nCnt++; //if (!DBNull.Value.Equals(dtPosting.Rows[i]["ClientNo"])) //{ // strClient = dtPosting.Rows[i]["ClientNo"].ToString(); //} } grdmn1 = dtDailyExp.NewRow(); grdmn1["PAN No"] = "Total no. of Accounts"; grdmn1["A/c No"] = Count; grdmn1["Branch"] = "TOTAL"; grdmn1["Amount"] = String.Format("{0:0.00}", dblAmt); grdmn1["Debit/CreditAmt"] = String.Format("{0:0.00}", dblcdAmt); dtDailyExp.Rows.Add(grdmn1); dblTotAmt += dblAmt; dblTotcdAmt += dblcdAmt; Count = 0; dblcdAmt = 0.00; grdmn1 = dtDailyExp.NewRow(); dtDailyExp.Rows.Add(grdmn1); grdmn1 = dtDailyExp.NewRow(); grdmn1["Branch"] = "GRAND TOTAL"; grdmn1["Amount"] = String.Format("{0:0.00}", dblTotAmt); grdmn1["Debit/CreditAmt"] = String.Format("{0:0.00}", dblTotcdAmt); dtDailyExp.Rows.Add(grdmn1); } pnlGrid.Visible = true; lblBank.Visible = true; lblBranch.Visible = true; lblHeading.Visible = true; lblBank.Text = global.BankName(); lblBranch.Text = Session["LoginBranchName"].ToString().Trim(); lblHeading.Text = "DAILY EXCEPTIONAL REPORT AS ON " + txtAsonDate.Text + ""; gvDetails.DataSource = dtDailyExp; gvDetails.DataBind(); Session["dtDetails"] = dtDailyExp; //objFrmPt.FormatGridView(gvDetails); //GridPrint(gvDetails); ViewState["Pagename"] = "DAILYEXCEPTIONALREPORT"; imgxl0.Visible = true; } else { ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('Data Not Found.')</script>"); imgxl0.Visible = false; pnlGrid.Visible = false; return; } } catch (Exception ex) { string g = ex.Message + ex; g = Regex.Replace(g, "[^a-zA-Z0-9_]+", " "); objLog.WriteLog("DailyExcepRep.aspx-->Exception in btnOK_Click() Event" + g); ClientScript.RegisterStartupScript(Page.GetType(), "VALIDATION", "<script language='javascript'>alert('" + g + "')</script>"); return; } finally { objLog.WriteLog("DailyExcepRep.aspx-->btnOK_Click() Event Reached finally block without any exceptions."); } }