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");
}
}
