public ActionResult DeleteWidget()
{
bool ret = true;
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
GetDashboardObject DashBoardObject = (GetDashboardObject)Session["DashBoard"];
WidgetObject PostDataArrived = CS.GetPostData <WidgetObject>(this.Request);
ret = qw.DeleteWidget(PostDataArrived.id);
DashboardRow dRow = DashBoardObject.rows.Find(r => r.widgets.Find(w => w.id == PostDataArrived.id) != null);
dRow.widgets.Remove(dRow.widgets.Find(w => w.id == PostDataArrived.id));
Session["DashBoard"] = DashBoardObject;
return(CS.ReturnForJQuery(ret));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public ActionResult DeleteRow()
{
DashboardRow DBRow = CS.GetPostData <DashboardRow>(this.Request);
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
GetDashboardObject DashBoardObject = (GetDashboardObject)Session["DashBoard"];
qw.DeleteRow(DBRow.id);
DashBoardObject.rows.Remove(DashBoardObject.rows.Find(c => c.id == DBRow.id));
Session["DashBoard"] = DashBoardObject;
return(CS.ReturnForJQuery(DBRow));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public ActionResult AddWidget()
{
WidgetObject woRet;
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
GetDashboardObject DashBoardObject = (GetDashboardObject)Session["DashBoard"];
WidgetObject PostDataArrived = CS.GetPostData <WidgetObject>(this.Request);
woRet = qw.AddWidget(PostDataArrived);
DashboardRow dbRow = DashBoardObject.rows.Find(r => r.id == woRet.rowID);
if (dbRow.widgets == null)
{
dbRow.widgets = new List <WidgetObject>();
}
dbRow.widgets.Add(woRet);
Session["DashBoard"] = DashBoardObject;
return(CS.ReturnForJQuery(woRet));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public ActionResult UpdateRow()
{
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
DashboardRow UpdatedDashBoardRow;
DashboardRow PostDataArrived = CS.GetPostData <DashboardRow>(this.Request);
GetDashboardObject DashBoardObject = (GetDashboardObject)Session["DashBoard"];
UpdatedDashBoardRow = qw.UpdateRow(PostDataArrived);
var row_widget = DashBoardObject.rows.Find(c => c.id == PostDataArrived.id);
UpdatedDashBoardRow.widgets = row_widget.widgets;
DashBoardObject.rows.Remove(row_widget);
DashBoardObject.rows.Add(UpdatedDashBoardRow);
Session["DashBoard"] = DashBoardObject;
return(CS.ReturnForJQuery(UpdatedDashBoardRow));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public ActionResult AddRow()
{
DashboardRow DBRow;
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
GetDashboardObject DashBoardObject = (GetDashboardObject)Session["DashBoard"];
DBRow = qw.AddRow(DashBoardObject.id, false, -1);
if (DashBoardObject.rows == null)
{
DashBoardObject.rows = new List <DashboardRow>();
}
DashBoardObject.rows.Add(DBRow);
Session["DashBoard"] = DashBoardObject;
return(CS.ReturnForJQuery(DBRow));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public ActionResult DeleteDashboard()
{
try
{
GetDashboardObject DashBoardObject = CS.GetPostData <GetDashboardObject>(this.Request);
DashboardWidget dBWidget = new DashboardWidget(ConnectionString);
//DashBoardObject.id = dBWidget.CreateDashBoard(DashBoardObject);
if (DashBoardObject.id == -1)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"];
if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString))
{
throw new Exception("ConnectionString not set");
}
DashboardWidget qw = new DashboardWidget(connectionStringSetting.ConnectionString);
return(CS.ReturnForJQuery((qw.Delete(DashBoardObject.id)) ? JSONConst.Success : JSONConst.Error));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
}
public ActionResult CreateDashboard()
{
try
{
GetDashboardObject DashBoardObject = CS.GetPostData <GetDashboardObject>(this.Request);
DashboardWidget dBWidget = new DashboardWidget(ConnectionString);
DashBoardObject.id = dBWidget.CreateDashBoard(DashBoardObject);
if (DashBoardObject.id == -1)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
Session["DashBoard"] = DashBoardObject;
AddRow();
return(CS.ReturnForJQuery(DashBoardObject));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
}
public List <GetDashboardObject> GetDashBoardsInfo(int?dashboardId, bool?active)
{
List <GetDashboardObject> lDBObjects = new List <GetDashboardObject>();
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.GetDashBoardInfo";
SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int);
pDashBoardID.Value = dashboardId;
oComm.Parameters.Add(pDashBoardID);
SqlParameter pActive = new SqlParameter("@ACTIVE", SqlDbType.Bit);
pActive.Value = active;
oComm.Parameters.Add(pActive);
oReader = oComm.ExecuteReader();
while (oReader.Read())
{
GetDashboardObject dbObject = new GetDashboardObject()
{
id = (int)oReader["dsb_id"],
usercode = oReader["dsb_userCode"].ToString(),
numrow = (int)oReader["dsb_rowsNum"],
date = oReader["dsb_date"] != DBNull.Value ? oReader["dsb_date"].ToString() : string.Empty,
active = (bool)oReader["dsb_active"]
};
lDBObjects.Add(dbObject);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Sqlconn.State == ConnectionState.Open)
{
Sqlconn.Close();
}
}
return(lDBObjects);
}
public ActionResult GetDashboardsActive()
{
try
{
DashboardWidget qw = new DashboardWidget(ConnectionString);
GetDashboardObject PostDataArrived = CS.GetPostData <GetDashboardObject>(this.Request);
return(CS.ReturnForJQuery(qw.Load(-1, true)));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
}
public ActionResult ActiveDashboard()
{
try
{
GetDashboardObject PostDataArrived = CS.GetPostData <GetDashboardObject>(this.Request);
ConnectionStringSettings connectionStringSetting = ConfigurationManager.ConnectionStrings["ISTATWebClientConnection"];
if (connectionStringSetting == null || string.IsNullOrEmpty(connectionStringSetting.ConnectionString))
{
throw new Exception("ConnectionString not set");
}
DashboardWidget qw = new DashboardWidget(connectionStringSetting.ConnectionString);
return(CS.ReturnForJQuery(qw.Active(PostDataArrived.id, PostDataArrived.active)));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(JSONConst.Error));
}
}
public ActionResult PreviewDashboard()
{
try
{
GetDashboardObject PostDataArrived = CS.GetPostData <GetDashboardObject>(this.Request);
List <GetDashboardObject> DashBoardObject;
DashboardWidget qw = new DashboardWidget(ConnectionString);
DashBoardObject = qw.Load(PostDataArrived.id);
Session["DashBoard"] = DashBoardObject[0];
return(CS.ReturnForJQuery(DashBoardObject));
}
catch (Exception ex)
{
return(CS.ReturnForJQuery(new JavaScriptSerializer().Serialize(new ISTAT.WebClient.Models.ControllerSupport.StringResult()
{
Msg = ex.Message
})));
}
}
public int CreateDashBoard(GetDashboardObject PostDataArrived)
{
int idDBRet;
string locales = "", values = "";
foreach (TextLocalised txt in PostDataArrived.text)
{
locales += txt.locale + "|";
values += txt.title + "|";
}
locales = locales.Substring(0, locales.Length - 1);
values = values.Substring(0, values.Length - 1);
try
{
using (SqlCommand oComm = new SqlCommand())
{
if (Sqlconn.State == ConnectionState.Closed)
{
Sqlconn.Open();
}
oComm.Connection = Sqlconn;
oComm.CommandType = CommandType.StoredProcedure;
oComm.CommandText = "DashBoard.Create";
SqlParameter pUserCode = new SqlParameter("@USERCODE", SqlDbType.NVarChar, 255);
pUserCode.Value = PostDataArrived.usercode;
oComm.Parameters.Add(pUserCode);
SqlParameter pRowNum = new SqlParameter("@ROWNUM", SqlDbType.Int);
pRowNum.Value = PostDataArrived.numrow;
oComm.Parameters.Add(pRowNum);
SqlParameter pLocales = new SqlParameter("@LOCALES", SqlDbType.VarChar, 2000);
pLocales.Value = locales;
oComm.Parameters.Add(pLocales);
SqlParameter pValues = new SqlParameter("@VALUES", SqlDbType.VarChar, 5000);
pValues.Value = values;
oComm.Parameters.Add(pValues);
SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int);
pDashBoardID.Direction = ParameterDirection.Output;
oComm.Parameters.Add(pDashBoardID);
oComm.ExecuteNonQuery();
idDBRet = (int)pDashBoardID.Value;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Sqlconn.State == ConnectionState.Open)
{
Sqlconn.Close();
}
}
return(idDBRet);
}
