public void AankoopRemoveClicked(Foundation.NSObject sender)
{
Debug.WriteLine("Start: PersoonController.AankoopRemoveClicked");
var selectedRowIndex = (int)AankopenTable.SelectedRow;
if (selectedRowIndex >= 0)
{
SelectedAankoop = dsAankopen.Aankopen[selectedRowIndex] as AankoopModel;
// Configure alert
var alert = new NSAlert()
{
AlertStyle = NSAlertStyle.Informational,
InformativeText = $"Weet je zeker dat je de aankoop van {SelectedAankoop.ApparaatNaam} wilt verwijderen?\n\nDit kan niet meer ongedaan gemaakt worden.",
MessageText = $"Delete {SelectedAankoop.ApparaatNaam}?",
};
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
SelectedAankoop.Delete(AppDelegate.Conn);
dsAankopen.Aankopen.Remove(SelectedAankoop);
AankopenTable.ReloadData();
}
});
}
Debug.WriteLine("Einde: PersoonController.AankoopRemoveClicked");
}
public void AankoopDoubleClicked(NSObject sender)
{
Debug.WriteLine("Start: PersoonController.AankoopDoubleClicked");
var selectedRowIndex = (int)AankopenTable.SelectedRow;
if (selectedRowIndex >= 0)
{
SelectedAankoop = dsAankopen.Aankopen[selectedRowIndex] as AankoopModel;
PerformSegue("AankoopSegue", this);
}
Debug.WriteLine("Einde: PersoonController.AankoopDoubleClicked");
}
public void LoadAankopen(SqliteConnection conn, string id)
{
bool shouldClose = false;
// clear last connection to preventcirculair call to update
_conn = null;
// Is the database already open?
if (conn.State != ConnectionState.Open)
{
shouldClose = true;
conn.Open();
}
using (var commandAK = conn.CreateCommand())
{
try
{
// Create new command
commandAK.CommandText = "SELECT DISTINCT ID FROM [Aankoop] WHERE PersoonID = '" + ID + "'";
using (var readerAK = commandAK.ExecuteReader())
{
while (readerAK.Read())
{
var aankoop = new AankoopModel();
var idAK = (string)readerAK["ID"];
aankoop.Load(conn, idAK);
Aankopen.Add(aankoop);
}
}
}
catch (Exception Exception)
{
Debug.WriteLine(Exception.Message);
}
}
if (shouldClose)
{
conn.Close();
}
// Save last connection
_conn = conn;
}
void LoadAankopen(SqliteConnection conn, string PersoonID)
{
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 [Aankoop] WHERE PersoonID = '" + PersoonID + "'";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var aankoop = new AankoopModel();
var id = (string)reader["ID"];
aankoop.Load(conn, id);
Aankopen.Add(aankoop);
}
}
}
catch (Exception Exception)
{
Debug.WriteLine(Exception.Message);
}
}
if (shouldClose)
{
conn.Close();
}
}
public override void AwakeFromNib()
{
Debug.WriteLine("Start: AankoopController.AwakeFromNib");
//base.AwakeFromNib();
_parentController = this.PresentingViewController as PersoonController;
if (_parentController != null)
{
Aankoop = _parentController.SelectedAankoop;
if (Aankoop == null)
{
Aankoop = new AankoopModel();
GekochtOpDate.DateValue = AppDelegate.DateTimeToNSDate(DateTime.Now);
GekochtOpText.StringValue = String.Empty;
IsNieuw = true;
}
else
{
GekochtOpText.StringValue = GekochtOpDate.DateValue.ToString();
}
Debug.WriteLine("GekochtOpDate: " + GekochtOpDate.DateValue);
Debug.WriteLine("GekochtOpText: " + GekochtOpText.StringValue);
if (ApparatenCombobox != null)
{
ApparatenCombobox.UsesDataSource = true;
ApparatenCombobox.Completes = true;
ApparatenCombobox.DataSource = new ApparatenComboDS();
if (!Aankoop.ApparaatNaam.Equals(string.Empty))
{
var index = ApparatenCombobox.DataSource.IndexOfItem(ApparatenCombobox, Aankoop.ApparaatNaam);
ApparatenCombobox.SelectItem(index);
}
}
}
Debug.WriteLine("Start: AankoopController.AwakeFromNib");
}
