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";
}
}
