private void UpdateBtn_Click(object sender, EventArgs e)
{
if (AccountTB.Text.Length == 0 || UsernameTB.Text.Length == 0 || PasswordTB.Text.Length == 0)
{
MessageBox.Show("Please select a record to update");
}
else
{
lockerTable.UserID = Int32.Parse(userID);
lockerTable.AccountName = AccountTB.Text.Trim();
lockerTable.Username = UsernameTB.Text.Trim();
lockerTable.Password = PasswordTB.Text.Trim();
using (DBEntity db = new DBEntity())
{
if (lockerTable.AccountID == 0)
{
db.UserLockers.Add(lockerTable);
}
else
{
db.Entry(lockerTable).State = EntityState.Modified;
}
db.SaveChanges();
}
DataPopulate();
MessageBox.Show("Record Successfully added");
}
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
if (AccountTB.Text.Length == 0 || UsernameTB.Text.Length == 0 || PasswordTB.Text.Length == 0)
{
MessageBox.Show("Please select a record to delete");
}
else
{
if (MessageBox.Show("Are you sure to delete this record permanently?", "Cofirm Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (DBEntity db = new DBEntity())
{
var record = db.Entry(lockerTable);
if (record.State == EntityState.Detached)
{
db.UserLockers.Attach(lockerTable);
}
db.UserLockers.Remove(lockerTable);
db.SaveChanges();
DataPopulate();
clear();
MessageBox.Show("Record deleted successfully.");
}
}
}
}
