protected Waterloo ReadNextElement(SqlDataReader reader)
{
Waterloo element = new Waterloo();
element.Status = reader.GetBoolean(1);
return(element);
}
public int Post(Waterloo value)
{
using (SqlConnection conn = new SqlConnection(_connectionString))
using (SqlCommand cmd = new SqlCommand(Insert, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@status", value.Status);
return(cmd.ExecuteNonQuery());
}
}
public IEnumerable <Waterloo> Get()
{
List <Waterloo> liste = new List <Waterloo>();
using (SqlConnection conn = new SqlConnection(_connectionString))
using (SqlCommand cmd = new SqlCommand(GetAll, conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Waterloo w = ReadNextElement(reader);
liste.Add(w);
}
reader.Close();
}
return(liste);
}
public string Post([FromBody] Waterloo value)
{
Waterloo w = new Waterloo(value.Status);
return($"Affected Rows: {bonaparte.Post(w)}");
}
