protected void btnUndo_Click(object sender, EventArgs e) { DataTable dt = (DataTable)Session[Constants.SES_CONFIG_APPROVE_DATA]; bool isOk = true; if (dt != null) { if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (dr["CheckerID"].ToString() != "") { isOk = false; } } if (isOk == true) { // goto undo operation JournalDAL oJournalDAL = new JournalDAL(); Result oResult = null; oResult = oJournalDAL.UndoJournals(dt, txtRefNo.Text); if (oResult.Status) { lblProgress.Text = "Undo done successfully"; } } else { lblProgress.Text = "Journals allready approved. Please check..."; } } } }
protected void btnMoveMain_Click(object sender, EventArgs e) { JournalDAL oJournalDAL = new JournalDAL(); DataTable dt = (DataTable)Session[Constants.SES_JOURNAL_RECON]; if (dt.Rows.Count > 0) { Result oResult = (Result)oJournalDAL.MoveToMain(dt); if (oResult.Status) { txtTotalDebitAmount.Text = ""; txtTotalCreditAmount.Text = ""; txtTotalNoofDebitTransaction.Text = ""; txtTotalNoofCreditTransaction.Text = ""; txtTotalBalance.Text = ""; gvAccJournals.DataSource = null; gvAccJournals.DataBind(); ucMessage.OpenMessage("Save done , Istiak message need to move into constain page.. ", Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage("Error.., Istiak message need to move", Constants.MSG_TYPE_ERROR); } } else { ucMessage.OpenMessage("No data is exist to move, Istiak message need to move into constain page.. ", Constants.MSG_TYPE_ERROR); } }
public void SetData() { txtTotalDebitAmount.Text = ""; txtTotalCreditAmount.Text = ""; txtTotalNoofDebitTransaction.Text = ""; txtTotalNoofCreditTransaction.Text = ""; txtTotalBalance.Text = ""; Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; /*tmp data load it should be come form Session of previous page..*/ JournalDAL oJournalDAL = new JournalDAL(); DateTime dtFromDate = Util.GetDateTimeByString(""); DateTime dtToDate = Util.GetDateTimeByString(""); string sAccountNmbr = "0961834840200"; string sReferenceNmbr = ""; Result oResult = oJournalDAL.LoadUnapprovedAccountingJournalList(sAccountNmbr, sReferenceNmbr, dtFromDate, dtToDate, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList != null) { if (dtTmpList.Rows.Count > 0) { gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList; // detail section object sumDrObj; sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' and IsReconciled=1 "); object sumCrObj; sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' and IsReconciled=1 "); object sumDrCountObj; sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' and IsReconciled=1 "); object sumCrCountObj; sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' and IsReconciled=1 "); txtTotalDebitAmount.Text = sumDrObj.ToString(); txtTotalCreditAmount.Text = sumCrObj.ToString(); txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString(); txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString(); txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString())); } } } /* end of data laod .. it is a completly tempory*/ }
protected void btnCheck_Click(object sender, EventArgs e) { JournalDAL oJournalDAL = new JournalDAL(); Result oResult = null; DateTime dtBalanceDate = Util.GetDateTimeByString(txtBalanceDate.Text); Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; oResult = oJournalDAL.GetJournals(txtRefNo.Text, chkArchive.Checked, dtBalanceDate, oConfig.DivisionID, oConfig.BankCodeID); ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_JBalance_lblProgress') ", true); txtTotalDebitAmount.Text = ""; txtTotalCreditAmount.Text = ""; txtTotalNoofDebitTransaction.Text = ""; txtTotalNoofCreditTransaction.Text = ""; txtTotalBalance.Text = ""; if (oResult.Status) { DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList.Rows.Count > 0) { DataTable dtClone = dtTmpList.Clone(); dtClone = dtTmpList.Copy(); Session[Constants.SES_CONFIG_APPROVE_DATA] = dtClone; dtTmpList.Columns.Remove("CheckerID"); gvSearchList.DataSource = dtTmpList; gvSearchList.DataBind(); // detail section object sumDrObj; sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' "); object sumCrObj; sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' "); object sumDrCountObj; sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' "); object sumCrCountObj; sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' "); txtTotalDebitAmount.Text = sumDrObj.ToString(); txtTotalCreditAmount.Text = sumCrObj.ToString(); txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString(); txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString(); txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString())); } else { gvSearchList.DataSource = null; gvSearchList.DataBind(); } } }
protected void btnSearch_Click(object sender, EventArgs e) { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; AccountReconciliation oAccountReconciliation = new AccountReconciliation(); JournalDAL oJournalDAL = new JournalDAL(); this.LoadUnapprovedAccRecon(); }
protected void btnApprove_Click(object sender, EventArgs e) { JournalDAL oJournalDAL = new JournalDAL(); Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; string sType = Request.QueryString["pType"]; if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_RECON).PadLeft(5, '0'))) { DataTable dt = new DataTable(); DataTable dtTmpList = (DataTable)Session[Constants.SES_CONFIG_UNAPPROVE_DATA]; int i = 0; dt = dtTmpList.Clone(); foreach (GridViewRow gvr in gvData.Rows) { if ((gvr.FindControl("txtRefNo") as TextBox).Text.Trim() != "") { DataRow newRow = dt.NewRow(); newRow.ItemArray = dtTmpList.Rows[i].ItemArray; newRow["ReferenceNo"] = (gvr.FindControl("txtRefNo") as TextBox).Text.Trim().ToUpper(); newRow["ReceiveDate"] = (gvr.FindControl("txtReceiveDt") as TextBox).Text.Trim(); newRow["ReconBy"] = (gvr.FindControl("txtReconBy") as TextBox).Text.Trim().ToUpper(); dt.Rows.Add(newRow); } i++; } Result oResult = (Result)oJournalDAL.ApproveAccountingJournal(dt, oConfig.UserName); if (oResult.Status) { ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR); } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_MANUAL).PadLeft(5, '0'))) { DataTable dt = (DataTable)Session[Constants.SES_CONFIG_UNAPPROVE_DATA]; Result oResult = (Result)oJournalDAL.ApproveManualAcctJournal(dt, oConfig.UserName); this.SearchAction(); if (oResult.Status) { ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR); } ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); } }
private void doAction(string ActionType) { AccountReconciliation oAccountReconciliation = new AccountReconciliation(); DataTable dtTmp = ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec.Clone(); dtTmp = ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec.Copy(); foreach (GridViewRow gvr in gvAccRecon.Rows) { CheckBox chk = (CheckBox)gvr.FindControl("chkSelected"); if (chk != null) { if (chk.Checked) { dtTmp.Rows[gvr.RowIndex]["ActionFlag"] = ActionType; } } } //do DB transaction oAccountReconciliation.DtAccountRec = dtTmp.Copy(); oAccountReconciliation.UserDetails = ucUserDet.UserDetail; JournalDAL oJournalDAL = new JournalDAL(); if (ActionType == "APPROVE") { if (oJournalDAL.ApproveAccJournal(oAccountReconciliation).Status) { ucMessage.OpenMessage("Successfully Approved.", Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage("Approved failure!!", Constants.MSG_TYPE_ERROR); } } else if (ActionType == "REJECT") { if (oJournalDAL.RejectAccJournal(oAccountReconciliation).Status) { ucMessage.OpenMessage("Successfully Rejected.", Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage("Reject failure!!", Constants.MSG_TYPE_ERROR); } } ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); //refresh grid view this.LoadUnapprovedAccRecon(); #region Assign Data in calculation field set //txtTotalFaceValue.Text = dTolFaceValue.ToString("N2"); #endregion }
protected void btnUpdate_Click(object sender, EventArgs e) { DataTable dt = (DataTable)Session[Constants.SES_CONFIG_APPROVE_DATA]; Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; JournalDAL oJournalDAL = new JournalDAL(); Result oResult = null; oResult = oJournalDAL.UpdateData(dt, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { lblProgress.Text = "updated successfully"; } else { lblProgress.Text = "error"; } }
protected void LoadUnapprovedAccRecon(string UserName, string DivisionID, string BankCodeID) { AccountReconciliation oAccountReconciliation = new AccountReconciliation(); JournalDAL oJournalDAL = new JournalDAL(); DataTable dtTmp = ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec.Clone(); oAccountReconciliation = (AccountReconciliation)oJournalDAL.LoadUnapprovedManualAcctJournalList(string.Empty, UserName, null, null, DivisionID, BankCodeID).Return; foreach (DataRow dr in oAccountReconciliation.DtAccountRec.Rows) { DataRow rowAccRecon = dtTmp.NewRow(); rowAccRecon["ValueDate"] = dr["ValueDate"].ToString(); rowAccRecon["SeqNo"] = int.Parse(dr["SeqNo"].ToString()); rowAccRecon["AccountNo"] = dr["AccountNo"].ToString(); rowAccRecon["SPTypeID"] = dr["SPTypeID"].ToString(); rowAccRecon["Narration"] = dr["Narration"].ToString(); rowAccRecon["CurrencyID"] = dr["CurrencyID"].ToString(); rowAccRecon["Amount"] = decimal.Parse(dr["Amount"].ToString()); rowAccRecon["JournalType"] = 0; rowAccRecon["DrCr"] = dr["DrCr"].ToString(); //[DivisionID] [char](3) NOT NULL, //[BankID] [char](3) NULL, //[MakerID] [varchar](20) NULL, //[MakeDate] [datetime] NULL, //[CheckerID] [varchar](20) NULL, //[CheckDate] [datetime] NULL, //[CheckerComment] [varchar](max) NULL, rowAccRecon["DivisionID"] = (dr["DivisionID"].ToString() == string.Empty || dr["DivisionID"] == null ? string.Empty : dr["DivisionID"].ToString().Trim()); rowAccRecon["BankID"] = (dr["BankID"].ToString() == string.Empty || dr["BankID"] == null ? string.Empty : dr["BankID"].ToString().Trim()); rowAccRecon["MakerID"] = (dr["MakerID"].ToString() == string.Empty || dr["MakerID"] == null ? string.Empty : dr["MakerID"].ToString().Trim()); rowAccRecon["MakeDate"] = (dr["MakeDate"].ToString() == string.Empty || dr["MakeDate"] == null ? string.Empty : dr["MakeDate"].ToString().Trim()); rowAccRecon["ActionFlag"] = "NIL"; dtTmp.Rows.Add(rowAccRecon); } //Store template table(null) in session ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec = dtTmp.Copy(); //Set Views this.SetView(dtTmp); }
protected void btnSave_Click(object sender, EventArgs e) { AccountReconciliation oAccountReconciliation = new AccountReconciliation(); JournalDAL oJournalDAL = new JournalDAL(); oAccountReconciliation = (AccountReconciliation)Session[Constants.SES_ACC_RECON]; oAccountReconciliation.UserDetails = ucUserDet.UserDetail; if (oJournalDAL.SaveAccJournal(oAccountReconciliation).Status) { ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR); } //finally do ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec.Clear(); this.SetView(null); //after ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); }
protected void btnSearch_Click(object sender, EventArgs e) { JournalDAL oJournalDAL = new JournalDAL(); string _anexCriteria = string.Empty; if (!string.IsNullOrEmpty(ddlSpType.SelectedItem.Value)) { _anexCriteria += " AND SPTypeID = '" + ddlSpType.SelectedItem.Value + "'"; } if (!string.IsNullOrEmpty(txtDate.Text.Trim())) { _anexCriteria += " AND ValueDate >= '" + Util.GetDateTimeByString(txtDate.Text).ToString("yyyy-MM-dd") + "' "; } if (!string.IsNullOrEmpty(ddlAccNumbe.SelectedItem.Value)) { _anexCriteria += " AND AccountNo = '" + ddlAccNumbe.SelectedItem.Value + "'"; } if (!string.IsNullOrEmpty(ddlAmountCondition.SelectedItem.Value) && !string.IsNullOrEmpty(txtAmountCondition.Text.Trim())) { _anexCriteria += " AND Amount " + ddlAmountCondition.SelectedItem.Value + " " + txtAmountCondition.Text.Trim() + ""; } if (!string.IsNullOrEmpty(txtPaymentFromDate.Text.Trim()) && !string.IsNullOrEmpty(txtPaymentToDate.Text.Trim())) { //no expression } if (!string.IsNullOrEmpty(txtReconFromDate.Text.Trim())) { _anexCriteria += " AND replace(convert(varchar, ReceiveDate, 106), ' ', '-') BETWEEN '" + txtReconFromDate.Text.Trim() + "' AND '" + (string.IsNullOrEmpty(txtReconToDate.Text.Trim()) ? txtReconFromDate.Text.Trim() : txtReconToDate.Text.Trim()) + "'"; } if (!string.IsNullOrEmpty(ddlJournalStatus.SelectedItem.Value)) { _anexCriteria += " AND IsReconciled = " + (ddlJournalStatus.SelectedItem.Value == "Reconciled" ? 1 : 0) + ""; } if (!string.IsNullOrEmpty(ddlDrCr.SelectedItem.Value)) { _anexCriteria += " AND DrCr = '" + (ddlDrCr.SelectedItem.Value == "Dr" ? 'D' : 'C') + "'"; } if (chkAscending.Checked) { _anexCriteria += " ORDER BY SeqNo ASC"; } else { _anexCriteria += " ORDER BY SeqNo DESC"; } string sTableName = ""; if (rdlType.SelectedValue.Equals("Download_Journal")) { sTableName = ""; btnReconcile.Enabled = false; btnMoveArchive.Enabled = false; btnMoveMain.Enabled = false; btnBalance.Enabled = false; btnAutoRecon.Enabled = true; } else if (rdlType.SelectedValue.Equals("Current_Journal")) { sTableName = "SPMS_AccountReconciliation"; btnReconcile.Enabled = true; btnMoveArchive.Enabled = true; btnMoveMain.Enabled = false; btnBalance.Enabled = true; btnAutoRecon.Enabled = true; } else if (rdlType.SelectedValue.Equals("Archives")) { sTableName = "SPMS_AccountReconciliation_Archive"; btnReconcile.Enabled = false; btnMoveArchive.Enabled = false; btnMoveMain.Enabled = true; btnBalance.Enabled = true; btnAutoRecon.Enabled = true; } DataTable dtTmp = (DataTable)(oJournalDAL.LoadAccountingJournalList(_anexCriteria, sTableName).Return); SetData(dtTmp); Session[Constants.SES_JOURNAL_RECON] = dtTmp; }
private void SearchAction() { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; string sType = Request.QueryString["pType"]; gvData.DataSource = null; gvData.DataBind(); txtTotalDebitAmount.Text = ""; txtTotalCreditAmount.Text = ""; txtTotalNoofDebitTransaction.Text = ""; txtTotalNoofCreditTransaction.Text = ""; txtTotalBalance.Text = ""; if (!string.IsNullOrEmpty(sType) && oConfig != null) { Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable(); if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_RECON).PadLeft(5, '0'))) { lgText.InnerHtml = "Accounting Journal Approval Queue List"; TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Accounting Journal' record found"); gvData.EmptyDataTemplate = tbGvData; JournalDAL oJournalDAL = new JournalDAL(); DateTime dtFromDate = Util.GetDateTimeByString(txtRecFromDate.Text); DateTime dtToDate = Util.GetDateTimeByString(txtRecToDate.Text); string sAccountNmbr = ddlAccNumbe.SelectedValue; string sReferenceNmbr = ddlReferenceNum.SelectedValue; Result oResult = oJournalDAL.LoadUnapprovedAccountingJournalList(sAccountNmbr, sReferenceNmbr, dtFromDate, dtToDate, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList != null) { if (dtTmpList.Rows.Count > 0) { gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList; // detail section object sumDrObj; sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' and IsReconciled=1 "); sumDrObj = sumDrObj.ToString() == "" ? 0 : sumDrObj; object sumCrObj; sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' and IsReconciled=1 "); sumCrObj = sumCrObj.ToString() == "" ? 0 : sumCrObj; object sumDrCountObj; sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' and IsReconciled=1 "); object sumCrCountObj; sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' and IsReconciled=1 "); txtTotalDebitAmount.Text = sumDrObj.ToString(); txtTotalCreditAmount.Text = sumCrObj.ToString(); txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString(); txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString(); txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString())); } } } } else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_JOURNAL_RECON.JOURNAL_MANUAL).PadLeft(5, '0'))) { lgText.InnerHtml = "Menual Journal Approval Queue List"; TemplateBuilder tbGvData = new TemplateBuilder(); tbGvData.AppendLiteralString("No 'Menual Journal' record found"); gvData.EmptyDataTemplate = tbGvData; //BranchDAL oBranchDAL = new BranchDAL(); JournalDAL oJournalDAL = new JournalDAL(); DateTime dtFromDate = Util.GetDateTimeByString(txtRecFromDate.Text); DateTime dtToDate = Util.GetDateTimeByString(txtRecToDate.Text); string sAccountNmbr = ddlAccNumbe.SelectedValue; Result oResult = oJournalDAL.LoadUnapprovedManualAcctJournalList(sAccountNmbr, null, dtFromDate, dtToDate, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { DataTable dtTmpList = ((SBM_BLC1.Entity.JournalRecon.AccountReconciliation)oResult.Return).DtAccountRec; if (dtTmpList != null) { if (dtTmpList.Rows.Count > 0) { gvData.DataSource = dtTmpList; gvData.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList; // detail section object sumDrObj; sumDrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'D' and IsReconciled=0 "); sumDrObj = sumDrObj.ToString() == "" ? 0 : sumDrObj; object sumCrObj; sumCrObj = dtTmpList.Compute("Sum(Amount)", "DrCr = 'C' and IsReconciled=0 "); sumCrObj = sumCrObj.ToString() == "" ? 0 : sumCrObj; object sumDrCountObj; sumDrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'D' and IsReconciled=0 "); object sumCrCountObj; sumCrCountObj = dtTmpList.Compute("Count(Amount)", "DrCr = 'C' and IsReconciled=0 "); txtTotalDebitAmount.Text = sumDrObj.ToString(); txtTotalCreditAmount.Text = sumCrObj.ToString(); txtTotalNoofDebitTransaction.Text = sumDrCountObj.ToString(); txtTotalNoofCreditTransaction.Text = sumCrCountObj.ToString(); txtTotalBalance.Text = Convert.ToString(Convert.ToDecimal(sumCrObj.ToString()) + Convert.ToDecimal(sumCrObj.ToString())); } } } } } }
protected void LoadUnapprovedAccRecon() { AccountReconciliation oAccountReconciliation = new AccountReconciliation(); JournalDAL oJournalDAL = new JournalDAL(); DataTable dtTmp = ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec.Clone(); Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; oAccountReconciliation = (AccountReconciliation)oJournalDAL.GetAllUnapprovedAccJournal(ddlSPType.SelectedItem.Value.Trim(), ddlAccountNo.SelectedItem.Value.Trim(), ddlMaker.SelectedItem.Value.Trim(), oConfig.DivisionID, oConfig.BankCodeID).Return; foreach (DataRow dr in oAccountReconciliation.DtAccountRec.Rows) { DataRow rowAccRecon = dtTmp.NewRow(); rowAccRecon["ValueDate"] = dr["ValueDate"].ToString(); rowAccRecon["SeqNo"] = int.Parse(dr["SeqNo"].ToString()); rowAccRecon["AccountNo"] = dr["AccountNo"].ToString(); rowAccRecon["SPTypeID"] = dr["SPTypeID"].ToString(); rowAccRecon["Narration"] = dr["Narration"].ToString(); rowAccRecon["CurrencyID"] = dr["CurrencyID"].ToString(); rowAccRecon["Amount"] = decimal.Parse(dr["Amount"].ToString()); rowAccRecon["JournalType"] = 0; rowAccRecon["DrCr"] = dr["DrCr"].ToString(); //[DivisionID] [char](3) NOT NULL, //[BankID] [char](3) NULL, //[MakerID] [varchar](20) NULL, //[MakeDate] [datetime] NULL, //[CheckerID] [varchar](20) NULL, //[CheckDate] [datetime] NULL, //[CheckerComment] [varchar](max) NULL, rowAccRecon["DivisionID"] = (dr["DivisionID"].ToString() == string.Empty || dr["DivisionID"] == null ? string.Empty : dr["DivisionID"].ToString().Trim()); rowAccRecon["BankID"] = (dr["BankID"].ToString() == string.Empty || dr["BankID"] == null ? string.Empty : dr["BankID"].ToString().Trim()); rowAccRecon["MakerID"] = (dr["MakerID"].ToString() == string.Empty || dr["MakerID"] == null ? string.Empty : dr["MakerID"].ToString().Trim()); rowAccRecon["MakeDate"] = (dr["MakeDate"].ToString() == string.Empty || dr["MakeDate"] == null ? string.Empty : DateTime.Parse(dr["MakeDate"].ToString().Trim()).ToString("dd-MM-yyyy")); rowAccRecon["ActionFlag"] = "NIL"; dtTmp.Rows.Add(rowAccRecon); } gvAccRecon.DataSource = dtTmp; gvAccRecon.DataBind(); //Store in session ((AccountReconciliation)Session[Constants.SES_ACC_RECON]).DtAccountRec = dtTmp.Copy(); //Set Values object obj = new object(); if (dtTmp.Select("DrCr='D'").Length > 0) { txtNoOfDrTrans.Text = dtTmp.Select("DrCr='D'").Length.ToString(); obj = dtTmp.Compute("SUM(Amount)", "DrCr='D'"); txtTotDrAmt.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0"; } else { txtNoOfDrTrans.Text = "0"; txtTotDrAmt.Text = "0"; } if (dtTmp.Select("DrCr='C'").Length > 0) { txtNoOfCrTrans.Text = dtTmp.Select("DrCr='C'").Length.ToString(); obj = dtTmp.Compute("SUM(Amount)", "DrCr='C'"); txtTotCrAmt.Text = Convert.ToDecimal(obj).ToString(); } else { txtNoOfCrTrans.Text = "0"; txtTotCrAmt.Text = "0"; } }