public static List <BookmarkItem> GetItems() { var adapter = new BookmarksTableAdapter(); var results = new List <BookmarkItem>(); try { var rows = adapter.GetData(); foreach (var row in rows) { var item = new BookmarkItem(); item.Title = row.Title; item.URL = row.URL; item.ID = row.Id; results.Add(item); } return(results); } catch (System.Data.ConstraintException) { return(results); } }
public static List <BookmarkItem> deleteItem(string titleIn) { var adapter = new BookmarksTableAdapter(); var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { if (row.Title.Equals(titleIn)) { adapter.Delete(row.Id, row.URL, row.Title); break; } } foreach (var row in rows) { var item = new BookmarkItem(); item.URL = row.URL; item.Title = row.Title; item.Id = row.Id; results.Add(item); } return(results); }
public static void AddBookmarkItem(BookmarkItem item) { if (CheckIfDuplicate(item)) { var adapter = new WebBrowser.Data.BrowserDBDataSetTableAdapters.BookmarkTableAdapter(); adapter.Insert(item.url, item.title); } }
// Method to get a list of BookmarkItems from the database public static List <BookmarkItem> GetItems() { var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { var item = new BookmarkItem(); item.URL = row.URL; item.Title = row.Title; results.Add(item); } return(results); }
public static Boolean CheckIfDuplicate(BookmarkItem item) { Boolean value = true; var currentItems = new List <BookmarkItem>(); currentItems = GetBookmarkItems(); foreach (BookmarkItem row in currentItems) { String urlFirst = row.url.ToString().Trim(); String urlSecond = item.url.ToString(); if (urlFirst.Equals(urlSecond)) { value = false; } } return(value); }
public static List <BookmarkItem> GetBookmarkItems() { BookmarksTableAdapter adapter = new BookmarksTableAdapter(); List <BookmarkItem> results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { BookmarkItem item = new BookmarkItem(); item.URL = row.URL; item.Title = row.Title; item.ID = row.Id; results.Add(item); } return(results); }
// Method to get one BookmarkItem from the database public static BookmarkItem GetItem(int index) { int i = 0; var rows = adapter.GetData(); var item = new BookmarkItem(); foreach (var row in rows) { if (i == index) { item.Id = row.Id; item.URL = row.URL; item.Title = row.Title; } i++; } return(item); }
public static List <BookmarkItem> GetBookmarkItems() { var adapter = new WebBrowser.Data.BrowserDBDataSetTableAdapters.BookmarkTableAdapter(); var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { var item = new BookmarkItem(); item.title = row.Title; item.url = row.URL; item.bookmarkID = row.Id; results.Add(item); } return(results); }
public static List <BookmarkItem> GetItems() { var adapter = new BookmarksTableAdapter(); var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { #pragma warning disable IDE0017 // Simplify object initialization var item = new BookmarkItem(); #pragma warning restore IDE0017 // Simplify object initialization item.URL = row.URL; item.Title = row.Title; item.Id = row.Id; results.Add(item); } return(results); }
public static List <BookmarkItem> GetSearchItems(string search) { var adapter = new BookamrksTableAdapter(); var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { var item = new BookmarkItem(); item.URL = row.URL; item.Title = row.Title; if (row.Title.Contains(search)) { results.Add(item); } } return(results); }
public static List <BookmarkItem> DeleteSelected(string selected) { var adapter = new BookamrksTableAdapter(); var results = new List <BookmarkItem>(); var rows = adapter.GetData(); foreach (var row in rows) { var item = new BookmarkItem(); item.URL = row.URL; item.Title = row.Title; results.Add(item); if (selected.Contains(row.Title)) { adapter.DeleteQuery(item.Title); results.Remove(item); } } return(results); }
public static void AddBookmarkItem(BookmarkItem item) { var adapter1 = new BookmarksTableAdapter(); var rows = adapter1.GetData(); if (rows.Count == 0) { adapter1.Insert(item.URL, item.Title); } else { List <string> URLs = new List <string>(); foreach (var row in rows) { URLs.Add(row.URL); } if (!URLs.Contains(item.URL)) { adapter1.Insert(item.URL, item.Title); } } }
// Method to add BookmarkItem to database public static void AddItem(BookmarkItem item) { adapter.Insert(item.URL, item.Title); }
public static void AddItem(BookmarkItem item) { // BookmarksTableAdapter adapter = new BookmarksTableAdapter(); adapter.Insert(item.URL, item.title.Substring(0, 50)); // why does this need an id parameter? }
public static void addBookmark(BookmarkItem item) { var adapter = new BookmarksTableAdapter(); }
// Method to delete bookmarkItem from the database public static void DeleteItem(int index) { BookmarkItem item = GetItem(index); adapter.Delete(item.Id, item.URL, item.Title); }
public static void AddItem(BookmarkItem item) { var adapter = new BookmarksTableAdapter(); adapter.Insert(item.URL, item.Title); }