private void btnOk_Click(object sender, EventArgs e)
{
if (id != -1)
{
using (var ctx = new UPdatabase())
{
var result = ctx.UpData.SingleOrDefault(b => b.ID == id);
result.UserName = txtName.Text;
result.Password = Encryption.Encrypt(txtPassword.Text, true);
ctx.SaveChanges();
}
}
else
{
var data = new DataVM();
data.UserName = txtName.Text;
data.Password = Encryption.Encrypt(txtPassword.Text, true);
using (var dbCtx = new UPdatabase())
{
//Add Student object into Students DBset
dbCtx.UpData.Add(data);
// call SaveChanges method to save student into database
dbCtx.SaveChanges();
}
//MessageBox.Show("Data stored in the database");
}
this.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
UPdatabase ctx = new UPdatabase();
var item = new DataVM() { ID = id };
ctx.UpData.Attach(item);
ctx.UpData.Remove(item);
ctx.SaveChanges();
GetAllDbItems.RefreshGrid(grdData);
}
internal static void RefreshGrid(DataGridView grid)
{
grid.DataSource = typeof(List<>); // OR use grid_accounts.DataSource = null;
using (UPdatabase ctx = new UPdatabase())
{
var allRows = ctx.UpData.ToList();
grid.DataSource = allRows;
grid.Rows[0].Selected = true;
}
}
internal static void RefreshGrid(DataGridView grid)
{
grid.DataSource = typeof(List <>); // OR use grid_accounts.DataSource = null;
using (UPdatabase ctx = new UPdatabase())
{
var allRows = ctx.UpData.ToList();
grid.DataSource = allRows;
grid.Rows[0].Selected = true;
}
}
internal static void myClickHandler(object sender, EventArgs e)
{
var menuItem = sender.ToString();
var idParts = menuItem.Split('-');
var id = Convert.ToInt32(idParts[0]);
using (var ctx = new UPdatabase())
{
var result = ctx.UpData.SingleOrDefault(b => b.ID == id);
Clipboard.SetText(Encryption.Decrypt(result.Password, true));
}
}
internal static void myClickHandler(object sender, EventArgs e)
{
var menuItem = sender.ToString();
var idParts = menuItem.Split('-');
var id = Convert.ToInt32(idParts[0]);
using (var ctx = new UPdatabase())
{
var result = ctx.UpData.SingleOrDefault(b => b.ID == id);
Clipboard.SetText(Encryption.Decrypt(result.Password, true));
}
}
internal static void GetAllDbData(ToolStripDropDownItem toolStripMenu)
{
using (UPdatabase ctx = new UPdatabase())
{
var allRows = ctx.UpData.ToList();
if (toolStripMenu.DropDownItems.Count != 0)
{
toolStripMenu.DropDownItems.Clear();
}
foreach (var name in allRows)
{
toolStripMenu.DropDownItems.Add(name.ID + "-" + name.UserName, null, myClickHandler);
item = ctx.UpData.FirstOrDefault(s => s.UserName == name.UserName);
}
}
}
internal static void GetAllDbData(ToolStripDropDownItem toolStripMenu)
{
using (UPdatabase ctx = new UPdatabase())
{
var allRows = ctx.UpData.ToList();
if (toolStripMenu.DropDownItems.Count != 0)
{
toolStripMenu.DropDownItems.Clear();
}
foreach (var name in allRows)
{
toolStripMenu.DropDownItems.Add(name.ID + "-" + name.UserName, null, myClickHandler);
item = ctx.UpData.FirstOrDefault(s => s.UserName == name.UserName);
}
}
}
public frmData(int Id)
{
InitializeComponent();
id = Id;
if (id != -1)
{
using (UPdatabase ctx = new UPdatabase())
{
var item = ctx.UpData.FirstOrDefault(s => s.ID == id);
txtName.Text = item.UserName;
lblPassword.Text = "New password";
//txtPassword.Text = Encryption.Decrypt(item.Password, true);
}
}
else
{
txtName.Text = "";
txtPassword.Text = "";
}
}