/// <summary>
        /// Gets the table for this timeline.
        /// </summary>
        /// <returns>
        /// The table for this timeline.
        /// </returns>
        /// <param name='TimelineTableGuid'>
        /// We pass in the GUID to allow other tables to be found (i.e., if you have made a list of tables to associate with this timeline)
        /// </param>
        public NoteDataXML_Table GetTableForThisTimeline(string TimelineTableGuid)
        {
            NoteDataXML_Table FoundTable = (NoteDataXML_Table)Layout.FindNoteByGuid(TimelineTableGuid);

            // April 1 2013 - this may make things TOO SLOW
            // but only way to guarantee al ive connection when the TIMELINE is not in the same panel as the TABLES
            FoundTable = (NoteDataXML_Table)Layout.GoToNote(FoundTable);
            if (null == FoundTable && false == errorthrown)
            {
                // just throw message once.
                NewMessage.Show(Loc.Instance.GetString("The table for this Timeline was not found. Probably the guid of it needs to be set to its caption."));
                errorthrown = true;
                //throw new Exception("The table for this Timeline was not found");
            }
            return(FoundTable);
        }
Exemplo n.º 2
0
        private static NoteDataXML_Table LoadStringAsTable(string data)
        {
            // Loading existing table
            System.IO.StringReader LinkTableReader = new System.IO.StringReader(data);
            System.Xml.Serialization.XmlSerializer LinkTableXML = new System.Xml.Serialization.XmlSerializer(typeof(NoteDataXML_Table));

            NoteDataXML_Table table = new NoteDataXML_Table();

            table = (NoteDataXML_Table)LinkTableXML.Deserialize(LinkTableReader);
            //						if (table != null)
            //						{
            //							MyLinkTable.SetTable (table.dataSource);
            //						}
            //NewMessage.Show("Loading a link table with GUID = " + table.GuidForNote);
            LinkTableXML = null;
            LinkTableReader.Close();
            LinkTableReader.Dispose();
            return(table);
        }
        protected override void DoBuildChildren(LayoutPanelBase Layout)
        {
            base.DoBuildChildren(Layout);
            CaptionLabel.Dock = DockStyle.Top;


            if (TableCreated == false)
            {
                Width  = 500;
                Height = 200;
                ParentNotePanel.Width  = Width;
                ParentNotePanel.Height = Height;

                TimelineStartDate = DateTime.Today;

                // A. Create the Table
                NoteDataXML_Table myTable = new NoteDataXML_Table(100, 100, new ColumnDetails[7] {
                    new ColumnDetails("Date", 50),
                    new ColumnDetails("Type", 50),
                    new ColumnDetails("Data", 50),
                    new ColumnDetails("Data2", 50),
                    new ColumnDetails("Data3", 50),
                    new ColumnDetails("Data4", 50),
                    new ColumnDetails("icon", 50)
                });
                string GuidOfTable = this.GuidForNote + "table";
                myTable.GuidForNote = GuidOfTable;

                myTable.Caption = Loc.Instance.GetStringFmt("Table for Timeline");



                Layout.AddNote(myTable);

                // we do not need to call CreateParent because AddNote does it for us
                //myTable.CreateParent (Layout);
                Save();
                myTable.AddRow(new object[7] {
                    DateTime.Today.ToString(), "100", "Example Description", "Example Title", "", "", 2
                });
                TableCreated = true;
                Save();
                // B. Populate it with example Row
            }
            Timeline      = new NotePanelTimeline(this);
            Timeline.Dock = DockStyle.Fill;
            ParentNotePanel.Controls.Add(Timeline);
            Timeline.dayPanelWidth = DayPanelWidth;
            Timeline.BringToFront();

            RowFilterStrip =
                LayoutDetails.BuildMenuPropertyEdit(Loc.Instance.GetString("Row Filter: {0}"), RowFilter, Loc.Instance.GetString("Filter via the columns on the table associated with this timeline."), HandleRowFilterChange);



            ToolStripSeparator sep = new ToolStripSeparator();


            ToolStripComboBox dropper = new ToolStripComboBox();



            dropper.ToolTipText   = Loc.Instance.GetString("Set the type of timeline you want by selecting an appropriate calendar.");
            dropper.DropDownStyle = ComboBoxStyle.DropDownList;
            foreach (Calendar.calendertype calendertype in Enum.GetValues(typeof(Calendar.calendertype)))
            {
                dropper.Items.Add(calendertype.ToString());
            }
            dropper.Text = MCalendarType.ToString();
            dropper.SelectedIndexChanged += HandleSelectedIndexCalendarPickerChanged;



            // Icons Per Column. We had the edit to a ToolStrip Host and add the Host to the toolstrip
            NumericUpDown numbers = new NumericUpDown();


            Panel numbersPanel = new Panel();

            numbersPanel.BackColor = dropper.BackColor;
            Label numbersLabel = new Label();

            numbersLabel.Left = 0;
            //numbersLabel.Dock = DockStyle.Left;
            numbersLabel.Text     = Loc.Instance.GetString("Icons/Column: ");
            numbersLabel.AutoSize = false;
            numbersLabel.Width    = 85;
            numbers.Left          = 90;
            numbers.Width         = 45;
            //numbersLabel.AutoSize = true;
            //numbers.Dock = DockStyle.Right;

            numbersPanel.Controls.Add(numbersLabel);
            numbersPanel.Controls.Add(numbers);
            numbersLabel.BringToFront();
            //numbersPanel.Dock = DockStyle.Fill;


            numbers.Value         = IconsPerColumn;
            numbers.ValueChanged += HandleIconsPerColumnValueChanged;
            numbers.Minimum       = 1;
            numbers.Maximum       = 20;
            ToolStripControlHost iconsPerColumn = new ToolStripControlHost(numbersPanel);


            // Day Width
            ToolStripControlHost setDayWidth = BuildDayWidth(dropper.BackColor);


            DateTimePicker dates = new DateTimePicker();

            dates.Width = 125;
            try {
                dates.Value = this.TimelineStartDate;
            } catch (Exception) {
                dates.Value = DateTime.Today;
            }
            dates.ValueChanged += HandleValueCurrentdateChanged;
            ToolStripControlHost dateToolStrip = new ToolStripControlHost(dates);

            dateToolStrip.ToolTipText = Loc.Instance.GetString("Select a date to center the timeline on that date.");



            properties.DropDownItems.Add(sep);
            properties.DropDownItems.Add(dropper);
            properties.DropDownItems.Add(iconsPerColumn);
            properties.DropDownItems.Add(setDayWidth);
            properties.DropDownItems.Add(RowFilterStrip);
            properties.DropDownItems.Add(dateToolStrip);


            // add hjistory to RowFilterStrip
            foreach (string history in RowHistory)
            {
                ToolStripMenuItem test = new ToolStripMenuItem(history);
                test.Click += delegate(object sender, EventArgs e){ RowFilter = RowFilterStrip.Text = test.Text; Timeline.Refresh(); };
                RowFilterStrip.DropDownItems.Add(test);
            }

            //
            //
            // Hide ZOom Panel
            //
            //
            ToolStripButton HideMonths = new ToolStripButton();

            HideMonths.Text         = Loc.Instance.GetString("Hide Months Panel");
            HideMonths.CheckOnClick = true;
            HideMonths.Checked      = this.HideZoomOutPanel;
            HideMonths.Click       += HandleHideMonthsClick;

            properties.DropDownItems.Add(HideMonths);
            // Adjust panel as needed; also add this to the menu too
            Timeline.HideZoomPanel(this.HideZoomOutPanel);
        }
Exemplo n.º 4
0
        public static System.Collections.Generic.List <string> ReciprocalLinks(string myLayoutGuid)
        {
            NoteDataXML_Table table = BuildLinMasterLinkTable();

            // returns a list of (Page Names.Guids) which will be links to Layouts
            // that are linked to me or notes inside me


//			if (combinedResult != Constants.BLANK) {
//				// Loading existing table
//				System.IO.StringReader LinkTableReader = new System.IO.StringReader (combinedResult);
//				System.Xml.Serialization.XmlSerializer LinkTableXML = new System.Xml.Serialization.XmlSerializer (typeof(NoteDataXML_Table));
//
//
//
//				table = (NoteDataXML_Table)LinkTableXML.Deserialize (LinkTableReader);
//				//						if (table != null)
//				//						{
//				//							MyLinkTable.SetTable (table.dataSource);
//				//						}
//				//NewMessage.Show("Loading a link table with GUID = " + table.GuidForNote);
//				LinkTableXML = null;
//				LinkTableReader.Close ();
//				LinkTableReader.Dispose ();
//
//			}
//			if (table != null) {
//
//			}


            //NewMessage.Show("Combined row count " + table.RowCount().ToString());

            // 2 - search the parent.child column where child=myGuid
            //     and retrieve the (group) column this list is a list of guids in form parent.child (the LinkNote)


            List <string> result = new List <string>();

            if (table != null)
            {
                DataView dataView = ((DataTable)table.dataSource).DefaultView;
                //dataView.Tables.Add();
                //	((DataTable)table.dataSource).RowFilter="";

                // The GUID we have is the LayoutGuid, so the Parent.* of the eqution
                dataView.RowFilter = String.Format("linkid Like '{0}.%'", myLayoutGuid);
                foreach (DataRowView row in dataView)
                {
                    // if linkid is equal


                    // add group AFTER translating
                    string doubleguid = row[CoreUtilities.Links.LinkTable.GROUP].ToString();
                    // this will be in parent.child form
                    string[] guids = doubleguid.Split(new char[1] {
                        '.'
                    });
                    if (guids != null && guids.Length == 2)
                    {
                        string guid = guids[0];

                        string name = GetNameFromGuid(guid);

                        if (IsSubpanel(guid) == true)
                        {
                            // if we are a subpanel
                            string parentGuid = GetSubpanelsParent(guid);
                            if (ExistsByGUID(parentGuid) == true)
                            {
                                name = GetNameFromGuid(parentGuid);
                            }
                        }

                        result.Add(String.Format("{0}.{1}", name, guid));
                    }
                }
            }


            // 3 - go through and parse the parent. part of the parent.child guids and return a list of
            //    Name.parentguid


            return(result);
        }
Exemplo n.º 5
0
        protected static NoteDataXML_Table BuildLinMasterLinkTable()
        {
            NoteDataXML_Table table      = null;
            BaseDatabase      MyDatabase = CreateDatabase();


            // 0 - GetValues (all linktable columns)  easy
            List <object[]> results = MyDatabase.GetValues(dbConstants.table_name, new string[1] {
                dbConstants.LINKTABLE
            }, "any", "*");
            string combinedResult = Constants.BLANK;

            //int record = 0;
            //NoteDataXML_Table table = null;

            if (results != null && results.Count > 0)
            {
                foreach (object[] row in results)
                {
                    if (row.Length > 0)
                    {
                        if (row [0].ToString() != Constants.BLANK)
                        {
                            if (table != null)
                            {
                                // now load secondtable and copy rows over
                                NoteDataXML_Table secondTable = LoadStringAsTable(row [0].ToString());
                                foreach (DataRow drow in secondTable.GetRows())
                                {
                                    object[] values = drow.ItemArray;
                                    values [0] = null;                                    //DBNull.Value;//DBNull.Value;

                                    table.AddRow(values);
                                }
                            }
                            else
                            {
                                table = LoadStringAsTable(row [0].ToString());
                            }

                            //							if (row[0].ToString ().IndexOf("<DocumentElement>") > -1)
                            //							{
                            //							record++;
                            //							if (1 == record)
                            //							{
                            //
                            //								combinedResult = row[0].ToString ();
                            //								// the first time we add it in a special way
                            //
                            //								int index_of_end = combinedResult.IndexOf("</DocumentElement>");
                            //								if (index_of_end > -1)
                            //								{
                            //									// chop string
                            //									combinedResult = combinedResult.Substring (0, index_of_end);
                            //								}
                            //								else
                            //								{
                            //									throw new Exception("Invalid table passed in");
                            //								}
                            //								// cut the bottom part off
                            //
                            //
                            //						//NewMessage.Show (row[0].ToString());
                            //
                            //							}
                            //							}//DocumentElement exists
                            //							else
                            //							{
                            //								// now we add each row
                            //							}
                        }
                    }
                }

                // we rebuild the text to be a proper table
                //				string END_TEXT = " </DocumentElement></diffgr:diffgram>  </dataSource> </NoteDataXML_Table>";
                //				combinedResult = combinedResult + END_TEXT;
            }
            // 1 - Consolidage all LinkTables  hard --> requires:
            MyDatabase.Dispose();
            return(table);
        }
Exemplo n.º 6
0
        /// <summary>
        /// will go through each "next" table from the source one
        /// the calling object
        /// and generateresults
        ///
        ///
        ///
        ///
        /// </summary>
        /// <returns></returns>
        public static string GenerateAllResults(ref string nextTable, DataTable currentTable, string Title, string Core_Table, LayoutPanelBase Layout, bool useHeadingStyle)
        {
            // probably should save first too but not sure
            // how to integrate that

            string sOriginalNextTable = nextTable;

            if (null == Layout)
            {
                throw new Exception("You must have a valid Layout loaded when doing a random table traversal.");
            }
            // do first table
            System.Collections.ArrayList notelist = Layout.GetAllNotes();
            NoteDataInterface[]          notes    = new NoteDataInterface[notelist.Count];
            notelist.CopyTo(notes);

            resultReturn sResult = GenerateResult(0, currentTable, ref nextTable, Title, notes, useHeadingStyle);



            // now, if there are more tables
            //classPageTable tables = this;



            if (sResult.sResult == " \n")
            {
                sResult.sResult = Constants.BLANK;
            }


            while (nextTable != null && nextTable != Constants.BLANK)
            {
                // looks for the note called start
                NoteDataXML_Table table = null;
                bool LINEAR_MODE        = false;

                if (nextTable[0] == '-')
                {
                    // Linear table system.
                    // a -X (any number, with a minus preceding it) represents a row

                    // basically we want to stay on the current table but go to the next row
                    table       = (NoteDataXML_Table)Layout.FindNoteByName(Core_Table);
                    LINEAR_MODE = true;
                }
                else
                {
                    // Grab the next table
                    NoteDataInterface potentialTable = Layout.FindNoteByName(nextTable);
                    if (potentialTable is NoteDataXML_Table)
                    {
                        table = (NoteDataXML_Table)potentialTable;
                        // sep 28 2011
                        // linear table system
                        // if we encounter a 'real table' reference that means
                        // to set the Core Table to that
                        Core_Table = nextTable;
                    }
                }



                //NotePanelTable table = (NotePanelTable)desktop.GetPanelByName(nextTable);

                resultReturn newResult;

                if (table != null)
                {
                    string old_next_table = nextTable;
                    string _caption       = "";              // table.Caption;
                    if (table.TableCaption != "")
                    {
                        _caption = table.TableCaption;
                    }

                    // see note A below for why we have this check
                    if (LINEAR_MODE == true && table.NextTable == "")
                    {
                        // leave nextable alone in Lienar mode
                        // needed for when we call a linear table from another table (instead of calling the linear table directly)
                    }
                    else
                    {
                        nextTable = table.NextTable;                         // this is clearing the row field!
                    }
                    newResult = GenerateResult(sResult.nModifier, (DataTable)table.dataSource, ref nextTable, _caption, notes, useHeadingStyle);



                    /* NOTE A September 28 2011
                     * There is a WEIRD pointer thing happening and working in my favor
                     * Basically because AppearanceClass.NextTable is passed as a ref into GenerateAllResults it is modified directly
                     * when we set Generate the next result
                     * basically we continue to setting this value (not sure why the breakpoint never succeeded though)
                     *
                     * So... I don't want to mess everything, so if we are in LINEAR mode then we
                     * manualy set the table.
                     */


                    // if (nextTable == old_next_table)
                    //{
                    //     nextTable = Header.Blank;
                    // }
                    //  nextTable = table.NextTable;
                    if (newResult.sResult == " \n")
                    {
                        newResult.sResult = Constants.BLANK;
                    }
                    sResult.sResult   = sResult.sResult + newResult.sResult;
                    sResult.nModifier = newResult.nModifier;
                }
                else
                {
                    // if we hit a null then we hit user error
                    // abort
                    nextTable = Constants.BLANK;
                }
            }


            nextTable = sOriginalNextTable;
            return(sResult.sResult);
        }