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 void PopulateRow() { foreach (GameObject row in rows) { //0 - 3 == idy = 0 // 3 -7 == idy = 1 //planeCount = 6, j == 6 int j = rows.IndexOf(row);// + (height * idy); DashboardRow dashboardrow = row.GetComponent <DashboardRow>(); if (plane.Count != table.RowCount()) { emptyRow(table.RowCount()); } if (j > table.GetTable().Count) { emptyRow(j); //dashboardrow.SetIndex(idx); } if (j < table.GetTable().Count) { List <string> data = table.GetTable() [j]; //dashboardrow.SetPlane(plane[j + (height * idy)]); dashboardrow.ChangeIdentifier(data [0]); dashboardrow.SetData(data.Skip(1).ToArray()); dashboardrow.SetIndex(idx); } } }
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 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 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 async Task <TelegramReplyMessage> Handle(CompleteTransactionQuery request, CancellationToken cancellationToken) { if (request.Transaction.Type == Transaction.TypeTransfer || request.Transaction.Category == "Available to budget") { return(TelegramReplyMessage.OperationCompletedMessage(request.Message)); } var dashboard = await _apiService.GetDashboardAsync(); var row = dashboard.FirstOrDefault(x => x.Name == request.Transaction.Category && x.Type == DashboardRowType.Category); if (row == null) { _logger.LogError($"No dashboard category found to send for {request.Transaction.Category}: " + $"{string.Join(", ", dashboard.Select(x => x.Name).ToArray())}"); row = new DashboardRow( "Error", DashboardRowType.Category, 0, 0, 0, 0, 0, false ); } var sb = new StringBuilder(); sb.AppendLine("👌 Available | 💸 Spent | 💰 Budgeted"); sb.AppendLine(row.ToHtmlSummary()); var reply = new TelegramReplyMessage { ChatId = request.Message.ChatId, ReplyMarkup = new ReplyKeyboardRemove(), Text = sb.ToString() }; return(reply); }
/// <summary> /// /// </summary> /// <param name="dashboardId"></param> /// <param name="splitted"></param> /// <param name="order">if -1 = next order</param> public DashboardRow AddRow(int dashboardId, bool split, int order) { DashboardRow DBRowRet; try { using (SqlCommand oComm = new SqlCommand()) { if (Sqlconn.State == ConnectionState.Closed) { Sqlconn.Open(); } oComm.Connection = Sqlconn; oComm.CommandType = CommandType.StoredProcedure; oComm.CommandText = "DashBoard.AddRow"; SqlParameter pDSBID = new SqlParameter("@DSBID", SqlDbType.Int); pDSBID.Value = dashboardId; oComm.Parameters.Add(pDSBID); SqlParameter pSplitted = new SqlParameter("@SPLITTED", SqlDbType.Bit); pSplitted.Value = split; oComm.Parameters.Add(pSplitted); SqlParameter pOrder = new SqlParameter("@ORDER", SqlDbType.Int); pOrder.Direction = ParameterDirection.InputOutput; pOrder.Value = order; oComm.Parameters.Add(pOrder); SqlParameter pRowID = new SqlParameter("@ROWID", SqlDbType.Int); pRowID.Direction = ParameterDirection.Output; oComm.Parameters.Add(pRowID); oComm.ExecuteNonQuery(); DBRowRet = new DashboardRow() { id = (int)pRowID.Value, order = (int)pOrder.Value, splitted = split, widgets = null }; } } catch (Exception ex) { throw ex; } finally { if (Sqlconn.State == ConnectionState.Open) { Sqlconn.Close(); } } return(DBRowRet); }
public void Reset() { resetIdy(); plane.Clear(); foreach (GameObject row in rows) { DashboardRow dashboardrow = row.GetComponent <DashboardRow>(); dashboardrow.EmptyRow(); dashboardrow.SetIndex(0); } }
public static string ToHtmlSummary(this DashboardRow dashboardRow) { if (dashboardRow.Type == DashboardRowType.Group) { return($"<b>{dashboardRow.Name}</b>"); } else { var emoji = dashboardRow.Available < 0 ? "❗️" : ""; return($"{dashboardRow.Name}: {emoji}{dashboardRow.Available} | {dashboardRow.Spent} | {dashboardRow.Budgeted}"); } }
public void Reset() { resetIdy(); plane.Clear(); foreach (GameObject row in rows) { DashboardRow dashboardrow = row.GetComponent <DashboardRow>(); dashboardrow.EmptyRow(); dashboardrow.SetIndex(0); } transform.GetComponent <ReferenceSelection>().resetAll(); }
public List <DashboardRow> GetDashBoardRows(int dashboardId) { List <DashboardRow> lRows = new List <DashboardRow>(); 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.GetDashBoardRow"; SqlParameter pDashBoardID = new SqlParameter("@IDDASHBOARD", SqlDbType.Int); pDashBoardID.Value = dashboardId; oComm.Parameters.Add(pDashBoardID); oReader = oComm.ExecuteReader(); while (oReader.Read()) { DashboardRow dbRow = new DashboardRow() { id = (int)oReader["dsb_row_id"], splitted = (bool)oReader["splitted"], order = (int)oReader["order"] }; lRows.Add(dbRow); } } } catch (Exception ex) { throw ex; } finally { if (Sqlconn.State == ConnectionState.Open) { Sqlconn.Close(); } } return(lRows); }
public void PopulateRow() { foreach (GameObject row in rows) { //string [] data =Aircraft_parent.transform.GetChild(i).GetComponent<movement>().GetData(); int j = rows.IndexOf(row); DashboardRow dashboardrow = row.GetComponent <DashboardRow>(); if (j + (height * idy) > plane.Count - 1) { dashboardrow.EmptyRow(); dashboardrow.SetIndex(idx); } else { //Debug.Log("Here"); dashboardrow.SetPlane(plane[j + (height * idy)]); //Debug.Log("Plane======================="+ plane[0]); var scene = SceneManager.GetActiveScene().name; if (scene == "ARScene") { string[] data = dashboardrow.GetPlane().GetComponent <movement>().GetData(); dashboardrow.ChangeIdentifier(data[0]); // SET TAIL ID dashboardrow.SetData(data.Skip(1).ToArray()); // dashboardrow.SetIndex(idx); } else if (scene == "LiveData") { string[] data = dashboardrow.GetPlane().GetComponent <AircraftDataManager>().GetData(); dashboardrow.ChangeIdentifier(data[0]); // SET TAIL ID dashboardrow.SetData(data.Skip(1).ToArray()); // dashboardrow.SetIndex(idx); } } } }
// Use this for initialization void Start() { //headingTransform = transform.Find("headingRow"); PopulateHeadings(); int i = 0; //foreach(Transform child in Aircraft_parent.transform) //{ // GameObject rowGameObject = Instantiate(rowPrefab, transform) as GameObject; // DashboardRow row = rowGameObject.GetComponent<DashboardRow>(); // row.SetIndex(0); // row.SetWidth(width); // row.Init(); // //row.SetPlane(child); // //row.SetIdentifierName(child.transform.GetComponent<movement>().callsign); // rowGameObject.transform.position = new Vector3(transform.position.x + Xoffset, transform.position.y+ Yoffset, transform.position.z + (i * spacing) + Zoffset ); // rows.Add(rowGameObject); // i++; //} //foreach (Transform child in Aircraft_parent.transform) // plane.Add(child); while (i != height) { GameObject rowGameObject = Instantiate(rowPrefab, transform) as GameObject; DashboardRow row = rowGameObject.GetComponent <DashboardRow>(); row.SetIndex(0); row.SetWidth(width); row.Init(); //row.SetPlane(plane[i + (height * idy)].transform); //rowGameObject.transform.position = new Vector3(transform.position.x + Xoffset, transform.position.y + Yoffset, transform.position.z + (i * spacing) + Zoffset); rowGameObject.transform.position = new Vector3(transform.position.x + Xoffset, transform.position.y + (i * spacing) + Yoffset, transform.position.z + Zoffset); rows.Add(rowGameObject); i++; } transform.Rotate(new Vector3(75, 0, 0)); //transform.parent.localScale = new Vector3(transform.parent.localScale.x - 0.2f, transform.parent.localScale.y, transform.parent.localScale.z); }
// Use this for initialization void Start() { headingTransform = transform.Find("headingRow"); PopulateHeadings(); int i = 0; while (i != height) { GameObject rowGameObject = Instantiate(rowPrefab, transform) as GameObject; DashboardRow row = rowGameObject.GetComponent <DashboardRow>(); row.SetIndex(0); row.SetWidth(width); row.Init(); //row.SetPlane(plane[i + (height * idy)].transform); //rowGameObject.transform.position = new Vector3(transform.position.x + Xoffset, transform.position.y + Yoffset, transform.position.z + (i * spacing) + Zoffset); rowGameObject.transform.position = new Vector3(transform.position.x + Xoffset, transform.position.y + (i * spacing) + Yoffset, transform.position.z + Zoffset); rows.Add(rowGameObject); i++; } transform.Rotate(new Vector3(75, 0, 0)); }
public async Task <List <DashboardRow> > GetDashboardAsync() { var categories = await GetCategoriesAsync(); var request = _sheetsService.Spreadsheets.Values.Get(_spreadSheetId, Options.DashboardRange); request.ValueRenderOption = SpreadsheetsResource.ValuesResource.GetRequest.ValueRenderOptionEnum.UNFORMATTEDVALUE; var response = await request.ExecuteAsync(); var values = response.Values; var result = new List <DashboardRow>(); if (values == null || values.Count == 0) { return(result); } foreach (var row in values) { try { var dashboardRow = DashboardRow.FromGoogleRow(row); if (!categories.Contains(dashboardRow.Name)) { dashboardRow.SetType(DashboardRowType.Group); } result.Add(dashboardRow); } catch (Exception e) { _logger.LogError(e, "DashboardRow instancing error"); } } return(result); }