protected void btnApprove_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBBReferenceNo.Text))
{
//oLien.UserDetails = ucUserDet.UserDetail;
SaleStatementReconDAL oSaleStatementReconDAL = new SaleStatementReconDAL();
SalesStatementReconciled oSalesStatementReconciled = new SalesStatementReconciled();
oSalesStatementReconciled.ReconSaleStatementReferenceNo = txtBBReferenceNo.Text;
//get User Details
oSalesStatementReconciled.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oSaleStatementReconDAL.Approve(oSalesStatementReconciled);
if (oResult.Status)
{
TotalClear();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
SalesStatementReconciled oSalesStatementReconciled = (SalesStatementReconciled)Session[Constants.SES_SALES_CLAIM_RECON];
if (oSalesStatementReconciled != null)
{
oSalesStatementReconciled.ReconSaleStatementTransNo = hdnReconSaleStatTransNo.Value.Equals("") ? "-1" : hdnReconSaleStatTransNo.Value;
oSalesStatementReconciled.ReconSaleStatementReferenceNo = txtBBReferenceNo.Text.Trim().ToUpper();
oSalesStatementReconciled.SPType.SPTypeID = ddlSpType.SelectedValue;
oSalesStatementReconciled.DebitDate = Util.GetDateTimeByString(txtDebitDate.Text);
oSalesStatementReconciled.DebitedFaceValue = Util.GetDecimalNumber(txtTtlDrAmnt.Text);
oSalesStatementReconciled.UserDetails = ucUserDet.UserDetail;
SaleStatementReconDAL oSaleStatmentReconDAL = new SaleStatementReconDAL();
Result oResult = oSaleStatmentReconDAL.Save(oSalesStatementReconciled);
if (oResult.Status)
{
TotalClear();
LoadPreviousList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
}
else
{
if (oResult.Message.Equals("A"))
{
ucMessage.OpenMessage("This BB Reference No. already used. Please check..", Constants.MSG_TYPE_ERROR);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
}
}
}
}
private void LoadDataByReferenceNo(string sBBRefNo, string sApprovalStatus)
{
SaleStatementReconDAL oSaleStatementReconDAL = new SaleStatementReconDAL();
Result oResult = oSaleStatementReconDAL.GetSalesStatementDataByBBRefNo(sBBRefNo, sApprovalStatus);
if (oResult.Status)
{
SetObject(oResult.Return as SalesStatementReconciled);
}
}
private void LoadPreviousList()
{
SaleStatementReconDAL oSaleStatementReconDAL = new SaleStatementReconDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = oSaleStatementReconDAL.LoadUnapprovedList(oConfig.UserName, false, oConfig.DivisionID, oConfig.BankCodeID);
if (oResult.Status)
{
DataTable dtTmpList = (DataTable)oResult.Return;
if (dtTmpList != null && dtTmpList.Rows.Count > 0)
{
dtTmpList.Columns.Remove("Maker ID");
}
gvData.DataSource = dtTmpList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
}
}
private void PopulateSalesStatementIssueDetailsGrid(GridViewRow gvRow)
{
SaleStatementReconDAL oSaleStatmentReconDAL = new SaleStatementReconDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = oSaleStatmentReconDAL.GetSalesIssueDetailByRefNo(gvRow.Cells[2].Text, oConfig.DivisionID);
if (oResult.Status)
{
DataTable dtSalesIssueDetail = oResult.Return as DataTable;
//Change Name for computing purpose
dtSalesIssueDetail.Columns[3].ColumnName = "SalesAmount";
txtNoOfReg.Text = dtSalesIssueDetail.Rows.Count.ToString();
object obj = dtSalesIssueDetail.Compute("SUM(SalesAmount)", "");
txtFaceValue.Text = Convert.ToDecimal(obj).ToString();
//Change back to previous name
dtSalesIssueDetail.Columns[3].ColumnName = "Sales Amount";
gvReg.DataSource = dtSalesIssueDetail;
gvReg.DataBind();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
//if (!hdDataType.Value.Equals("2"))
//{
if (!string.IsNullOrEmpty(hdnReconSaleStatTransNo.Value))
{
SaleStatementReconDAL oSaleStatementReconDAL = new SaleStatementReconDAL();
Result oResult = (Result)oSaleStatementReconDAL.Detete(hdnReconSaleStatTransNo.Value);
if (oResult.Status)
{
TotalClear();
LoadPreviousList();
ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
}
else
{
if (oResult.Message.Equals(Constants.TABLE_MAIN))
{
ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
}
//}
//else
//{
// ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_INFO);
// ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
//}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBBReferenceNo.Text))
{
SalesStatementReconciled oSalesStatementReconciled = new SalesStatementReconciled();
oSalesStatementReconciled.ReconSaleStatementReferenceNo = txtBBReferenceNo.Text;
SaleStatementReconDAL oSaleStatementReconDAL = new SaleStatementReconDAL();
oSalesStatementReconciled.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oSaleStatementReconDAL.Reject(oSalesStatementReconciled);
if (oResult.Status)
{
ucMessage.OpenMessage(Constants.MSG_SUCCESS_REJECT, Constants.MSG_TYPE_SUCCESS);
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
}
}
protected void txtReferenceNo_TextChanged(object sender, EventArgs e)
{
bool isRefNoFrmtOk = false;
string sRefNo = txtReferenceNo.Text.Trim();
//string[] aRefNo = sRefNo.Split('/');
//if (aRefNo.Length.Equals(4))
//{
// isRefNoFrmtOk = true;
//}
if (!string.IsNullOrEmpty(ddlSpType.SelectedValue) && !string.IsNullOrEmpty(ddlYear.SelectedValue))
{
//sRefNo = ddlSpType.SelectedValue + "/ABC/" + sRefNo + "/" + ddlYear.SelectedValue;
txtReferenceNo.Text = sRefNo;
isRefNoFrmtOk = true;
}
if (isRefNoFrmtOk)
{
int iIndx = -1;
SalesStatementReconciled oSSRecon = (SalesStatementReconciled)Session[Constants.SES_SALES_CLAIM_RECON];
if (oSSRecon != null)
{
DataTable dtClaimDetails = oSSRecon.DtClaimDetails;
//For Each dr As DataRow In dt.Select("query")
DataRow[] rows = dtClaimDetails.Select("RefNo='" + txtReferenceNo.Text + "'");
foreach (var vClaimDtl in rows)
{
iIndx = dtClaimDetails.Rows.IndexOf(vClaimDtl);
if ((gvClaim.Rows.Count > iIndx))
{
GridViewRow gvRow = gvClaim.Rows[iIndx];
SetReconciliationDetails(gvRow);
}
break;
}
}
if (iIndx.Equals(-1))
{
SaleStatementReconDAL oSaleStatmentReconDAL = new SaleStatementReconDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = oSaleStatmentReconDAL.GetSalesStatementDataByRefNo(txtReferenceNo.Text, oConfig.DivisionID);
if (oResult.Status)
{
DataTable dtSaleStatement = oResult.Return as DataTable;
if (dtSaleStatement.Columns.Count.Equals(1))
{
ucMessage.OpenMessage("This reference number already reconciled !!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel5, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearSalesClaimSection();
}
else if (dtSaleStatement.Rows.Count > 0)
{
//DDListUtil.Assign(ddlSpType, DB.GetDBValue(dtSaleStatement.Rows[0]["SPTypeID"]));
txtClaimBBDate.Text = (Date.GetDateTimeByString(dtSaleStatement.Rows[0]["StatementDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimFromDate.Text = (Date.GetDateTimeByString(dtSaleStatement.Rows[0]["FromDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimToDate.Text = (Date.GetDateTimeByString(dtSaleStatement.Rows[0]["ToDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimAmount.Text = DB.GetDBValue(dtSaleStatement.Rows[0]["TotalFaceValue"]);
txtDebitAmount.Text = DB.GetDBValue(dtSaleStatement.Rows[0]["TotalFaceValue"]);
txtClaimComment.Text = string.Empty;
hdnSaleStatTrnsNo.Value = DB.GetDBValue(dtSaleStatement.Rows[0]["SaleStatementTransNo"]);
}
else
{
ucMessage.OpenMessage("Invalid reference number!!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel5, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearSalesClaimSection();
}
}
}
btnAdd.Focus();
}
else
{
ucMessage.OpenMessage("Please select SP Type and Year.", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearSalesClaimSection();
}
}
protected void SearchAction()
{
string sType = Request.QueryString["pType"];
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
gvData.DataSource = null;
gvData.DataBind();
if (!string.IsNullOrEmpty(sType))
{
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();
#region Recon Sales Statement
if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.SALES_STATEMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Sales Statement Approval Queue List";
SaleStatementReconDAL oSaleStatmentReconDAL = new SaleStatementReconDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Sale Statement' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oSaleStatmentReconDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
#endregion Recon Sales Statement
#region Recon Commission Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.COMMISSION).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Commission Claim Approval Queue List";
CommClaimReconciliationDAL oCommClaimRecDAL = new CommClaimReconciliationDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Commission Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oCommClaimRecDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpCurrencyList = (DataTable)oResult.Return;
if (dtTmpCurrencyList != null)
{
gvData.DataSource = dtTmpCurrencyList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpCurrencyList;
}
}
#endregion
#region Recon Interest Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.INTEREST).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Interest Claim Approval Queue List";
InterestReimbursementDAL oIntReimDAL = new InterestReimbursementDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Interest Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oIntReimDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion
#region Recon Encashment Claim
else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_RECON.ENCASHMENT).PadLeft(5, '0')))
{
lgText.InnerHtml = "Reconciliantion Encashment Claim Approval Queue List";
EncashmentReimbursementDAL oEncashReimDAL = new EncashmentReimbursementDAL();
TemplateBuilder tbGvData = new TemplateBuilder();
tbGvData.AppendLiteralString("No 'Reconciliantion Encashment Claim' record found");
gvData.EmptyDataTemplate = tbGvData;
Result oResult = oEncashReimDAL.LoadUnapprovedList(null, true, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpIssueUpdateList = (DataTable)oResult.Return;
if (dtTmpIssueUpdateList != null)
{
gvData.DataSource = dtTmpIssueUpdateList;
gvData.DataBind();
Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpIssueUpdateList;
}
}
#endregion
//Make Filter By User
if (!string.IsNullOrEmpty(oConfig.FilterMakerID))
{
DDListUtil.Assign(ddlUserName, oConfig.FilterMakerID.Trim());
FilterData(oConfig.FilterMakerID.Trim());
}
}
}
