private void BtnAdd_Click(object sender, EventArgs e)
{
string select = cmbSelect.Text.ToLower();
if (select == "elever")
{
int txtbox1int = Int32.Parse(txtBox1.Text);
int txtbox5int = Int32.Parse(txtBox5.Text);
EleverModel elev = new EleverModel(txtbox1int, txtBox2.Text, txtBox3.Text, txtBox4.Text, txtbox5int, txtBox6.Text);
SqliteDataAccess.AddElev(elev);
}
else if (select == "vårdnadshavare")
{
int txtbox1int = Int32.Parse(txtBox1.Text);
int txtbox5int = Int32.Parse(txtBox5.Text);
int txtbox6int = Int32.Parse(txtBox6.Text);
SqliteDataAccess.NewVårdnadshavare(txtbox1int, txtBox2.Text, txtBox3.Text, txtBox4.Text, txtbox5int, txtbox6int);
}
Back();
}
public static void GenerateHushåll(EleverModel elev, VårdnadshavareModel vårdnadshavare)
{
using IDbConnection cnn = new SQLiteConnection(LoadConnectionString());
cnn.Execute($"INSERT INTO Hushåll (Elev_Personnummer, Vårdnadshavare_Personnummer) VALUES ({elev.Elev_Personnummer}, {vårdnadshavare.Vårdnadshavare_Personnummer})");
}
public static void AddElev(EleverModel Elev)
{
using IDbConnection cnn = new SQLiteConnection(LoadConnectionString());
cnn.Execute($"INSERT INTO Elever VALUES (@Elev_Personnummer, @Namn, @Adress, @Epost, @Telefonnummer, @Klass_Namn)", Elev);
}
