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));
}
