MainWindowGridController.cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using Shared;
using System.Data;
using System.Drawing;

namespace Client
{
    public partial class MainWindow : Form
    {
        private GridFormats gridFormat = GridFormats.None;
        
        enum GridFormats {
            Project,
            Literature,
            Search,
            User,
            Tag,
            None
        }

        public enum SearchTypes
        {
            FreeText,
            ByTag,
            Relevance
        }
        private struct PreviousSearch
        {
            public SearchTypes byTag;
            public string query;
            public object Tag; 
            public ResultType types;
            public int resultCount;
            public PreviousSearch(string query, ResultType type, SearchTypes byTag, int resultCount)
            {
                this.byTag = byTag;
                this.query = query;
                this.types = type;
                this.resultCount = resultCount;
                Tag = null;
            }
            public PreviousSearch(string query, ResultType type, SearchTypes byTag, int resultCount, object tag)
            {
                this.byTag = byTag;
                this.query = query;
                this.types = type;
                this.resultCount = resultCount;
                this.Tag = tag;
            }
        }


        DataTable currentData = null;


        private void SetProjectGrid()
        {
            currentData = new DataTable();
            currentData.Columns.Add("object", typeof(ISearchable));
            currentData.Columns.Add(" ", typeof(Image));
            currentData.Columns.Add("Title", typeof(string));
            currentData.Columns.Add("Subject", typeof(string));
            currentData.Columns.Add("Department", typeof(string));
            currentData.Columns.Add("Year", typeof(string));
            mainGridView.DataSource = null;
            mainGridView.DataSource = currentData;

            gridFormat = GridFormats.Project;

            mainGridView.Columns[0].Visible = false;

            mainGridView.Columns[1].Width = 20;
            mainGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[1].Resizable = DataGridViewTriState.False;
            mainGridView.Columns[1].ReadOnly = true;

            mainGridView.Columns[2].Width = 245;
            mainGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            mainGridView.Columns[2].ReadOnly = true;

            mainGridView.Columns[3].Width = 150;
            mainGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[3].ReadOnly = true;

            mainGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[4].Width = 150;
            mainGridView.Columns[4].ReadOnly = true;

            mainGridView.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[5].Width = 40;
            mainGridView.Columns[5].ReadOnly = true;
        }
        public void ShowProjects()
        {
            ShowProjects(null, false);
        }
        public void ShowProjects(string query, bool userSearch)
        {
            if (gridFormat != GridFormats.Project)
            {
                SetProjectGrid();
            }
            currentData.Rows.Clear();
            ProjectInfo[] items;
            List<SearchResult> results = null;
            if (query == null)
                items = accessHandler.ListProjects();
            else if(!userSearch)
            {
                results = accessHandler.Search(query, ResultType.Project);
                items = new ProjectInfo[results.Count];
            }
            else
            {
                ISearchable[] gg = accessHandler.ListItems(ResultType.Project, query);
                items = new ProjectInfo[gg.Length];
                for (int i = 0; i < gg.Length; i++)
                {
                    items[i] = (ProjectInfo)gg[i];
                }
            }
            
            for(int i=0;i<items.Length;i++)
            {
                if (query != null && !userSearch)
                    items[i] = (ProjectInfo)results[i].Item;

                currentData.Rows.Add(
                    items[i],
                    global::Client.Properties.Resources.ResourceManager.GetObject("project"), 
                    items[i].Title, 
                    items[i].subject, 
                    items[i].department, 
                    items[i].Date == DateTime.MinValue ? "" : items[i].Date.Year.ToString()
                    );
            }
        }
        private void SetLiteratureGrid()
        {
            currentData = new DataTable();
            currentData.Columns.Add("object", typeof(ISearchable));
            currentData.Columns.Add(" ", typeof(Image));
            currentData.Columns.Add("Title", typeof(string));
            currentData.Columns.Add("Author(s)", typeof(string));
            currentData.Columns.Add("ISBN", typeof(string));
            currentData.Columns.Add("Year", typeof(string));
            mainGridView.DataSource = null;
            mainGridView.DataSource = currentData;

            gridFormat = GridFormats.Literature;

            mainGridView.Columns[0].Visible = false;

            mainGridView.Columns[1].Width = 20;
            mainGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[1].Resizable = DataGridViewTriState.False;
            mainGridView.Columns[1].ReadOnly = true;

            mainGridView.Columns[2].Width = 245;
            mainGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            mainGridView.Columns[2].ReadOnly = true;

            mainGridView.Columns[3].Width = 150;
            mainGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[3].ReadOnly = true;

            mainGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[4].Width = 150;
            mainGridView.Columns[4].ReadOnly = true;

            mainGridView.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[5].Width = 40;
            mainGridView.Columns[5].ReadOnly = true;
        }

        public void ShowLiterature()
        {
            ShowLiterature(null, false);
        }
        public void ShowLiterature(string query, bool userSearch)
        {
            if (gridFormat != GridFormats.Literature)
            {
                SetLiteratureGrid();
            }
            currentData.Rows.Clear();
            LiteratureInfo[] items;
            List<SearchResult> results = null;
            if (query == null)
                items = accessHandler.ListLiterature();
            else if (!userSearch)
            {
                results = accessHandler.Search(query, ResultType.Literature);
                items = new LiteratureInfo[results.Count];
            }
            else
            {
                ISearchable[] gg = accessHandler.ListItems(ResultType.Literature, query);
                items = new LiteratureInfo[gg.Length];
                for (int i = 0; i < gg.Length; i++)
                {
                    items[i] = (LiteratureInfo)gg[i];
                }
            }

            for (int i = 0; i < items.Length; i++)
            {
                if (query != null && !userSearch)
                    items[i] = (LiteratureInfo)results[i].Item;

                currentData.Rows.Add(
                    items[i],
                    global::Client.Properties.Resources.ResourceManager.GetObject("literature"),
                    items[i].Title,
                    items[i].author,
                    items[i].isbn,
                    items[i].Date == DateTime.MinValue ? "" : items[i].Date.Year.ToString()
                    );
            }
        }

        private void SetUsersGrid()
        {
            currentData = new DataTable();
            currentData.Columns.Add("object", typeof(ISearchable));
            currentData.Columns.Add(" ", typeof(Image));
            currentData.Columns.Add("Name", typeof(string));
            currentData.Columns.Add("Department", typeof(string));
            currentData.Columns.Add("UserName", typeof(string));
            mainGridView.DataSource = null;
            mainGridView.DataSource = currentData;

            gridFormat = GridFormats.User;

            mainGridView.Columns[0].Visible = false;

            mainGridView.Columns[1].Width = 20;
            mainGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[1].Resizable = DataGridViewTriState.False;
            mainGridView.Columns[1].ReadOnly = true;

            mainGridView.Columns[2].Width = 245;
            mainGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            mainGridView.Columns[2].ReadOnly = true;

            mainGridView.Columns[3].Width = 190;
            mainGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[3].ReadOnly = true;

            mainGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[4].Width = 150;
            mainGridView.Columns[4].ReadOnly = true;
        }

        public void ShowUsers()
        {
            ShowUsers(null);
        }
        public void ShowUsers(string query)
        {
            if (gridFormat != GridFormats.User)
            {
                SetUsersGrid();
            }
            currentData.Rows.Clear();
            PersonInfo[] items;
            ISearchable[] r2 = null;
            List<SearchResult> results = null;
            if (query == null)
            {
                r2 = accessHandler.ListItems(ResultType.Person);
                items = new PersonInfo[r2.Length];
            }
            else
            {
                results = accessHandler.Search(query, ResultType.Person);
                items = new PersonInfo[results.Count];
            }

            for (int i = 0; i < items.Length; i++)
            {
                if (query != null)
                    items[i] = (PersonInfo)results[i].Item;
                else
                    items[i] = (PersonInfo)r2[i];

                currentData.Rows.Add(
                    items[i],
                    global::Client.Properties.Resources.ResourceManager.GetObject("user"),
                    items[i].name,
                    items[i].department,
                    items[i].username
                    );
            }
        }
        private void SetTagGrid()
        {
            currentData = new DataTable();
            currentData.Columns.Add("object", typeof(TagInfo));
            currentData.Columns.Add(" ", typeof(Image));
            currentData.Columns.Add("Tag Name", typeof(string));
            currentData.Columns.Add("Tag Usage", typeof(string));
            mainGridView.DataSource = null;
            mainGridView.DataSource = currentData;

            gridFormat = GridFormats.Tag;

            mainGridView.Columns[0].Visible = false;

            mainGridView.Columns[1].Width = 20;
            mainGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[1].Resizable = DataGridViewTriState.False;
            mainGridView.Columns[1].ReadOnly = true;

            mainGridView.Columns[2].Width = 245;
            mainGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            mainGridView.Columns[2].ReadOnly = true;

            mainGridView.Columns[3].Width = 100;
            mainGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[3].ReadOnly = true;
            mainGridView.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;


        }
        public void ShowTags()
        {
            ShowTags(null);
        }
        public void ShowTags(string query)
        {
            if (gridFormat != GridFormats.Tag)
            {
                SetTagGrid();
            }
            currentData.Rows.Clear();
            TagInfo[] tags = accessHandler.GetAllTags();
            Dictionary<string, int> sortedTags = new Dictionary<string, int>();
            
            foreach (TagInfo ti in tags)
            {
                if (sortedTags.ContainsKey(ti.Name))
                    sortedTags[ti.Name]++;
                else sortedTags.Add(ti.Name, 1);
            }

            foreach (KeyValuePair<string, int> kvp in sortedTags)
            {
                TagInfo ti = new TagInfo(kvp.Key, -1, "", kvp.Value);
                currentData.Rows.Add(
                    ti,
                    global::Client.Properties.Resources.ResourceManager.GetObject("tag"),
                    ti.Name,
                    ti.Count
                    );
            }
            mainGridView.Sort(mainGridView.Columns["Tag Usage"], System.ComponentModel.ListSortDirection.Descending);
        }

        private List<ListViewItem> previousSearches = new List<ListViewItem>();
        // a little bool to stop an infinite loop that occurs when the selected index of the sidebar is changed when searching causing a new search to be called.
        private bool IsSearching = false;

        private void SetSearchGrid()
        {
            currentData = new DataTable();
            currentData.Columns.Add("object", typeof(ISearchable));
            currentData.Columns.Add(" ", typeof(Image));
            currentData.Columns.Add("Type", typeof(string));
            currentData.Columns.Add("Title", typeof(string));
            currentData.Columns.Add("Description", typeof(string));
            currentData.Columns.Add("Date", typeof(string));
            currentData.Columns.Add("Score", typeof(float));
            mainGridView.DataSource = null;
            mainGridView.DataSource = currentData;

            gridFormat = GridFormats.Search;

            mainGridView.Columns[0].Visible = false;

            mainGridView.Columns[1].Width = 20;
            mainGridView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[1].Resizable = DataGridViewTriState.False;
            mainGridView.Columns[1].ReadOnly = true;

            mainGridView.Columns[2].ReadOnly = true;
            mainGridView.Columns[2].Width = 75;
            mainGridView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;

            mainGridView.Columns[3].Width = 150;
            mainGridView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            mainGridView.Columns[3].ReadOnly = true;

            mainGridView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            mainGridView.Columns[4].ReadOnly = true;

            mainGridView.Columns[5].Width = 40;
            mainGridView.Columns[5].ReadOnly = true;
            mainGridView.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
            
            mainGridView.Columns[6].Width = 40;
            mainGridView.Columns[6].ReadOnly = true;
            mainGridView.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
        }

        public void ShowSearch()
        {
            ShowSearch(null, ResultType.All, SearchTypes.FreeText);
        }
        public void ShowSearch(string query, ResultType type, SearchTypes searchType)
        {
            ShowSearch(query, type, searchType, null);
        }
        
        public void ShowSearch(string query, ResultType type, SearchTypes searchType, object tag)
        {
            if (gridFormat != GridFormats.Search)
            {
                SetSearchGrid();
            }
            currentData.Rows.Clear();

            if (string.IsNullOrEmpty(query) || query.Length < 3)
                return;

            IsSearching = true;

            

            ISearchable[] results = null;
            if (query == null)
            {
                results = accessHandler.ListItems(type);
            }
            else
            {
                switch (searchType)
                {
                    case SearchTypes.FreeText:
                        results = accessHandler.Search(query, type).ToArray();
                        break;
                    case SearchTypes.ByTag:
                        results = accessHandler.SearchByTag(query).ToArray();
                        break;
                    case SearchTypes.Relevance:
                        results = accessHandler.ShowRelated((int)tag).ToArray();
                        break;
                    default:
                        break;
                }
                
            }
            string img = "find.png";

            bool found = false;
            foreach (ListViewItem lvi in previousSearches)
            {
                PreviousSearch ps = (PreviousSearch)lvi.Tag;
                if (ps.query.ToLower() == query.ToLower())
                {
                    found = true;
                    lvi.Selected = true;
                    ps.resultCount = results.Length;
                    lvi.Text = query + " (" + results.Length + ")";
                }
            }
            if (!found)
            {
                ListViewItem lvi = new ListViewItem(query + " (" + results.Length + ")", img, sidebarTree.Groups[2]);
                lvi.Tag = new PreviousSearch(query, type, searchType, results.Length, tag);
                previousSearches.Insert(0, lvi);
                sidebarTree.Items.Insert(0, lvi);
                lvi.Selected = true;
            }

            for (int i = 0; i < results.Length; i++)
            {
                object image;

                ISearchable asd = results[i] is SearchResult ? ((SearchResult)results[i]).Item : results[i];

                if (asd is LiteratureInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("literature");
                else if (asd is ProjectInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("project");
                else if (asd is PersonInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("user");
                else
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("edit");
                
                float relevance = results[i] is SearchResult ? ((SearchResult)results[i]).Relevance : 0;

                string date = results[i].Date != DateTime.MinValue ? results[i].Date.Year.ToString() : "N/A";


                currentData.Rows.Add(
                    asd,
                    image,
                    results[i].Type,
                    results[i].Title,
                    results[i].Description,
                    date,
                    Math.Round(relevance, 1)
                    );
            }
            UpdateStats();
            IsSearching = false;
        }

        public void ShowRelated(int id)
        {
            if (gridFormat != GridFormats.Search)
            {
                SetSearchGrid();
            }
            currentData.Rows.Clear();

            IsSearching = true;

            ISearchable[] results = accessHandler.ShowRelated(id).ToArray();

            for (int i = 0; i < results.Length; i++)
            {
                object image;

                ISearchable asd = results[i] is SearchResult ? ((SearchResult)results[i]).Item : results[i];

                if (asd is LiteratureInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("literature");
                else if (asd is ProjectInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("project");
                else if (asd is PersonInfo)
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("user");
                else
                    image = global::Client.Properties.Resources.ResourceManager.GetObject("edit");

                float relevance = results[i] is SearchResult ? ((SearchResult)results[i]).Relevance : 0;

                string date = results[i].Date != DateTime.MinValue ? results[i].Date.Year.ToString() : "N/A";


                currentData.Rows.Add(
                    asd,
                    image,
                    results[i].Type,
                    results[i].Title,
                    results[i].Description,
                    date,
                    Math.Round(relevance, 1)
                    );
            }
            UpdateStats();
            IsSearching = false;
        }


    }
}

---