private void trunDbBtn_Click(object sender, EventArgs e)
{
try
{
using (var context = new ApplicationDbContext())
{
var listener = new ProgressBarListener()
{
Context = context, Bar = sqlProgressBar, StatusLbl = sqlStatusLbl
};
listener.listen();
List <string> tableList = context.Model.GetEntityTypes()
.Select(t => t.GetTableName())
.Distinct()
.ToList();
foreach (string t in tableList)
{
string prefix = "dbo.";
string name = prefix + t;
context.Database.ExecuteSqlRaw("DELETE FROM " + name);
}
context.SaveChanges();
}
} catch (DbUpdateException ex)
{
debugBox.Text = "An error occured while saving changes\n" + ex.Message;
}
}
private void fillDbBtn_Click(object sender, EventArgs e)
{
try
{
using (var context = new ApplicationDbContext())
{
var listener = new ProgressBarListener {
Context = context, Bar = sqlProgressBar, StatusLbl = sqlStatusLbl
};
listener.listen();
var exampleK1 = new Kunde
{
Anrede = 0,
Vorname = "Max",
Nachname = "Mustermann",
Adresse = "Musterstr. 1",
Plz = 12345,
Ort = "Musterstadt",
Telefon = "+49123 456789",
Email = "*****@*****.**",
Bemerkungen = "",
Rechnungen = new List <Rechnung>
{
new Rechnung {
KundeId = 1, ObjektId = 1, Datum = new DateTime(2021, 05, 19, 10, 30, 00), Taetigkeiten = "(automatisch generiert)", Material = "(automatisch generiert)", Arbeitszeit = new TimeSpan(1, 30, 0), Summe = 65, Bemerkungen = "(automatisch generiert)"
},
new Rechnung {
KundeId = 1, ObjektId = 1, Datum = new DateTime(2021, 05, 26, 14, 00, 00), Taetigkeiten = "(automatisch generiert)", Material = "(automatisch generiert)", Arbeitszeit = new TimeSpan(1, 30, 0), Summe = 65, Bemerkungen = "(automatisch generiert)"
},
},
Objekte = new List <Objekt>
{
new Objekt {
KundeId = 1, Adresse = "Musterstr. 2", Plz = 12345, Ort = "Musterstadt", Bemerkungen = ""
},
}
};
context.Kunden.Add(exampleK1);
context.SaveChanges();
}
} catch (DbUpdateException ex)
{
debugBox.Text = "An error occured while saving changes\n" + ex.Message;
}
}