private void AddButton_Click(object sender, EventArgs e)
{
using (PharmacyEntities db = new PharmacyEntities())
{
Manufactures buff = new Manufactures();
try
{
buff.id = Convert.ToInt32(idTextBox.Text);
buff.NameManufacture = nameTextBox.Text;
}
catch (FormatException)
{
MessageBox.Show("Неверно введённые данные!");
return;
}
db.Manufactures.Add(buff);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("ID не должен повторяться!");
return;
}
}
this.Close();
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
using (PharmacyEntities db = new PharmacyEntities())
{
db.ProductList.RemoveRange(db.ProductList.Where(items => items.shelfLife < DateTime.Now));
db.SaveChanges();
InitializeRows();
}
}
private void DeleteToolStripButton_Click(object sender, EventArgs e)
{
switch (tablesToolStripComboBox.SelectedIndex)
{
case 0:
foreach (var item in dataGridView.Rows)
{
if ((item as DataGridViewRow).Selected)
{
using (PharmacyEntities db = new PharmacyEntities())
{
var buff = db.Manufactures.Find((int)(item as DataGridViewRow).Cells[0].Value);
db.Manufactures.Remove(buff);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("Ошибка");
return;
}
}
break;
}
}
InitializeRows();
break;
case 1:
foreach (var item in dataGridView.Rows)
{
if ((item as DataGridViewRow).Selected)
{
using (PharmacyEntities db = new PharmacyEntities())
{
var buff = db.MedicalPreparations.Find((int)(item as DataGridViewRow).Cells[0].Value);
db.MedicalPreparations.Remove(buff);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("Ошибка");
return;
}
}
break;
}
}
InitializeRows();
break;
case 2:
foreach (var item in dataGridView.Rows)
{
if ((item as DataGridViewRow).Selected)
{
using (PharmacyEntities db = new PharmacyEntities())
{
var buff = db.PointsOfSale.Find((int)(item as DataGridViewRow).Cells[0].Value);
db.PointsOfSale.Remove(buff);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("Ошибка");
return;
}
}
break;
}
}
InitializeRows();
break;
case 3:
foreach (var item in dataGridView.Rows)
{
if ((item as DataGridViewRow).Selected)
{
using (PharmacyEntities db = new PharmacyEntities())
{
var buff = db.ProductList.Find((int)(item as DataGridViewRow).Cells[0].Value);
db.ProductList.Remove(buff);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
MessageBox.Show("Ошибка");
return;
}
}
break;
}
}
InitializeRows();
break;
}
}