private static SqlCommand UpdateData(Entity.TestData testData, int testDataId)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = $"UPDATE tblTestData SET tekst=@tekst, datum=@datum, getal=@Getal WHERE testdataid={testDataId}";
command.Parameters.AddWithValue("@tekst", testData.Tekst);
command.Parameters.AddWithValue("@datum", testData.Datum);
command.Parameters.AddWithValue("@getal", testData.Getal);
return(command);
}
private static SqlCommand InsertData(Entity.TestData testData)
{
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO tblTestData (tekst, datum, Getal) Values (@tekst, @datum, @Getal)";
command.Parameters.AddWithValue("@tekst", testData.Tekst);
command.Parameters.AddWithValue("@datum", testData.Datum);
command.Parameters.AddWithValue("@getal", testData.Getal);
return(command);
}
public static void Update(Entity.TestData testData, int id)
{
Database db = new Database();
db.ExecuteNonquery(UpdateData(testData, id));
}
public static void Insert(Entity.TestData testData)
{
Database db = new Database();
db.ExecuteNonquery(InsertData(testData));
}
