private void BindAssociates(CustomerAccountsVo AccountVo)
{
DataTable dtJoinHolder = new DataTable();
DataTable dtJoinHolderGV = new DataTable();
DataTable dtNominees = new DataTable();
DataTable dtNomineesGV = new DataTable();
DataRow drJoinHolder;
DataRow drNominees;
try
{
dsCustomerAssociates = customerTransactionBo.GetMFFolioAccountAssociates(AccountVo.AccountId, customerVo.CustomerId);
dtJoinHolder = dsCustomerAssociates.Tables[0];
dtNominees = dsCustomerAssociates.Tables[1];
if (AccountVo.IsJointHolding == 1)
{
if (dtJoinHolder.Rows.Count > 0 && dtJoinHolder != null)
{
dtJoinHolderGV.Columns.Add("AssociateId");
dtJoinHolderGV.Columns.Add("Name");
dtJoinHolderGV.Columns.Add("Relationship");
dtJoinHolderGV.Columns.Add("Stat");
foreach (DataRow dr in dtJoinHolder.Rows)
{
drJoinHolder = dtJoinHolderGV.NewRow();
drJoinHolder[0] = dr["CA_AssociationId"].ToString();
drJoinHolder[1] = dr["NAME"].ToString();
drJoinHolder[2] = dr["XR_Relationship"].ToString();
drJoinHolder[3] = dr["Stat"].ToString();
dtJoinHolderGV.Rows.Add(drJoinHolder);
}
gvJoint2.DataSource = dtJoinHolderGV;
ViewState["JointHold"] = dtJoinHolderGV;
gvJoint2.DataBind();
gvJoint2.Visible = true;
//trJointHolders.Visible = true;
//trJointHoldersGrid.Visible = true;
gvJoint2.Columns[3].Visible = false;
trJoint2Header.Visible = true;
}
else
{
trJoint2Header.Visible = false;
}
}
if (dtNominees.Rows.Count > 0 && dtJoinHolder != null)
{
dtNomineesGV.Columns.Add("AssociateId");
dtNomineesGV.Columns.Add("Name");
dtNomineesGV.Columns.Add("Relationship");
dtNomineesGV.Columns.Add("Stat");
foreach (DataRow dr in dtNominees.Rows)
{
drNominees = dtNomineesGV.NewRow();
drNominees[0] = dr["CA_AssociationId"].ToString();
drNominees[1] = dr["NAME"].ToString();
drNominees[2] = dr["XR_Relationship"].ToString();
drNominees[3] = dr["Stat"].ToString();
dtNomineesGV.Rows.Add(drNominees);
}
ViewState["Nominees"] = dtNomineesGV;
gvNominee2.DataSource = dtNomineesGV;
gvNominee2.DataBind();
gvNominee2.Columns[3].Visible = false;
gvNominee2.Visible = true;
trNominee2Header.Visible = true;
}
else
{
trNominee2Header.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CustomerMFAccountAdd.ascx:BindAssociates()");
object[] objects = new object[1];
objects[0] = customerVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}