private void RemoveMatchingExpiredItems(Variant item) { if (ExpiredItems.Any(x => x.VariantId == item.VariantId)) { ApplyChange(new ExpiredItemDeletedEvent(Id, item.VariantId)); } }
private void ExpiredItems_OnLoaded(object sender, RoutedEventArgs e) { try { DataTable dt = new DataTable(); string date = DateTime.Today.AddDays(7).ToString("yyyy-MM-dd"); con = new SqlConnection(ConString); con.Open(); cmd = new SqlCommand("select inv.ingredient,CONCAT(inv.quantity,' ',inv.unit) as quantity,convert(varchar, inv.e_date, 3) as e_date,CASE WHEN supplier_id IS NULL THEN '' ELSE (SELECT CONCAT(sup.supplier_name,' ',sup.supplier_mobile) FROM dbo.suppliers as sup where supplier_id= inv.supplier_id) END AS supplier_details from dbo.inventory as inv where inv.e_date <= @date", con); cmd.Parameters.AddWithValue("@date", date.ToString()); adapter = new SqlDataAdapter(cmd); adapter.Fill(dt); ExpiredItems.SetBinding(ItemsControl.ItemsSourceProperty, new Binding { Source = dt }); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { con.Close(); } }
internal void Apply(ExpiredItemDeletedEvent @event) { ExpiredItems.Remove(ExpiredItems.FirstOrDefault(i => i.VariantId == @event.VariantId)); }