protected void Page_Load(object sender, EventArgs e)
{
var categoryId = Request.QueryString["CategoryId"];
var categoryIdInt = Int64.Parse(categoryId);
var typeId = Request.QueryString["TypeId"];
var typeIdInt = string.IsNullOrEmpty(typeId) ? 1 : Int64.Parse(typeId);
const string connString = "Data Source=(local);Initial Catalog=6-SecurityMisconfig;User Id=6-SecurityMisconfig-User;Password=qc9yFUrYyWiLx80ZFlgj;";
const string sqlString = "SELECT * FROM Widget WHERE CategoryId = @CategoryId AND TypeId = @TypeId";
using (var conn = new SqlConnection(connString))
{
using (var command = new SqlCommand(sqlString, conn))
{
command.Parameters.Add("@CategoryId", SqlDbType.Int).Value = categoryIdInt;
command.Parameters.Add("@TypeId", SqlDbType.Int).Value = typeIdInt;
command.Connection.Open();
WidgetGrid.DataSource = command.ExecuteReader();
WidgetGrid.DataBind();
}
}
Trace.Warn("All data successfully loaded using conn string " + connString);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// Load Data WareHouse
Helpers.SetDataSource(cboDataDW, MyBI.Me.GetDW(), "Value", "Text");
WHCode = Get_Param(PageArgs.WHCode);
if (!string.IsNullOrEmpty(WHCode))
{
cboDataDW.Value = WHCode;
gridPortletList.DataSource = MyBI.Me.Get_Widget(WHCode);
gridPortletList.DataBind();
IQueryable<lsttbl_Widget> widgets = MyBI.Me.Get_Widget(WHCode);
foreach (lsttbl_Widget wg in widgets)
{
if (wg.WidgetType == "gauge")
{
WidgetGauge wgGauge = wg.JsonObj_Gauge;
}
else if (wg.WidgetType == "chart")
{
WidgetChart wgChart = wg.JsonObj_Chart;
}
else
{
// grid
WidgetGrid wgGrid = wg.JsonObj_Grid;
}
}
}
}
}
// Use this for initialization
void Start()
{
Grid = new WidgetGrid(true);
//add nodes for each widget in the grid as children from this node
foreach (Widget widget in Grid.widgets)
{
AddWidget(widget);
}
}
public override WidgetBase GetInputSett()
{
try
{
var ret = new WidgetGrid();
foreach (wcPropGrid_Column ctrl in this.ctrlColumn.Controls)
{
if (ctrl == null) continue;
ret.Columns.Add(ctrl.Get_GridColumn());
}
return ret;
}
catch { return new WidgetGrid(); }
}
public override WidgetBase GetInputSett()
{
try
{
var ret = new WidgetGrid();
foreach (wcPropGrid_Column ctrl in this.ctrlColumn.Controls)
{
if (ctrl == null)
{
continue;
}
ret.Columns.Add(ctrl.Get_GridColumn());
}
return(ret);
}
catch { return(new WidgetGrid()); }
}
