Beispiel #1
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            string  s = broj.Text;
            string  o = operater.Text;
            kartica k = new kartica();

            k.broj     = s;
            k.operater = o;
            try
            {
                db.karticas.InsertOnSubmit(k);
                db.SubmitChanges();
            }
            catch (Exception)
            {
                throw;
            }
            w.ucitaj();
            Close();
        }
Beispiel #2
0
        private void DatePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
        {
            var a = from s in db.saobracajs
                    where s.datum == date.SelectedDate
                    select s;
            int     max = 0;
            kartica ss  = null;

            foreach (var item in a)
            {
                if (item.ostvareniSaobracaj > max)
                {
                    max = item.ostvareniSaobracaj;
                    ss  = item.kartica;
                }
            }
            var b = from t in db.telefons
                    select t;


            marko.Content = (b.FirstOrDefault(x => x.idkartice == x.id)).korisnik.ime;
        }
Beispiel #3
0
        private void button_Click(object sender, RoutedEventArgs e)
        {
            string        s    = novSaobracaj.Text;
            korisnik      k    = (comboBox_Korisnik.SelectedItem as korisnik);
            kartica       broj = (comboBox_broj.SelectedItem as kartica);
            tipSaobracaja tip  = (comboBox_saobracaj.SelectedItem as tipSaobracaja);
            saobracaj     novi = new saobracaj();

            novi.idKartice          = k.id;
            novi.ostvareniSaobracaj = int.Parse(s);
            novi.idTipaSaobracaja   = tip.id;
            novi.datum = DateTime.Now;

            try
            {
                db.saobracajs.InsertOnSubmit(novi);
                db.SubmitChanges();
            }
            catch (Exception)
            {
                throw;
            }
            osveziListu();
        }
 partial void Deletekartica(kartica instance);
 partial void Updatekartica(kartica instance);
 partial void Insertkartica(kartica instance);