private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            using (var context = new KiskereskedoEntities1())

            {
                context.Configuration.ProxyCreationEnabled = false;
                aruKeszletDataGrid.ItemsSource = context.RaktarLeker().ToList();

            }
        }
        public static void ValaszthatoFeltolt(int Levalogat)
        {
            using (var context = new KiskereskedoEntities1())

            {
                context.Configuration.ProxyCreationEnabled = false;
                AruLista = context.ValaszthatoAruLeker(Levalogat).ToList();

            }
        }
        public static void ComboFeltolt()
        {
            using (var context = new KiskereskedoEntities1())

            {
                context.Configuration.ProxyCreationEnabled = false;
                AruKategoriak = context.AruKatLeker().ToList();

            }
        }
 public static void ArLeker(string Levalogat)
 {
     using (var context = new KiskereskedoEntities1())
     {
         ArLista = context.ArLeker("Camembert").ToList();
     }
     foreach (var ArLeker in ArLista)
     {
         EgysegAr = Convert.ToInt32(ArLeker.EgysegAr);
     }
 }
        private void ListazasIndit_Click(object sender, RoutedEventArgs e)
        {
            if (DatumValaszt.Text == "")
                {
                    MessageBox.Show("Dátum megadása kötelező");
                }
                else
                {
                    using (var context = new KiskereskedoEntities1())

                    {

                        DateTime DatumLevalogat = Convert.ToDateTime(DatumValaszt.Text.Remove(DatumValaszt.Text.Length - 1, 1));
                        context.Configuration.ProxyCreationEnabled = false;
                        ListaGrid.ItemsSource = context.RendelesListaz(DatumLevalogat).ToList();
                        var Arleker = context.ListaArLeker(DatumLevalogat).ToList();
                        foreach (var Lekert in Arleker)
                    {
                        Osszesen.Text = Lekert.ToString();
                    }
                    }
                    }
        }