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 }