Example #1
0
        // Need to do player orderbook report still


        public static List <AdgvColumn> PlayerOrderbookAdgvCols()
        {
            List <AdgvColumn> cols = new List <AdgvColumn>();

            AdgvColumn col = new AdgvColumn("order_id", typeof(int));

            cols.Add(col);
            col = new AdgvColumn("is_ask", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("share_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("num", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("price", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("player_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("player_name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("club_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("club_name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("position", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("wages", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("value", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("value_wages", typeof(decimal));
            cols.Add(col);
            col = new AdgvColumn("fitness", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("morale", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("injured", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("injury_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("form", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("rating", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("banned", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("cup_tied", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("yellow_cards", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("red_cards", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("dob", typeof(DateTime));
            cols.Add(col);
            col = new AdgvColumn("foot", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("height", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("weight", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("country_id", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("agent_name", typeof(string));
            cols.Add(col);

            return(cols);
        }
Example #2
0
        public static List <AdgvColumn> ClubOrderbookAdgvCols()
        {
            List <AdgvColumn> cols = new List <AdgvColumn>();

            AdgvColumn col = new AdgvColumn("order_id", typeof(int));

            cols.Add(col);
            col = new AdgvColumn("is_ask", typeof(string));
            cols.Add(col);
            //col = new AdgvColumn("share_type", typeof(string));
            //cols.Add(col);
            col = new AdgvColumn("share_id", typeof(int));
            cols.Add(col);
            // Add in club name.
            col = new AdgvColumn("club_name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("num", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("price", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("total", typeof(int));
            cols.Add(col);
            //col = new AdgvColumn("club_id", typeof(int));
            //cols.Add(col);
            //col = new AdgvColumn("club_name", typeof(string));
            //cols.Add(col);
            col = new AdgvColumn("balance", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("form", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("fans_start", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("fans_current", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("stadium_size_start", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("stadium_size_current", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("stadium_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("manager_name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("chairman_name", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("home_colour", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("away_colour", typeof(string));
            cols.Add(col);
            col = new AdgvColumn("value", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("default_formation", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("rating", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("country_id", typeof(string));
            cols.Add(col);
            //col = new AdgvColumn("committed_tactics", typeof(Byte[]));
            //cols.Add(col);
            col = new AdgvColumn("game_world_id", typeof(int));
            cols.Add(col);
            col = new AdgvColumn("proposed_manager", typeof(string));
            cols.Add(col);

            return(cols);
        }