public List<WidgetObject> GetDashBoardWidget(int rowId)
{
List<WidgetObject> lWidgets = new List<WidgetObject>();
SqlDataReader oReader;
try
{
using (SqlCommand oComm = new SqlCommand())
{
if (Sqlconn.State == ConnectionState.Closed)
Sqlconn.Open();
oComm.Connection = Sqlconn;
oComm.CommandType = CommandType.StoredProcedure;
oComm.CommandText = "DashBoard.GetDashBoardWidget";
SqlParameter pRowID = new SqlParameter("@IDROW", SqlDbType.Int);
pRowID.Value = rowId;
oComm.Parameters.Add(pRowID);
oReader = oComm.ExecuteReader();
while (oReader.Read())
{
WidgetObject widget = new WidgetObject()
{
id = (int)oReader["wdg_id"],
cssClass = oReader["wdg_class"] != DBNull.Value ? oReader["wdg_class"].ToString() : string.Empty,
rowID = (int)oReader["wdg_row_id"],
cell = (int)oReader["wdg_cell"],
type = oReader["wdg_type"] != DBNull.Value ? oReader["wdg_type"].ToString() : string.Empty,
chartype = oReader["wdg_chartType"] != DBNull.Value ? oReader["wdg_chartType"].ToString() : string.Empty,
v = oReader["wdg_v"] != DBNull.Value ? (bool)oReader["wdg_v"] : false,
vt = oReader["wdg_vt"] != DBNull.Value ? (bool)oReader["wdg_vt"] : false,
vc = oReader["wdg_vc"] != DBNull.Value ? (bool)oReader["wdg_vc"] : false,
endPoint = oReader["wdg_endPoint"] != DBNull.Value ? oReader["wdg_endPoint"].ToString() : string.Empty,
endPointType = oReader["wdg_endPointType"] != DBNull.Value ? oReader["wdg_endPointType"].ToString() : string.Empty,
endPointV20 = oReader["wdg_endPointV20"] != DBNull.Value ? oReader["wdg_endPointV20"].ToString() : string.Empty,
endPointSource = oReader["wdg_endPointSource"] != DBNull.Value ? oReader["wdg_endPointSource"].ToString() : string.Empty,
endPointDecimalSeparator = oReader["wdg_decimalCulture"] != DBNull.Value ? oReader["wdg_decimalCulture"].ToString() : string.Empty,
dataflow_id = oReader["wdg_dataflow_id"] != DBNull.Value ? oReader["wdg_dataflow_id"].ToString() : string.Empty,
dataflow_agency_id = oReader["wdg_dataflow_agency_id"] != DBNull.Value ? oReader["wdg_dataflow_agency_id"].ToString() : string.Empty,
dataflow_version = oReader["wdg_dataflow_version"] != DBNull.Value ? oReader["wdg_dataflow_version"].ToString() : string.Empty,
criteria = oReader["wdg_criteria"] != DBNull.Value ? oReader["wdg_criteria"].ToString() : string.Empty,
layout = oReader["wdg_layout"] != DBNull.Value ? oReader["wdg_layout"].ToString() : string.Empty
};
lWidgets.Add(widget);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Sqlconn.State == ConnectionState.Open)
Sqlconn.Close();
}
return lWidgets;
}
public WidgetObject UpdateWidget(WidgetObject widgetObject)
{
bool ret = true;
try
{
using (SqlCommand oComm = new SqlCommand())
{
if (Sqlconn.State == ConnectionState.Closed)
Sqlconn.Open();
oComm.Connection = Sqlconn;
oComm.CommandType = CommandType.StoredProcedure;
oComm.CommandText = "DashBoard.UpdateWidget";
SqlParameter pWDGID = new SqlParameter("@WDG_ID", SqlDbType.Int);
pWDGID.Value = widgetObject.id;
oComm.Parameters.Add(pWDGID);
SqlParameter pWdgClass = new SqlParameter("@WDG_CLASS", SqlDbType.NVarChar);
pWdgClass.Value = widgetObject.cssClass;
oComm.Parameters.Add(pWdgClass);
SqlParameter pRowID = new SqlParameter("@WDG_ROW_ID", SqlDbType.Int);
pRowID.Value = widgetObject.rowID;
oComm.Parameters.Add(pRowID);
SqlParameter pWdgCell = new SqlParameter("@WDG_CELL", SqlDbType.Int);
pWdgCell.Value = widgetObject.cell;
oComm.Parameters.Add(pWdgCell);
SqlParameter pType = new SqlParameter("@WDG_TYPE", SqlDbType.NVarChar);
pType.Value = widgetObject.type;
oComm.Parameters.Add(pType);
SqlParameter pChartType = new SqlParameter("@WDG_CHARTTYPE", SqlDbType.NVarChar);
pChartType.Value = widgetObject.chartype;
oComm.Parameters.Add(pChartType);
SqlParameter pV = new SqlParameter("@WDG_V", SqlDbType.Bit);
pV.Value = widgetObject.v;
oComm.Parameters.Add(pV);
SqlParameter pVT = new SqlParameter("@WDG_VT", SqlDbType.Bit);
pVT.Value = widgetObject.vt;
oComm.Parameters.Add(pVT);
SqlParameter pVC = new SqlParameter("@WDG_VC", SqlDbType.Bit);
pVC.Value = widgetObject.vc;
oComm.Parameters.Add(pVC);
SqlParameter pEndPoint = new SqlParameter("@WDG_ENDPOINT", SqlDbType.NVarChar);
pEndPoint.Value = widgetObject.endPoint;
oComm.Parameters.Add(pEndPoint);
SqlParameter pEndPointType = new SqlParameter("@WDG_ENDPOINTTYPE", SqlDbType.NVarChar);
pEndPointType.Value = widgetObject.endPointType;
oComm.Parameters.Add(pEndPointType);
SqlParameter pEndPointV20 = new SqlParameter("@WDG_ENDPOINTV20", SqlDbType.NVarChar);
pEndPointV20.Value = widgetObject.endPointV20;
oComm.Parameters.Add(pEndPointV20);
SqlParameter pEndPointSource = new SqlParameter("@WDG_ENDPOINTSOURCE", SqlDbType.NVarChar);
pEndPointSource.Value = widgetObject.endPointSource;
oComm.Parameters.Add(pEndPointSource);
SqlParameter pEndPointDecimal = new SqlParameter("@WDG_ENDPOINTDECIMAL", SqlDbType.NVarChar);
pEndPointDecimal.Value = widgetObject.endPointDecimalSeparator;
oComm.Parameters.Add(pEndPointDecimal);
SqlParameter pDataFlowID = new SqlParameter("@WDG_DATAFLOW_ID", SqlDbType.NVarChar);
pDataFlowID.Value = widgetObject.dataflow_id;
oComm.Parameters.Add(pDataFlowID);
SqlParameter pAgencyID = new SqlParameter("@WDG_DATAFLOW_AGENCY_ID", SqlDbType.NVarChar);
pAgencyID.Value = widgetObject.dataflow_agency_id;
oComm.Parameters.Add(pAgencyID);
SqlParameter pVersion = new SqlParameter("@WDG_DATAFLOW_VERSION", SqlDbType.NVarChar);
pVersion.Value = widgetObject.dataflow_version;
oComm.Parameters.Add(pVersion);
SqlParameter pCriteria = new SqlParameter("@WDG_CRITERIA", SqlDbType.NText);
pCriteria.Value = widgetObject.criteria;
oComm.Parameters.Add(pCriteria);
SqlParameter pLayout = new SqlParameter("@WDG_LAYOUT", SqlDbType.NText);
pLayout.Value = widgetObject.layout;
oComm.Parameters.Add(pLayout);
oComm.ExecuteNonQuery();
foreach (TextLocalised tl in widgetObject.text)
{
UpdateWidgetText(widgetObject.id, tl);
}
}
}
catch (Exception ex)
{
ret = false;
throw ex;
}
finally
{
if (Sqlconn.State == ConnectionState.Open)
Sqlconn.Close();
}
return widgetObject;
}
public List<WidgetObject> GetUpdateableWidgets()
{
List<WidgetObject> lWidgets = new List<WidgetObject>();
SqlDataReader oReader;
try
{
using (SqlCommand oComm = new SqlCommand())
{
if (Sqlconn.State == ConnectionState.Closed)
Sqlconn.Open();
oComm.Connection = Sqlconn;
oComm.CommandType = CommandType.StoredProcedure;
oComm.CommandText = "Caching.GetUpdateableWidgets";
oReader = oComm.ExecuteReader();
while (oReader.Read())
{
WidgetObject widget = new WidgetObject()
{
id = (int)oReader["wdg_id"],
cssClass = oReader["wdg_class"] != DBNull.Value ? oReader["wdg_class"].ToString() : string.Empty,
rowID = (int)oReader["wdg_row_id"],
cell = (int)oReader["wdg_cell"],
type = oReader["wdg_type"] != DBNull.Value ? oReader["wdg_type"].ToString() : string.Empty,
chartype = oReader["wdg_chartType"] != DBNull.Value ? oReader["wdg_chartType"].ToString() : string.Empty,
v = oReader["wdg_v"] != DBNull.Value ? (bool)oReader["wdg_v"] : false,
vt = oReader["wdg_vt"] != DBNull.Value ? (bool)oReader["wdg_vt"] : false,
vc = oReader["wdg_vc"] != DBNull.Value ? (bool)oReader["wdg_vc"] : false,
endPoint = oReader["wdg_endPoint"] != DBNull.Value ? oReader["wdg_endPoint"].ToString() : string.Empty,
endPointType = oReader["wdg_endPointType"] != DBNull.Value ? oReader["wdg_endPointType"].ToString() : string.Empty,
endPointV20 = oReader["wdg_endPointV20"] != DBNull.Value ? oReader["wdg_endPointV20"].ToString() : string.Empty,
endPointDecimalSeparator = oReader["wdg_decimalCulture"] != DBNull.Value ? oReader["wdg_decimalCulture"].ToString() : string.Empty,
endPointSource = oReader["wdg_endpointSource"] != DBNull.Value ? oReader["wdg_endpointSource"].ToString() : string.Empty,
dataflow_id = oReader["wdg_dataflow_id"] != DBNull.Value ? oReader["wdg_dataflow_id"].ToString() : string.Empty,
dataflow_agency_id = oReader["wdg_dataflow_agency_id"] != DBNull.Value ? oReader["wdg_dataflow_agency_id"].ToString() : string.Empty,
dataflow_version = oReader["wdg_dataflow_version"] != DBNull.Value ? oReader["wdg_dataflow_version"].ToString() : string.Empty,
criteria = oReader["wdg_criteria"] != DBNull.Value ? oReader["wdg_criteria"].ToString() : string.Empty,
layout = oReader["wdg_layout"] != DBNull.Value ? oReader["wdg_layout"].ToString() : string.Empty
};
widget.text = new List<TextLocalised>() { new TextLocalised() { locale = oReader["wdg_text_Locale"].ToString() } };
lWidgets.Add(widget);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Sqlconn.State == ConnectionState.Open)
Sqlconn.Close();
}
return lWidgets;
}