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);
}
}
public void BindCurrency(ClaimDAL cDal)
{
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.COMMISSION_CLAIM + ")";
if (cDal == null)
{
cDal = new ClaimDAL();
}
ddlConversionCurrency.DataSource = cDal.GetCurrencySource(sCurrecncyCriteria) as DataTable;
ddlConversionCurrency.DataTextField = "DisplayMember";
ddlConversionCurrency.DataValueField = "ValueMember";
ddlConversionCurrency.DataBind();
}
public IList <ClaimViewModel> GetUserClaims(UserViewModel user)
{
try
{
ClaimDAL claimDAL = new ClaimDAL();
IList <ClaimBE> entities;
var uservm = Mapper.Map <UserViewModel, UserBE>(user);
entities = claimDAL.GetUserClaims(uservm);
return(Mapper.Map <ClaimBE, ClaimViewModel>(entities));
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadSPTypeData()
{
Result oResult = new Result();
if (!string.IsNullOrEmpty(ddlSpType.SelectedValue))
{
try
{
ClaimDAL cDAL = new ClaimDAL();
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
oResult = (Result)cDAL.GetSalesStatementFromDate(ddlSpType.SelectedValue, oConfig.DivisionID, oConfig.BankCodeID);
if (oResult.Status)
{
txtDateFrom.Text = oResult.Return.ToString();
SetToDate(Util.GetDateTimeByString(txtDateFrom.Text));
ddlDuration.Enabled = true;
ddlDuration.SelectedIndex = 0;
}
else
{
ddlDuration.SelectedIndex = 0;
ddlDateTo.Items.Clear();
}
}
catch (Exception exp)
{
}
}
else
{
txtDateFrom.Text = string.Empty;
ddlDuration.SelectedIndex = 0;
ddlDateTo.Items.Clear();
//Me.ControlOperation(False)
}
gvData.DataSource = null;
gvData.DataBind();
txtTotalFaceValue.Text = string.Empty;
}
public void LoadCurrencyData()
{
if (ddlConversionCurrency.SelectedIndex > 0)
{
double dblTemp = -1;
ClaimDAL claimDAL = new ClaimDAL();
Result oResultData = claimDAL.GetConversionRate(ddlConversionCurrency.SelectedValue, ddlSpType.SelectedValue);
if (oResultData.Status)
{
dblTemp = (double)oResultData.Return;
if (dblTemp == 0.0)
{
txtConversionRate.Text = "0.0000";
txtConversionRate.Enabled = true;
txtConversionRate.Focus();
txtTotalNonOrgCommission2.Text = "0.00";
txtTotalOrgCommission2.Text = "0.00";
txtTotalCommissionClaim.Text = "0.00";
}
else
{
txtConversionRate.Text = dblTemp.ToString("0.0000");
txtTotalNonOrgCommission2.Text = CalculateConvertedAmount(Util.GetDecimalNumber(txtTotalNonOrgCommission1.Text), Convert.ToDecimal(dblTemp)).ToString("N2");
txtTotalOrgCommission2.Text = CalculateConvertedAmount(Util.GetDecimalNumber(txtTotalOrgCommission1.Text), Convert.ToDecimal(dblTemp)).ToString("N2");
txtConversionRate.Enabled = false;
txtTotalCommissionClaim.Text = (Util.GetDecimalNumber(txtTotalNonOrgCommission2.Text) + Convert.ToDecimal(txtTotalOrgCommission2.Text)).ToString("N2");
}
}
}
else
{
txtConversionRate.Text = "0.0000";
txtConversionRate.Enabled = false;
txtTotalNonOrgCommission2.Text = "0.00";
txtTotalOrgCommission2.Text = "0.00";
txtTotalCommissionClaim.Text = "0.00";
}
}
private void InitializeData()
{
gvData.DataSource = null;
gvData.DataBind();
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
DDListUtil.LoadDDLFromXML(ddlDuration, "DateDuration", "Type", "Duration", false);
ddlDuration.Enabled = false;
txtStatementDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
// year
for (int i = 1995; i < DateTime.Now.Year + 1 + 1; i++)
{
DDListUtil.Add(ddlYear, i.ToString(), i.ToString());
}
txtDateFrom.ReadOnly = true;
DDListUtil.Assign(ddlYear, DateTime.Now.Year);
ClaimDAL claimDAL = new ClaimDAL();
//Store BASE_CURRENCY
ViewState[_BASE_CUREENCY] = claimDAL.GetBaseCurrencyID();
}
private void InitializeData()
{
gvData.DataSource = null;
gvData.DataBind();
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
// year
for (int i = 1995; i < DateTime.Now.Year + 1 + 1; i++)
{
DDListUtil.Add(ddlYear, i.ToString(), i.ToString());
}
ddlYear.Text = DateTime.Now.Year.ToString();
//Set ToDate
txtClaimDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtPaymentDateFrom.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtPaymentDateTo.Text = DateTime.Now.ToString("dd/MM/yyyy");
ClaimDAL claimDAL = new ClaimDAL();
//Store BASE_CURRENCY
ViewState[_BASE_CUREENCY] = claimDAL.GetBaseCurrencyID();
}
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;
}
}
public ClaimBLL()
{
Dal = new ClaimDAL();
}
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;
}
}
}
}
public void Delete()
{
ClaimDAL DAL = new ClaimDAL();
DAL.Delete(this.ID);
}
public void Save()
{
ClaimDAL DAL = new ClaimDAL();
DAL.Save(this);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
ClaimDAL oClaimDAL = new ClaimDAL();
Result oResult = oClaimDAL.SearchList(
this.txtRefNo.Text,
this.chkLastStatement.Checked,
this.ddlSPType.SelectedValue,
Util.GetDateTimeByString(Request[txtFromDate.UniqueID].Trim()),
Util.GetDateTimeByString(Request[txtToDate.UniqueID].Trim()),
this.Type,
this.chkStatemenDt.Checked, oConfig.DivisionID, oConfig.BankCodeID);
ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_Claim_lblProgress') ", true);
gvSearchList.DataSource = null;
gvSearchList.DataBind();
if (oResult.Status)
{
DataTable dtIssueList = (DataTable)oResult.Return;
DataTable dtSearchListTmp = dtIssueList.Clone();
dtSearchListTmp = dtIssueList.Copy();
if (this.Type.Equals(Constants.SEARCH_CLAIM.COMMISSION_CLAIM.ToString()))
{
dtSearchListTmp.Columns.Remove("CommissionClaimTransNo");
dtSearchListTmp.Columns.Remove("CurrencyID");
dtSearchListTmp.Columns.Remove("ConvRate");
dtSearchListTmp.Columns.Remove("DurationType");
}
else if (this.Type.Equals(Constants.SEARCH_CLAIM.ENCASHMENT_CLAIM.ToString()))
{
dtSearchListTmp.Columns.Remove("EncashmentClaimTransNo");
dtSearchListTmp.Columns.Remove("DurationType");
dtSearchListTmp.Columns.Remove("Levi");
//dtSearchListTmp.Columns.Remove("CurrencyID");
//dtSearchListTmp.Columns.Remove("ConvRate");
}
else if (this.Type.Equals(Constants.SEARCH_CLAIM.INTEREST_CLAIM.ToString()))
{
dtSearchListTmp.Columns.Remove("InterestClaimTransNo");
dtSearchListTmp.Columns.Remove("DurationType");
//dtSearchListTmp.Columns.Remove("CurrencyID");
dtSearchListTmp.Columns.Remove("Remuneration");
dtSearchListTmp.Columns.Remove("Levi");
}
else if (this.Type.Equals(Constants.SEARCH_CLAIM.SALESSTATEMENT_CLAIM.ToString()))
{
dtSearchListTmp.Columns.Remove("SaleStatementTransNo");
dtSearchListTmp.Columns.Remove("DurationType");
}
if (dtSearchListTmp != null && dtSearchListTmp.Rows.Count > 0)
{
gvSearchList.DataSource = dtSearchListTmp;
gvSearchList.DataBind();
}
Session[Constants.SES_CONFIG_APPROVE_DATA] = dtIssueList;
}
}
