private void DataGridRepair_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DeliveryOfConsumables OgrEmpl = DataGridRepair.SelectedItem as DeliveryOfConsumables;
if (OgrEmpl != null)
{
check = db.DeliveryOfConsumables.Where(w => w.DateOfIssue == OgrEmpl.DateOfIssue && w.Quantity == OgrEmpl.Quantity).Select(s => s.id).FirstOrDefault();
}
else
{
check = 0;
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
int idk = db.Role.Where(w => w.Name == Cmbbx2.Text).Select(s => s.id).FirstOrDefault();
DeliveryOfConsumables DOC = new DeliveryOfConsumables()
{
FK_Consumable_id = db.Consumable.Where(w => w.Name == Cmbbx1.Text).Select(s => s.id).FirstOrDefault(),
FK_Worker_id = db.Workers.Where(w => w.FirstName == Fname.Text && w.LastName == Lname.Text && w.FK_Role_id == idk).Select(s => s.id).FirstOrDefault(),
Quantity = Convert.ToInt32(quant.Text),
FK_StatusOfConsumableIssued_id = 1,
DateOfIssue = DateTime.Now
};
db.DeliveryOfConsumables.Add(DOC);
db.SaveChanges();
}
