protected void RadToolBar2_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { switch (e.Item.Value) { case "Insert": ReportBind(); break; case "Delete": PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); System.Collections.Specialized.IOrderedDictionary[] dataIDs = Grid1.GetSelectedRowsKeys(); List <TB_EAI_PowerBIReport> Datas = new List <TB_EAI_PowerBIReport>(); if (dataIDs.Length > 0) { for (int i = 0; i < dataIDs.Length; i++) { Datas.Add( new TB_EAI_PowerBIReport { ApplicationID = dataIDs[i]["ApplicationID"].ToString(), WorkSpaceID = dataIDs[i]["WorkSpaceID"].ToString(), ReportID = dataIDs[i]["ReportID"].ToString() }); } if (UCO.DeleteTB_EAI_PowerBIReport(Datas)) { ReportBind(); } } break; } }
private void ApplicatoinBind() { PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); TB_EAI_PowerBIApplication Data = UCO.GetTB_EAI_PowerBIApplication(); if (Data != null) { hfApplicationID.Value = Data.ApplicationID; txtApplicationID.Text = Data.ApplicationID; txtApplicationDesc.Text = Data.ApplicationDesc; txtUserName.Text = Data.UserName; txtPassword.Text = Data.Password; txtAuthorityUrl.Text = Data.AuthorityUrl.Replace("https://login.microsoftonline.com/", "").Replace("/", ""); lblAuthorityUrl2.Text = Data.AuthorityUrl; txtResourceUrl.Text = Data.ResourceUrl; txtApiUrl.Text = Data.ApiUrl; } else { hfApplicationID.Value = ""; txtApplicationID.Text = ""; txtApplicationDesc.Text = ""; txtUserName.Text = ""; txtPassword.Text = ""; txtAuthorityUrl.Text = ""; lblAuthorityUrl2.Text = "https://login.microsoftonline.com//"; txtResourceUrl.Text = "https://analysis.windows.net/powerbi/api"; txtApiUrl.Text = "https://api.powerbi.com/"; } }
private async Task GetReport() { PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); TB_EAI_PowerBIApplication App = UCO.GetTB_EAI_PowerBIApplication(); TB_EAI_PowerBIReport Report = UCO.GetTB_EAI_PowerBIReportOne(new TB_EAI_PowerBIReport() { ApplicationID = App.ApplicationID, ReportNO = Request["Report"] }); await this._embedService.EmbedReport( "", Report.WorkSpaceID, Report.ReportID, App.AuthorityUrl, App.ResourceUrl, Report.ApplicationID, App.ApiUrl, App.UserName, App.Password); ScriptManager.RegisterStartupScript( this.Page , this.Page.GetType() , Guid.NewGuid().ToString() , string.Format("onSuccess('{0}','{1}','{2}');" , this._embedService.EmbedConfig.EmbedToken.Token , this._embedService.EmbedConfig.EmbedUrl , this._embedService.EmbedConfig.Id) , true); }
private void ReportBind() { PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); DataTable dt = UCO.GetTB_EAI_PowerBIReport(); string sort = (string)ViewState["Sort1"]; dt.DefaultView.Sort = string.IsNullOrEmpty(sort) ? "ReportNO" : sort; Grid1.DataSource = dt; Grid1.DataBind(); }
protected void RadToolBar1_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e) { PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); switch (e.Item.Value) { case "Save": if (UCO.UploadApplicationID(hfApplicationID.Value, txtApplicationID.Text.Trim())) { lblAuthorityUrl2.Text = "https://login.microsoftonline.com/" + txtAuthorityUrl.Text + "/"; if (UCO.SaveTB_EAI_PowerBIApplication( new TB_EAI_PowerBIApplication() { ApplicationID = txtApplicationID.Text.Trim(), ApplicationDesc = txtApplicationDesc.Text.Trim(), UserName = txtUserName.Text.Trim(), Password = txtPassword.Text.Trim(), ApiUrl = txtApiUrl.Text.Trim(), ResourceUrl = txtResourceUrl.Text.Trim(), AuthorityUrl = lblAuthorityUrl2.Text.Trim() } , hfApplicationID.Value == "")) { ScriptManager.RegisterStartupScript( this.Page , this.Page.GetType() , Guid.NewGuid().ToString() , "alert('" + lblSaveSuccess.Text + "');" , true); ApplicatoinBind(); } else { ScriptManager.RegisterStartupScript( this.Page , this.Page.GetType() , Guid.NewGuid().ToString() , "alert('" + lblSaveError.Text + "');" , true); } } break; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // 系統管理者 PowerBI查閱者 if (!new BaseUCO().IsUserInRoles(new[] { "SystemAdmin", "PowerBIUser" })) { Response.Redirect("~/Default.aspx"); } PowerBIMaintainUCO UCO = new PowerBIMaintainUCO(); TB_EAI_PowerBIReport Report = UCO.GetTB_EAI_PowerBIReportOne(new TB_EAI_PowerBIReport() { ReportNO = Request["Report"] }); AddSiteMapNode("我的首頁", "~/Homepage.aspx"); AddSiteMapNode("大數據分析"); AddSiteMapNode("大數據分析"); AddSiteMapNode(Report.ReportDesc, "~/CDS/PowerBI/Setting/PowerBIReport.aspx?Report=" + Report.ReportNO); Page.RegisterAsyncTask(new PageAsyncTask(GetReport)); } }