Пример #1
0
        /// <summary>
        /// Gets what resources a planet has. By giving it the Planet id.
        /// </summary>
        /// <param name="planetId"></param>
        /// <returns></returns>
        public List <Resourcedata> PlanetResources(int planetId)
        {
            List <Resourcedata> result = new List <Resourcedata>();

            if (Check())
            {
                string Query = string.Format("SELECT resources.Resources_id, resources.Name, resources.Initial_Price, resources.Description, planetresources.Price FROM resource, planetresources WHERE resources.Resources_id == planetresources.Resources_id AND planetresources.Planet_id = {0};", planetId);
                using (SQLiteCommand command = new SQLiteCommand(Query, dbc))
                {
                    try
                    {
                        using (SQLiteDataReader rdq = command.ExecuteReader())
                        {
                            while (rdq.Read())
                            {
                                Resourcedata record = new Resourcedata(rdq.GetInt32(0), rdq.GetString(1), rdq.GetInt32(2), rdq.GetString(3), planetId, 0, 0, 0, rdq.GetInt32(4), 0, "null");
                                result.Add(record);
                            }
                        }
                    }
                    catch (Exception ex) { Console.WriteLine("Error " + ex); }
                }
            }
            return(result);
        }
Пример #2
0
        /// <summary>
        /// This gets the resource information if you give it the resource_id.
        /// </summary>
        /// <param name="resource_id"></param>
        /// <returns></returns>
        public List <Resourcedata> getResource(int resources_id)
        {
            List <Resourcedata> result = new List <Resourcedata>();

            if (Check())
            {
                string Query = string.Format("SELECT resources.Resources_id, resources.Name, resources.Initial_Price, resources.Description, media.Media_id, media.file_Loc FROM resources, resourcesmedia, media WHERE (resources.Resources_id == resourcesmedia.Resources_id AND resourcesmedia.Media_id == media.Media_id) AND resources.Resources_id == {0};", resources_id);
                using (SQLiteCommand command = new SQLiteCommand(Query, dbc))
                {
                    try
                    {
                        using (SQLiteDataReader rdq = command.ExecuteReader())
                        {
                            while (rdq.Read())
                            {
                                Resourcedata record = new Resourcedata(rdq.GetInt32(0), rdq.GetString(1), rdq.GetInt32(2), rdq.GetString(3), 0, 0, 0, 0, 0, rdq.GetInt32(4), rdq.GetString(5));
                                result.Add(record);
                            }
                        }
                    }
                    catch (Exception ex) { Console.WriteLine("Error " + ex); }
                }
            }
            return(result);
        }
Пример #3
0
        /// <summary>
        /// Gets all the resources what the ship selected has.
        /// </summary>
        /// <param name="shipId"></param>
        /// <returns></returns>
        public List <Resourcedata> ShipResources(int shipId)
        {
            List <Resourcedata> result = new List <Resourcedata>();

            if (Check())
            {
                string Query = string.Format("SELECT resources.Resources_id, resources.Name, resources.Initial_Price, resources.Description, shipresource.Amount, shipresource.Bought_Price FROM resource, shipresource WHERE resources.Resources_id == shipresource.Resources_id AND shipresource.Ship_id = '{0}';", shipId);
                using (SQLiteCommand command = new SQLiteCommand(Query, dbc))
                {
                    try
                    {
                        using (SQLiteDataReader rdq = command.ExecuteReader())
                        {
                            while (rdq.Read())
                            {
                                Resourcedata record = new Resourcedata(rdq.GetInt32(0), rdq.GetString(1), rdq.GetInt32(2), rdq.GetString(3), 0, 0, shipId, rdq.GetInt32(4), rdq.GetInt32(5), 0, "null");
                                result.Add(record);
                            }
                        }
                    }
                    catch (Exception ex) { Console.WriteLine("Error " + ex); }
                }
            }
            return(result);
        }
Пример #4
0
        public List <Resourcedata> getResource(int resource_id)
        {
            List <Resourcedata> result = new List <Resourcedata>();
            Resourcedata        record = new Resourcedata(1, "resour", 2, "descrp", 1, 2, 3, 4, 5, 6, "loc");

            result.Add(record);
            return(result);
        }
Пример #5
0
        public List <Resourcedata> ShipResources(int shipId)
        {
            List <Resourcedata> result = new List <Resourcedata>();
            Resourcedata        record = new Resourcedata(shipId, "resour", 2, "descrp", 1, 2, 3, 4, 5, 6, "loc");

            result.Add(record);
            return(result);
        }