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));
}
}
