private void button1_Click(object sender, EventArgs e) { using (var oldHobbyklub = new Hobbyklub2Entities1()) { using (var hobbyKlub = new HobbyKlubEntities1()) { //foreach (var m in hobbyKlub.Member) hobbyKlub.Member.DeleteObject(m); foreach (var t in hobbyKlub.Tool) { hobbyKlub.Tool.DeleteObject(t); } foreach (var p in hobbyKlub.Part) { hobbyKlub.Part.DeleteObject(p); } //foreach (var p in hobbyKlub.Location) hobbyKlub.Location.DeleteObject(p); hobbyKlub.SaveChanges(); //foreach (var m in oldHobbyklub.) MEDLEM existerer ikke i Entity, selvom den existerer i databasen? Desuden ligger der ikke nogen Medlemsdata i denne database, kun tools. //{ // hobbyKlub.Member.AddObject(new Member() { Name = m.NAVN, Address = m.ADRESSE, Zip = m.POSTNUMMER, City = m.BY, LoenNumber = m.LON_NUMMER }); //} int toolid = 1; foreach (var t in oldHobbyklub.VAERKTOJ) { int n; if (t.K_NUMMER[0] != 'K') //throw new Exception("error in K_NUMMER"); { n = int.Parse(t.K_NUMMER); // try without K } else { n = int.Parse(t.K_NUMMER.Substring(1)); } int partno = 1; Action <string> a = s => { if (!string.IsNullOrEmpty(s)) { hobbyKlub.Part.AddObject(new Part() { Description = s, PartNo = partno++, ToolId = toolid }); } }; if (t.DEL1 != null) { if (t.DEL1.Length > 0) { a(t.DEL1); } } if (t.DEL2 != null) { if (t.DEL2.Length > 0) { a(t.DEL2); } } if (t.DEL3 != null) { if (t.DEL3.Length > 0) { a(t.DEL3); } } if (t.DEL4 != null) { if (t.DEL4.Length > 0) { a(t.DEL4); } } if (t.DEL5 != null) { if (t.DEL5.Length > 0) { a(t.DEL5); } } if (t.DEL6 != null) { if (t.DEL6.Length > 0) { a(t.DEL6); } } if (t.DEL7 != null) { if (t.DEL7.Length > 0) { a(t.DEL7); } } string toolName = t.BESKRIV; int pos = t.BESKRIV.IndexOf(' ', 0); if (pos >= 0) { toolName = t.BESKRIV.Substring(0, pos); } hobbyKlub.Tool.AddObject(new Tool() { ToolId = toolid++, Name = toolName, Description = t.BESKRIV, K_number = n }); textBox1.Text = "ToolIDs = " + toolid.ToString(); } hobbyKlub.SaveChanges(); } } }
private void button1_Click(object sender, EventArgs e) { using (var oldHobbyklub = new Hobbyklub2Entities1()) { using (var hobbyKlub = new HobbyKlubEntities1()) { //foreach (var m in hobbyKlub.Member) hobbyKlub.Member.DeleteObject(m); foreach (var t in hobbyKlub.Tool) hobbyKlub.Tool.DeleteObject(t); foreach (var p in hobbyKlub.Part) hobbyKlub.Part.DeleteObject(p); //foreach (var p in hobbyKlub.Location) hobbyKlub.Location.DeleteObject(p); hobbyKlub.SaveChanges(); //foreach (var m in oldHobbyklub.) MEDLEM existerer ikke i Entity, selvom den existerer i databasen? Desuden ligger der ikke nogen Medlemsdata i denne database, kun tools. //{ // hobbyKlub.Member.AddObject(new Member() { Name = m.NAVN, Address = m.ADRESSE, Zip = m.POSTNUMMER, City = m.BY, LoenNumber = m.LON_NUMMER }); //} int toolid = 1; foreach (var t in oldHobbyklub.VAERKTOJ) { int n; if (t.K_NUMMER[0] != 'K') //throw new Exception("error in K_NUMMER"); n = int.Parse(t.K_NUMMER); // try without K else n = int.Parse(t.K_NUMMER.Substring(1)); int partno = 1; Action<string> a = s => { if (!string.IsNullOrEmpty(s)) { hobbyKlub.Part.AddObject(new Part() { Description = s, PartNo = partno++, ToolId = toolid }); } }; if (t.DEL1 != null) if (t.DEL1.Length > 0) a(t.DEL1); if (t.DEL2 != null) if (t.DEL2.Length > 0) a(t.DEL2); if (t.DEL3 != null) if (t.DEL3.Length > 0) a(t.DEL3); if (t.DEL4 != null) if (t.DEL4.Length > 0) a(t.DEL4); if (t.DEL5 != null) if (t.DEL5.Length > 0) a(t.DEL5); if (t.DEL6 != null) if (t.DEL6.Length > 0) a(t.DEL6); if (t.DEL7 != null) if (t.DEL7.Length > 0) a(t.DEL7); string toolName = t.BESKRIV; int pos = t.BESKRIV.IndexOf(' ', 0); if (pos >= 0) toolName = t.BESKRIV.Substring(0, pos); hobbyKlub.Tool.AddObject(new Tool() { ToolId = toolid++, Name = toolName, Description = t.BESKRIV, K_number = n }); textBox1.Text = "ToolIDs = " + toolid.ToString(); } hobbyKlub.SaveChanges(); } } }