partial void PersoonRemoveClicked(Foundation.NSObject sender)
{
Debug.WriteLine("Start: PersonenController.PersoonRemoveClicked");
if ((int)PersonenTable.SelectedRow >= 0)
{
var selectedRowIndex = PersonenTable.SelectedRow;
SelectedPersoon = dsPersonen.Personen[(int)PersonenTable.SelectedRow] as PersoonModel;
// Configure alert
var alert = new NSAlert()
{
AlertStyle = NSAlertStyle.Informational,
InformativeText = $"Weet je zeker dat je de persoon {SelectedPersoon.Achternaam} wilt verwijderen?\n\nDit kan niet meer ongedaan gemaakt worden.",
MessageText = $"Delete {SelectedPersoon.Achternaam}?",
};
alert.AddButton("Cancel");
alert.AddButton("Delete");
alert.BeginSheetForResponse(this.View.Window, (result) =>
{
// Should we delete the requested row?
if (result == 1001)
{
// Remove the given row from the dataset
SelectedPersoon.Delete(AppDelegate.Conn);
dsPersonen.Personen.Remove(SelectedPersoon);
ReloadTable();
}
});
}
Debug.WriteLine("Einde: PersonenController.PersoonRemoveClicked");
}
public AankopenDS(SqliteConnection conn, PersoonModel _persoon)
{
Conn = conn;
if (AppDelegate.Conn != null && _persoon != null)
{
LoadAankopen(conn, _persoon.ID);
}
}
public LidmaatschappenDS(SqliteConnection conn, PersoonModel _persoon)
{
Conn = conn;
if (AppDelegate.Conn != null && _persoon != null)
{
LoadLidmaatschappen(conn, _persoon.ID);
}
}
public OnderhoudDS(SqliteConnection conn, PersoonModel _persoon)
{
Conn = conn;
if (AppDelegate.Conn != null && _persoon != null)
{
LoadOnderhoud(conn, _persoon.ID);
}
}
public GevolgdeOpleidingenDS(SqliteConnection conn, PersoonModel _persoon)
{
Conn = conn;
if (AppDelegate.Conn != null && _persoon != null)
{
LoadGevolgdeOpleidingen(conn, _persoon.ID);
}
}
partial void PersoonAddClicked(Foundation.NSObject sender)
{
Debug.WriteLine("Start: PersonenController.PersoonAddClicked");
SelectedPersoon = null;
PerformSegue("PersoonNewSegue", this);
Debug.WriteLine("Einde: PersonenController.PersoonAddClicked");
}
public void RowDoubleClicked(NSObject sender)
{
Debug.WriteLine("Start: PersonenController.RowDoubleClicked");
SelectedPersoon = dsPersonen.Personen[(int)PersonenTable.SelectedRow] as PersoonModel;
PerformSegue("PersoonSegue", this);
Debug.WriteLine("Einde: PersonenController.RowDoubleClicked");
}
internal void RaisePersonModified(PersoonModel persoon)
{
Debug.WriteLine("Start: PersoonController.RaisePersonModified");
if (this.PersonModified != null)
{
this.PersonModified(persoon);
}
Debug.WriteLine("Einde: PersoonController.RaisePersonModified");
}
public override void AwakeFromNib()
{
Debug.WriteLine("Start: NewPersoonController.AwakeFromNib");
base.AwakeFromNib();
_parentController = this.PresentingViewController as PersonenController;
if (_parentController != null)
{
Persoon = new PersoonModel();
}
Debug.WriteLine("Einde: NewPersoonController.AwakeFromNib");
}
void LoadPersonen(SqliteConnection conn)
{
Personen.Clear();
bool shouldClose = false;
// Is the database already open?
if (conn.State != ConnectionState.Open)
{
shouldClose = true;
conn.Open();
}
// Execute query
using (var command = conn.CreateCommand())
{
try
{
// Create new command
command.CommandText = "SELECT DISTINCT ID FROM [Persoon]";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var persoon = new PersoonModel();
var id = (string)reader["ID"];
persoon.Load(conn, id);
AddPersoon(persoon);
}
}
}
catch (Exception Exception)
{
Debug.WriteLine(Exception.Message);
}
}
if (shouldClose)
{
conn.Close();
}
}
public override void AwakeFromNib()
{
Debug.WriteLine("Start: PersoonController.AwakeFromNib");
base.AwakeFromNib();
_parentController = this.PresentingViewController as PersonenController;
if (_parentController != null)
{
Persoon = _parentController.SelectedPersoon;
if (Persoon != null)
{
LoadTables();
}
else
{
Persoon = new PersoonModel();
}
}
Debug.WriteLine("Einde: PersoonController.AwakeFromNib");
}
public bool AddPersoon(PersoonModel _persoon)
{
Personen.Add(_persoon);
return(true);
}
