private void LoadDataByID(string sUserID)
{
User oUser = new User(sUserID);
UserDAL oUserDAL = new UserDAL();
Result oResult = new Result();
oResult = oUserDAL.LoadByID(oUser);
if (oResult.Status)
{
oUser = (User)oResult.Return;
if (oUser != null)
{
txtLoginUserID.Text = oUser.UserName.ToString();
txtUserFirstName.Text = oUser.FirstName.ToString();
txtUserLastName.Text = oUser.LastName.ToString();
txtNewPassword.Attributes.Add("value", oUser.Password.ToString());
txtConfirmPassword.Attributes.Add("value", oUser.Password.ToString());
chkStatus.Checked = oUser.Status;
Util.ChkChangeSetColor(chkStatus);
DDListUtil.Assign(ddlDesignation, oUser.Designation.DesignationID.ToString());
DDListUtil.Assign(ddlUserClass, oUser.Group.GroupID.ToString());
DDListUtil.Assign(ddlDivision, oUser.DivisionID.Trim());
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oUser.UserDetails.MakerID;
userDetails.MakeDate = oUser.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckerID = oUser.UserDetails.CheckerID;
userDetails.CheckDate = oUser.UserDetails.CheckDate;
userDetails.CheckerComment = oUser.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdUserID.Value = oUser.UserID.ToString();
txtLoginUserID.ReadOnly = false;
}
else
{
ClearTextValue();
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
else
{
ClearTextValue();
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true);
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
EnableDisableControls(true);
foreach (ListItem item in chkListForBB.Items)
{
item.Enabled = true;
item.Selected = false;
}
txtTotalFaceValue.Text = "0.00";
if (ddlDuration.Items.Count > 0)
{
ddlDuration.SelectedIndex = 0;
}
if (ddlSpType.Items.Count > 0)
{
ddlSpType.SelectedIndex = 0;
}
txtReferenceNo.Text = "";
DDListUtil.Assign(ddlYear, DateTime.Now.Year);
txtStatementDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtDateFrom.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
ddlDateTo.Items.Clear();
gvData.DataSource = null;
gvData.DataBind();
}
private void MoveAction(string sType)
{
txtLoginUserID.ReadOnly = true;
UserDAL oUserDAL = new UserDAL();
Result oResult = oUserDAL.LoadMoveData(txtLoginUserID.Text, sType);
if (oResult.Status)
{
User oUser = (User)oResult.Return;
if (oUser != null)
{
ClearTextValue();
hdDataType.Value = "M";
txtLoginUserID.Text = oUser.UserName.ToString();
txtUserFirstName.Text = oUser.FirstName.ToString();
txtUserLastName.Text = oUser.LastName.ToString();
txtNewPassword.Attributes.Add("value", oUser.Password.ToString());
txtConfirmPassword.Attributes.Add("value", oUser.Password.ToString());
chkStatus.Checked = oUser.Status;
Util.ChkChangeSetColor(chkStatus);
DDListUtil.Assign(ddlDesignation, oUser.Designation.DesignationID.ToString());
DDListUtil.Assign(ddlUserClass, oUser.Group.GroupID.ToString());
}
ucUserDet.UserDetail = oUser.UserDetails;
hdUserID.Value = oUser.UserID.ToString();
}
}
public void SetObject(Group oGp)
{
txtGroupID.Text = oGp.GroupID.ToString();
txtGroupName.Text = oGp.GroupName.ToString();
txtDescription.Text = oGp.Description.ToString();
DDListUtil.Assign(ddlDepartmentID, oGp.Department.DepartmentID);
DataTable dtOpr = (DataTable)Session[Constants.SES_GROUP_OPERATION_DATA];
int iCount = dtOpr.Rows.Count;
DataView dv = new DataView();
dv.Table = oGp.DTScreenList;
if (oGp.DTScreenList.Rows.Count > 0)
{
foreach (GridViewRow row in gvScreenList.Rows)
{
dv.RowFilter = "ScreenID = '" + row.Cells[0].Text + "'";
if (dv.Count > 0)
{
if (dv[0]["ScreenID"].ToString() == row.Cells[0].Text)
{
string sOperationCode = dv[0]["OperationCode"].ToString();
for (int i = dtOpr.Rows.Count; i > 0; i--)
{
CheckBox chk = (CheckBox)row.FindControl(dtOpr.Rows[i - 1]["Description"].ToString());
string sRowVal = dtOpr.Rows[i - 1]["OperationTypeID"].ToString();
if (sOperationCode.Contains(sRowVal))
{
if (chk != null)
{
if (sRowVal.Equals("1"))
{
if (!sOperationCode[0].ToString().Equals(sRowVal))
{
continue;
}
}
chk.Checked = true;
}
}
else
{
if (chk != null)
{
chk.Checked = false;
}
}
}
}
}
}
}
//UserDetails userDetail = oGp.UserDetails;
//userDetail.MakeDate = DateTime.Now;
//ucUserDet.UserDetail = userDetail;
hdGpID.Value = oGp.GroupID.ToString();
}
private void LoadSPType()
{
SPTypeDAL oSPTypeDAL = new SPTypeDAL();
Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue);
if (oResult.Status)
{
ddlDenomination.Items.Clear();
DataTable dtGetDenomID = (DataTable)oResult.Return;
if (dtGetDenomID.Rows.Count > 0)
{
DDListUtil.Assign(ddlDenomination, dtGetDenomID, true);
txtSeries.Text = string.Empty;
txtFrom.Text = string.Empty;
txtTo.Text = string.Empty;
txtQuantity.Text = string.Empty;
txtDnmAmount.Text = string.Empty;
txtDrawerNumber.Text = string.Empty;
txtCabinetNumber.Text = string.Empty;
gvReceiveDetail.DataSource = null;
gvReceiveDetail.DataBind();
}
}
}
private void LoadBySPType()
{
SPPolicy oSPPolicy = null;
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = (Result)oSPPolicyDAL.LatestPolicy(ddlSpType.SelectedValue, Constants.ACTIVITY_TYPE.ISSUE, DateTime.Now);
if (oResult.Status)
{
ddlDDDenom.Items.Clear();
oSPPolicy = (SPPolicy)oResult.Return;
DataTable dtDenom = new DataTable();
if (oSPPolicy.SPType.ListOfDenomination.Denomination.Count > 0)
{
dtDenom.Columns.Add(new DataColumn("Text", typeof(string)));
dtDenom.Columns.Add(new DataColumn("Value", typeof(string)));
DataRow rowDenom = null;
for (int i = 0; i < oSPPolicy.SPType.ListOfDenomination.Denomination.Count; i++)
{
rowDenom = dtDenom.NewRow();
rowDenom["Text"] = oSPPolicy.SPType.ListOfDenomination.Denomination[i].DenominationID.ToString();
rowDenom["Value"] = oSPPolicy.SPType.ListOfDenomination.Denomination[i].Series.ToString();
dtDenom.Rows.Add(rowDenom);
}
}
DDListUtil.Assign(ddlDDDenom, dtDenom, true);
}
}
private void ClearData()
{
txtMasterNo.Text = string.Empty;
txtCustomerID.Text = string.Empty;
txtCustomerName.Text = string.Empty;
txtAddress.Text = string.Empty;
txtPermanentAddress.Text = string.Empty;
txtForignAddress.Text = string.Empty;
txtTINNo.Text = string.Empty;
txtPhone.Text = string.Empty;
txtEmail.Text = string.Empty;
ddlSex.SelectedIndex = 0;
txtNationality.Text = "Bangladeshi";
ddlNationalityCountry.SelectedIndex = 0;
ddlResidentCountry.SelectedIndex = 0;
txtDateofBirth.Text = string.Empty;
ddlDateofBirthCountry.SelectedIndex = 0;
txtBirthPlace.Text = string.Empty;
txtPassportNo.Text = string.Empty;
ddlPassportCountry.SelectedIndex = 0;
txtPassportIssueAt.Text = string.Empty;
txtNationalID.Text = string.Empty;
ddlNationalIDCountry.SelectedIndex = 0;
txtNationalIDIssueAt.Text = string.Empty;
txtBirthCertNo.Text = string.Empty;
ddlBirthCertNoCountry.SelectedIndex = 0;
txtBirthCertNoIssueAt.Text = string.Empty;
ddlResidenceStatus.SelectedIndex = 0;
//txtCustomerName2.Text = string.Empty;
//txtAddress2.Text = string.Empty;
//txtForignAddress2.Text = string.Empty;
//txtPhone2.Text = string.Empty;
//txtDateofBirth2.Text = string.Empty;
//ddlSex2.SelectedIndex = 0;
//txtNationality2.Text = "Bangladeshi";
//txtPassportNo2.Text = string.Empty;
//txtIssueAt2.Text = string.Empty;
//txtNationalID2.Text = string.Empty;
//txtBirthCertNo2.Text = string.Empty;
//txtEmail2.Text = string.Empty;
//ddlResidenceStatus2.SelectedIndex = 0;
DDListUtil.Assign(ddlDateofBirthCountry, "BANGLADESH");
DDListUtil.Assign(ddlNationalityCountry, "BANGLADESH");
DDListUtil.Assign(ddlResidentCountry, "BANGLADESH");
DDListUtil.Assign(ddlPassportCountry, "BANGLADESH");
DDListUtil.Assign(ddlNationalIDCountry, "BANGLADESH");
DDListUtil.Assign(ddlBirthCertNoCountry, "BANGLADESH");
hdTmpCustomerID.Value = "";
hdnIsReinvested.Value = "0";
}
private void LoadToDateData()
{
/*
* If Me.ActiveControl.Name = "cboDuration" Then Exit Function
* If Me.ActiveControl.Name = "btnSearchRefNo" Then Exit Function
* If Me.cboToDate.SelectedIndex > 0 Then
* Me.FillReferenceDetailGrid()
* Me.cboCurrencyID.Enabled = True
* Me.cboCurrencyID.SelectedValue = Me.cStrSPCurrency
* Me.LoadCurrencyData()
* Else
* Me.cDtSalesStatementData = Nothing
* dgrSalesReferenceDetails.DataSource = Nothing
* dgrSalesReferenceDetails.Refresh()
* dgrRegistrationDetails.DataSource = Nothing
* dgrRegistrationDetails.Refresh()
* Me.txtTotalOrgCommission.Text = "0.00"
* Me.txtTotalNonOrgCommission.Text = "0.00"
* Me.txtConvTotalOrgCommission.Text = "0.00"
* Me.txtConvTotalNonOrgCommission.Text = "0.00"
* If Not IsNothing(Me.cboCurrencyID.DataSource) Then
* Me.cboCurrencyID.SelectedIndex = 0
* End If
* Me.cboCurrencyID.Enabled = False
* Me.txtConversionRate.Text = "0.0000"
* End If
*/
if (ddlDateTo.SelectedIndex > 0)
{
FillReferenceDetailGrid("");
ddlConversionCurrency.Enabled = true;
string sSPCurrency = ViewState[_SPTYPE_CUREENCY] as string;
if (!string.IsNullOrEmpty(sSPCurrency))
{
DDListUtil.Assign(ddlConversionCurrency, sSPCurrency);
}
LoadCurrencyData();
}
else
{
gvData.DataSource = null;
gvData.DataBind();
txtTotalFaceValue.Text = "0.00";
txtTotalNonOrgCommission1.Text = "0.00";
txtTotalNonOrgCommission2.Text = "0.00";
txtTotalOrgCommission1.Text = "0.00";
txtTotalOrgCommission2.Text = "0.00";
if (ddlConversionCurrency.Items.Count > 0)
{
ddlConversionCurrency.SelectedIndex = 0;
}
ddlConversionCurrency.Enabled = false;
txtConversionRate.Text = "0.0000";
}
}
private void LoadCurrencyBySPType(string sSPTypeID)
{
ddlReconCurrency.Items.Clear();
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = oSPPolicyDAL.GetCurrencyList(sSPTypeID, Constants.ACTIVITY_TYPE.INTEREST_REIMBURSE, DateTime.Now);
if (oResult.Status)
{
DDListUtil.Assign(ddlReconCurrency, (DataTable)oResult.Return, true);
}
}
private void LoadCustomerTypeBySpType(string sSPType)
{
CustomerTypeWiseSPLimitDAL oCustTypeWiseSPLimit = new CustomerTypeWiseSPLimitDAL();
Result oResult = (Result)oCustTypeWiseSPLimit.GetCustomerTypeBySpType(sSPType);
if (oResult.Status)
{
ddlCustomerType.Items.Clear();
DataTable dtGetCustomerTypeID = (DataTable)oResult.Return;
DDListUtil.Assign(ddlCustomerType, dtGetCustomerTypeID);
}
}
private void LoadDataByID(string sBankID)
{
Bank oBank = new Bank(sBankID);
BankDAL oBankDAL = new BankDAL();
Result oResult = new Result();
oResult = oBankDAL.LoadByID(oBank);
if (oResult.Status)
{
oBank = (Bank)oResult.Return;
txtBankID.Text = oBank.BankID.Trim();
txtBankID.ReadOnly = true;
txtDivisionName.Text = oBank.DivisionName;
txtBdBankCode.Text = oBank.BBCode;
txtAddress.Text = oBank.Address;
txtZipCode.Text = oBank.ZipCode;
txtPhoneNumber.Text = oBank.Phone;
txtEmailID.Text = oBank.Email;
txtFaxNumber.Text = oBank.Fax;
txtSWIFTBIC.Text = oBank.SWIFTBIC;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oBank.UserDetails.MakerID;
userDetails.MakeDate = oBank.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckerID = oBank.UserDetails.CheckerID;
userDetails.CheckDate = oBank.UserDetails.CheckDate;
userDetails.CheckerComment = oBank.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
DDListUtil.Assign(ddlBranchCode, oBank.Branch.BranchID);
DDListUtil.Assign(ddlToMonth, oBank.FiscalToMonth.ToString());
DDListUtil.Assign(ddlFromMonth, oBank.FiscalFormMonth.ToString());
DDListUtil.Assign(ddlCountryName, oBank.Country.ToString());
hdBankID.Value = sBankID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadBySPType(Issue oIssue)
{
SPPolicy oSPPolicy = null;
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = (Result)oSPPolicyDAL.LatestPolicy(oIssue.SPType.SPTypeID, Constants.ACTIVITY_TYPE.ISSUE, oIssue.VersionIssueDate);
if (oResult.Status)
{
ddlCustomerType.Items.Clear();
oSPPolicy = (SPPolicy)oResult.Return;
DDListUtil.Assign(ddlCustomerType, oSPPolicy.DTCustomerTypePolicy, true);
}
}
private void LoadDataByID(string sSPTypeID)
{
SPTypeWiseAccountMapping oSPTypeWiseAccountMapping = new SPTypeWiseAccountMapping(sSPTypeID);
SPTypeWiseAccountMappingDAL oSPWiseAccountMappingDAL = new SPTypeWiseAccountMappingDAL();
Result oResult = new Result();
oResult = oSPWiseAccountMappingDAL.LoadByID(oSPTypeWiseAccountMapping);
if (oResult.Status)
{
oSPTypeWiseAccountMapping = (SPTypeWiseAccountMapping)oResult.Return;
DDListUtil.Assign(ddlSPTypeID, oSPTypeWiseAccountMapping.SPType.SPTypeID.Trim());
ddlSPTypeID.Enabled = false;
txtStoInHandAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.StockInHandAcc);
txtStoInHandName.Text = oSPTypeWiseAccountMapping.StockInHandAccName;
txtLibOnStoAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.LiabilityOnStockAcc);
txtLibOnStoName.Text = oSPTypeWiseAccountMapping.LiabilityOnStockAccName;
txtHolAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.HoldingAcc);
txtHolName.Text = oSPTypeWiseAccountMapping.HoldingAccName;
txtAccComAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.AccruedInterestAcc);
txtComName.Text = oSPTypeWiseAccountMapping.AccruedInterestAccName;
txtAdvAgiIntAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.AdvAgainstInterestAcc);
txtAdvAgiIntName.Text = oSPTypeWiseAccountMapping.AdvAgainstInterestAccName;
txtAdvAgiPriAcc.Text = SBM_BLC1.Common.String.AddSeperator(oSPTypeWiseAccountMapping.AdvAgainstPrincipalAcc);
txtAdvAgiPriName.Text = oSPTypeWiseAccountMapping.AdvAgainstPrincipalAccName;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oSPTypeWiseAccountMapping.UserDetails.MakerID;
userDetails.MakeDate = oSPTypeWiseAccountMapping.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oSPTypeWiseAccountMapping.UserDetails.CheckDate;
userDetails.CheckerID = oSPTypeWiseAccountMapping.UserDetails.CheckerID;
userDetails.CheckDate = oSPTypeWiseAccountMapping.UserDetails.CheckDate;
userDetails.CheckerComment = oSPTypeWiseAccountMapping.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdSPTypeID.Value = sSPTypeID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadBySPType()
{
SPPolicy oSPPolicy = null;
SPPolicyDAL oSPPolicyDAL = new SPPolicyDAL();
Result oResult = (Result)oSPPolicyDAL.LatestPolicy(ddlSpType.SelectedValue, Constants.ACTIVITY_TYPE.ISSUE, DateTime.Now);
if (oResult.Status)
{
ddlCurrency.Items.Clear();
oSPPolicy = (SPPolicy)oResult.Return;
DDListUtil.Assign(ddlCurrency, oSPPolicy.DTCurrencyActivityPolicy, true);
}
}
private void LoadDataByID(string sCurrencyID)
{
CurrencyWiseAccountMapping oCurrencyWiseAccountMapping = new CurrencyWiseAccountMapping(sCurrencyID);
CurrencyWiseAccountMappingDAL oCurrencyWiseAccountMappingDAL = new CurrencyWiseAccountMappingDAL();
Result oResult = new Result();
oResult = oCurrencyWiseAccountMappingDAL.LoadByID(oCurrencyWiseAccountMapping);
if (oResult.Status)
{
oCurrencyWiseAccountMapping = (CurrencyWiseAccountMapping)oResult.Return;
DDListUtil.Assign(ddlCurrencyID, oCurrencyWiseAccountMapping.Currency.CurrencyID);
ddlCurrencyID.Enabled = false;
txtSusPenAcc.Text = SBM_BLC1.Common.String.AddSeperator(oCurrencyWiseAccountMapping.SuspenseAcc);
txtSusPenName.Text = oCurrencyWiseAccountMapping.SuspenseAccName;
txtForExcchAcc.Text = SBM_BLC1.Common.String.AddSeperator(oCurrencyWiseAccountMapping.ForeignExchangeAcc);
txtForExcchName.Text = oCurrencyWiseAccountMapping.ForeignExchangeAccName;
txtBraFaxAcc.Text = SBM_BLC1.Common.String.AddSeperator(oCurrencyWiseAccountMapping.BranchFxAcc);
txtBraFaxName.Text = oCurrencyWiseAccountMapping.BranchFxAccName;
txtBraExcFaxAcc.Text = SBM_BLC1.Common.String.AddSeperator(oCurrencyWiseAccountMapping.BranchExFxAcc);
txtBraExcFaxName.Text = oCurrencyWiseAccountMapping.BranchExFxAccName;
txtBngBankAcc.Text = SBM_BLC1.Common.String.AddSeperator(oCurrencyWiseAccountMapping.BangladesgBankAcc);
txtBngBankName.Text = oCurrencyWiseAccountMapping.BangladesgBankAccName;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oCurrencyWiseAccountMapping.UserDetails.MakerID;
userDetails.MakeDate = oCurrencyWiseAccountMapping.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oCurrencyWiseAccountMapping.UserDetails.CheckDate;
userDetails.CheckerID = oCurrencyWiseAccountMapping.UserDetails.CheckerID;
userDetails.CheckDate = oCurrencyWiseAccountMapping.UserDetails.CheckDate;
userDetails.CheckerComment = oCurrencyWiseAccountMapping.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdnCurrencyID.Value = sCurrencyID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
protected void SetDenominationBySPTypeID(SPTypeDAL oSPTypeDAL)
{
if (oSPTypeDAL == null)
{
oSPTypeDAL = new SPTypeDAL();
}
Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue);
if (oResult.Status)
{
ddlDenomination.Items.Clear();
DataTable dtGetDenomID = (DataTable)oResult.Return;
DDListUtil.Assign(ddlDenomination, dtGetDenomID);
}
}
private void LoadDataByID(string sBranchID)
{
Branch oBranch = new Branch(sBranchID);
BranchDAL oBranchDAL = new BranchDAL();
Result oResult = new Result();
oResult = oBranchDAL.LoadByID(oBranch);
if (oResult.Status)
{
oBranch = (Branch)oResult.Return;
txtBranchID.Text = oBranch.BranchID.Trim();
txtBranchID.ReadOnly = true;
txtBranchName.Text = oBranch.BranchName;
txtBdBankCode.Text = oBranch.BbCode;
txtAddress.Text = oBranch.Address;
txtZipCode.Text = oBranch.ZipCode;
txtPhoneNumber.Text = oBranch.Phone;
txtEmailID.Text = oBranch.Email;
txtFaxNumber.Text = oBranch.Fax;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oBranch.UserDetails.MakerID;
userDetails.MakeDate = oBranch.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oBranch.UserDetails.CheckDate;
userDetails.CheckerID = oBranch.UserDetails.CheckerID;
userDetails.CheckDate = oBranch.UserDetails.CheckDate;
userDetails.CheckerComment = oBranch.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
DDListUtil.Assign(ddlCountryName, oBranch.Country.ToString());
hdBranchID.Value = sBranchID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void CalculateInterestClaim()
{
decimal dCalInterest = 0;
decimal dIncomeTax = 0;
int iSelectedCount = 0;
string sRegNo = "";
foreach (GridViewRow gvr in gvData.Rows)
{
CheckBox chk = (CheckBox)gvr.FindControl("chkSelected");
if (chk != null)
{
if (chk.Checked)
{
dCalInterest += Util.GetDecimalNumber(gvr.Cells[7].Text);//Payment Amount to be calculated
dIncomeTax += Util.GetDecimalNumber(gvr.Cells[6].Text);
sRegNo = Convert.ToString(gvr.Cells[1].Text).Trim();
iSelectedCount++;
}
}
}
InterestClaimDAL intClaimDAL = new InterestClaimDAL();
Result cdresult = intClaimDAL.GetConversionDetails(sRegNo);
string sCCY = "00";
decimal dRate = 1;
if (cdresult.Status)
{
DataTable dtConversionCCY = (DataTable)cdresult.Return;
sCCY = Convert.ToString(dtConversionCCY.Rows[0]["CurrencyID"]);
dRate = Convert.ToDecimal(dtConversionCCY.Rows[0]["ConvRate"]);
}
DDListUtil.Assign(ddlConversionCurrency, sCCY);
ddlConversionCurrency.Enabled = false;
txtConversionRate.Text = dRate.ToString("N2");
txtConversionRate.Enabled = false;
#region Assign Data in calculation field set
txtSelectCount.Text = "TOTAL SELECTED " + iSelectedCount.ToString() + " OF " + gvData.Rows.Count;
txtTotalIncomeTax1.Text = dIncomeTax.ToString("N2");
txtRemuneration.Text = CalculateRemuneration(false).ToString("N2");
txtTotalIncomeTax2.Text = (CalculateConvertedAmount(dIncomeTax, Util.GetDecimalNumber(txtConversionRate.Text))).ToString("N2");
txtTotalInterest1.Text = (dCalInterest).ToString("N2");
txtTotalInterest2.Text = CalculateConvertedAmount(dCalInterest, Util.GetDecimalNumber(txtConversionRate.Text)).ToString("N2");
#endregion
}
private void LoadDataByID(string sSPTypeID, string sDenomination)
{
ScripMapping oScripMapping = new ScripMapping(sSPTypeID, Convert.ToInt32(sDenomination == "" ? "0" : sDenomination));
ScripMappingDAL oScripMappingDAL = new ScripMappingDAL();
Result oResult = new Result();
oResult = oScripMappingDAL.LoadByID(oScripMapping);
if (oResult.Status)
{
oScripMapping = (ScripMapping)oResult.Return;
DDListUtil.Assign(ddlSPType, oScripMapping.SPTypeID.Trim());
//ddlSPType.Text = oScripMapping.SPTypeID.Trim();
ddlSPType.Enabled = false;
SetDenominationBySPTypeID(null);
ddlDenomination.Enabled = false;
DDListUtil.Assign(ddlDenomination, oScripMapping.Denomination.ToString());
DDListUtil.Assign(ddlScriptFormat, oScripMapping.ScripFormat.ToString());
hdSPTypeID.Value = oScripMapping.SPTypeID.Trim();
hdDenomination.Value = oScripMapping.Denomination.ToString();
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oScripMapping.UserDetails.MakerID;
userDetails.MakeDate = oScripMapping.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oScripMapping.UserDetails.CheckDate;
userDetails.CheckerID = oScripMapping.UserDetails.CheckerID;
userDetails.CheckDate = oScripMapping.UserDetails.CheckDate;
userDetails.CheckerComment = oScripMapping.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
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);
txtDateFrom.ReadOnly = true;
txtTotalFaceValue.Text = "0.00";
// year
for (int i = 1995; i < DateTime.Now.Year + 1 + 1; i++)
{
DDListUtil.Add(ddlYear, i.ToString(), i.ToString());
}
DDListUtil.Assign(ddlYear, DateTime.Now.Year);
}
private void InitializeData()
{
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlJournalType, "JournalType", "Description", "SPMS_JournalType", true);
ReportDAL rdal = new ReportDAL();
Result oResult = rdal.LoadAccountingEntryOperator();
if (oResult.Status)
{
DataTable dtAccountUser = (DataTable)oResult.Return;
DDListUtil.Assign(ddlOperator, dtAccountUser, false);
}
txtToDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtFromDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
chkAccEntryOper.Checked = true;
chkJournalType.Checked = true;
chkUploadDataRange.Checked = true;
}
public void ClaimSearchLoadAction(DataRow dtRow)
{
if (dtRow != null)
{
string sSalesClaimTransNo = Convert.ToString(dtRow["SaleStatementTransNo"]);
hdnClaimTransNo.Value = sSalesClaimTransNo;
txtReferenceNo.Text = Convert.ToString(dtRow["Reference No"]);
DateTime parsedDate;
DateTime.TryParseExact(Convert.ToString(dtRow["Statement Date"]), Constants.DateTimeFormats, null, DateTimeStyles.None, out parsedDate);
txtStatementDate.Text = parsedDate.ToString(Constants.DATETIME_FORMAT);
DateTime.TryParseExact(Convert.ToString(dtRow["From Date"]), 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"]);
DDListUtil.Assign(ddlDuration, Convert.ToString(dtRow["DurationType"]));
DateTime.TryParseExact(Convert.ToString(dtRow["To Date"]), 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] = "";
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;
FillRegistrationDetailGrid(sSalesClaimTransNo);
EnableDisableControls(false);
}
}
private void LoadDataByID(string sCustomerID, string sSPTypeID)
{
CustomerTypeWiseSPLimit oCTWiseSPLimit = new CustomerTypeWiseSPLimit(sCustomerID, sSPTypeID);
CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
Result oResult = new Result();
oResult = oCTWiseSPLimitDAL.LoadByID(oCTWiseSPLimit);
if (oResult.Status)
{
oCTWiseSPLimit = (CustomerTypeWiseSPLimit)oResult.Return;
DDListUtil.Assign(ddlSPType, oCTWiseSPLimit.SPType.SPTypeID.Trim());
DDListUtil.Assign(ddlCustType, oCTWiseSPLimit.CustomerType.CustomerTypeID.Trim());
ddlCustType.Enabled = false;
ddlSPType.Enabled = false;
txtMinLim.Text = oCTWiseSPLimit.MinimumLimit.ToString();
txtMaxLim.Text = oCTWiseSPLimit.MaximumLimit.ToString();
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oCTWiseSPLimit.UserDetails.MakerID;
userDetails.MakeDate = oCTWiseSPLimit.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oCTWiseSPLimit.UserDetails.CheckDate;
userDetails.CheckerID = oCTWiseSPLimit.UserDetails.CheckerID;
userDetails.CheckDate = oCTWiseSPLimit.UserDetails.CheckDate;
userDetails.CheckerComment = oCTWiseSPLimit.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdCustomerID.Value = oCTWiseSPLimit.CustomerType.CustomerTypeID;
hdSPTypeID.Value = oCTWiseSPLimit.SPType.SPTypeID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadDataByID(string sSPTypeID)
{
BBAddress oBBAddress = new BBAddress(sSPTypeID);
BBAddressDAL oBBAddressDAL = new BBAddressDAL();
Result oResult = new Result();
oResult = oBBAddressDAL.LoadByID(oBBAddress);
if (oResult.Status)
{
oBBAddress = (BBAddress)oResult.Return;
DDListUtil.Assign(ddlSPType, oBBAddress.SPType.SPTypeID);
ddlSPType.Enabled = false;
txtSaleStatementAddress.Text = oBBAddress.SalesStatemetAddress;
txtCommClaimAddress.Text = oBBAddress.CommissionClaimAddress;
txtInrestClaimAddress.Text = oBBAddress.InterestClaimAddress;
txtEncashClaimAddress.Text = oBBAddress.EncashmentClaimAddress;
txtReinAddress.Text = oBBAddress.ReinvestmentAddress;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oBBAddress.UserDetails.MakerID;
userDetails.MakeDate = oBBAddress.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckerID = oBBAddress.UserDetails.CheckerID;
userDetails.CheckDate = oBBAddress.UserDetails.CheckDate;
userDetails.CheckerComment = oBBAddress.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdSPTypeID.Value = sSPTypeID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadDataByID(string sSPTypeID)
{
SPReportMap oSPReportMap = new SPReportMap(sSPTypeID);
SPReportMappingDAL oSPReportMappingDAL = new SPReportMappingDAL();
Result oResult = new Result();
oResult = oSPReportMappingDAL.LoadByID(oSPReportMap);
if (oResult.Status)
{
oSPReportMap = (SPReportMap)oResult.Return;
DDListUtil.Assign(ddlCommissionClaim, oSPReportMap.CommissionClaimFormat.ToString());
DDListUtil.Assign(ddlEncashmentClaim, oSPReportMap.EncashmentClaimFormat.ToString());
DDListUtil.Assign(ddlInterestClaim, oSPReportMap.InterestClaimFormat.ToString());
DDListUtil.Assign(ddlSaleStatement, oSPReportMap.SalesStatemetFormat.ToString());
DDListUtil.Assign(ddlSPType, oSPReportMap.SPTypeID.Trim());
ddlSPType.Enabled = false;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oSPReportMap.UserDetails.MakerID;
userDetails.MakeDate = oSPReportMap.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oSPReportMap.UserDetails.CheckDate;
userDetails.CheckerID = oSPReportMap.UserDetails.CheckerID;
userDetails.CheckDate = oSPReportMap.UserDetails.CheckDate;
userDetails.CheckerComment = oSPReportMap.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdSPTypeID.Value = sSPTypeID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
private void LoadDataByID(string sCurrencyID)
{
CommonMapping oCM = new CommonMapping(sCurrencyID);
CommonMappingDAL oCMDAL = new CommonMappingDAL();
Result oResult = new Result();
oResult = oCMDAL.LoadByID(oCM);
if (oResult.Status)
{
oCM = (CommonMapping)oResult.Return;
txtAccount.Text = oCM.PnLAcc.Trim();
txtAccName.Text = oCM.PnLAccName.Trim();
DDListUtil.Assign(ddlCurrencyID, oCM.Currency.CurrencyID);
ddlCurrencyID.Enabled = false;
if (string.IsNullOrEmpty(hdDataType.Value))
{
//When Loading from Approver End
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.MakerID = oCM.UserDetails.MakerID;
userDetails.MakeDate = oCM.UserDetails.MakeDate;
ucUserDet.UserDetail = userDetails;
}
else if (hdDataType.Value.Equals("T"))
{
//When loading from temp table
UserDetails userDetails = ucUserDet.UserDetail;
userDetails.CheckDate = oCM.UserDetails.CheckDate;
userDetails.CheckerID = oCM.UserDetails.CheckerID;
userDetails.CheckDate = oCM.UserDetails.CheckDate;
userDetails.CheckerComment = oCM.UserDetails.CheckerComment;
ucUserDet.UserDetail = userDetails;
}
hdCurrencyID.Value = sCurrencyID;
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
}
}
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 LoadDataByID(int iSPID)
{
SecurityPolicy oSp = new SecurityPolicy(iSPID);
SecurityPolicyDAL oSpDAL = new SecurityPolicyDAL();
Result oResult = new Result();
oResult = oSpDAL.LoadByID(oSp);
ClearTextValue();
if (oResult.Status)
{
oSp = (SecurityPolicy)oResult.Return;
if (oSp != null)
{
DDListUtil.Assign(ddlRequiredToChangePw, oSp.IsChangePassFirst);
txtOldPwprohibited.Text = oSp.OldPassProhibited.ToString();
txtMinimumPwLg.Text = oSp.MinPassLength.ToString();
DDListUtil.Assign(ddlAlphaNumPw, oSp.IsForceAlphaNumericPass);
txtPwExpDays.Text = oSp.PassExpiresAfterDays.ToString();
txtDayEarly.Text = oSp.DaysEarlierPass.ToString();
txtWrongLoginTrial.Text = oSp.MaxWrongTtrial.ToString();
ucUserDet.UserDetail = oSp.UserDetails;
hdSecurityPolicyID.Value = oSp.SecurityPolicyID.ToString();
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true);
}
}
else
{
ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true);
}
}
private void InitializeData()
{
gvIntClaimDetail.PageSize = (int)Constants.PAGING_UNAPPROVED;
gvClaim.DataSource = null;
gvClaim.DataBind();
gvIntClaimDetail.DataSource = null;
gvIntClaimDetail.DataBind();
// Dropdown load SPType
DDListUtil.LoadDDLFromDB(ddlSpType, "SPTypeID", "TypeDesc", "SPMS_SPType", true);
// year
for (int i = 1995; i < DateTime.Today.Year + 1; i++)
{
DDListUtil.Add(ddlYear, i.ToString(), i.ToString());
}
DDListUtil.Assign(ddlYear, DateTime.Now.Year);
//Initial Value Set
txtReconciliationDate.Text = DateTime.Now.ToString(Constants.DATETIME_FORMAT);
txtReimConvRate.Text = "1.0000";
txtCovRateToBC.Text = "1.00";
string sRefNo = Request.QueryString[OBJ_REF_NO];
string sPageID = Request.QueryString[OBJ_PAGE_ID];
if (!string.IsNullOrEmpty(sRefNo))
{
sRefNo = oCrypManager.GetDecryptedString(sRefNo, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sPageID))
{
sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING);
}
if (!string.IsNullOrEmpty(sRefNo) && !string.IsNullOrEmpty(sPageID))
{
string sOperationType = sPageID.Substring(4, 1);
if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType))
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
SEARCH_FROM = 2;
LoadDataByReferenceNo(sRefNo, "1");//query from Temp Table
#region User-Detail.
UserDetails oUserDetails = ucUserDet.UserDetail;
oUserDetails.CheckerID = oConfig.UserName;
oUserDetails.CheckDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
#endregion User-Detail.
fsList.Visible = false;
EnableDisableControl(true);
}
}
else
{
Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];
UserDetails oUserDetails = new UserDetails();
oUserDetails.MakerID = oConfig.UserName;
oUserDetails.MakeDate = DateTime.Now;
ucUserDet.UserDetail = oUserDetails;
fsList.Visible = true;
LoadPreviousList();
EnableDisableControl(false);
}
}
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();
}
}