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;
}
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;
}
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);
}
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;
}
public void DeleteRekening(string IBAN)
{
Rekeningen R = (from Rekening in db.Rekeningens where Rekening.IBAN == IBAN select Rekening).Single();
db.Rekeningens.DeleteOnSubmit(R);
}