private void GetAdviserLinkData() { DataTable dtBindLinks = new DataTable(); DataRow drAdvisorLinks; dtBindLinks.Columns.Add("AL_LinkId"); dtBindLinks.Columns.Add("A_AdviserId"); dtBindLinks.Columns.Add("XLU_LinkUserCode"); dtBindLinks.Columns.Add("XLTY_LinkTypeCode"); dtBindLinks.Columns.Add("WLM_Link"); dtBindLinks.Columns.Add("AL_LinkImagePath"); dtBindLinks.Columns.Add("WLM_AltLinkName"); if (userVo.UserType == "Customer") { linkUserId = 2; } else { linkUserId = 1; } AOTALVo.advisorId = advisorVo.advisorId; AOTALVo.AMCLinkTypeCode = linkTypeId; AOTALVo.AMCLinkUserCode = linkUserId; adviserOTALink = advisorBo.GetAdviserOnlineTransactionAMCLinks(AOTALVo); if (adviserOTALink != null) { msgNoRecords.Visible = false; for (int i = 1; i <= adviserOTALink.Count; i++) { AOTALVo = new AdviserOnlineTransactionAMCLinksVo(); AOTALVo = adviserOTALink[i - 1]; drAdvisorLinks = dtBindLinks.NewRow(); drAdvisorLinks[0] = AOTALVo.AMCLinkId; drAdvisorLinks[1] = AOTALVo.advisorId; drAdvisorLinks[2] = AOTALVo.AMCLinkUserCode; drAdvisorLinks[3] = AOTALVo.AMCLinkTypeCode; drAdvisorLinks[4] = AOTALVo.AMCLinks; drAdvisorLinks[5] = "~/Images/" + AOTALVo.AMCImagePath; drAdvisorLinks[6] = AOTALVo.AltLinkName; dtBindLinks.Rows.Add(drAdvisorLinks); } if (dtBindLinks.Rows.Count > 0) { gvAdviserLinks.DataSource = dtBindLinks; gvAdviserLinks.DataBind(); //HyperLink HpLink = (HyperLink)gvAdviserLinks.HeaderRow.FindControl("hlAMCLinkImages"); //HpLink.ImageUrl = "Images/" + dtBindLinks.; } } else { gvAdviserLinks.DataSource = null; msgNoRecords.Visible = true; msgNoRecords.InnerText = "No Links available for this adviser.."; } }
private void GetAdviserLinkData() { DataTable dtBindLinks = new DataTable(); DataRow drAdvisorLinks; dtBindLinks.Columns.Add("AL_LinkId"); dtBindLinks.Columns.Add("A_AdviserId"); dtBindLinks.Columns.Add("XLU_LinkUserCode"); dtBindLinks.Columns.Add("XLTY_LinkTypeCode"); dtBindLinks.Columns.Add("AL_LinkWithPin"); dtBindLinks.Columns.Add("WLM_LinkImagePath"); dtBindLinks.Columns.Add("WLM_Id"); dtBindLinks.Columns.Add("AL_LinkWithOutPin"); if (Session[SessionContents.CustomerVo] != null) { linkUserId = 2; } else { linkUserId = 1; } AOTALVo.advisorId = advisorVo.advisorId; AOTALVo.AMCLinkTypeCode = linkTypeId; AOTALVo.AMCLinkUserCode = linkUserId; adviserOTALink = advisorBo.GetAdviserOnlineTransactionAMCLinks(AOTALVo); int tempId = 0; if (adviserOTALink != null && adviserOTALink.Count > 0) { msgNoRecords.Visible = false; //tempId = adviserOTALink[0].WerpMasterlinkId; for (int i = 1; i <= adviserOTALink.Count; i++) { AOTALVo = new AdviserOnlineTransactionAMCLinksVo(); AOTALVo = adviserOTALink[i - 1]; if (tempId != AOTALVo.WerpMasterlinkId) { drAdvisorLinks = dtBindLinks.NewRow(); drAdvisorLinks["AL_LinkId"] = AOTALVo.AMCLinkId; drAdvisorLinks["A_AdviserId"] = AOTALVo.advisorId; drAdvisorLinks["XLU_LinkUserCode"] = AOTALVo.AMCLinkUserCode; drAdvisorLinks["XLTY_LinkTypeCode"] = AOTALVo.AMCLinkTypeCode; drAdvisorLinks["WLM_Id"] = AOTALVo.WerpMasterlinkId; drAdvisorLinks["WLM_LinkImagePath"] = "~/Images/" + AOTALVo.AMCImagePath; if (AOTALVo.IsAMCLinksWithPin == 0) { if (!string.IsNullOrEmpty(AOTALVo.ExternalLinkCode) && AOTALVo.ExternalLinkCode == "TPSL") { drAdvisorLinks["AL_LinkWithOutPin"] = AOTALVo.AMCLinks + "&txtUserID=" + customerVo.CustomerId.ToString(); } else { drAdvisorLinks["AL_LinkWithOutPin"] = AOTALVo.AMCLinks; } drAdvisorLinks["AL_LinkWithPin"] = String.Empty; } else { drAdvisorLinks["AL_LinkWithPin"] = AOTALVo.AMCLinks; drAdvisorLinks["AL_LinkWithOutPin"] = String.Empty; } dtBindLinks.Rows.Add(drAdvisorLinks); tempId = AOTALVo.WerpMasterlinkId; } else if (tempId == AOTALVo.WerpMasterlinkId) { if (AOTALVo.IsAMCLinksWithPin == 1) { dtBindLinks.Rows[dtBindLinks.Rows.Count - 1]["AL_LinkWithPin"] = AOTALVo.AMCLinks; } else { dtBindLinks.Rows[dtBindLinks.Rows.Count - 1]["AL_LinkWithOutPin"] = AOTALVo.AMCLinks; } } } if (dtBindLinks.Rows.Count > 0) { gvAdviserLinks.DataSource = dtBindLinks; gvAdviserLinks.DataBind(); //HyperLink HpLink = (HyperLink)gvAdviserLinks.HeaderRow.FindControl("hlAMCLinkImages"); //HpLink.ImageUrl = "Images/" + dtBindLinks.; } } else { gvAdviserLinks.DataSource = null; msgNoRecords.Visible = true; msgNoRecords.InnerText = "No Links available for this adviser.."; } }