public Plant Insert(Plant entity)
{
using (SQLiteConnection connection = db.Connection)
{
string query = @"INSERT INTO Plant VALUES (null, :naam, :plant_grootte_id, :zaailing, :verplant, :opmerking, :voorraad)";
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
command.Parameters.AddWithValue("naam", entity.Naam);
command.Parameters.AddWithValue("plant_grootte_id", ConvertPlantGrootte.GetPlantGrootteId(entity.PlantGrootte));
command.Parameters.AddWithValue("zaailing", entity.Zaailing);
command.Parameters.AddWithValue("verplant", entity.Verplant);
command.Parameters.AddWithValue("opmerking", entity.Opmerking);
command.Parameters.AddWithValue("voorraad", entity.Voorraad);
try
{
//command.ExecuteNonQuery();
command.ExecuteScalar(System.Data.CommandBehavior.KeyInfo);
entity.Id = db.getLastInsertedId(connection);
return(entity);
}
catch (SQLiteException e)
{
// If a PK constraint was violated, handle the exception
if (e.ResultCode == SQLiteErrorCode.Constraint)
{
return(entity);
}
// Unexpected error: rethrow to let the caller handle it
throw;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (validateFields())
{
Plant.Naam = txtNaam.Text;
Plant.Opmerking = txtOpmerking.Text;
Plant.PlantGrootte = ConvertPlantGrootte.Convert(Convert.ToInt32(nudMinHoogte.Value), Convert.ToInt32(nudMaxHoogte.Value));
Plant.Zaailing = Convert.ToInt32(nudJaarling.Value);
Plant.Verplant = Convert.ToInt32(nudVerplant.Value);
Plant.Voorraad = Convert.ToInt32(nudAantal.Value);
DialogResult = DialogResult.OK;
}
}
private void PlantAddEdit_Load(object sender, EventArgs e)
{
Text = Plant.Naam + " bewerken";
if (Plant.Naam == null)
{
Text = "Nieuwe plant";
}
txtNaam.Text = Plant.Naam;
txtOpmerking.Text = Plant.Opmerking;
nudAantal.Value = Plant.Voorraad;
int[] plantGrootte = ConvertPlantGrootte.Convert(Plant.PlantGrootte);
nudMinHoogte.Value = Plant.MinHoogte();
nudMaxHoogte.Value = Plant.MaxHoogte();
nudJaarling.Value = Plant.Zaailing;
nudVerplant.Value = Plant.Verplant;
}
public bool Update(Plant entity)
{
using (SQLiteConnection connection = db.Connection)
{
string query = string.Format(@"UPDATE Plant
SET naam=:naam,plant_grootte_id=:plant_grootte_id,zaailing=:zaailing,verplant=:verplant,opmerking=:opmerking,voorraad=:voorraad
WHERE id = {0};" , entity.Id);
using (SQLiteCommand command = new SQLiteCommand(query, connection))
{
command.Parameters.AddWithValue("naam", entity.Naam);
command.Parameters.AddWithValue("plant_grootte_id", ConvertPlantGrootte.GetPlantGrootteId(entity.PlantGrootte));
command.Parameters.AddWithValue("zaailing", entity.Zaailing);
command.Parameters.AddWithValue("verplant", entity.Verplant);
command.Parameters.AddWithValue("opmerking", entity.Opmerking);
command.Parameters.AddWithValue("voorraad", entity.Voorraad);
try
{
//command.ExecuteNonQuery();
var key = command.ExecuteScalar(System.Data.CommandBehavior.KeyInfo);
return(true);
}
catch (SQLiteException e)
{
// If a PK constraint was violated, handle the exception
if (e.ResultCode == SQLiteErrorCode.Constraint)
{
return(false);
}
// Unexpected error: rethrow to let the caller handle it
throw;
}
}
}
}
public void TestGetPlantGrootteId()
{
Assert.AreEqual(1, ConvertPlantGrootte.GetPlantGrootteId(Plant.Grootte.G0020));
Assert.AreEqual(2, ConvertPlantGrootte.GetPlantGrootteId(Plant.Grootte.G2040));
Assert.AreEqual(3, ConvertPlantGrootte.GetPlantGrootteId(Plant.Grootte.G4060));
}
public void TestNumbersToEnum()
{
Plant.Grootte plantGrootte = ConvertPlantGrootte.Convert(120, 140);
Assert.AreEqual(Plant.Grootte.G120140, plantGrootte);
}
public void TestEumToNumbers()
{
int[] plantGrootte = ConvertPlantGrootte.Convert(Plant.Grootte.G120140);
Assert.AreEqual(120, plantGrootte[0]);
Assert.AreEqual(140, plantGrootte[1]);
}
public int MaxHoogte()
{
return(ConvertPlantGrootte.Convert(PlantGrootte)[1]);
}
public int MinHoogte()
{
return(ConvertPlantGrootte.Convert(PlantGrootte)[0]);
}