예제 #1
0
        public string[] GetAllLogNames()
        {
            System.Collections.Generic.IList <string> allLogs = new System.Collections.Generic.List <string>();
            using (EventLogSession logSession = new EventLogSession())
            {
                IEnumerable <string> logNames = logSession.GetLogNames();
                foreach (string logName in logNames)
                {
                    using (EventLogConfiguration logConfig = new EventLogConfiguration(logName))
                    {
                        if (logConfig.IsEnabled)
                        {
                            allLogs.Add(logName);
                        }
                    }
                }
            }

            return(allLogs.Cast <string>().ToArray());
        }
        public ActionResult loadGrid(String Uni, int Year, String Location, String Type, String SubType)
        {
            SearchViewModel model = new SearchViewModel();

            model.PageSize = 25;
            int    columns = 0;
            String sql     = "Select ";

            if (SubType.Equals("All"))
            {
                sql = sql + "*";
            }
            else
            {
                sql = sql + SubType;
            }
            int flag = 0;

            Type = (Type == "Criminal Offense") ? "Criminal_Offense" : Type;
            sql  = sql + " from " + Type + " where id in (select id from locationyear where name = '" + Uni + "' AND year = " + Year + " AND location = '" + Location + "')";
            //var temp;
            //Console.WriteLine(sql);
            List <string> tempList = new List <string>();

            if (Type == "Discipline")
            {
                flag = 1;
                var temp = new System.Collections.Generic.List <Discipline>();
                tempList.Add("id"); tempList.Add("drug"); tempList.Add("weapon"); tempList.Add("liquor");
                model.generalList = temp.Cast <object>().ToList();
            }
            else if (Type == "Arrests")
            {
                flag = 2;
                tempList.Add("id"); tempList.Add("drug"); tempList.Add("weapon"); tempList.Add("liquor");
                var temp = new System.Collections.Generic.List <Arrests>();
                model.generalList = temp.Cast <object>().ToList();
            }
            else if (Type == "Criminal_Offense")
            {
                flag = 3;
                tempList.Add("id"); tempList.Add("burgla"); tempList.Add("murd"); tempList.Add("vehic"); tempList.Add("neg_m"); tempList.Add("robbe"); tempList.Add("forcib"); tempList.Add("nonfor"); tempList.Add("agg_a"); tempList.Add("arson");
                var temp = new System.Collections.Generic.List <Criminal_Offense>();
                model.generalList = temp.Cast <object>().ToList();
            }

            else if (Type == ("VAWA"))
            {
                flag = 4;
                tempList.Add("id"); tempList.Add("stalk"); tempList.Add("dating"); tempList.Add("domest");
                var temp = new System.Collections.Generic.List <VAWA>();
                model.generalList = temp.Cast <object>().ToList();
            }
            //new System.Collections.Generic.List<Discipline>();
            //model.Location.Add(new LocYear(2014, "UF", "FL", "Campus"));
            model.PageSize = 25;

            int class_type = 0;

            using (connection)
            {
                connection.Open();
                //string sql = "Select NAME, STATE, YEAR, LOCATION FROM LOCATIONYEAR WHERE STATE = 'FL'";
                OracleCommand cmd = new OracleCommand(sql, connection);
                cmd.CommandType = System.Data.CommandType.Text;
                OracleDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    switch (flag)
                    {
                    case 1:
                        Discipline di = new Discipline(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3));

                        class_type = 1;
                        columns    = 4;
                        model.generalList.Add(di);
                        break;

                    case 2:
                        Arrests ar = new Arrests(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3));

                        columns    = 4;
                        class_type = 2;
                        model.generalList.Add(ar);
                        break;

                    case 3:
                        Criminal_Offense co = new Criminal_Offense(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9));

                        columns    = 10;
                        class_type = 3;
                        model.generalList.Add(co);
                        break;

                    case 4:
                        VAWA va = new VAWA(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3));

                        columns    = 4;
                        class_type = 4;
                        model.generalList.Add(va);
                        break;
                    }
                    //;
                }
                connection.Close();
            }
            ViewBag.NbColumns  = columns;
            ViewBag.Tlist      = tempList;
            ViewBag.Class_Type = class_type;
            return(View("loadGrid", new Tuple <SearchViewModel, Discipline>(model, null)));
            //return Json(model);
        }
        public string[] GetAllLogNames()
        {
            System.Collections.Generic.IList<string> allLogs = new System.Collections.Generic.List<string>();
            using (EventLogSession logSession = new EventLogSession())
            {
                IEnumerable<string> logNames = logSession.GetLogNames();
                foreach (string logName in logNames)
                {
                    using (EventLogConfiguration logConfig = new EventLogConfiguration(logName))
                    {
                        if (logConfig.IsEnabled)
                        {
                            allLogs.Add(logName);
                        }
                    }
                }
            }

            return allLogs.Cast<string>().ToArray();
        }