public void ClaimSearchLoadAction(DataRow dtRow) { if (dtRow != null) { string sCommClaimTransNo = Convert.ToString(dtRow["CommissionClaimTransNo"]); hdnClaimTransNo.Value = sCommClaimTransNo; txtReferenceNo.Text = Convert.ToString(dtRow["Reference No"]); DateTime parsedDate; DateTime.TryParseExact(Convert.ToString(dtRow["Date"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); txtStatementDate.Text = parsedDate.ToString(Constants.DATETIME_FORMAT); DateTime.TryParseExact(Convert.ToString(dtRow["FromDate"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); txtDateFrom.Text = parsedDate.ToString(Constants.DATETIME_FORMAT); ddlYear.Text = Util.GetDateTimeByString(txtStatementDate.Text).Year.ToString(); ddlSpType.Text = Convert.ToString(dtRow["SP Type"]); ddlDuration.Text = Convert.ToString(dtRow["DurationType"]); string sSPCurrency = ViewState[_SPTYPE_CUREENCY] as string; ClaimDAL claimDAL = null; if (string.IsNullOrEmpty(sSPCurrency)) { claimDAL = new ClaimDAL(); ViewState[_SPTYPE_CUREENCY] = claimDAL.GetSPCurrency(ddlSpType.SelectedValue); } txtConversionRate.Text = Convert.ToString(dtRow["ConvRate"]); DateTime.TryParseExact(Convert.ToString(dtRow["ToDate"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); string sToDate = parsedDate.ToString(Constants.DATETIME_dd_MMM_yyyy); DataTable dtTempTodate = new DataTable(); dtTempTodate.Columns.Add(new DataColumn("ValueMember", typeof(string))); dtTempTodate.Columns.Add(new DataColumn("DisplayMember", typeof(string))); DataRow drTempDataRow = dtTempTodate.NewRow(); drTempDataRow[0] = 0; drTempDataRow[1] = string.Empty; dtTempTodate.Rows.Add(drTempDataRow); drTempDataRow = dtTempTodate.NewRow(); drTempDataRow[0] = sToDate; drTempDataRow[1] = sToDate; dtTempTodate.Rows.Add(drTempDataRow); dtTempTodate.AcceptChanges(); ddlDateTo.DataSource = dtTempTodate; ddlDateTo.DataTextField = "DisplayMember"; ddlDateTo.DataValueField = "ValueMember"; ddlDateTo.DataBind(); ddlDateTo.Text = sToDate; BindCurrency(claimDAL); string sCurrencyID = Convert.ToString(dtRow["CurrencyID"]); ddlConversionCurrency.Text = sCurrencyID; FillReferenceDetailGrid(sCommClaimTransNo); EnableDisableControls(false); } }
public void ClaimSearchLoadAction(DataRow dtRow) { if (dtRow != null) { string sInterestClaimTransNo = Convert.ToString(dtRow["InterestClaimTransNo"]); hdnClaimTransNo.Value = sInterestClaimTransNo; txtReferenceNo.Text = Convert.ToString(dtRow["Reference No"]); DateTime parsedDate; DateTime.TryParseExact(Convert.ToString(dtRow["Statement Date"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); txtClaimDate.Text = parsedDate.ToString(Constants.DATETIME_FORMAT); DateTime.TryParseExact(Convert.ToString(dtRow["From Date"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); txtPaymentDateFrom.Text = parsedDate.ToString(Constants.DATETIME_FORMAT); DateTime.TryParseExact(Convert.ToString(dtRow["To Date"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate); txtPaymentDateTo.Text = parsedDate.ToString(Constants.DATETIME_FORMAT); ddlYear.Text = Util.GetDateTimeByString(txtClaimDate.Text).Year.ToString(); ddlSpType.Text = Convert.ToString(dtRow["SP Type"]); string sSPCurrency = ViewState[_SPTYPE_CUREENCY] as string; //if (string.IsNullOrEmpty(sSPCurrency)) { ClaimDAL claimDAL = new ClaimDAL(); ViewState[_SPTYPE_CUREENCY] = claimDAL.GetSPCurrency(ddlSpType.SelectedValue); } FillIntPaymentDetailGrid(sInterestClaimTransNo); //DDListUtil.Assign(ddlConversionCurrency, Convert.ToString(dtRow["Currency ID"])); //txtConversionRate.Text = Convert.ToString(dtRow["Conversion Rate"]); txtTotalLevi1.Text = Convert.ToString(dtRow["Levi"]); txtTotalIncomeTax1.Text = Convert.ToString(dtRow["Income Tax"]); txtTotalInterest1.Text = Convert.ToString(dtRow["Interest Amount"]); txtRemuneration.Text = "0.00"; // Format(vDataRow(cOInterestReimbursementClaim.cOproperties.Remuneration), "0.00") //temporary txtTotalIncomeTax2.Text = CalculateConvertedAmount(Util.GetDecimalNumber(txtTotalIncomeTax1.Text), Util.GetDecimalNumber(txtConversionRate.Text)).ToString("0.00"); //Mid(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalIncomeTax.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000"), 1, Len(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalIncomeTax.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000")) - 2) //temporary txtTotalLevi2.Text = "0.00"; //;Mid(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalLevi.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000"), 1, Len(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalLevi.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000")) - 2) txtTotalInterest2.Text = CalculateConvertedAmount(Util.GetDecimalNumber(txtTotalInterest1.Text), Util.GetDecimalNumber(txtConversionRate.Text)).ToString("0.00"); //Mid(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalInterest.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000"), 1, Len(Format(Me.CalculateConvertedAmount(Val(Me.txtTotalInterest.Text.Trim), Val(Me.txtConversionRate.Text.Trim)), "0.0000")) - 2) //'Code Added By Jahid //'Me.txtTotalInterest.Text = Format(CDbl(Me.txtTotalInterest.Text), "0.00") ' - CDbl(Me.txtTotalLevi.Text) - CDbl(Me.txtTotalIncomeTax.Text) //'Me.txtTotalConvertedInterest.Text = Format(CDbl(Me.txtTotalConvertedInterest.Text), "0.00") ' - CDbl(Me.txtTotalConvertedLevi.Text) - CDbl(Me.txtTotalConvertedIncomeTax.Text) //strToDate = Format(CDate(vDataRow(cOInterestReimbursementClaim.cOproperties.ToDate)), modCommon.DateFormat) //Me.btnSelectAll.Enabled = False //Me.btnDeselectAll.Enabled = False EnableDisableControls(false); } }
private void LoadSPTypeData() { //Clear Grid value gvData.DataSource = null; gvData.DataBind(); if (!string.IsNullOrEmpty(ddlSpType.SelectedValue)) { if (ddlSpType.SelectedValue.Equals("3MS") || ddlSpType.SelectedValue.Equals("BSP") || ddlSpType.SelectedValue.Equals("DIB") || ddlSpType.SelectedValue.Equals("DPB") || ddlSpType.SelectedValue.Equals("FSP") || ddlSpType.SelectedValue.Equals("PSC") || ddlSpType.SelectedValue.Equals("WDB") ) { ClaimDAL cDal = new ClaimDAL(); Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; Result oResult = (Result)cDal.GetCommissionFromDate(ddlSpType.SelectedValue, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { string sDate = (string)oResult.Return; if (sDate != null) { txtDateFrom.Text = sDate; } } if (txtDateFrom.Text != string.Empty) { SetToDate(); ddlDateTo.Enabled = true; ddlDuration.Enabled = true; ddlDuration.Text = Convert.ToString((int)SBM_BLV1.baseCommon.enmDurationType.Date_Range); BindCurrency(cDal); ddlConversionCurrency.Enabled = true; ViewState[_SPTYPE_CUREENCY] = cDal.GetSPCurrency(ddlSpType.SelectedValue); } /*If Me.txtFromDate.Text.Trim <> "" Then * Me.SetToDate() 'Fill ToDate Combo * Me.cboDuration.SelectedValue = CStr(modCommon.enmDurationType.Date_Range) * Me.ControlOperation(True) * strCurrecncyCriteria = " INNER JOIN ([SELECT top 1 PolicyID,max(PolicyEffectDate) from SPMS_SPPolicy WHERE SPTypeID='" & Me.cboSPType.SelectedValue & "' group by PolicyID order by max(PolicyEffectDate) DESC ]. AS b INNER JOIN SPMS_SPCurrencyPolicy ON b.PolicyID = SPMS_SPCurrencyPolicy.PolicyID) ON a.CurrencyID = SPMS_SPCurrencyPolicy.CurrencyID" * strCurrecncyCriteria &= " WHERE (((SPMS_SPCurrencyPolicy.ActivityType)=" & modCommon.enmActivityType.Commission_Claim & "))" * Me.cboCurrencyID.DataSource = cOCommon.GetCurrencySource(strCurrecncyCriteria) */ //FillReferenceDetailGrid(""); //ddlDuration.Enabled = true; } else { ddlDuration.Enabled = false; ddlDateTo.Enabled = false; } } else { ddlDuration.Enabled = false; ddlDateTo.Enabled = false; } }
private void FillIntPaymentDetailGrid(string sInterestClaimTransNo) { InterestClaimDAL intClaimDAL = new InterestClaimDAL(); ClaimDAL claimDAL = new ClaimDAL(); Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; /////Currency Update string sCurrecncyCriteria = " INNER JOIN (SELECT TOP (1) PolicyID, MAX(PolicyEffectDate) AS PolicyEffectDate FROM SPMS_SPPolicy WHERE (SPTypeID = '" + ddlSpType.SelectedValue + "') GROUP BY PolicyID ORDER BY PolicyEffectDate DESC) AS b INNER JOIN SPMS_SPCurrencyPolicy ON b.PolicyID = SPMS_SPCurrencyPolicy.PolicyID ON a.CurrencyID = SPMS_SPCurrencyPolicy.CurrencyID "; sCurrecncyCriteria += " WHERE (SPMS_SPCurrencyPolicy.ActivityType = " + (int)Constants.ACTIVITY_TYPE.INTEREST_CLAIM + ")"; DataTable dtCurrencySource = claimDAL.GetCurrencySource(sCurrecncyCriteria); if (dtCurrencySource != null) { ddlConversionCurrency.DataSource = dtCurrencySource; ddlConversionCurrency.DataTextField = "DisplayMember"; ddlConversionCurrency.DataValueField = "ValueMember"; ddlConversionCurrency.DataBind(); ddlConversionCurrency.Enabled = false; } string sSPCurrency = ViewState[_SPTYPE_CUREENCY] as string; if (string.IsNullOrEmpty(sSPCurrency)) { sSPCurrency = claimDAL.GetSPCurrency(ddlSpType.SelectedValue); } ViewState[_SPTYPE_CUREENCY] = sSPCurrency;//claimDAL.GetSPCurrency(ddlSpType.SelectedValue); LoadCurrencyData(); //// string reportType = ""; reportType = ddlReportCategory.SelectedValue; Result oResult = intClaimDAL.GetInterestClaimData(ddlSpType.SelectedValue, Util.GetDateTimeByString(txtPaymentDateFrom.Text), Util.GetDateTimeByString(txtPaymentDateTo.Text), reportType, sInterestClaimTransNo, oConfig.DivisionID, oConfig.BankCodeID); if (oResult.Status) { DataTable dtIntClaim = oResult.Return as DataTable; if (dtIntClaim != null && dtIntClaim.Rows.Count > 0) { hdnGridTotal.Value = dtIntClaim.Rows.Count.ToString(); dtIntClaim.Columns.Remove("CurrencyID"); dtIntClaim.Columns.Remove("InterestRate"); dtIntClaim.Columns.Remove("PaidInterestA"); dtIntClaim.Columns.Remove("IncomeTaxA"); dtIntClaim.Columns.Remove("PaymentAmountA"); gvData.DataSource = dtIntClaim; gvData.DataBind(); DDListUtil.Assign(ddlConversionCurrency, Convert.ToString(dtIntClaim.Rows[0]["PCurrencyID"])); if (ddlConversionCurrency.SelectedIndex.Equals(0)) { ucMessage.OpenMessage("Please assign currency in Policy Setup for Interest Claim.", Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); } txtConversionRate.Text = Convert.ToString(dtIntClaim.Rows[0]["PConvRate"]); txtConversionRate.Enabled = false; if (!string.IsNullOrEmpty(sInterestClaimTransNo)) { foreach (GridViewRow gvr in gvData.Rows) { CheckBox chk = (CheckBox)gvr.FindControl("chkSelected"); if (chk != null) { chk.Checked = true; chk.Enabled = false; } } txtSelectCount.Text = "TOTAL SELECTED " + dtIntClaim.Rows.Count + " OF " + dtIntClaim.Rows.Count; } else { txtSelectCount.Text = "TOTAL SELECTED 0 OF " + dtIntClaim.Rows.Count; } } } }