/// <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"); }