Ejemplo n.º 1
0
        public ActionResult Search(Search searchableStuff)
        {
            string keyword = searchableStuff.keyword;
            List<string> tablesToSearch = new List<string>();
            if (!(searchableStuff.table==null))
            {
                tablesToSearch.Add(searchableStuff.table);
            }
            Search searchResult = new Search();

            List<List<object>> tablesWillSearch = new List<List<object>>();

            if (tablesToSearch.Count()==0)
            {
                tablesWillSearch = DataAccess.DataAccess.ListTables();
            }
            else
            {
                foreach (string table in tablesToSearch)
                {
                    List<object> list = new List<object> { table };
                    tablesWillSearch.Add(list);
                }
            }

            foreach (List<object> tables in tablesWillSearch)
            {
                if (!(tables[0].ToString().StartsWith("Asp") || tables[0].ToString().StartsWith("__")))
                {
                    List<List<object>> tableResults = TableSearch(tables[0], keyword);
                    foreach (List<object> result in tableResults)
                    {
                        switch (tables[0].ToString())
                        {
                            case "Messages":
                                Message m = new Message();
                                m.id = (int)result[0];
                                m.from = (string)result[1];
                                m.to = (string)result[2];
                                m.body = (string)result[3];
                                m.project = (string)result[4];
                                m.time = (DateTime)result[5];
                                searchResult.messages.Add(m);
                                break;
                            case "Projects":
                                Project p = new Project();
                                p.id = (int)result[0];
                                p.name = (string)result[1];
                                p.description = (string)result[2];
                                break;
                            case "Events":
                                Event e = new Event();
                                e.id = (int)result[0];
                                e.calendarId = (int)result[1];
                                e.title = (string)result[2];
                                e.description = (string)result[3];
                                e.occurencetime = (DateTime)result[4];
                                e.time = (DateTime)result[5];
                                searchResult.events.Add(e);
                                break;
                            case "User":
                                User u = new User();
                                u.id = (int)result[0];
                                break;
                            default:
                                Other o = new Other();
                                o.result = result;
                                o.table = (string)tables[0];
                                searchResult.others.Add(o);
                                break;
                        }
                    }
                }
            }

            return View(searchResult);
        }
Ejemplo n.º 2
0
        public ActionResult Tester()
        {
            Project project = new Project();
            project.calendars = new List<Calendar>();
            project.auths = new List<ProjectAuth>();
            project.description = "This is a static description not being pulled from the database.";
            project.name = "This is a static name";

            List<List<object>> calendarResult = DataAccess.DataAccess.Read(Build.StringArray("Calendars"), Build.StringArray("id"), Build.StringArray("id = 1"));
            foreach (List<object> calendar in calendarResult)
            {
                Calendar cal = new Calendar();
                cal.id = (int)calendar[0];
                cal.events = new List<Event>();
                List<List<object>> eventResult = DataAccess.DataAccess.Read(Build.StringArray("Events"), Build.StringArray("id", "calendar_id", "title", "description", "time"), Build.StringArray("calendar_id = " + cal.id));
                foreach (List<object> evt in eventResult)
                {
                    Event e = new Event();
                    e.id = (int)evt[0];
                    e.calendarId = (int)evt[1];
                    e.title = (string)evt[2];
                    e.description = (string)evt[3];
                    e.time = (DateTime)evt[4];
                    cal.events.Add(e);
                }
                project.calendars.Add(cal);
            }

            return View("Mock", project);
        }
Ejemplo n.º 3
0
        public ActionResult Project(int id)
        {
            // if (!Authorized(id))
             //   return Redirect("/");

            Session["ProjectViewed"] = id;
            NotificationController _notificationController = new NotificationController();

            Project project = new Project();
            project.calendars = new List<Calendar>();
            project.auths = new List<ProjectAuth>();
            project.description = "This is a static description not being pulled from the database.";
            project.name = "This is a static name";
            project.chat = Chat();
            //project.notifications =  @{Html.RenderAction("NotificationView");}

            List<List<object>> calendarResult = DataAccess.DataAccess.Read(Build.StringArray("Calendars"), Build.StringArray("id"), Build.StringArray("project_id = " + Session["ProjectViewed"]));
            foreach (List<object> calendar in calendarResult)
            {
                Calendar cal = new Calendar();
                cal.id = (int)calendar[0];
                Session["Calendar"] = cal.id;
                cal.events = new List<Event>();
                List<List<object>> eventResult = DataAccess.DataAccess.Read(Build.StringArray("Events"), Build.StringArray("id", "calendar_id", "title", "description", "_time"), Build.StringArray("calendar_id = " + cal.id));
                foreach (List<object> evt in eventResult)
                {
                    Event e = new Event();
                    e.id = (int)evt[0];
                    e.calendarId = (int)evt[1];
                    e.title = (string)evt[2];
                    e.description = (string)evt[3];
                    e.time = (DateTime)evt[4];
                    cal.events.Add(e);
                }
                project.calendars.Add(cal);
            }

            return View("Mock", project);
        }