public void DataGridViewRightClickActions(object sender, ToolStripItemClickedEventArgs e, DataTableConnection dt)
{
if (e.ClickedItem.Text == "Copy URL" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[1];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Copy Username" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[2];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Copy Password" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[3];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Delete Entry" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
TableTableAdapter regionTableAdapter = new TableTableAdapter();
//DataTableConnection dataTableConnection = new DataTableConnection();
//var dataTable = dataTableConnection.RefreshDataTable();
regionTableAdapter.Delete(Convert.ToInt32(mainWindow.passwordRecordGridView.CurrentRow.Cells[0].Value),
mainWindow.passwordRecordGridView.CurrentRow.Cells[1].Value.ToString(),
mainWindow.passwordRecordGridView.CurrentRow.Cells[2].Value.ToString(),
mainWindow.passwordRecordGridView.CurrentRow.Cells[3].Value.ToString());
dt.RefreshDataTable();
}
}
public void DataGridViewRightClickActions(object sender, ToolStripItemClickedEventArgs e, DataTableConnection dt)
{
if (e.ClickedItem.Text == "Copy URL" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[1];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Copy Username" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[2];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Copy Password" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
mainWindow.passwordRecordGridView.CurrentCell = mainWindow.passwordRecordGridView.Rows[mainWindow.passwordRecordGridView.CurrentCell.RowIndex].Cells[3];
columnToCopy = mainWindow.passwordRecordGridView.CurrentCell.ColumnIndex;
Clipboard.SetDataObject(mainWindow.passwordRecordGridView.CurrentCell.Value.ToString().Trim(), false);
}
else if (e.ClickedItem.Text == "Delete Entry" && mainWindow.passwordRecordGridView.CurrentCell.Value != null)
{
TableTableAdapter regionTableAdapter = new TableTableAdapter();
mainWindow.rightClickMenu.Visible = false;
var confirmResult = MessageBox.Show("Are you sure to delete this entry ?", "Confirm Delete", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
regionTableAdapter.Delete(Convert.ToInt32(mainWindow.passwordRecordGridView.CurrentRow.Cells[0].Value),
mainWindow.passwordRecordGridView.CurrentRow.Cells[1].Value.ToString(),
mainWindow.passwordRecordGridView.CurrentRow.Cells[2].Value.ToString(),
mainWindow.passwordRecordGridView.CurrentRow.Cells[3].Value.ToString());
dt.RefreshDataTable();
}
}
}
public static void UpdateDatabase()
{
var adapter = new TableTableAdapter();
var bookmarkSet = new BookmarksDataSet();
adapter.Update(bookmarkSet);
}
public static void DeleteBookmarkItem(BookmarkItem item)
{
var adapter = new TableTableAdapter();
adapter.DeleteQuery(item.ID, item.URL, item.Name);
UpdateDatabase();
}
private void SaveEntry_Click(object sender, EventArgs e)
{
TableTableAdapter regionTableAdapter = new TableTableAdapter();
DataTableConnection dataTableConnection = new DataTableConnection();
dataTableConnection.mainWindow = this;
var dataTable = dataTableConnection.RefreshDataTable();
if (uRLTextBox.Text.Trim() != "" && usernameTextBox.Text.Trim() != "" && passwordTextBox.Text.Trim() != "")
{
if (dataTable.Rows.Count == 0)
{
regionTableAdapter.Insert(1, URLTextBox.Text, UsernameTextBox.Text, PasswordTextBox.Text);
URLTextBox.Text = "";
UsernameTextBox.Text = "";
PasswordTextBox.Text = "";
}
else
{
regionTableAdapter.Insert(Convert.ToInt32(dataTable.Rows[dataTable.Rows.Count - 1].ItemArray[0]) + 1, URLTextBox.Text, UsernameTextBox.Text, PasswordTextBox.Text);
URLTextBox.Text = "";
UsernameTextBox.Text = "";
PasswordTextBox.Text = "";
}
}
dataTableConnection.RefreshDataTable();
}
public static BookmarkItem FindBookmark(string term)
{
var adapter = new TableTableAdapter();
var workingList = GetBookmarkList();
var result = workingList.Find(x => x.Name == term);
return(result);
}
private void deleteButton_Click(object sender, EventArgs e)
{
var adapter = new TableTableAdapter();
var BookmarkList = adapter.GetData();
var bookmarkItem = listBox1.SelectedItem.ToString();
foreach (var bookmark in BookmarkList)
{
if (bookmarkItem.Contains(bookmark.Name))
{
BookmarkManager.DeleteBookmarkRow(bookmark);
}
}
listBox1.Items.Remove(bookmarkItem);
}
public static List <BookmarkItem> GetBookmarkList()
{
var adapter = new TableTableAdapter();
var result = new List <BookmarkItem>();
var rows = adapter.GetData();
foreach (var row in rows)
{
var item = new BookmarkItem();
item.URL = row.URL;
item.Name = row.Name;
result.Add(item);
}
return(result);
}
public static void DeleteBookmarkRow(BookmarksDataSet.TableRow item)
{
var adapter = new TableTableAdapter();
adapter.Delete(item.Id, item.URL, item.Name);
}
public static TableDataTable GetBookmarkData()
{
var adapter = new TableTableAdapter();
return(adapter.GetData());
}
public static void AddBookmark(BookmarkItem item)
{
var adapter = new TableTableAdapter();
adapter.Insert(item.URL, item.Name);
}
