private void button1_Click(object sender, EventArgs e)
{
try
{
stepEntities db = new stepEntities();//PULL EF
var add = new client // START ADD NEW CLIENT COMMAND AND DEFINE DATA
{
firstname = textBoxFirst.Text,
lastname = textBoxLast.Text,
phonenumber = textBoxMobile.Text,
housenumber = textBoxHome.Text,
age = int.Parse(textBoxAge.Text)
};
db.clients.Add(add);
db.SaveChanges();//SAVE CHNAGES
MessageBox.Show("Client Has Been Added");//SHOW MESSAGE BOX BASED ON IF IT HAS WORKED
//START BLANK MESSAGE BOXES
textBoxFirst.Text = "";
textBoxLast.Text = "";
textBoxAge.Text = "";
textBoxMobile.Text = "";
textBoxHome.Text = "";
//END BLANK MESSAGE BOXES
}
catch (Exception)
{
MessageBox.Show("Addtion was unsucessfull, please contact System Administrator");//IF UNABLE TO ADD SHOW MESSAGE
}
}
private void buttonChangePassword_Click(object sender, EventArgs e)
{
stepEntities db = new stepEntities(); //PULL EF
//START UPDATE USER PASSWORD
var query = from staff in db.staff1 where staff.username == textBoxUsername.Text select staff;
foreach (var tables in query)
{
tables.password = textBoxChangePassword.Text;
}
db.SaveChanges();
//END UPDATE USER PASSWORD
MessageBox.Show("Your Password Has Been Changed, These Settings Will Take Impact The Next Time You Logon"); //START MESSAGE BOX CONFIRMING CHANGE
textBoxChangePassword.Text = "";//START CLEAR PASSWORD BOX
}