public static PlantSpeciesInfo GetPlantSpeciesInfo(int platnSpeciesId) { PlantSpecies plantSpecies = GetPlantSpecies(platnSpeciesId); PlantSpeciesInfo plantSpeciesInfo = new PlantSpeciesInfo { id = plantSpecies.id, name = plantSpecies.name, varieties = GetVarietiesForPlant(plantSpecies.id) }; return(plantSpeciesInfo); }
private static List <PlantSpecies> GetPlantSpecies(string query) { List <PlantSpecies> plantSpecies = new List <PlantSpecies>(); foreach (var plantSpec in pgSqlSingleManager.ExecuteSQL(query)) { PlantSpecies newPlantSpec = new PlantSpecies { id = Int32.Parse(plantSpec["id"]), name = plantSpec["name"] }; plantSpecies.Add(newPlantSpec); } return(plantSpecies); }
public static PlantSpecies AddPlantSpecies(string name) { pgSqlSingleManager.ExecuteSQL($"insert into cultivation.plant_species (name) values ('{name}')"); var plantResult = pgSqlSingleManager.ExecuteSQL($"select * from cultivation.plant_species where name = '{name}'"); string addPlantQuery = $"insert into cultivation.plants (plant_species) " + $"values ({Int32.Parse(plantResult[0]["id"])})"; pgSqlSingleManager.ExecuteSQL(addPlantQuery); PlantSpecies newPlant = new PlantSpecies { id = Int32.Parse(plantResult[0]["id"]), name = plantResult[0]["name"] }; return(newPlant); }
private static List <Plant> GetPlants(string query) { List <Plant> plants = new List <Plant>(); foreach (var plant in pgSqlSingleManager.ExecuteSQL(query)) { Plant newPlant = new Plant { id = Int32.Parse(plant["id"]), plantSpecies = PlantSpecies.GetPlantSpecies(Int32.Parse(plant["plant_species"])) }; try { newPlant.variety = Variety.GetVariety(Int32.Parse(plant["plant_variety"])); } catch { } plants.Add(newPlant); } return(plants); }