private void btnToevoegen_Click(object sender, EventArgs e) { string s = ""; Levrancier lev = new Levrancier(); Adress ad = new Adress(); if (txtNaam.Text != "") { lev.Naam = txtNaam.Text; } else { s += "Naam? "; } lev.Omschrijving = rtbOmschrijving.Text; if (txtTel1.Text != "" && txtTel1.Text.ToCharArray().All(c => char.IsDigit(c))) { lev.Telefoon1 = txtTel1.Text; } else { s += "Telefoon1? "; } if (txtTel2.Text != "" && txtTel2.Text.ToCharArray().All(c => char.IsDigit(c))) { lev.Telefoon2 = txtTel2.Text; } if (re.IsMatch(txtEmail.Text)) { lev.Email = txtEmail.Text; } else { s += "Email? "; } if (newAd) { if (txtStraat.Text != "" && txtStraat.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Straat = txtStraat.Text; } else { s += "Adress: Straat ? "; } if (txtHuisNr.Text != "" && txtHuisNr.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Huisnummer = Convert.ToInt32(txtHuisNr.Text); } else { s += "Adress: Huisnummer ? "; } if (txttGem.Text != "" && txttGem.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Gemeente = txttGem.Text; } else { s += "Adress: Gemeente ? "; } if (txtPC.Text != "" && txtPC.Text.ToCharArray().All(c => char.IsDigit(c))) { ad.Postcode = txtPC.Text; } else { s += "Adress: Postcode ? "; } if (txtLand.Text != "" && txtLand.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Land = txtLand.Text; } else { s += "Adress: Land ? "; } } if (s == "") { using (var ctx = new ProjectContext()) { if (newAd && (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null)) { lev.adress = ad; } else if (newAd && ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) != null) { lev.adress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); } else if (!newAd) { lev.adress = ctx.Adressen.FirstOrDefault(a => a.AdressId == ((Adress)cmbAdress.SelectedItem).AdressId); } ctx.Levranciers.Add(lev); ctx.SaveChanges(); EditProduct.Leveranciers = ctx.Levranciers.ToList(); AddProduct.Leveranciers = ctx.Levranciers.ToList(); } EditProduct.cmb_Leveranciere.DataSource = null; EditProduct.cmb_Leveranciere.DataSource = EditProduct.Leveranciers; EditProduct.cmb_Leveranciere.SelectedItem = lev; AddProduct.cmb_Leveranciere.DataSource = null; AddProduct.cmb_Leveranciere.DataSource = AddProduct.Leveranciers; AddProduct.cmb_Leveranciere.SelectedItem = lev; btnToevoegen.DialogResult = DialogResult.OK; } else { MessageBox.Show(s); s = ""; } }
private void btnToevoegen_Click(object sender, EventArgs e) { Klant klt = new Klant(); Adress ad = new Adress(); string s = ""; Regex re = new Regex(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"); if (txtVnaam.Text != "" && txtVnaam.Text.ToCharArray().All(c => char.IsLetter(c))) { klt.Voornaam = txtVnaam.Text; } else { s += "Voornaam ? "; } if (txtAnaam.Text != "" && txtAnaam.Text.ToCharArray().All(c => char.IsLetter(c))) { klt.achternaam = txtAnaam.Text; } else { s += "Achternaam ? "; } if (dtpGD.Value != null && dtpGD.Value < DateTime.Now) { klt.Geboortdatum = dtpGD.Value; } else { s += "Geboortdatum ? "; } if (txtTel1.Text != "" && txtTel1.Text.ToCharArray().All(c => char.IsDigit(c))) { klt.Telefoon1 = txtTel1.Text; if (txtTel2.Text != "") { klt.Telefoon2 = txtTel2.Text; } } else { s += "Telefoon ? "; } if (re.IsMatch(txtEmail.Text)) { klt.Email = txtEmail.Text; } else { s += "Email ? "; } if (newAd) { if (txtStraat.Text != "" && txtStraat.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Straat = txtStraat.Text; } else { s += "Adress: Straat ? "; } if (txtHuisNr.Text != "" && txtHuisNr.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Huisnummer = Convert.ToInt32(txtHuisNr.Text); } else { s += "Adress: Huisnummer ? "; } if (txttGem.Text != "" && txttGem.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Gemeente = txttGem.Text; } else { s += "Adress: Gemeente ? "; } if (txtPC.Text != "" && txtPC.Text.ToCharArray().All(c => char.IsDigit(c))) { ad.Postcode = txtPC.Text; } else { s += "Adress: Postcode ? "; } if (txtLand.Text != "" && txtLand.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Land = txtLand.Text; } else { s += "Adress: Land ? "; } } klt.IsBedrijf = cbBedrijf.Checked; if (txtBTW.Text != "") { klt.BTWNummer = txtBTW.Text; } else { s += "BTW nummer ? "; } klt.IngevoegdDatum = DateTime.UtcNow; if (rtbComentaar.Text != "") { klt.Commentaar = rtbComentaar.Text; } if (s == "") { using (var ctx = new ProjectContext()) { if (newAd && (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null)) { klt.adress = ad; ctx.SaveChanges(); Adresses = ctx.Adressen.ToList(); cmbAdress.DataSource = Adresses; } else if (newAd && ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) != null) { klt.adress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); } else if (!newAd) { klt.adress = ctx.Adressen.FirstOrDefault(a => a.AdressId == ((Adress)cmbAdress.SelectedItem).AdressId); } klt.IngevoegdDoor = ctx.Users.FirstOrDefault(u => u.UserId == Login.user.UserId); ctx.Klanten.Add(klt); ctx.SaveChanges(); Databeheer.Klanten = ctx.Klanten.Include("Adress").Include("IngevoegdDoor").ToList(); AddOrder.Klanten = ctx.Klanten.Include("Adress").Include("IngevoegdDoor").ToList(); EditOrder.Klanten = ctx.Klanten.Include("Adress").Include("IngevoegdDoor").ToList(); } if (AddOrder.cmb_Klanten != null) { AddOrder.cmb_Klanten.DataSource = null; AddOrder.cmb_Klanten.DataSource = AddOrder.Klanten; } if (EditOrder.cmb_Klanten != null) { EditOrder.cmb_Klanten.DataSource = EditOrder.Klanten; EditOrder.cmb_Klanten.Text = klt.ToString(); } if (Databeheer.dgv_klanten != null) { Databeheer.loaddgvklants(); } this.DialogResult = DialogResult.OK; } else { MessageBox.Show(s); s = ""; } }
private void btnOpslaan_Click(object sender, EventArgs e) { string s = ""; Bezorger lev = new Bezorger(); Adress ad = new Adress(); if (txtNaam.Text != "") { lev.Naam = txtNaam.Text; } else { s += "Naam? "; } lev.Omschrijving = rtbOmschrijving.Text; if (txtTel1.Text != "" && txtTel1.Text.ToCharArray().All(c => char.IsDigit(c))) { lev.Telefoon1 = txtTel1.Text; } else { s += "Telefoon1? "; } if (txtTel2.Text != "" && txtTel2.Text.ToCharArray().All(c => char.IsDigit(c))) { lev.Telefoon2 = txtTel2.Text; } if (re.IsMatch(txtEmail.Text)) { lev.Email = txtEmail.Text; } else { s += "Email? "; } if (newAd) { if (txtStraat.Text != "" && txtStraat.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Straat = txtStraat.Text; } else { s += "Adress: Straat ? "; } if (txtHuisNr.Text != "" && txtHuisNr.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Huisnummer = Convert.ToInt32(txtHuisNr.Text); } else { s += "Adress: Huisnummer ? "; } if (txttGem.Text != "" && txttGem.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Gemeente = txttGem.Text; } else { s += "Adress: Gemeente ? "; } if (txtPC.Text != "" && txtPC.Text.ToCharArray().All(c => char.IsDigit(c))) { ad.Postcode = txtPC.Text; } else { s += "Adress: Postcode ? "; } if (txtLand.Text != "" && txtLand.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Land = txtLand.Text; } else { s += "Adress: Land ? "; } } if (s == "") { using (var ctx = new ProjectContext()) { if (newAd && (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null)) { lev.adress = ad; } else if (newAd && ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) != null) { lev.adress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); } else if (!newAd) { lev.adress = ctx.Adressen.FirstOrDefault(a => a.AdressId == ((Adress)cmbAdress.SelectedItem).AdressId); } ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).Naam = lev.Naam; ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).Naam = lev.Omschrijving; ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).Telefoon1 = lev.Telefoon1; ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).Telefoon2 = lev.Telefoon2; ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).Email = lev.Email; ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == Databeheer.bezorger.BezorgerId).adress = lev.adress; ctx.SaveChanges(); Databeheer.Deliverers = ctx.Bezorgers.Include("adress").ToList(); } Databeheer.dgv_Deliverer.DataSource = null; Databeheer.dgv_Deliverer.DataSource = Databeheer.Deliverers; btnOpslaan.DialogResult = DialogResult.OK; } else { MessageBox.Show(s); s = ""; } }
private void button1_Click(object sender, EventArgs e) { User us = new User(); Adress ad = new Adress(); string s = ""; Regex re = new Regex(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"); Regex re1 = new Regex("^(?=.*?[A-Za-z])(?=.*?[0-9])(?=.*?[#?!@$%^_&*-]).{8,}$"); if (txtVnaam.Text != "" && txtVnaam.Text.ToCharArray().All(c => char.IsLetter(c))) us.Voornaam = txtVnaam.Text; else s += "Voornaam ? "; if (txtAnaam.Text != "" && txtAnaam.Text.ToCharArray().All(c => char.IsLetter(c))) us.Achternaam = txtAnaam.Text; else s += "Achternaam ? "; if (dtpGD.Value != null && dtpGD.Value < DateTime.Now) us.Geboortdatum = dtpGD.Value; else s += "Geboortdatum ? "; if (txtTel.Text != "" && txtTel.Text.ToCharArray().All(c => char.IsDigit(c))) us.Telefoon = txtTel.Text; else s += "Telefoon ? "; if (re.IsMatch(txtEmail.Text)) us.Email = txtEmail.Text; else s += "Email ? "; if (newAd) { if (txtStraat.Text != "" && txtStraat.Text.ToCharArray().All(c => char.IsLetter(c))) ad.Straat = txtStraat.Text; else s += "Adress: Straat ? "; if (txtHuisNr.Text != "" && txtHuisNr.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) ad.Huisnummer = Convert.ToInt32(txtHuisNr.Text); else s += "Adress: Huisnummer ? "; if (txttGem.Text != "" && txttGem.Text.ToCharArray().All(c => char.IsLetter(c))) ad.Gemeente = txttGem.Text; else s += "Adress: Gemeente ? "; if (txtPC.Text != "" && txtPC.Text.ToCharArray().All(c => char.IsDigit(c))) ad.Postcode = txtPC.Text; else s += "Adress: Postcode ? "; if (txtLand.Text != "" && txtLand.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) ad.Land = txtLand.Text; else s += "Adress: Land ? "; } us.Role = (RoleUser)cmbRoles.SelectedItem; if (s == "") { using (var ctx = new ProjectContext()) { if (newAd && (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null)) us.adress = ad; else if (newAd && ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) != null) us.adress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); else if (!newAd) us.adress = ctx.Adressen.FirstOrDefault(a => a.AdressId == ((Adress)cmbAdress.SelectedItem).AdressId); ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Voornaam = us.Voornaam; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Achternaam = us.Achternaam; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Geboortdatum = us.Geboortdatum; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Telefoon = us.Telefoon; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Email = us.Email; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).adress = us.adress; ctx.Users.FirstOrDefault(u => u.UserId == Databeheer.user.UserId).Role = us.Role; ctx.SaveChanges(); Databeheer.Users = ctx.Users.Include("Adress").ToList(); } Databeheer.loaddgvusers(); this.DialogResult = DialogResult.OK; } else { MessageBox.Show(s); s = ""; } }
private void btnAddOrder_Click(object sender, EventArgs e) { bool overstock = false; Adress ad = new Adress(); string s = ""; Order ord = new Order(); OrderDetail orddt = new OrderDetail(); ord.OrderDatum = DateTime.UtcNow; ord.status = (OrderStatus)cmbStatus.SelectedItem; if (ord.status > OrderStatus.Geanuleerd && ord.BezorgdDoor == null) { s += "Bestellingen met staus 'Klaar' of 'Verzondzn' moet ueen bezorger hebben ? "; } if (newAd) { if (txtStraat.Text != "" && txtStraat.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Straat = txtStraat.Text; } else { s += "Adress: Straat ? "; } if (txtHuisNr.Text != "" && txtHuisNr.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Huisnummer = Convert.ToInt32(txtHuisNr.Text); } else { s += "Adress: Huisnummer ? "; } if (txttGem.Text != "" && txttGem.Text.ToCharArray().All(c => char.IsLetter(c))) { ad.Gemeente = txttGem.Text; } else { s += "Adress: Gemeente ? "; } if (txtPC.Text != "" && txtPC.Text.ToCharArray().All(c => char.IsDigit(c))) { ad.Postcode = txtPC.Text; } else { s += "Adress: Postcode ? "; } if (txtLand.Text != "" && txtLand.Text.ToCharArray().All(c => char.IsLetterOrDigit(c))) { ad.Land = txtLand.Text; } else { s += "Adress: Land ? "; } } using (var ctx = new ProjectContext()) { foreach (ProductOrdered item in ProductsOrdered) { if (ctx.Products.FirstOrDefault(p => p.ProductId == item.ProductId).UnitsOnStock < item.aantal) { overstock = true; s += $"Slechts {ctx.Products.FirstOrDefault(p => p.ProductId == item.ProductId).UnitsOnStock} stuks zijn beschikbaar voor artikel: {ctx.Products.FirstOrDefault(p => p.ProductId == item.ProductId)} "; } } } if (s == "") { using (var ctx = new ProjectContext()) { this.DialogResult = DialogResult.OK; if (newAd && (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null)) { ord.BezorgdAdress = ad; } else if (newAd && ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) != null) { ord.BezorgdAdress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); } else if (!newAd) { ord.BezorgdAdress = ctx.Adressen.FirstOrDefault(a => a.AdressId == ((Klant)cmbKlanten.SelectedItem).adress.AdressId); } ord.klant = ctx.Klanten.FirstOrDefault(k => k.KlantId == ((Klant)cmbKlanten.SelectedItem).KlantId); ord.user = ctx.Users.FirstOrDefault(a => a.UserId == ((User)Login.user).UserId); if (cmbBezorgers.SelectedIndex > -1) { ord.BezorgdDoor = ctx.Bezorgers.FirstOrDefault(b => b.BezorgerId == ((Bezorger)cmbBezorgers.SelectedItem).BezorgerId); } ctx.Orders.Add(ord); ctx.SaveChanges(); foreach (ProductOrdered item in ProductsOrdered) { orddt.order = ctx.Orders.FirstOrDefault(o => o.OrderId == ord.OrderId); orddt.product = ctx.Products.FirstOrDefault(p => p.ProductId == item.ProductId); orddt.Aantal = item.aantal; ctx.Products.FirstOrDefault(p => p.ProductId == item.ProductId).UnitsOnStock -= item.aantal; ctx.OrderDetails.Add(orddt); ctx.SaveChanges(); } Bestellingen.OrderLines = ctx.Orders.Join(ctx.OrderDetails, o => o.OrderId, od => od.order.OrderId, (o, od) => new OrderLine() { orderid = o.OrderId, klant = o.klant, user = o.user, orderdate = o.OrderDatum, status = o.status, bezorgddoor = o.BezorgdDoor, adress = o.BezorgdAdress, orderdetailid = od.ID, product = od.product, aantal = od.Aantal }).OrderByDescending(o => o.orderdate).ToList(); Bestellingen.loaddgvOrders(); DialogResult dr = MessageBox.Show("FActuur afdrukken?", "", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { printDocument1.Print(); } } } else { MessageBox.Show(s); s = ""; } }
private void btnupload_Click(object sender, EventArgs e) { Product pr = new Product(); OpenFileDialog dialog = new OpenFileDialog(); //dialog.Filter = "Text files | *.txt"; dialog.Multiselect = false; if (dialog.ShowDialog() == DialogResult.OK) { string FileLocation = dialog.FileName; Microsoft.Office.Interop.Word.Application App = new Microsoft.Office.Interop.Word.Application(); Microsoft.Office.Interop.Word.Document Doc = App.Documents.Open(FileLocation); Microsoft.Office.Interop.Word.Table tab1 = Doc.Content.Tables[1]; Microsoft.Office.Interop.Word.Table tab2 = Doc.Content.Tables[2]; Microsoft.Office.Interop.Word.Table tab3 = Doc.Content.Tables[3]; Levrancier lev = new Levrancier(); Adress ad = new Adress(); lev.Naam = tab1.Cell(2, 1).Range.Text.Substring(0, tab1.Cell(2, 1).Range.Text.Length - 2); lev.Omschrijving = tab1.Cell(2, 2).Range.Text.Substring(0, tab1.Cell(2, 2).Range.Text.Length - 2); lev.Telefoon1 = tab1.Cell(2, 3).Range.Text.Substring(0, tab1.Cell(2, 3).Range.Text.Length - 2); lev.Telefoon2 = tab1.Cell(2, 4).Range.Text.Substring(0, tab1.Cell(2, 4).Range.Text.Length - 2); lev.Email = tab1.Cell(2, 5).Range.Text.Substring(0, tab1.Cell(2, 5).Range.Text.Length - 2); ad.Straat = tab2.Cell(2, 1).Range.Text.Substring(0, tab2.Cell(2, 1).Range.Text.Length - 2); ad.Huisnummer = Convert.ToInt32(tab2.Cell(2, 2).Range.Text.Substring(0, tab2.Cell(2, 2).Range.Text.Length - 2)); ad.Gemeente = tab2.Cell(2, 3).Range.Text.Substring(0, tab2.Cell(2, 3).Range.Text.Length - 2); ad.Postcode = tab2.Cell(2, 4).Range.Text.Substring(0, tab2.Cell(2, 4).Range.Text.Length - 2); ad.Land = tab2.Cell(2, 5).Range.Text.Substring(0, tab2.Cell(2, 5).Range.Text.Length - 2); for (int i = 2; i <= tab3.Rows.Count; i++) { pr.ProductNaam = tab3.Cell(i, 1).Range.Text.Substring(0, tab3.Cell(i, 1).Range.Text.Length - 2); pr.UnitPrice = Convert.ToDouble(tab3.Cell(i, 3).Range.Text.Substring(0, tab3.Cell(i, 3).Range.Text.Length - 2)); pr.UnitsOnStock = Convert.ToInt32(tab3.Cell(i, 2).Range.Text.Substring(0, tab3.Cell(i, 2).Range.Text.Length - 2)); pr.ProductNummer = tab3.Cell(i, 4).Range.Text.Substring(0, tab3.Cell(i, 4).Range.Text.Length - 2); pr.BarCode = tab3.Cell(i, 5).Range.Text.Substring(0, tab3.Cell(i, 5).Range.Text.Length - 2); pr.Gewicht = Convert.ToDouble(tab3.Cell(i, 6).Range.Text.Substring(0, tab3.Cell(i, 6).Range.Text.Length - 2)); pr.Breedte = Convert.ToDouble(tab3.Cell(i, 7).Range.Text.Substring(0, tab3.Cell(i, 7).Range.Text.Length - 2)); pr.Lengte = Convert.ToDouble(tab3.Cell(i, 8).Range.Text.Substring(0, tab3.Cell(i, 8).Range.Text.Length - 2)); pr.Hoogte = Convert.ToDouble(tab3.Cell(i, 9).Range.Text.Substring(0, tab3.Cell(i, 9).Range.Text.Length - 2)); pr.Omschrijving = tab3.Cell(i, 10).Range.Text.Substring(0, tab3.Cell(i, 10).Range.Text.Length - 2); using (var ctx = new ProjectContext()) { Product P = ctx.Products.FirstOrDefault(p => p.ProductNummer == pr.ProductNummer); if (P == null) { if (ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land) == null) { lev.adress = ad; } else { lev.adress = ctx.Adressen.FirstOrDefault(a => a.Straat + " " + a.Huisnummer + " " + a.Gemeente + " " + a.Postcode + " " + a.Land == ad.Straat + " " + ad.Huisnummer + " " + ad.Gemeente + " " + ad.Postcode + " " + ad.Land); } ctx.SaveChanges(); if (ctx.Levranciers.FirstOrDefault(l => l.Naam == lev.Naam) == null) { pr.levrancier = lev; } else { pr.levrancier = ctx.Levranciers.FirstOrDefault(l => l.Naam == lev.Naam); } ctx.Products.Add(pr); ctx.SaveChanges(); } else { ctx.Products.FirstOrDefault(p => p.ProductNummer == pr.ProductNummer).UnitsOnStock = P.UnitsOnStock + pr.UnitsOnStock; } ctx.SaveChanges(); Producten = ctx.Products.Include("levrancier").ToList(); } loaddgvprodut(); } } }