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