protected void addNewDashboard_Click(object sender, EventArgs e)
{
DataSet newIDDS = DashboardDataAccess.insertNewDashboard(userID, addDashboardName.Text);
int newID = (int)newIDDS.Tables[0].Rows[0]["newID"];
Response.Redirect("~/NewDashboard/DashboardTest.aspx?dashboardID=" + newID);
}
void deleteLink_Click(object sender, EventArgs e)
{
var link = ((LinkButton)sender);
int widgetOnDashboardID = int.Parse(link.CommandArgument);
DashboardDataAccess.deleteWidgetFromDB(widgetOnDashboardID);
Response.Redirect(Request.RawUrl);
}
protected void widgetModeNames_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList widgetModeNames = (DropDownList)sender;
int widgetOnDashboardID = int.Parse(widgetModeNames.ID.Split('_')[1]);
int modeID = int.Parse(widgetModeNames.SelectedValue);
DashboardDataAccess.updateWidgetOnDashboardMode(modeID, widgetOnDashboardID);
Response.Redirect(Request.RawUrl);
}
protected void btnUpdateSettings_Click(object sender, EventArgs e)
{
DashboardDataAccess.updateDashboardName(updateName.Text, dashBoardID);
if (setHome.Checked == true && home == false)
{
DashboardDataAccess.makeHomeDashboard(dashBoardID, userID);
}
Response.Redirect(Request.RawUrl);
}
public void updateWidgetSize(int widgetOnDashboardID, int height, int width)
{
DashboardDataAccess.updateWidgetSize(widgetOnDashboardID, height, width);
}
public void updateWidgetPosition(int widgetOnDashboardID, int top, int left)
{
DashboardDataAccess.updateWidgetPosition(widgetOnDashboardID, top, left);
}
protected void deleteDB_Click(object sender, EventArgs e)
{
DashboardDataAccess.deleteDashboard(dashBoardID);
Response.Redirect(Request.RawUrl);
}
protected void addWidgetButton_Click(object sender, EventArgs e)
{
DashboardDataAccess.addWidgetToDashboard(int.Parse(widgetsList.SelectedItem.Value), dashBoardID);
Response.Redirect(Request.RawUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
var user = (Orchestrator.Entities.CustomPrincipal)Page.User;
userID = user.IdentityId;
// Get list of dashboards
DataSet dashboardListDS = DashboardDataAccess.getDashboardsForUser(userID);
if (dashboardListDS.Tables[0].Rows.Count == 0)
{
var dsNewDash = DashboardDataAccess.insertNewDashboard(userID, "Home");
DashboardDataAccess.makeHomeDashboard(int.Parse(dsNewDash.Tables[0].Rows[0]["newID"].ToString()), userID);
dashboardListDS = DashboardDataAccess.getDashboardsForUser(userID);
}
dashboardList.DataSource = dashboardListDS.Tables[0];
dashboardList.DataValueField = dashboardListDS.Tables[0].Columns[0].ToString();
dashboardList.DataTextField = dashboardListDS.Tables[0].Columns[1].ToString();
DataSet dbWidgets;
if (!Page.IsPostBack)
{
dashboardList.DataBind();
}
//Get widgets on home dashboard
if (Request.QueryString["dashboardID"] == null)
{
DataSet dashBoardDetails = DashboardDataAccess.getHomeDashboardDetails(userID);
home = true;
dashBoardID = (int)dashBoardDetails.Tables[0].Rows[0]["dashboardId"];
dbWidgets = DashboardDataAccess.getDBWidgetsForDashboardID(dashBoardID, userID);
if (!Page.IsPostBack)
{
dashboardList.Items.FindByValue(dashBoardID.ToString()).Selected = true;
}
}
else
{
dashBoardID = int.Parse(Request.QueryString["dashboardID"]);
dbWidgets = DashboardDataAccess.getDBWidgetsForDashboardID(dashBoardID, userID);
if (dbWidgets.Tables.Count > 0)
{
if (dbWidgets.Tables[1].Rows.Count > 0)
{
if (!Page.IsPostBack)
{
updateName.Text = dbWidgets.Tables[1].Rows[0]["dashboardName"].ToString();
dashboardList.Items.FindByValue(dashBoardID.ToString()).Selected = true;
}
}
else
{
Response.Redirect("~/NewDashboard/DashboardTest.aspx");
}
}
}
if (DashboardDataAccess.homeDashboard(dashBoardID))
{
home = true;
deleteDB.Visible = false;
lblHomeDashboard.Text = "This is your home dashboard.";
setHome.Visible = false;
}
DataSet widgetListDS = DashboardDataAccess.getWidgetsNotOnDBForDBID(dashBoardID);
widgetsList.DataSource = widgetListDS.Tables[0];
widgetsList.DataValueField = widgetListDS.Tables[0].Columns[0].ToString();
widgetsList.DataTextField = widgetListDS.Tables[0].Columns[1].ToString();
if (!Page.IsPostBack)
{
widgetsList.DataBind();
}
string widgetsHtml = "";
UserControl userControl;
UserControl userControl2;
DropDownList widgetModeNames;
foreach (DataRow row in dbWidgets.Tables[0].Rows)
{
//If the widget is not a javascript based chart
/*
* 1 - Table
* 2 - Javascript
* 3 - Datatable
*/
if ((int)row["type"] == 1)
{
userControl = (UserControl)LoadControl("~/UserControls/Webparts/wp" + row["tagName"].ToString() + ".ascx");
//userControl = (UserControl)LoadControl("~/NewDashboard/UserControls/" + row["tagName"].ToString() + ".ascx");
}
else if ((int)row["type"] == 3)
{
userControl = (UserControl)LoadControl("~/NewDashboard/UserControls/" + row["tagName"].ToString() + ".ascx");
}
else
{
//The user control has to be added twice so it resizes without needing to refresh the dashboard
userControl = (UserControl)LoadControl("~/NewDashboard/UserControls/" + row["tagName"].ToString() + ".ascx");
userControl2 = (UserControl)LoadControl("~/NewDashboard/UserControls/" + row["tagName"].ToString() + ".ascx");
widgetsHtml = "<textarea id=\"code" + row["widgetOnDashboardID"] + "\" style=\"display: none;\">";
widgetsHtml += "<div id=\"" + row["tagName"] + "\" style=\"width: 100%; height: 100%;\"></div>";
widgitPlaceHolder.Controls.Add(new LiteralControl(widgetsHtml));
widgitPlaceHolder.Controls.Add(userControl2);
widgetsHtml = "</textarea>";
widgitPlaceHolder.Controls.Add(new LiteralControl(widgetsHtml));
javascriptPlaceHolder.Controls.Add(userControl);
userControl2.Attributes.Add("mode", row["mode"].ToString());
}
//The control has to be displayed inside the div tags
widgetsHtml = "<div class=\"dragbox\" id=\"dragbox_" + row["widgetOnDashboardID"] + "\" style=\"overflow: hidden; position: absolute; z-index: 2; left:" + row["leftPos"] + "px; top:" + row["topPos"] + "px; width:" + row["width"] + "px; height:" + row["height"] + "px\">\n";
widgetsHtml += "<div class=\"header\" style=\"text-align:center\">\n";
widgetsHtml += " <div class=\"headerTitle\">" + row["widgetName"].ToString();
widgitPlaceHolder.Controls.Add(new LiteralControl(widgetsHtml));
//If the user is able to select modes for the control then a drop down list is produced
if (bool.Parse(row["hasModes"].ToString()) == true)
{
widgitPlaceHolder.Controls.Add(new LiteralControl(" For: "));
widgetModeNames = new DropDownList();
widgetModeNames.ID = "widgetModeNameList_" + row["widgetOnDashboardID"];
DataSet widgetModeNamesDS = DashboardDataAccess.getModesForWidget(int.Parse(row["widgetID"].ToString()));
widgetModeNames.DataSource = widgetModeNamesDS.Tables[0];
widgetModeNames.DataValueField = widgetModeNamesDS.Tables[0].Columns[1].ToString();
widgetModeNames.DataTextField = widgetModeNamesDS.Tables[0].Columns[0].ToString();
widgetModeNames.DataBind();
widgetModeNames.AutoPostBack = true;
widgetModeNames.SelectedIndexChanged += new EventHandler(widgetModeNames_SelectedIndexChanged);
widgitPlaceHolder.Controls.Add(widgetModeNames);
if (!Page.IsPostBack)
{
widgetModeNames.Items.FindByValue(row["mode"].ToString()).Selected = true;
}
}
widgetsHtml = "<span> <span style=\"float: right;\">";
widgitPlaceHolder.Controls.Add(new LiteralControl(widgetsHtml));
LinkButton deleteLink = new LinkButton();
deleteLink.ID = "deleteWidgetLink_" + row["widgetOnDashboardID"].ToString();
deleteLink.CommandArgument = row["widgetOnDashboardID"].ToString();
deleteLink.Text = "X";
deleteLink.Click += new EventHandler(deleteLink_Click);
widgitPlaceHolder.Controls.Add(deleteLink);
//If the control is not a graph then allow a scroll bar to be visible
if ((int)row["type"] == 1 || (int)row["type"] == 3)
{
widgetsHtml = "</span></div></div><div class=\"dragbox-content\" id=\"view" + row["widgetOnDashboardID"] + "\" style=\"clear: both; width:" + ((int)row["width"] - 10) + "px; height:" + ((int)row["height"] - 30) + "px;\"><div id=\"" + row["tagName"] + "\" style=\"width: 100%; height: 100%; overflow-y: auto;\">";
//widgetsHtml = "</span></div></div><div class=\"dragbox-content\" id=\"view" + row["widgetOnDashboardID"] + "\" style=\"clear: both; width:" + ((int)row["width"] - 10) + "px; height:" + ((int)row["height"] - 30) + "px;\"><div id=\"" + row["tagName"] + "\" style=\"width: 100%; height: 100%;\">";
}
else
{
widgetsHtml = "</span></div></div><div class=\"dragbox-content\" id=\"view" + row["widgetOnDashboardID"] + "\" style=\"clear: both; width:" + ((int)row["width"] - 10) + "px; height:" + ((int)row["height"] - 30) + "px;\"><div id=\"" + row["tagName"] + "\" style=\"width: 100%; height: 100%;\">";
}
widgitPlaceHolder.Controls.Add(new LiteralControl(widgetsHtml));
if ((int)row["type"] == 1 || (int)row["type"] == 3)
{
widgitPlaceHolder.Controls.Add(userControl);
}
widgitPlaceHolder.Controls.Add(new LiteralControl("</div></div></div>\n\n"));
/* Current Modes
* 1 - Last 30 Days
* 2 - This week
* 3 - This month
* 4 - This year */
userControl.Attributes.Add("mode", row["mode"].ToString());
}
}