public List <Situation> SituationList(int id, Situation.SituationType type) { List <Situation> situations = new List <Situation>(); foreach (Plant plant in GetPlants()) { situations.Add(Database.GetSituation(id, Situation.SituationType.Ideal)); } return(situations); }
public Situation GetSituation(int id, Situation.SituationType type) { string query = "SELECT * FROM [Current_situation] WHERE [Planter] = @id;"; SqlCommand cmd = new SqlCommand(query, conn); cmd.CommandType = CommandType.Text; if (type == Situation.SituationType.Current) { cmd.Parameters.AddWithValue("@situation", "Current_situation"); cmd.Parameters.AddWithValue("@identifier", "Planter"); } else if (type == Situation.SituationType.Desired) { cmd.Parameters.AddWithValue("@situation", "Desired_situation"); cmd.Parameters.AddWithValue("@identifier", "Planter"); } else if (type == Situation.SituationType.Ideal) { cmd.Parameters.AddWithValue("@situation", "Ideal_situation"); cmd.Parameters.AddWithValue("@identifier", "Plant"); } cmd.Parameters.AddWithValue("@id", id); conn.Open(); SqlDataReader result = cmd.ExecuteReader(); if (result.HasRows) { if (result.Read()) { int air = result.GetInt32(1); int hum = result.GetInt32(2); int light = result.GetInt32(3); int soil = result.GetInt32(4); int temp = result.GetInt32(5); conn.Close(); return(new Situation(type, id, air, hum, light, soil, temp)); } else { conn.Close(); return(null); } } else { conn.Close(); return(new Situation(Situation.SituationType.Current, 0, 0, 0, 0, 0, 0)); return(null); } }
public Situation GetSituation(int id, Situation.SituationType type) { return(Database.GetSituation(id, type)); }