/// <summary>
/// Initializes a new instance of the WebsiteViewModel class.
/// </summary>
public WebsiteViewModel()
{
DatabaseHelper.Open();
var reader = DatabaseHelper.Select <WebsiteItem>();
while (reader.Read())
{
if (reader.HasRows)
{
WesitesList.Add(new WebsiteItem(reader));
}
}
reader.Close();
DatabaseHelper.Close();
}
private void ExecuteDeleteCommand(int index)
{
if (index < 0 || index >= WesitesList.Count)
{
return;
}
DatabaseHelper.Open();
var row = DatabaseHelper.Delete <WebsiteItem>($"Id = {WesitesList[index].Id}");
DatabaseHelper.Close();
if (row > 0)
{
WesitesList.RemoveAt(index);
}
}
private void ExecuteAddCommand()
{
var view = new AddWebView();
view.Show();
Messenger.Default.Send(new NotificationMessageAction <WebsiteItem>(null, item =>
{
DatabaseHelper.Open();
var row = DatabaseHelper.InsertOrIgnore <WebsiteItem>("Name, Url", "@name, @url",
new SQLiteParameter("@name", item.Name),
new SQLiteParameter("@url", item.Url));
DatabaseHelper.Close();
if (row > 0)
{
WesitesList.Add(item);
}
view.Close();
}), "web");
}
