public bool update(DB_objects.Scenario s)
{
SqlCommand comm = new SqlCommand("UPDATE scenario SET name=@name, description=@description WHERE scenario_code=@scenario_code", myConnection);
comm.Parameters.Add("@name", s.name);
comm.Parameters.Add("@description", s.description);
comm.Parameters.Add("@scenario_code", s.scenario_code);
return(comm.ExecuteNonQuery() == 1);
}
public bool create(DB_objects.Scenario s)
{
SqlCommand comm = new SqlCommand("INSERT INTO scenario(name, description) VALUES(@name, @description)", myConnection);
comm.Parameters.Add("@name", s.name);
comm.Parameters.Add("@description", s.description);
int id = -1;
id = (Int32)comm.ExecuteScalar();
if (id == -1)
{
return(false);
}
s.scenario_code = id;
return(true);
}
private static void fillScenarios(string language, SqlConnection connection)
{
SqlCommand cmd = new SqlCommand("sp_connectScenario", connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@selectedLanguage", System.Data.SqlDbType.NVarChar).Value = language;
SqlDataReader reader = cmd.ExecuteReader();
DB_objects.Scenario s;
while (reader.Read())
{
s = new DB_objects.Scenario(reader[1].ToString(), reader[2].ToString());
s.addAttribute(reader[3].ToString(), reader[4].ToString(), reader[5].ToString());
scenarios[reader[0].ToString()] = s;
}
reader.Close();
}
public List <DB_objects.Scenario> retrieve()
{
List <DB_objects.Scenario> result = new List <DB_objects.Scenario>();
SqlCommand comm = new SqlCommand("SELECT scenario_code, name, description " +
"FROM scenario ", myConnection);
SqlDataReader reader = comm.ExecuteReader();
DB_objects.Scenario s;
while (reader.Read())
{
s = new DB_objects.Scenario();
s.scenario_code = Int32.Parse(reader[0].ToString());
s.name = reader[1].ToString();
s.description = reader[2].ToString();
result.Add(s);
}
reader.Close();
return(result);
}
