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);
}
}
}
}
protected void gvClaim_RowCommand(object sender, GridViewCommandEventArgs e)
{
//get the row
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
//gvClaim.RowStyle.CssClass = "odd";
//gvRow.BackColor = Color.Blue;
if (((Button)e.CommandSource).Text.Equals("Select"))
{
PopulateSalesStatementIssueDetailsGrid(gvRow);
SetReconciliationDetails(gvRow);
btnAdd.Focus();
}
else if (((Button)e.CommandSource).Text.Equals("Remove"))
{
SalesStatementReconciled oSalesStatementReconciled = (SalesStatementReconciled)Session[Constants.SES_SALES_CLAIM_RECON];
if (oSalesStatementReconciled != null)
{
oSalesStatementReconciled.DtClaimDetails.Rows.RemoveAt(gvRow.RowIndex);
gvClaim.DataSource = oSalesStatementReconciled.DtClaimDetails;
gvClaim.DataBind();
//Store in Session
Session[Constants.SES_SALES_CLAIM_RECON] = oSalesStatementReconciled;
if (gvRow.Cells[2].Text.Equals(txtReferenceNo.Text.Trim()))
{
ClearSalesClaimSection();
}
//Set Values
txtNoOfClaim.Text = oSalesStatementReconciled.DtClaimDetails.Rows.Count.ToString();
object obj = oSalesStatementReconciled.DtClaimDetails.Compute("SUM(ClaimAmount)", "");
txtTtlCalimAmnt.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0";
obj = oSalesStatementReconciled.DtClaimDetails.Compute("SUM(DebitAmount)", "");
txtTtlDrAmnt.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0";
}
}
}
private void SetObject(SalesStatementReconciled oSSRecon)
{
Session[Constants.SES_SALES_CLAIM_RECON] = oSSRecon;
if (oSSRecon != null)
{
ddlSpType.Text = oSSRecon.SPType.SPTypeID;
ddlYear.Text = oSSRecon.DebitDate.Year.ToString();
txtDebitDate.Text = oSSRecon.DebitDate.ToString(Constants.DATETIME_FORMAT);
txtBBReferenceNo.Text = oSSRecon.ReconSaleStatementReferenceNo;
hdnReconSaleStatTransNo.Value = oSSRecon.ReconSaleStatementTransNo;
//Set user details
if (SEARCH_FROM.Equals(1))//if viewed from Temp By Maker
{
ucUserDet.UserDetail = oSSRecon.UserDetails;
}
else if (SEARCH_FROM.Equals(2))//if viewed from Temp By Checker
{
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.MakeDate = oSSRecon.UserDetails.MakeDate;
oUserDetails.MakerID = oSSRecon.UserDetails.MakerID;
ucUserDet.UserDetail = oUserDetails;
}
gvClaim.DataSource = oSSRecon.DtClaimDetails;
gvClaim.DataBind();
//Set a background color as Selected
//gvClaim.Rows[0].BackColor = Color.Blue;
SetClaimSatementDetailSectionValue(oSSRecon.DtClaimDetails);
if (gvClaim.Rows.Count > 0)
{
PopulateSalesStatementIssueDetailsGrid(gvClaim.Rows[0]);
}
}
}
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 btnAdd_Click(object sender, EventArgs e)
{
SalesStatementReconciled oSalesStatementReconciled = (SalesStatementReconciled)Session[Constants.SES_SALES_CLAIM_RECON];
if (oSalesStatementReconciled == null)
{
oSalesStatementReconciled = new SalesStatementReconciled();
}
// SaleStatement List
DataTable dtClaimDetails = oSalesStatementReconciled.DtClaimDetails;
if (dtClaimDetails.Columns.Count <= 0)
{
dtClaimDetails.Columns.Add(new DataColumn("RefNo", typeof(string)));
dtClaimDetails.Columns.Add(new DataColumn("ClaimDateBB", typeof(string)));
dtClaimDetails.Columns.Add(new DataColumn("ClaimDateFrom", typeof(string)));
dtClaimDetails.Columns.Add(new DataColumn("ClaimDateTo", typeof(string)));
dtClaimDetails.Columns.Add(new DataColumn("ClaimAmount", typeof(decimal)));
dtClaimDetails.Columns.Add(new DataColumn("DebitAmount", typeof(decimal)));
dtClaimDetails.Columns.Add(new DataColumn("Comment", typeof(string)));
//saving in DB purpose. This is hidden is design
dtClaimDetails.Columns.Add(new DataColumn("SaleStatementTransNo", typeof(string)));
}
DataRow[] rows = dtClaimDetails.Select("RefNo='" + txtReferenceNo.Text + "'");
if (rows.Length <= 0)
{
DataRow rowClaimDetails = dtClaimDetails.NewRow();
rowClaimDetails["RefNo"] = txtReferenceNo.Text;
DateTime parsedDate;
DateTime.TryParseExact(txtClaimBBDate.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimBBDate.Text);
rowClaimDetails["ClaimDateBB"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimBBDate.Text;
DateTime.TryParseExact(txtClaimFromDate.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimFromDate.Text);
rowClaimDetails["ClaimDateFrom"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimFromDate.Text;
DateTime.TryParseExact(txtClaimToDate.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimToDate.Text);
rowClaimDetails["ClaimDateTo"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimToDate.Text;
rowClaimDetails["ClaimAmount"] = txtClaimAmount.Text;
rowClaimDetails["DebitAmount"] = txtDebitAmount.Text;
rowClaimDetails["Comment"] = txtClaimComment.Text;
rowClaimDetails["SaleStatementTransNo"] = hdnSaleStatTrnsNo.Value;
dtClaimDetails.Rows.Add(rowClaimDetails);
}
else
{
int iRowIndex = -1;
foreach (var vClaimDtl in rows)
{
iRowIndex = dtClaimDetails.Rows.IndexOf(vClaimDtl);
break;
}
if (iRowIndex != -1)
{
dtClaimDetails.Rows[iRowIndex]["DebitAmount"] = txtDebitAmount.Text;
dtClaimDetails.Rows[iRowIndex]["Comment"] = txtClaimComment.Text.ToUpper();
}
}
//Store in Session
oSalesStatementReconciled.DtClaimDetails = dtClaimDetails;
Session[Constants.SES_SALES_CLAIM_RECON] = oSalesStatementReconciled;
gvClaim.DataSource = dtClaimDetails;
gvClaim.DataBind();
//Set Values
SetClaimSatementDetailSectionValue(dtClaimDetails);
ClearSalesClaimSection();
txtReferenceNo.Focus();
}
