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