private void importBtn_Click(object sender, EventArgs e) { OpenFileDialog importOlvaso = new OpenFileDialog(); importOlvaso.InitialDirectory = Application.StartupPath; importOlvaso.Filter = "Comma Seperated Values (*.csv)|*.csv"; importOlvaso.DefaultExt = "csv"; importOlvaso.AddExtension = true; if (importOlvaso.ShowDialog() != DialogResult.OK) { return; } using (StreamReader sr = new StreamReader(importOlvaso.FileName, Encoding.Default)) { while (!sr.EndOfStream) { string[] sor = sr.ReadLine().Split(';'); asset asset = new asset(); manufacturer manufacturer = new manufacturer(); asset.assetname = sor[0]; asset.model = sor[1]; asset.category = sor[2]; try { asset.purchasedate = DateTime.Parse(sor[3]); } catch (Exception) { throw; } asset.price = Int32.Parse(sor[4]); asset.serialnumber = sor[5]; manufacturer.manufacturerName = sor[6]; manufacturer.manufacturerWebsite = sor[7]; manufacturer.manufacturerEmail = sor[8]; context.assets.Add(asset); context.manufacturers.Add(manufacturer); } } try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } setData(); }
private void newAssetBtn_Click(object sender, EventArgs e) { newAsset form = new newAsset(); if (form.ShowDialog() == DialogResult.OK) { asset assets = new asset(); assets.assetname = form.assetNameTextbox.Text; assets.model = form.modelTextBox.Text; assets.category = form.categoryTextBox.Text; try { assets.purchasedate = form.dateTimePicker1.Value; } catch (Exception ex) { MessageBox.Show(ex.Message); } assets.price = Int32.Parse(form.priceTextBox.Text); assets.serialnumber = form.serialTextBox.Text; context.assets.Add(assets); try { context.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message); } MessageBox.Show("Az eszköz hozzáadása az adatbázishoz sikeres volt"); setData(); } else { MessageBox.Show("Az új eszköz nem lett hozzáadva az adatbázishoz"); } }