Esempio n. 1
0
        public void EditRekening(string IBAN, string BSN, double Saldo, Typen Type)
        {
            Rekeningen R = (from Rekening in db.Rekeningens where Rekening.IBAN == IBAN select Rekening).Single();

            R.Rekeninghouder = BSN;
            R.Saldo          = Saldo;
            R.Type           = Type.Naam;
        }
Esempio n. 2
0
        public void EditRekening(string IBAN, string BSN, double Saldo, Typen Type, DateTime SluitDatum)
        {
            Rekeningen R = (from Rekening in db.Rekeningens where Rekening.IBAN == IBAN select Rekening).Single();
            Klanten    K = (from Klant in db.Klantens where Klant.BSN == BSN select Klant).Single();

            R.IBAN       = IBAN;
            R.Klanten    = K;
            R.Saldo      = Saldo;
            R.Typen      = Type;
            R.SluitDatum = SluitDatum;
        }
Esempio n. 3
0
        public void NewRekening(string IBAN, string BSN, double Saldo, Typen Type)
        {
            Rekeningen R = new Rekeningen();

            R.IBAN           = IBAN;
            R.Rekeninghouder = BSN;
            R.Saldo          = Saldo;
            R.Type           = Type.Naam;
            R.OpenDatum      = DateTime.Now;

            db.Rekeningens.InsertOnSubmit(R);
        }
Esempio n. 4
0
        private void dgRekeningen_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            if (editing && (Rekeningen)dgRekeningen.SelectedItem == SelectedItem)
            {
                editing = false;
                ClearForm();
            }
            else
            {
                editing      = true;
                SelectedItem = (Rekeningen)dgRekeningen.SelectedItem;
                if (SelectedItem != null)
                {
                    txtIBAN.IsReadOnly = true;
                    txtIBAN.Text       = SelectedItem.IBAN;
                    int i = 0;
                    foreach (String BSN in BSNs)
                    {
                        if (BSN == SelectedItem.Klanten.BSN)
                        {
                            cbKlanten.SelectedIndex = i;
                        }
                        else
                        {
                            i++;
                        }
                    }
                    txtSaldo.Text        = SelectedItem.Saldo.ToString();
                    cbTypes.SelectedItem = SelectedItem.Typen;
                    dpEinddatum.Text     = SelectedItem.SluitDatum.ToString();

                    btnSave.Visibility   = Visibility.Hidden;
                    btnEdit.Visibility   = Visibility.Visible;
                    btnDelete.Visibility = Visibility.Visible;
                }
            }
        }
 private void detach_Rekeningens(Rekeningen entity)
 {
     this.SendPropertyChanging();
     entity.Klanten = null;
 }
 partial void DeleteRekeningen(Rekeningen instance);
 partial void UpdateRekeningen(Rekeningen instance);
 partial void InsertRekeningen(Rekeningen instance);
 private void attach_Rekeningens(Rekeningen entity)
 {
     this.SendPropertyChanging();
     entity.Typen = this;
 }
Esempio n. 10
0
        public void DeleteRekening(string IBAN)
        {
            Rekeningen R = (from Rekening in db.Rekeningens where Rekening.IBAN == IBAN select Rekening).Single();

            db.Rekeningens.DeleteOnSubmit(R);
        }