protected void btnUpdate_Click(object sender, EventArgs e)
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
try
{
DataView dv = oInterestReimbursement.DtIntePaymentDetails.DefaultView;
dv.RowFilter = "IntPaymentTransNo='" + txtIntTransNo.Text + "' AND InterestClaimTransNo='" + txtIntClaimTransNo.Text + "'";
if (dv.Count > 0)
{
dv[0]["ReconAmount"] = Convert.ToDecimal(txtReconAmount.Text).ToString("N2");
dv.RowFilter = null;
}
oInterestReimbursement.DtIntePaymentDetails.AcceptChanges();
Populate_PaymentDetails(txtCRefNo.Text);
Calculate_PaymentDetails(oInterestReimbursement, txtCRefNo.Text);
DataView dv1 = oInterestReimbursement.DtInteClaimReimbursement.DefaultView;
dv1.RowFilter = "ClaimRefNo='" + txtCRefNo.Text + "'";
if (dv1.Count > 0)
{
object obj = oInterestReimbursement.DtIntePaymentDetails.Compute("SUM(ReconAmount)", "ClaimRefNo='" + txtCRefNo.Text + "'");
dv1[0]["ReconAmount"] = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
dv1.RowFilter = null;
}
Calculate_ClaimDetails(oInterestReimbursement);
oInterestReimbursement.DtIntePaymentDetails.AcceptChanges();
ClearInterestPaymentDetailSection();
}
catch (Exception ex)
{
ucMessage.OpenMessage(ex.Message, Constants.MSG_TYPE_ERROR);
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBBReferenceNo.Text))
{
InterestReimbursement oIntReim = Session[Constants.SES_INTE_RECON] as InterestReimbursement;
InterestReimbursementDAL oInterestReimbursementDAL = new InterestReimbursementDAL();
//get User Details
oIntReim.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oInterestReimbursementDAL.Approve(oIntReim);
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
{
ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oInterestReimbursement != null)
{
oInterestReimbursement.InterestReimburseTransNo = hdnInterestReimburseTransNo.Value.Equals("") ? "-1" : hdnInterestReimburseTransNo.Value;
oInterestReimbursement.InterestReimburseReferenceNo = txtBBReferenceNo.Text.Trim().ToUpper();
oInterestReimbursement.SPType.SPTypeID = ddlSpType.SelectedValue;
oInterestReimbursement.ReimburseDate = DateTime.Now;
oInterestReimbursement.Currency.CurrencyID = ddlReconCurrency.SelectedValue;
oInterestReimbursement.ConvRate = Util.GetDecimalNumber(txtReimConvRate.Text);
oInterestReimbursement.ConvRateToBC = Util.GetDecimalNumber(txtCovRateToBC.Text);
oInterestReimbursement.ClaimAmount = Util.GetDecimalNumber(txtTotInterest.Text);
oInterestReimbursement.ReconAmount = Util.GetDecimalNumber(txtTotRecInt.Text);
oInterestReimbursement.Remuneration = Util.GetDecimalNumber(txtTotRemuneration.Text);
oInterestReimbursement.BBAmount = Util.GetDecimalNumber(txtBBAmount.Text);
decimal dIR = 0;
decimal dDR = 0;
object obj = oInterestReimbursement.DtInteClaimReimbursement.Compute("SUM(ReconAmount)", "");
dIR = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj) : 0;
obj = 0;
obj = oInterestReimbursement.DtIntePaymentDetails.Compute("SUM(ReconAmount)", "");
dDR = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj) : 0;
if (dIR != dDR)
{
ucMessage.OpenMessage("Claim recon details and payment recon details mismatched. May have manual journal. Please check..", Constants.MSG_TYPE_ERROR);
return;
}
oInterestReimbursement.UserDetails = ucUserDet.UserDetail;
InterestReimbursementDAL oInterestReimbursementDAL = new InterestReimbursementDAL();
Result oResult = oInterestReimbursementDAL.Save(oInterestReimbursement);
if (oResult.Status)
{
LoadPreviousList();
TotalClear();
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 gvIntClaimDetail_RowCommand(object sender, GridViewCommandEventArgs e)
{
//get the row
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
//gvRow.BackColor = Color.Blue;
if (((Button)e.CommandSource).Text.Equals("Select"))
{
//SetInterestClaimDetails(gvRow);
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
DataView dv = new DataView();
dv.Table = oInterestReimbursement.DtIntePaymentDetails;
dv.RowFilter = "ClaimRefNo='" + gvRow.Cells[2].Text.Trim() + "'";
txtRegNo.Text = dv[gvRow.RowIndex]["RegNo"].ToString();
txtPaymentDate.Text = dv[gvRow.RowIndex]["PaymentDate"].ToString();
txtClaimAmount.Text = dv[gvRow.RowIndex]["ClaimAmount"].ToString();
txtReconAmount.Text = dv[gvRow.RowIndex]["ReconAmount"].ToString();
txtIntClaimTransNo.Text = dv[gvRow.RowIndex]["InterestClaimTransNo"].ToString();
txtIntTransNo.Text = dv[gvRow.RowIndex]["IntPaymentTransNo"].ToString();
txtCRefNo.Text = dv[gvRow.RowIndex]["ClaimRefNo"].ToString();
txtReconAmount.Focus();
dv.RowFilter = null;
//btnAdd.Focus();
}
else if (((Button)e.CommandSource).Text.Equals("Remove"))
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oInterestReimbursement != null)
{
//Delete Interest Payment Details
Delete_PaymentDetails(gvRow.Cells[2].Text, gvRow.Cells[3].Text, oInterestReimbursement);
Populate_PaymentDetails(gvRow.Cells[2].Text);
DataView dv1 = oInterestReimbursement.DtInteClaimReimbursement.DefaultView;
dv1.RowFilter = "ClaimRefNo='" + gvRow.Cells[2].Text + "'";
if (dv1.Count > 0)
{
object obj = oInterestReimbursement.DtIntePaymentDetails.Compute("SUM(ReconAmount)", "ClaimRefNo='" + gvRow.Cells[2].Text + "'");
dv1[0]["ReconAmount"] = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
dv1.RowFilter = null;
}
//Store in Session
Session[Constants.SES_INTE_RECON] = oInterestReimbursement;
Calculate_ClaimDetails(oInterestReimbursement);
ClearInterestPaymentDetailSection();
}
txtClaimRefNo.Focus();
}
}
private void SetObject(InterestReimbursement oInterestReimbursement)
{
Session[Constants.SES_INTE_RECON] = oInterestReimbursement;
if (oInterestReimbursement != null)
{
ddlSpType.Text = oInterestReimbursement.SPType.SPTypeID;
ddlYear.Text = oInterestReimbursement.ReimburseDate.Year.ToString();
txtBBReferenceNo.Text = oInterestReimbursement.InterestReimburseReferenceNo;
LoadCurrencyBySPType(oInterestReimbursement.SPType.SPTypeID);
ddlReconCurrency.Text = oInterestReimbursement.Currency.CurrencyID;
txtReimConvRate.Text = Convert.ToString(oInterestReimbursement.ConvRate);
txtCovRateToBC.Text = Convert.ToString(oInterestReimbursement.ConvRateToBC);
txtBBAmount.Text = Convert.ToString(oInterestReimbursement.BBAmount);
//Set user details
if (SEARCH_FROM.Equals(1))//if viewed from Temp By Maker
{
ucUserDet.UserDetail = oInterestReimbursement.UserDetails;
}
else if (SEARCH_FROM.Equals(2))//if viewed from Temp By Checker
{
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.MakeDate = oInterestReimbursement.UserDetails.MakeDate;
oUserDetails.MakerID = oInterestReimbursement.UserDetails.MakerID;
ucUserDet.UserDetail = oUserDetails;
}
gvClaim.DataSource = oInterestReimbursement.DtInteClaimReimbursement;
gvClaim.DataBind();
//txtTotRecInt.Text = Convert.ToString(oInterestReimbursement.ClaimAmount);
//txtTotRecRem.Text = Convert.ToString(oInterestReimbursement.Remuneration);
////From InterestClaim
//object obj = oInterestReimbursement.DtInteClaimReimbursement.Compute("SUM(Interest)", "");
//txtTotInterest.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0";
////From InterestClaim
//obj = oInterestReimbursement.DtInteClaimReimbursement.Compute("SUM(Remuneration)", "");
//txtTotRemuneration.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0";
Calculate_ClaimDetails(oInterestReimbursement);
//txtTotVariation.Text = (Util.GetDecimalNumber(txtTotInterest.Text) - oInterestReimbursement.InterestAmount).ToString();
hdnInterestReimburseTransNo.Value = oInterestReimbursement.InterestReimburseTransNo;
//Set a background color as Selected
//gvClaim.Rows[0].BackColor = Color.Blue;
//SetClaimSatementDetailSectionValue(oSalesStatementReconciled.DtClaimDetails);
if (gvClaim.Rows.Count > 0)
{
PopulateInterestPaymentDetailsGrid(gvClaim.Rows[0]);
}
}
}
private void Delete_PaymentDetails(string sClaimRefNo, string sRegNo, InterestReimbursement oIR)
{
DataView dv = oIR.DtIntePaymentDetails.DefaultView;
dv.RowFilter = "ClaimRefNo='" + sClaimRefNo.Trim() + "' And RegNo='" + sRegNo.Trim() + "'";
for (int i = 0; i < dv.Count; i++)
{
dv.Delete(0);
}
oIR.DtIntePaymentDetails.AcceptChanges();
dv.RowFilter = null;
}
private void Calculate_PaymentDetails(InterestReimbursement oIR, string sClaimRefNo)
{
//Set Values
//NoOfInterestPay
object obj = oIR.DtIntePaymentDetails.Compute("COUNT(ClaimRefNo)", "ClaimRefNo='" + sClaimRefNo + "'");
txtNoOfInterestPay.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//Total Interest
obj = oIR.DtIntePaymentDetails.Compute("SUM(ClaimAmount)", "ClaimRefNo='" + sClaimRefNo + "'");
txtTotalClaimAmount.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//Total Recon Interest
obj = oIR.DtIntePaymentDetails.Compute("SUM(ReconAmount)", "ClaimRefNo='" + sClaimRefNo + "'");
txtTotalReconAmount.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//variation
txtTotalVariation.Text = (Util.GetDecimalNumber(txtTotalClaimAmount.Text) - Util.GetDecimalNumber(txtTotalReconAmount.Text)).ToString();
}
protected void gvClaim_RowCommand(object sender, GridViewCommandEventArgs e)
{
//get the row
GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer;
//gvRow.BackColor = Color.Blue;
if (((Button)e.CommandSource).Text.Equals("Select"))
{
//SetInterestClaimDetails(gvRow);
PopulateInterestPaymentDetailsGrid(gvRow);
//btnAdd.Focus();
}
else if (((Button)e.CommandSource).Text.Equals("Remove"))
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oInterestReimbursement != null)
{
oInterestReimbursement.DtInteClaimReimbursement.Rows.RemoveAt(gvRow.RowIndex);
oInterestReimbursement.DtInteClaimReimbursement.AcceptChanges();
gvClaim.DataSource = oInterestReimbursement.DtInteClaimReimbursement;
gvClaim.DataBind();
//Delete Interest Payment Details
Delete_PaymentDetails(gvRow.Cells[2].Text, oInterestReimbursement);
gvIntClaimDetail.DataSource = null;
//Store in Session
Session[Constants.SES_INTE_RECON] = oInterestReimbursement;
if (gvRow.Cells[2].Text.Equals(txtClaimRefNo.Text.Trim()))
{
ClearInterestClaimSection();
}
Calculate_ClaimDetails(oInterestReimbursement);
ClearInterestPaymentDetail();
}
txtClaimRefNo.Focus();
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtBBReferenceNo.Text))
{
InterestReimbursement oIntReim = new InterestReimbursement();
oIntReim.InterestReimburseReferenceNo = txtBBReferenceNo.Text;
InterestReimbursementDAL oIntReimDAL = new InterestReimbursementDAL();
oIntReim.UserDetails = ucUserDet.UserDetail;
Result oResult = (Result)oIntReimDAL.Reject(oIntReim);
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);
}
}
private void Calculate_ClaimDetails(InterestReimbursement oIR)
{
if (oIR == null)
{
return;
}
//Set Values
//Total Interest
object obj = oIR.DtIntePaymentDetails.Compute("SUM(ClaimAmount)", "");
txtTotInterest.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//Total Recon Interest
obj = oIR.DtIntePaymentDetails.Compute("SUM(ReconAmount)", "");
txtTotRecInt.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//Total Remunaration
obj = oIR.DtInteClaimReimbursement.Compute("SUM(Remuneration)", "");
txtTotRemuneration.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//Total Recon Remunaration
//obj = oInterestReimbursement.DtInteClaimReimbursement.Compute("SUM(ReconRemuneration)", "");
txtTotRecRem.Text = !DBNull.Value.Equals(obj) ? Convert.ToDecimal(obj).ToString() : "0.00";
//variation
txtTotVariation.Text = (Util.GetDecimalNumber(txtTotInterest.Text) - Util.GetDecimalNumber(txtTotRecInt.Text)).ToString();
txtBBVariation.Text = (Util.GetDecimalNumber(txtBBAmount.Text) - Util.GetDecimalNumber(txtTotRecInt.Text)).ToString();
}
private void Populate_PaymentDetails(string sClaimRefNo)
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oInterestReimbursement == null)
{
oInterestReimbursement = new InterestReimbursement();
}
DataTable dtPaymentDetails = oInterestReimbursement.DtIntePaymentDetails;
if (dtPaymentDetails.Columns.Count <= 0)
{
dtPaymentDetails.Columns.Add(new DataColumn("ClaimRefNo", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("RegNo", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("PaymentDate", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("ClaimAmount", typeof(decimal)));
dtPaymentDetails.Columns.Add(new DataColumn("ReconAmount", typeof(decimal)));
//saving in DB purpose. This is hidden in design
dtPaymentDetails.Columns.Add(new DataColumn("InterestClaimTransNo", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("IntPaymentTransNo", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("Narration", typeof(string)));
dtPaymentDetails.Columns.Add(new DataColumn("AccountNo", typeof(string)));
dtPaymentDetails.TableName = "IntPaymentDetails";
}
DataRow[] rows = dtPaymentDetails.Select("ClaimRefNo='" + sClaimRefNo + "'");
if (rows.Length <= 0)
{
InterestReimbursementDAL oInterestReimbursementDAL = new InterestReimbursementDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
Result oResult = oInterestReimbursementDAL.GetIntePaymentDetailsByClaimTransNo(sClaimRefNo, oConfig.DivisionID, oConfig.BankCodeID);
DataTable dtTmpPayDetail = null;
if (oResult.Status)
{
dtTmpPayDetail = oResult.Return as DataTable;
}
for (int i = 0; i < dtTmpPayDetail.Rows.Count; i++)
{
DataRow r = dtPaymentDetails.NewRow();
r["ClaimRefNo"] = dtTmpPayDetail.Rows[i]["ClaimRefNo"];
r["RegNo"] = dtTmpPayDetail.Rows[i]["RegNo"];
r["PaymentDate"] = Convert.ToDateTime(dtTmpPayDetail.Rows[i]["PaymentDate"]).ToString("dd-MMM-yyyy");
r["ClaimAmount"] = dtTmpPayDetail.Rows[i]["ClaimAmount"];
r["ReconAmount"] = dtTmpPayDetail.Rows[i]["ReconAmount"];
r["InterestClaimTransNo"] = dtTmpPayDetail.Rows[i]["InterestClaimTransNo"];
r["IntPaymentTransNo"] = dtTmpPayDetail.Rows[i]["IntPaymentTransNo"];
r["Narration"] = dtTmpPayDetail.Rows[i]["Narration"];
r["AccountNo"] = dtTmpPayDetail.Rows[i]["AccountNo"];
dtPaymentDetails.Rows.Add(r);
}
}
DataView dv = new DataView();
dv.Table = dtPaymentDetails;
dv.RowFilter = "ClaimRefNo='" + sClaimRefNo + "'";
gvIntClaimDetail.DataSource = dv;
gvIntClaimDetail.DataBind();
Calculate_PaymentDetails(oInterestReimbursement, sClaimRefNo);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oInterestReimbursement == null)
{
oInterestReimbursement = new InterestReimbursement();
}
DataTable dtClaimDetails = oInterestReimbursement.DtInteClaimReimbursement;
if (dtClaimDetails.Columns.Count <= 0)
{
dtClaimDetails.Columns.Add(new DataColumn("ClaimRefNo", typeof(string)));
dtClaimDetails.Columns.Add(new DataColumn("ClaimDate", 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("IncomeTax", typeof(decimal)));
dtClaimDetails.Columns.Add(new DataColumn("ReconAmount", typeof(decimal)));
dtClaimDetails.Columns.Add(new DataColumn("Remuneration", typeof(decimal)));
//dtClaimDetails.Columns.Add(new DataColumn("ReconIncomeTax", typeof(decimal)));
//dtClaimDetails.Columns.Add(new DataColumn("ReconRemuneration", typeof(decimal)));
//dtClaimDetails.Columns.Add(new DataColumn("Comment", typeof(string)));
//saving in DB purpose. This is hidden in design
dtClaimDetails.Columns.Add(new DataColumn("InterestClaimTransNo", typeof(string)));
}
DataRow[] rows = dtClaimDetails.Select("ClaimRefNo='" + txtClaimRefNo.Text + "'");
if (rows.Length <= 0)
{
DataRow rowClaimDetails = dtClaimDetails.NewRow();
rowClaimDetails["ClaimRefNo"] = txtClaimRefNo.Text;
DateTime parsedDate;
DateTime.TryParseExact(txtClaimDate.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimDate.Text);
rowClaimDetails["ClaimDate"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimDate.Text;
DateTime.TryParseExact(txtClaimDateFrom.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimDateFrom.Text);
rowClaimDetails["ClaimDateFrom"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimDateFrom.Text;
DateTime.TryParseExact(txtClaimDateTo.Text, Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
//parsedDate = Convert.ToDateTime(txtClaimDateTo.Text);
rowClaimDetails["ClaimDateTo"] = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy);//txtClaimDateTo.Text;
rowClaimDetails["ClaimAmount"] = txtInterest.Text;
rowClaimDetails["ReconAmount"] = txtInterest.Text;
rowClaimDetails["Remuneration"] = txtRemuneration.Text;
rowClaimDetails["InterestClaimTransNo"] = hdnInterestClaimTransNo.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]["ReconInterest"] = txtReconInterest.Text;
//dtClaimDetails.Rows[iRowIndex]["ReconRemuneration"] = txtReconRemuneration.Text;
//dtClaimDetails.Rows[iRowIndex]["Comment"] = txtComment.Text.ToUpper();
}
}
//Store in Session
oInterestReimbursement.DtInteClaimReimbursement = dtClaimDetails;
Session[Constants.SES_INTE_RECON] = oInterestReimbursement;
gvClaim.DataSource = dtClaimDetails;
gvClaim.DataBind();
Populate_PaymentDetails(txtClaimRefNo.Text);
Calculate_ClaimDetails(oInterestReimbursement);
ClearInterestClaimSection();
txtClaimRefNo.Focus();
}
protected void txtClaimRefNo_TextChanged(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
bool isRefNoFrmtOk = false;
string sRefNo = txtClaimRefNo.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;
txtClaimRefNo.Text = sRefNo;
isRefNoFrmtOk = true;
}
if (isRefNoFrmtOk)
{
int iIndx = -1;
InterestReimbursement oIntReim = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
if (oIntReim != null)
{
DataTable dtClaimDetails = oIntReim.DtInteClaimReimbursement;
DataRow[] rows = dtClaimDetails.Select("ClaimRefNo='" + txtClaimRefNo.Text + "'");
foreach (var vClaimDtl in rows)
{
iIndx = dtClaimDetails.Rows.IndexOf(vClaimDtl);
if ((gvClaim.Rows.Count > iIndx))
{
GridViewRow gvRow = gvClaim.Rows[iIndx];
SetInterestClaimDetails(gvRow);
}
break;
}
}
if (iIndx.Equals(-1))
{
InterestReimbursementDAL oInterestReimbursementDAL = new InterestReimbursementDAL();
Result oResult = oInterestReimbursementDAL.GetInteClaimStatementByClaimRefNo(txtClaimRefNo.Text.Trim(), oConfig.DivisionID, oConfig.BankCodeID);
if (oResult.Status)
{
DataTable dtIntersetClaim = oResult.Return as DataTable;
if (dtIntersetClaim.Rows.Count > 0)
{
DDListUtil.Assign(ddlSpType, DB.GetDBValue(dtIntersetClaim.Rows[0]["SPTypeID"]));
txtClaimDate.Text = (Date.GetDateTimeByString(dtIntersetClaim.Rows[0]["StatementDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimDateFrom.Text = (Date.GetDateTimeByString(dtIntersetClaim.Rows[0]["FromDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimDateTo.Text = (Date.GetDateTimeByString(dtIntersetClaim.Rows[0]["ToDate"].ToString())).ToString(Constants.DATETIME_FORMAT);
txtClaimCurrncy.Text = DB.GetDBValue(dtIntersetClaim.Rows[0]["CurrencyCode"]);
txtClaimCurrncy.Attributes["CurrencyID"] = DB.GetDBValue(dtIntersetClaim.Rows[0]["CurrencyID"]);
txtConvRate.Text = DB.GetDBValue(dtIntersetClaim.Rows[0]["ConvRate"]);
txtReimConvRate.Text = "1.0000";
txtCovRateToBC.Text = "1.0000";
txtInterest.Text = DB.GetDBValue(dtIntersetClaim.Rows[0]["InterestAmount"]);
txtRemuneration.Text = DB.GetDBValue(dtIntersetClaim.Rows[0]["Remuneration"]);
hdnInterestClaimTransNo.Value = DB.GetDBValue(dtIntersetClaim.Rows[0]["InterestClaimTransNo"]);
}
else
{
ucMessage.OpenMessage("Invalid reference number !!", Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearInterestClaimSection();
}
}
else
{
ucMessage.OpenMessage(oResult.Message, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
ClearInterestClaimSection();
}
}
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);
ClearInterestClaimSection();
}
}
protected void txtBBAmount_TextChanged(object sender, EventArgs e)
{
InterestReimbursement oInterestReimbursement = (InterestReimbursement)Session[Constants.SES_INTE_RECON];
Calculate_ClaimDetails(oInterestReimbursement);
}
