private void BindPeriodDropDown()
{
DataTable dtPeriod;
dtPeriod = XMLBo.GetDatePeriod(path);
ddlPeriod.DataSource = dtPeriod;
ddlPeriod.DataTextField = "PeriodType";
ddlPeriod.DataValueField = "PeriodCode";
ddlPeriod.DataBind();
ddlPeriod.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select a Period", "Select a Period"));
}
private void BindLoanPartner()
{
string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
DataTable dt = XMLBo.GetLoanPartner(path);
ddlLoanPartner.DataSource = dt;
ddlLoanPartner.DataValueField = dt.Columns["XLP_LoanPartnerCode"].ToString();
ddlLoanPartner.DataTextField = dt.Columns["XLP_LoanPartner"].ToString();
ddlLoanPartner.DataBind();
ddlLoanPartner.Items.Insert(0, new ListItem("Select", "0"));
}
protected void rbtnNonIndividual_CheckedChanged(object sender, EventArgs e)
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "NIND");
ddlCustomerSubType.DataSource = dtCustomerSubType;
ddlCustomerSubType.DataTextField = "CustomerTypeName";
ddlCustomerSubType.DataValueField = "CustomerSubTypeCode";
ddlCustomerSubType.DataBind();
ddlCustomerSubType.Items.Insert(0, new ListItem("Select a Sub-Type", "Select a Sub-Type"));
trCompanyName.Visible = true;
trIndividualName.Visible = false;
}
private void BindDropDowns(PropertyVo propertyVo, CustomerAccountsVo customerAccountsVo, string path)
{
try
{
userVo = (UserVo)Session["userVo"];
customerVo = (CustomerVo)Session["CustomerVo"];
dtMeasureCode = XMLBo.GetMeasureCode(path, AssetGroupCode);
ddlMeasureCode.DataSource = dtMeasureCode;
ddlMeasureCode.DataTextField = "Measure";
ddlMeasureCode.DataValueField = "MeasureCode";
ddlMeasureCode.DataBind();
ddlMeasureCode.Items.Insert(0, new ListItem("Select a Measure Code", "Select a Measure Code"));
// Bind the Instrument Category for an Asset
dsInstrumentCategory = assetBo.GetAssetInstrumentCategory(AssetGroupCode);
ddlInstrumentCat.DataSource = dsInstrumentCategory.Tables[0];
ddlInstrumentCat.DataTextField = "PAIC_AssetInstrumentCategoryName";
ddlInstrumentCat.DataValueField = "PAIC_AssetInstrumentCategoryCode";
ddlInstrumentCat.DataBind();
ddlInstrumentCat.Items.Insert(0, new ListItem("Select an Instrument Category", "Select an Instrument Category"));
ddlInstrumentSubCat.Items.Clear();
// Bind State Drop Downs
dtStates = XMLBo.GetStates(path);
ddlState.DataSource = dtStates;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateCode";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioPropertyEntry.ascx:BindDropDowns()");
object[] objects = new object[5];
objects[0] = userVo;
objects[1] = propertyVo;
objects[2] = customerAccountsVo;
objects[3] = path;
objects[4] = customerVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void rbtnNonIndividual_CheckedChanged(object sender, EventArgs e)
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "NIND");
ddlCustomerSubType.DataSource = dtCustomerSubType;
ddlCustomerSubType.DataTextField = "CustomerTypeName";
ddlCustomerSubType.DataValueField = "CustomerSubTypeCode";
ddlCustomerSubType.DataBind();
if (customerVo != null)
{
Session[SessionContents.CustomerVo] = customerVo;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "PageLoadScript", "loadcontrol('EditCustomerNonIndividualProfile','none');", true);
}
}
private void BindPeriodDropDown()
{
DataTable dtPeriod;
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
dtPeriod = XMLBo.GetDatePeriod(path);
ddlPeriod.DataSource = dtPeriod;
ddlPeriod.DataTextField = "PeriodType";
ddlPeriod.DataValueField = "PeriodCode";
ddlPeriod.DataBind();
ddlPeriod.Items.Insert(0, new ListItem("Select a Period", "Select a Period"));
}
/// <summary>
/// Bind all the Drop down for Customer Income Screen
/// </summary>
/// <param name="path"></param>
public void BindDropDowns(string path)
{
dtCurrency = XMLBo.GetCurrency(path);
ddlAICurrency.DataSource = dtCurrency;
ddlAICurrency.DataTextField = "CurrencyName";
ddlAICurrency.DataValueField = "CurrencyCode";
ddlAICurrency.DataBind();
ddlAICurrency.SelectedValue = "1";
ddlBICurrency.DataSource = dtCurrency;
ddlBICurrency.DataTextField = "CurrencyName";
ddlBICurrency.DataValueField = "CurrencyCode";
ddlBICurrency.DataBind();
ddlBICurrency.SelectedValue = "1";
ddlGSCurrency.DataSource = dtCurrency;
ddlGSCurrency.DataTextField = "CurrencyName";
ddlGSCurrency.DataValueField = "CurrencyCode";
ddlGSCurrency.DataBind();
ddlGSCurrency.SelectedValue = "1";
ddlOSICurrency.DataSource = dtCurrency;
ddlOSICurrency.DataTextField = "CurrencyName";
ddlOSICurrency.DataValueField = "CurrencyCode";
ddlOSICurrency.DataBind();
ddlOSICurrency.SelectedValue = "1";
ddlPICurrency.DataSource = dtCurrency;
ddlPICurrency.DataTextField = "CurrencyName";
ddlPICurrency.DataValueField = "CurrencyCode";
ddlPICurrency.DataBind();
ddlPICurrency.SelectedValue = "1";
ddlRICurrency.DataSource = dtCurrency;
ddlRICurrency.DataTextField = "CurrencyName";
ddlRICurrency.DataValueField = "CurrencyCode";
ddlRICurrency.DataBind();
ddlRICurrency.SelectedValue = "1";
ddlTHSCurrency.DataSource = dtCurrency;
ddlTHSCurrency.DataTextField = "CurrencyName";
ddlTHSCurrency.DataValueField = "CurrencyCode";
ddlTHSCurrency.DataBind();
ddlTHSCurrency.SelectedValue = "1";
ddlTotal.DataSource = dtCurrency;
ddlTotal.DataTextField = "CurrencyName";
ddlTotal.DataValueField = "CurrencyCode";
ddlTotal.DataBind();
ddlTotal.SelectedValue = "1";
}
private string GetLoanTypeName(string loanTypeCode)
{
string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
DataTable dt = XMLBo.GetLoanType(path);
foreach (DataRow dr in dt.Rows)
{
if (dr["XLT_LoanTypeCode"].ToString() == loanTypeCode)
{
return(dr["XLT_LoanType"].ToString());
}
}
return(string.Empty);
}
private string GetBorrowerTypeName(string partnerId)
{
string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
DataTable dt = XMLBo.GetCustomerCategory(path);
foreach (DataRow dr in dt.Rows)
{
if (dr["XCC_CustomerCategoryCode"].ToString() == partnerId)
{
return(dr["XCC_CustomerCategory"].ToString());
}
}
return(string.Empty);
}
/// <summary>
/// Binding Period Dropdown From Xml File
/// </summary>
private void BindPeriodDropDown()
{
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
DataTable dtPeriod;
dtPeriod = XMLBo.GetDatePeriod(path);
ddlPeriod.DataSource = dtPeriod;
ddlPeriod.DataTextField = "PeriodType";
ddlPeriod.DataValueField = "PeriodCode";
ddlPeriod.DataBind();
ddlPeriod.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select a Period", "0"));
ddlPeriod.Items.RemoveAt(15);
ddlPeriod.SelectedIndex = 0;
}
private void BindReptTransactionDashBoard()
{
DataSet dsTreeNodes = new DataSet();
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
DataRow[] drXmlTreeSubSubNode;
DataRow drTransationTreeNode;
DataTable dtTransationTreeNode = new DataTable();
dtTransationTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtTransationTreeNode.Columns.Add("TreeNodeText1", typeof(String));
// dtTransationTreeNode.Columns.Add("Path1", typeof(String));
dtTransationTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtTransationTreeNode.Columns.Add("TreeNodeText2", typeof(String));
//For Transaction 2014 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2014;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drTransationTreeNode = dtTransationTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
if (count == 0)
{
count++;
drTransationTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drTransationTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
//drTransationTreeNode["Path1"] = drSubSubNode["Path"].ToString();
dtTransationTreeNode.Rows.Add(drTransationTreeNode);
}
else if (count == 1)
{
count++;
drTransationTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drTransationTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
// drTransationTreeNode["Path2"] = drSubSubNode["Path"].ToString();
count = 0;
drTransationTreeNode = dtTransationTreeNode.NewRow();
}
}
rptTransationTree.DataSource = dtTransationTreeNode;
rptTransationTree.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SessionBo.CheckSession();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
customerVo = (CustomerVo)Session[SessionContents.CustomerVo];
userVo = (UserVo)Session[SessionContents.UserVo];
if (!IsPostBack)
{
this.BindGrid(mypager.CurrentPage);
}
if (customerVo.Type == "NIND")
{
dtRelationship = XMLBo.GetRelationship(path, "NIND");
ddlRelationship.DataSource = dtRelationship;
ddlRelationship.DataTextField = "Relationship";
ddlRelationship.DataValueField = "RelationshipCode";
ddlRelationship.DataBind();
}
else
{
dtRelationship = XMLBo.GetRelationship(path, "IND");
ddlRelationship.DataSource = dtRelationship;
ddlRelationship.DataTextField = "Relationship";
ddlRelationship.DataValueField = "RelationshipCode";
ddlRelationship.DataBind();
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CustomerAssociatesAdd.ascx.cs:Page_Load()");
object[] objects = new object[4];
objects[0] = path;
objects[1] = customerVo;
objects[2] = userVo;
objects[3] = dtRelationship;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private string GetLoanPartnerName(string partnerId)
{
string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
DataTable dt = XMLBo.GetLoanPartner(path);
foreach (DataRow dr in dt.Rows)
{
if (dr["XLP_LoanPartnerCode"].ToString() == partnerId)
{
return(dr["XLP_LoanPartner"].ToString());
}
}
return(string.Empty);
}
private void BindDropDowns(string path)
{
dtMaritalStatus = XMLBo.GetMaritalStatus(path);
ddlMaritalStatus.DataSource = dtMaritalStatus;
ddlMaritalStatus.DataTextField = "MaritalStatus";
ddlMaritalStatus.DataValueField = "MaritalStatusCode";
ddlMaritalStatus.DataBind();
ddlMaritalStatus.Items.Insert(0, new ListItem("Select a Status", "Select a Status"));
dtNationality = XMLBo.GetNationality(path);
ddlNationality.DataSource = dtNationality;
ddlNationality.DataTextField = "Nationality";
ddlNationality.DataValueField = "NationalityCode";
ddlNationality.DataBind();
ddlNationality.Items.Insert(0, new ListItem("Select a Nationality", "Select a Nationality"));
dtOccupation = XMLBo.GetOccupation(path);
ddlOccupation.DataSource = dtOccupation;
ddlOccupation.DataTextField = "Occupation";
ddlOccupation.DataValueField = "OccupationCode";
ddlOccupation.DataBind();
ddlOccupation.Items.Insert(0, new ListItem("Select an Occupation", "Select a Occupation"));
dtQualification = XMLBo.GetQualification(path);
ddlQualification.DataSource = dtQualification;
ddlQualification.DataTextField = "Qualification";
ddlQualification.DataValueField = "QualificationCode";
ddlQualification.DataBind();
ddlQualification.Items.Insert(0, new ListItem("Select a Qualification", "Select a Qualification"));
dtStates = XMLBo.GetStates(path);
ddlCorrAdrState.DataSource = dtStates;
ddlCorrAdrState.DataTextField = "StateName";
ddlCorrAdrState.DataValueField = "StateCode";
ddlCorrAdrState.DataBind();
ddlCorrAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
ddlPermAdrState.DataSource = dtStates;
ddlPermAdrState.DataTextField = "StateName";
ddlPermAdrState.DataValueField = "StateCode";
ddlPermAdrState.DataBind();
ddlPermAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
ddlOfcAdrState.DataSource = dtStates;
ddlOfcAdrState.DataTextField = "StateName";
ddlOfcAdrState.DataValueField = "StateCode";
ddlOfcAdrState.DataBind();
ddlOfcAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
protected void BindDropdowns()
{
dtStates = XMLBo.GetStates(path);
ddlCorrAdrState.DataSource = dtStates;
ddlCorrAdrState.DataTextField = "StateName";
ddlCorrAdrState.DataValueField = "StateCode";
ddlCorrAdrState.DataBind();
ddlCorrAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
ddlPermAdrState.DataSource = dtStates;
ddlPermAdrState.DataTextField = "StateName";
ddlPermAdrState.DataValueField = "StateCode";
ddlPermAdrState.DataBind();
ddlPermAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
private void BindRelationshipDropDown()
{
if (txtParentCustomerType.Value != string.Empty)
{
if (ddlRelationship.Items.Count > 0)
{
ddlRelationship.Items.RemoveAt(0);
}
dtRelationship = XMLBo.GetRelationship(path, txtParentCustomerType.Value);
ddlRelationship.DataSource = dtRelationship;
ddlRelationship.DataTextField = "Relationship";
ddlRelationship.DataValueField = "RelationshipCode";
ddlRelationship.DataBind();
}
ddlRelationship.Items.Insert(0, new ListItem("Select", "Select"));
}
private void BindDropDowns(string path)
{
try
{
dtAccountType = XMLBo.GetBankAccountTypes(path);
ddlAccountType.DataSource = dtAccountType;
ddlAccountType.DataTextField = "BankAccountType";
ddlAccountType.DataValueField = "BankAccountTypeCode";
ddlAccountType.DataBind();
ddlAccountType.Items.Insert(0, new ListItem("Select an Account Type", "Select an Account Type"));
dtModeofOperation = XMLBo.GetModeOfHolding(path);
ddlModeOfOperation.DataSource = dtModeofOperation;
ddlModeOfOperation.DataTextField = "ModeOfHolding";
ddlModeOfOperation.DataValueField = "ModeOfHoldingCode";
ddlModeOfOperation.DataBind();
ddlModeOfOperation.Items.Insert(0, new ListItem("Select a Mode of Holding", "Select a Mode of Holding"));
dtStates = XMLBo.GetStates(path);
ddlBankAdrState.DataSource = dtStates;
ddlBankAdrState.DataTextField = "StateName";
ddlBankAdrState.DataValueField = "StateCode";
ddlBankAdrState.DataBind();
ddlBankAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AddBankDetails.ascx:BindDropDowns()");
object[] objects = new object[4];
objects[0] = path;
objects[1] = dtAccountType;
objects[2] = dtModeofOperation;
objects[3] = dtStates;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindDropDowns(string path)
{
// Bind Business Type Drop Downs
dt = XMLBo.GetBusinessType(path);
ddlBusinessType.DataSource = dt;
ddlBusinessType.DataTextField = "BusinessType";
ddlBusinessType.DataValueField = "BusinessTypeCode";
ddlBusinessType.DataBind();
ddlBusinessType.Items.Insert(0, new ListItem("Select a Business Type", "Select a Business Type"));
dtStates = XMLBo.GetStates(path);
ddlState.DataSource = dtStates;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateCode";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SessionBo.CheckSession();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
if (Session["Current_Link"].ToString() == "RMCustomerIndividualLeftPane")
{
dtRelationship = XMLBo.GetRelationship(path, "IND");
ddlRelationship.DataSource = dtRelationship;
ddlRelationship.DataTextField = "Relationship";
ddlRelationship.DataValueField = "RelationshipCode";
ddlRelationship.DataBind();
}
else if (Session["Current_Link"].ToString() == "RMCustomerNonIndividualLeftPane")
{
dtRelationship = XMLBo.GetRelationship(path, "NIND");
ddlRelationship.DataSource = dtRelationship;
ddlRelationship.DataTextField = "Relationship";
ddlRelationship.DataValueField = "RelationshipCode";
ddlRelationship.DataBind();
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "FamilyDetails.ascx:Page_Load()");
object[] objects = new object[1];
objects[0] = path;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindDropDowns(string path)
{
DataTable dt = null;
try
{
// Bind States Drop Down
dt = XMLBo.GetStates(path);
ddlCorrAdrState.DataSource = dt;
ddlCorrAdrState.DataTextField = "StateName";
ddlCorrAdrState.DataValueField = "StateCode";
ddlCorrAdrState.DataBind();
ddlCorrAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
ddlPermAdrState.DataSource = dt;
ddlPermAdrState.DataTextField = "StateName";
ddlPermAdrState.DataValueField = "StateCode";
ddlPermAdrState.DataBind();
ddlPermAdrState.Items.Insert(0, new ListItem("Select a State", "Select a State"));
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CustomerNonIndividualAdd.ascx:BindDropDowns()");
object[] objects = new object[2];
objects[0] = path;
objects[1] = dt;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
/// <summary>
/// Binds all the Dropdowns with the necessary data
/// </summary>
private void BindDropDowns(string path)
{
userVo = (UserVo)Session["userVo"];
customerVo = (CustomerVo)Session["CustomerVo"];
portfolioId = int.Parse(Session[SessionContents.PortfolioId].ToString());
//Bind the Systematic Transaction Types to dropdown
dtSystematicTransactionType = XMLBo.GetSystematicTransactionType(path);
ddlSystematicType.DataSource = dtSystematicTransactionType;
ddlSystematicType.DataTextField = "SystematicType";
ddlSystematicType.DataValueField = "SystemationTypeCode";
ddlSystematicType.DataBind();
ddlSystematicType.Items.Insert(0, "Select a Transaction Type");
// Bind the Frequency to dropdown
dtFrequency = assetBo.GetFrequencyCode(path);
ddlFrequency.DataSource = dtFrequency;
ddlFrequency.DataTextField = "Frequency";
ddlFrequency.DataValueField = "FrequencyCode";
ddlFrequency.DataBind();
ddlFrequency.Items.Insert(0, "Select Frequency");
//Bind the Customer Account Details to dropdown
if (schemePlanCode != 0)
{
dsCustomerMFAccounts = customerAccountBo.GetCustomerMFAccounts(portfolioId, AssetGroupCode, schemePlanCode);
}
else
{
dsCustomerMFAccounts = customerAccountBo.GetCustomerMFAccounts(portfolioId, AssetGroupCode, 0);
}
ddlMFAccount.DataSource = dsCustomerMFAccounts.Tables[0];
ddlMFAccount.DataTextField = "CMFA_FolioNum";
ddlMFAccount.DataValueField = "CMFA_AccountId";
ddlMFAccount.DataBind();
ddlMFAccount.Items.Insert(0, "Select a Folio");
}
protected void rbtnNonIndividual_CheckedChanged(object sender, EventArgs e)
{
try
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "NIND");
ddlCustomerSubType.DataSource = dtCustomerSubType;
ddlCustomerSubType.DataTextField = "CustomerTypeName";
ddlCustomerSubType.DataValueField = "CustomerSubTypeCode";
ddlCustomerSubType.DataBind();
ddlCustomerSubType.Items.Insert(0, new ListItem("Select", "Select"));
ddlAdviserBranchList.Items.Clear();
ddlAdviseRMList.Items.Clear();
BindListBranch();
BindRMforBranchDropdown(0, 0);
//ddlAdviserBranchList.EnableViewState = false;
trIndividualName.Visible = false;
trNonIndividualName.Visible = true;
trSalutation.Visible = false;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CustomerType.ascx:rbtnNonIndividual_CheckedChanged()");
object[] objects = new object[1];
objects[0] = path;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindSubTypeDropDown()
{
try
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "IND");
ddlCustomerSubType.DataSource = dtCustomerSubType;
ddlCustomerSubType.DataTextField = "CustomerTypeName";
ddlCustomerSubType.DataValueField = "CustomerSubTypeCode";
ddlCustomerSubType.DataBind();
ddlCustomerSubType.Items.Insert(0, new ListItem("Select", "Select"));
//txtFirstName.Visible = true;
//txtMiddleName.Visible = true;
//txtLastName.Visible = true;
//lblName.Visible = true;
//txtCompanyName.Visible = false;
//lblCompanyName.Visible = false;
trIndividualName.Visible = true;
trNonIndividualName.Visible = false;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CustomerType.ascx:rbtnIndividual_CheckedChanged()");
object[] objects = new object[1];
objects[0] = path;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void LoadBrokerCode()
{
ProductEquityBo productEquityBo = new ProductEquityBo();
try
{
DataTable dt = productEquityBo.GetBrokerCode(portfolioId, ddlTradeAcc.SelectedItem.Text.ToString());
if (dt.Rows[0]["XB_BrokerCode"].ToString() != "")
{
txtBroker.Text = XMLBo.GetBrokerName(path, dt.Rows[0]["XB_BrokerCode"].ToString());
txtBroker.Enabled = false;
}
else
{
txtBroker.Text = "";
txtBroker.Enabled = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EquityManualSingleTransaction.ascx:LoadBrokerCode()");
object[] objects = new object[2];
objects[0] = path;
objects[1] = portfolioId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindDropDowns(string path)
{
AdvisorVo advisorVo = new AdvisorVo();
try
{
dtState = commonLookupBo.GetWERPLookupMasterValueList(14000, 0);
ddlCorrAdrState.DataSource = dtState;
ddlCorrAdrState.DataTextField = "WCMV_Name";
ddlCorrAdrState.DataValueField = "WCMV_LookupId";
ddlCorrAdrState.DataBind();
ddlCorrAdrState.Items.Insert(0, new ListItem("--SELECT--", "0"));
ddlPermAdrState.DataSource = dtState;
ddlPermAdrState.DataTextField = "WCMV_Name";
ddlPermAdrState.DataValueField = "WCMV_LookupId";
ddlPermAdrState.DataBind();
ddlPermAdrState.Items.Insert(0, new ListItem("--SELECT--", "0"));
dtOccupation = commonLookupBo.GetWERPLookupMasterValueList(3000, 0);
ddlOccupation.DataSource = dtOccupation;
ddlOccupation.DataTextField = "WCMV_Name";
ddlOccupation.DataValueField = "WCMV_LookupId";
ddlOccupation.DataBind();
ddlOccupation.Items.Insert(0, new ListItem("--SELECT--", "0"));
dtNationality = XMLBo.GetNationality(path);
ddlNationality.DataSource = dtNationality;
ddlNationality.DataTextField = "Nationality";
ddlNationality.DataValueField = "NationalityCode";
ddlNationality.DataBind();
ddlNationality.Items.Insert(0, new ListItem("Select a Nationality", "Select a Nationality"));
dtCity = commonLookupBo.GetWERPLookupMasterValueList(8000, 0);
ddlCorrAdrCity.DataSource = dtCity;
ddlCorrAdrCity.DataTextField = "WCMV_Name";
ddlCorrAdrCity.DataValueField = "WCMV_LookupId";
ddlCorrAdrCity.DataBind();
ddlCorrAdrCity.Items.Insert(0, new ListItem("--SELECT--", "0"));
ddlPermAdrCity.DataSource = dtCity;
ddlPermAdrCity.DataTextField = "WCMV_Name";
ddlPermAdrCity.DataValueField = "WCMV_LookupId";
ddlPermAdrCity.DataBind();
ddlPermAdrCity.Items.Insert(0, new ListItem("--SELECT--", "0"));
if (customerVo.Type == null || customerVo.Type.ToUpper().ToString() == "IND")
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "IND");
}
else
{
dtCustomerSubType = XMLBo.GetCustomerSubType(path, "NIND");
}
//ddlCustomerSubType.DataSource = dtCustomerSubType;
//ddlCustomerSubType.DataTextField = "CustomerTypeName";
//ddlCustomerSubType.DataValueField = "CustomerSubTypeCode";
//ddlCustomerSubType.DataBind();
//ddlCustomerSubType.SelectedValue = customerVo.SubType;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "EditCustomerIndividualProfile.ascx:BindDropDowns()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void LoadPropertyGrid(int portfolioId)
{
List <PropertyVo> propertyList = new List <PropertyVo>();
try
{
string path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
int count;
propertyList = propertyBo.GetPropertyPortfolio(portfolioId, mypager.CurrentPage, hdnSort.Value, out count);
if (count > 0)
{
lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
tblPager.Visible = true;
}
if (propertyList != null)
{
lblMsg.Visible = false;
DataTable dtProperty = new DataTable();
//dtProperty.Columns.Add("SI.No");
dtProperty.Columns.Add("PropertyId");
dtProperty.Columns.Add("Sub Category");
dtProperty.Columns.Add("Particulars");
dtProperty.Columns.Add("City");
dtProperty.Columns.Add("Area");
dtProperty.Columns.Add("Measurement Unit");
dtProperty.Columns.Add("Purchase Date");
dtProperty.Columns.Add("Purchase Cost");
dtProperty.Columns.Add("Current Value");
DataRow drProperty;
for (int i = 0; i < propertyList.Count; i++)
{
drProperty = dtProperty.NewRow();
propertyVo = new PropertyVo();
propertyVo = propertyList[i];
//drProperty[0] = (i + 1).ToString();
drProperty[0] = propertyVo.PropertyId.ToString();
drProperty[1] = propertyVo.AssetSubCategoryName.ToString();
drProperty[2] = propertyVo.Name.ToString();
drProperty[3] = propertyVo.PropertyCity.ToString();
drProperty[4] = propertyVo.Quantity.ToString("f0");
drProperty[5] = XMLBo.GetMeasureCodeName(path, propertyVo.MeasureCode.ToString());
if (propertyVo.PurchaseDate != DateTime.MinValue)
{
drProperty[6] = propertyVo.PurchaseDate.ToString("dd/MM/yyyy");
}
else
{
drProperty[6] = string.Empty;
}
drProperty[7] = propertyVo.PurchaseValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
drProperty[8] = propertyVo.CurrentValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
dtProperty.Rows.Add(drProperty);
}
gvrProperty.DataSource = dtProperty;
gvrProperty.DataBind();
this.GetPageCount();
}
else
{
lblMsg.Visible = true;
gvrProperty.DataSource = null;
gvrProperty.DataBind();
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "PortfolioProperty.ascx:LoadPropertyGrid()");
object[] objects = new object[2];
objects[0] = propertyVo;
objects[1] = propertyList;
FunctionInfo = exBase.AddObject(FunctionInfo, null);/*, objects*/
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void BindReptReportDashBoard()
{
// dtReportTreeNode = XMLBo.GetUploadTreeNode(path);
DataSet dsTreeNodes = new DataSet();
DataTable dtRoleAssociationTreeNode = new DataTable();
//string expression = "NodeType = 'Reports'";
//dtReportTreeNode.DefaultView.RowFilter = expression;
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
dtRoleAssociationTreeNode = XMLBo.GetRoleAssociationTreeNode(path);
DataRow[] drXmlTreeSubSubNode;
DataRow[] drXmlRoleToTreeSubSubNode;
DataRow drReportTreeNode;
DataTable dtReportTreeNode = new DataTable();
dtReportTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtReportTreeNode.Columns.Add("TreeNodeText1", typeof(String));
dtReportTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtReportTreeNode.Columns.Add("TreeNodeText2", typeof(String));
if (advisorVo.advisorId == Convert.ToInt32(ConfigurationSettings.AppSettings["ONLINE_ADVISER"]))
{
}
//For upload 2009 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2010;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drReportTreeNode = dtReportTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
int roleCount = 0;
drXmlRoleToTreeSubSubNode = dtRoleAssociationTreeNode.Select("TreeSubSubNodeCode=" + drSubSubNode["TreeSubSubNodeCode"].ToString());
if (drXmlRoleToTreeSubSubNode.Count() > 0)
{
foreach (DataRow drUserRole in drXmlRoleToTreeSubSubNode)
{
if (int.Parse(drUserRole["UserRoleId"].ToString()) == roleId)
{
roleCount++;
break;
}
}
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drReportTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drReportTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
dtReportTreeNode.Rows.Add(drReportTreeNode);
}
else if (count == 1)
{
count++;
drReportTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drReportTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
count = 0;
drReportTreeNode = dtReportTreeNode.NewRow();
}
}
else
{
// break;
}
}
rptReportTree.DataSource = dtReportTreeNode;
rptReportTree.DataBind();
}
private void BindReptHoldingsDashBoard()
{
DataSet dsTreeNodes = new DataSet();
dsTreeNodes = XMLBo.GetSuperAdminTreeNodes(path);
DataRow[] drXmlTreeSubSubNode;
DataRow drHoldingsTreeNode;
DataTable dtHoldingsTreeNode = new DataTable();
dtHoldingsTreeNode.Columns.Add("TreeNode1", typeof(Int32));
dtHoldingsTreeNode.Columns.Add("TreeNodeText1", typeof(String));
dtHoldingsTreeNode.Columns.Add("TreeNode2", typeof(Int32));
dtHoldingsTreeNode.Columns.Add("TreeNodeText2", typeof(String));
//For holding dashboard 2013 is Tree Node Id in Sub Table in XML...
int treeSubNodeId = 2013;
drXmlTreeSubSubNode = dsTreeNodes.Tables[2].Select("TreeSubNodeCode=" + treeSubNodeId.ToString());
int count = 0;
drHoldingsTreeNode = dtHoldingsTreeNode.NewRow();
foreach (DataRow drSubSubNode in drXmlTreeSubSubNode)
{
int roleCount = 0;
if ((roleId == 1001 || roleId == 1002) && (drSubSubNode["TreeSubSubNodeCode"].ToString() == "3021" || drSubSubNode["TreeSubSubNodeCode"].ToString() == "3022" || drSubSubNode["TreeSubSubNodeCode"].ToString() == "3023"))
{
roleCount = 0;
}
else
{
roleCount++;
}
if (roleCount > 0)
{
if (count == 0)
{
count++;
drHoldingsTreeNode["TreeNode1"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drHoldingsTreeNode["TreeNodeText1"] = drSubSubNode["TreeSubSubNodeText"].ToString();
dtHoldingsTreeNode.Rows.Add(drHoldingsTreeNode);
}
else if (count == 1)
{
count++;
drHoldingsTreeNode["TreeNode2"] = drSubSubNode["TreeSubSubNodeCode"].ToString();
drHoldingsTreeNode["TreeNodeText2"] = drSubSubNode["TreeSubSubNodeText"].ToString();
count = 0;
drHoldingsTreeNode = dtHoldingsTreeNode.NewRow();
}
}
if (roleId == 1009)
{
break;
}
}
rptHoldingTree.DataSource = dtHoldingsTreeNode;
rptHoldingTree.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SessionBo.CheckSession();
userVo = (UserVo)Session[SessionContents.UserVo];
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
try
{
// customerFamilyList = new List<CustomerFamilyVo>();
customerVo = (CustomerVo)Session["CustomerVo"];
rmVo = (RMVo)Session["RmVo"];
customerId = customerVo.CustomerId;
StringBuilder sbAddress = new StringBuilder();
lblName.Text = customerVo.FirstName.ToString() + " " + customerVo.MiddleName.ToString() + " " + customerVo.LastName.ToString();
lblPhone.Text = customerVo.ResISDCode.ToString() + " - " + customerVo.ResSTDCode.ToString() + " - " + customerVo.ResPhoneNum.ToString();
lblEmail.Text = customerVo.Email.ToString();
sbAddress.Append(customerVo.Adr1Line1.ToString());
sbAddress.Append("<br />");
sbAddress.Append(customerVo.Adr1Line2.ToString());
sbAddress.Append("<br />");
sbAddress.Append(customerVo.Adr1Line3.ToString());
sbAddress.Append("<br />");
sbAddress.Append(customerVo.Adr1PinCode.ToString());
sbAddress.Append("<br />");
if (customerVo.Adr1State.ToString() != "")
{
sbAddress.Append(XMLBo.GetStateName(path, customerVo.Adr1State.ToString()));
sbAddress.Append("<br />");
}
sbAddress.Append(customerVo.Adr1City.ToString());
sbAddress.Append("<br />");
sbAddress.Append(customerVo.Adr1Country.ToString());
lblAddress.Text = sbAddress.ToString();
Session["RmVo"] = rmVo;
// Session["CustomerVo"] = customerVo;
Session["Check"] = "Dashboard";
//Binding the Customer Family Grid
customerFamilyList = customerFamilyBo.GetCustomerFamily(customerVo.CustomerId);
if (customerFamilyList == null)
{
tdFamilyDetailsHeader.Visible = false;
tdFamilyDetailsGrid.Visible = false;
}
else
{
DataTable dtCustomerFamilyList = new DataTable();
dtCustomerFamilyList.Columns.Add("CustomerId");
dtCustomerFamilyList.Columns.Add("Name");
dtCustomerFamilyList.Columns.Add("Relationship");
DataRow drCustomerFamily;
for (int i = 0; i < customerFamilyList.Count; i++)
{
drCustomerFamily = dtCustomerFamilyList.NewRow();
CustomerFamilyVo customerFamilyVo = new CustomerFamilyVo();
customerFamilyVo = customerFamilyList[i];
drCustomerFamily[0] = customerFamilyVo.AssociateCustomerId.ToString();
drCustomerFamily[1] = customerFamilyVo.AssociateCustomerName.ToString();
drCustomerFamily[2] = customerFamilyVo.Relationship;
dtCustomerFamilyList.Rows.Add(drCustomerFamily);
}
if (dtCustomerFamilyList.Rows.Count > 0)
{
gvFamilyMembers.DataSource = dtCustomerFamilyList;
gvFamilyMembers.DataBind();
gvFamilyMembers.Visible = true;
}
else
{
gvFamilyMembers.DataSource = null;
gvFamilyMembers.DataBind();
}
}
//Call the function to bind the Bank Details
lblBankDetailsMsg.Visible = false;
BindBankDetails();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RMCustomerDashboard.ascx:Page_Load()");
object[] objects = new object[4];
objects[0] = customerFamilyList;
objects[1] = rmVo;
objects[2] = customerVo;
objects[3] = userVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SessionBo.CheckSession();
path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString());
customerVo = (CustomerVo)Session["CustomerVo"];
customerId = customerVo.CustomerId;
customerBankAccId = int.Parse(Session["CustBankAccId"].ToString());
customerBankAccountVo = customerBankAccountBo.GetCustomerBankAccount(customerId, customerBankAccId);
lblAccNum.Text = customerBankAccountVo.BankAccountNum.ToString();
//lblAccType.Text = customerBankAccountVo.AccountType;
if (customerBankAccountVo.AccountType == "CC")
{
lblAccType.Text = "C.C.";
}
if (customerBankAccountVo.AccountType == "CR")
{
lblAccType.Text = "Current";
}
if (customerBankAccountVo.AccountType == "FR")
{
lblAccType.Text = "F.C.N.R.";
}
if (customerBankAccountVo.AccountType == "NE")
{
lblAccType.Text = "NRE";
}
if (customerBankAccountVo.AccountType == "NO")
{
lblAccType.Text = "NRO";
}
if (customerBankAccountVo.AccountType == "OD")
{
lblAccType.Text = "O.D.";
}
if (customerBankAccountVo.AccountType == "SV")
{
lblAccType.Text = "Savings";
}
if (customerBankAccountVo.AccountType == "OT")
{
lblAccType.Text = "Other";
}
if (customerBankAccountVo.AccountType == "TBC")
{
lblAccType.Text = "To Be Categorized";
}
//lblAccType.Text = XMLBo.GetBankAccountTypes(path, customerBankAccountVo.AccountType);
if (customerBankAccountVo.ModeOfOperation == "SO")
{
lblModeOfOperation.Text = "Self Only";
}
if (customerBankAccountVo.ModeOfOperation == "SI")
{
lblModeOfOperation.Text = "Singly";
}
if (customerBankAccountVo.ModeOfOperation == "SE")
{
lblModeOfOperation.Text = "Severaly";
}
if (customerBankAccountVo.ModeOfOperation == "JO")
{
lblModeOfOperation.Text = "Jointly";
}
if (customerBankAccountVo.ModeOfOperation == "AS")
{
lblModeOfOperation.Text = "Anyone or Survivor";
}
if (customerBankAccountVo.ModeOfOperation == "BR")
{
lblModeOfOperation.Text = "As per Board Resolution";
}
if (customerBankAccountVo.ModeOfOperation == "ES")
{
lblModeOfOperation.Text = "Either or Survivor";
}
if (customerBankAccountVo.ModeOfOperation == "FS")
{
lblModeOfOperation.Text = "Former or Survivor";
}
if (customerBankAccountVo.ModeOfOperation == "TBC")
{
lblModeOfOperation.Text = "To Be Categorized";
}
//lblModeOfOperation.Text = customerBankAccountVo.ModeOfOperation;
lblBankName.Text = customerBankAccountVo.BankName.ToString();
lblBranchName.Text = customerBankAccountVo.BranchName.ToString();
lblLine1.Text = customerBankAccountVo.BranchAdrLine1.ToString();
lblLine2.Text = customerBankAccountVo.BranchAdrLine2.ToString();
lblLine3.Text = customerBankAccountVo.BranchAdrLine3.ToString();
lblPinCode.Text = customerBankAccountVo.BranchAdrPinCode.ToString();
lblCity.Text = customerBankAccountVo.BranchAdrCity.ToString();
lblIfsc.Text = customerBankAccountVo.IFSC.ToString();
lblMicr.Text = customerBankAccountVo.MICR.ToString();
state = XMLBo.GetStateName(path, customerBankAccountVo.BranchAdrState);
lblState.Text = state;
lblCountry.Text = customerBankAccountVo.BranchAdrCountry;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewCustomerAllBankDetails.ascx:PageLoad()");
object[] objects = new object[3];
objects[0] = customerBankAccId;
objects[1] = customerBankAccountVo;
objects[2] = customerId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}