public Dashboard PowerBIDetails(Dashboard board, User user)
{
string url = WebConfigurationManager.AppSettings["ReportingServerURL"];
board.PowerBiModelList = new List <PowerBiModel>();
//Get KPIs
PowerBIReportsApi pwBi = new PowerBIReportsApi(IO.Swagger.Client.Configuration.DefaultApiClient);
var power = pwBi.GetPowerBIReportsString(0, 0, "", "", "", "", user.Username, user.Password, url);
JObject jObject = JObject.Parse(power);
board.PowerBiCount = ((Newtonsoft.Json.Linq.JContainer)jObject.Last.Last).Count;
if (((Newtonsoft.Json.Linq.JContainer)jObject.Last.Last).Count > 0)
{
foreach (var item in ((Newtonsoft.Json.Linq.JContainer)jObject.Last.Last).ToList())
{
PowerBiModel model = new PowerBiModel();
var startIndex = item.ToString().IndexOf("Name");
startIndex = startIndex + 8;
var endINdex = item.ToString().IndexOf("Description");
endINdex = endINdex - 7;
model.Name = item.ToString().Substring(startIndex, (endINdex - startIndex));
board.PowerBiModelList.Add(model);
}
}
return(board);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
List <PowerBiModel> reportsList = new List <PowerBiModel>();
var devToken = PowerBIToken.CreateReportEmbedTokenWithScopes(workspaceCollection, workspaceId);
using (var client = this.CreatePowerBIClient(devToken))
{
var reportsResponse = client.Reports.GetReports(workspaceCollection, workspaceId);
for (int i = 0; i < reportsResponse.Value.ToList().Count; i++)
{
reportsList.Add(new PowerBiModel
{
Id = reportsResponse.Value[i].Id,
Name = reportsResponse.Value[i].Name,
EmbedUrl = reportsResponse.Value[i].EmbedUrl,
WebUrl = reportsResponse.Value[i].WebUrl,
//Report = reportsResponse.Value[i].
}
);
}
}
var reportId = reportsList[0].Id;
using (var client = this.CreatePowerBIClient(devToken))
{
var embedToken = PowerBIToken.CreateReportEmbedToken(workspaceCollection, workspaceId, reportId);
var viewModel = new PowerBiModel
{
Report = reportsList[0].Report,
AccessToken = embedToken.Generate(accessKey)
};
accessTokenText.Value = viewModel.AccessToken;
embedUrlText.Value = viewModel.EmbedUrl;
}
}
}
public ActionResult Index()
{
if (CheckUserSession())
{
_dbService = new DashboardService();
Dashboard board = new Dashboard();
board = _dbService.KpiDetails(board, (Models.User)Session["user"]);
//Get PowerBiReports
//board = _dbService.PowerBIDetails(board, (Models.User)Session["user"]);
//Get Reports
board = _dbService.SSRSReportDetails(board, (Models.User)Session["user"]);
ReportingService2010 rs = new ReportingService2010();
Models.User user = (Models.User)Session["user"];
string url = WebConfigurationManager.AppSettings["ReportingServerURL"];
rs.Credentials = new System.Net.NetworkCredential(user.Username, user.Password, url);
var items = rs.ListChildren("/", true);
board.PowerBiModelList = new List <PowerBiModel>();
int pcnt = 0;
for (var i = 0; i < items.Length; i++)
{
if (items[i].TypeName.Equals("PowerBIReport"))
{//Report Kpi
PowerBiModel pbi = new PowerBiModel();
pbi.Name = items[i].Name;
board.PowerBiModelList.Add(pbi);
pcnt++;
}
}
board.PowerBiCount = pcnt;
return(View(board));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Index(string cfd = "")
{
if (CheckUserSession())
{
this.InitialFunc();
ViewBag.folders = _folders;
ViewBag.current_folder = cfd;
if (cfd.Equals("") && _folders.Count > 0)
{
ViewBag.current_folder = _folders[0];
}
_dbService = new DashboardService();
Dashboard board = new Dashboard();
board = _dbService.KpiDetails(board, (Models.User)Session["user"]);
//Get PowerBiReports
//board = _dbService.PowerBIDetails(board, (Models.User)Session["user"]);
//Get Reports
//board = _dbService.SSRSReportDetails(board, (Models.User)Session["user"]);
ReportingService2010 rs = new ReportingService2010();
Models.User user = (Models.User)Session["user"];
rs.Credentials = new System.Net.NetworkCredential(user.Username, user.Password, _url);
var items = rs.ListChildren("/" + ViewBag.current_folder, true); //Hoxworth Name Path
board.PowerBiModelList = new List <PowerBiModel>();
int pcnt = 0;
for (var i = 0; i < items.Length; i++)
{
if (items[i].TypeName.Equals("PowerBIReport"))
{//Report Kpi
PowerBiModel pbi = new PowerBiModel();
pbi.Name = items[i].Name;
board.PowerBiModelList.Add(pbi);
pcnt++;
}
}
board.PowerBiCount = pcnt;
board.ReportModelList = new List <ReportModel>();
pcnt = 0;
for (var i = 0; i < items.Length; i++)
{
if (items[i].TypeName.Equals("Report"))
{//Report Kpi
ReportModel pbi = new ReportModel();
pbi.Name = items[i].Name;
board.ReportModelList.Add(pbi);
pcnt++;
}
}
board.ReportCount = pcnt;
ViewBag.current_page = "index";
return(View(board));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public ActionResult Guide(string cfd = "", int rid = 0, string sch = "", string returnUrl = null)
{
if (CheckUserSession())
{
if (sch == null)
{
sch = "";
}
ViewData["ReturnUrl"] = returnUrl;
ViewData["ReturnMsg"] = "";
ViewData["ReturnCode"] = 0;
ViewBag.rid = rid;
ViewBag.sch = "";
ViewBag.cid = 0;
ViewBag.screenUrl = "";
string json = string.Empty;
//string ur = @"http://52.191.118.216:801/Guide/GetReports";
string ur = @"http://*****:*****@"http://52.191.118.216:801/Guide/GetReport?rid=" + rid;
ur = @"http://localhost:8801/Guide/GetReport?rid=" + rid;
request = (HttpWebRequest)WebRequest.Create(ur);
request.AutomaticDecompression = DecompressionMethods.GZip;
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader reader = new StreamReader(stream))
{
json = reader.ReadToEnd();
}
var modelreport = JsonConvert.DeserializeObject <Dictionary <string, object> >(json);
ViewBag.userList = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["userList"].ToString());
ViewBag.freqList = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["freqList"].ToString());
ViewBag.filterList = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["filterList"].ToString());
ViewBag.summaryList = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["summaryList"].ToString());
ViewBag.columnList = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["columnList"].ToString());
ViewBag.drill1List = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["drill1List"].ToString());
ViewBag.drill2List = JsonConvert.DeserializeObject <List <ReportInfo> >(modelreport["drill2List"].ToString());
this.InitialFunc();
ViewBag.folders = _folders;
ViewBag.current_folder = cfd;
if (cfd.Equals("") && _folders.Count > 0)
{
ViewBag.current_folder = _folders[0];
}
_dbService = new DashboardService();
Dashboard board = new Dashboard();
board = _dbService.KpiDetails(board, (Models.User)Session["user"]);
//Get PowerBiReports
//board = _dbService.PowerBIDetails(board, (Models.User)Session["user"]);
//Get Reports
//board = _dbService.SSRSReportDetails(board, (Models.User)Session["user"]);
ReportingService2010 rs = new ReportingService2010();
Models.User user = (Models.User)Session["user"];
rs.Credentials = new System.Net.NetworkCredential(user.Username, user.Password, _url);
var items = rs.ListChildren("/" + ViewBag.current_folder, true); //Hoxworth Name Path
board.PowerBiModelList = new List <PowerBiModel>();
int pcnt = 0;
for (var i = 0; i < items.Length; i++)
{
if (items[i].TypeName.Equals("PowerBIReport"))
{//Report Kpi
PowerBiModel pbi = new PowerBiModel();
pbi.Name = items[i].Name;
board.PowerBiModelList.Add(pbi);
pcnt++;
}
}
board.PowerBiCount = pcnt;
board.ReportModelList = new List <ReportModel>();
pcnt = 0;
for (var i = 0; i < items.Length; i++)
{
if (items[i].TypeName.Equals("Report"))
{//Report Kpi
ReportModel pbi = new ReportModel();
pbi.Name = items[i].Name;
board.ReportModelList.Add(pbi);
pcnt++;
}
}
board.ReportCount = pcnt;
ViewBag.current_page = "guide";
ViewBag.current_rid = rid;
return(View(board));
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
