Example #1
0
        public static List <string> GetModels(int brandId)
        {
            List <string> models             = new List <string>();
            var           carBrandsSqlResult = MySqlExecuter.SelectData($"SELECT Name FROM car_models WHERE Brand_Id='{brandId}' AND Name<>''", MySqlRouter.GetConnectionString());

            if (carBrandsSqlResult.HasError)
            {
                throw new Exception(carBrandsSqlResult.ErrorText);
            }
            else
            {
                foreach (DataRow row in carBrandsSqlResult.ResultData.Rows)
                {
                    models.Add(row["Name"].ToString());
                }
                return(models);
            }
        }
Example #2
0
        public static List <Brand> GetAllBrands()
        {
            List <Brand> cars = new List <Brand>();
            var          carBrandsSqlResult = MySqlExecuter.SelectData("SELECT Id, Name FROM car_brands WHERE Name<>''", MySqlRouter.GetConnectionString());

            if (carBrandsSqlResult.HasError)
            {
                throw new Exception(carBrandsSqlResult.ErrorText);
            }
            else
            {
                foreach (DataRow row in carBrandsSqlResult.ResultData.Rows)
                {
                    int    id    = Int32.Parse(row["Id"].ToString());
                    string brand = row["Name"].ToString();
                    cars.Add(new Brand(id, brand));
                }
                return(cars);
            }
        }