public void SetUser(string u) { using (var eb = new EB_LoginsEntities()) { var user = eb.Users.FirstOrDefault(x => x.Username == u); currentUser = user; currUser.Text = user.Username; } }
private void Login_Load(object sender, EventArgs e) { try { using (var x = new EB_LoginsEntities()) { UsernameTxt.AutoCompleteCustomSource.AddRange(x.Users.Select(y => y.Username).ToArray()); } } catch { } }
private void ConfirmBtn_Click(object sender, EventArgs e) { if (UsernameTxt.Text == string.Empty || PasswordTxt.Text == string.Empty) { MessageBox.Show("fields must not be empty!"); return; } using (var eb = new EB_LoginsEntities()) { var u = eb.Users.FirstOrDefault(x => x.Username == UsernameTxt.Text); if (u != null) { MessageBox.Show("Username already taken."); return; } } if (!SamePassword) { ActiveControl = PasswordTxt; MessageBox.Show("Password does not match"); PasswordTxt.Clear(); ConfirmPassTxt.Clear(); return; } using (var a = new EB_LoginsEntities()) { var user = new User(); user.Id = Guid.NewGuid().ToString(); user.Username = UsernameTxt.Text; user.Password = PasswordTxt.Text; user.AddLogin = CanAddUser.Checked; user.Rec_Delete = CanDelete.Checked; user.Rec_Edit = CanEdit.Checked; user.Rec_Create = CanReg.Checked; user.Comp_Create = Comp_Reg_cb.Checked; user.Comp_Edit = Comp_Edit_cb.Checked; user.IssueDocument = Issue_Doc_cb.Checked; a.Users.Add(user); a.SaveChanges(); } MessageBox.Show("Successfully added"); this.Close(); }
private void ConfirmBtn_Click(object sender, EventArgs e) { if (!canSave()) { return; } using (var eb = new EB_LoginsEntities()) { var u = eb.Users.FirstOrDefault(x => x.Username == currentUser.Username); if (u != null) { u.Password = newPassword.Text; } eb.SaveChanges(); MessageBox.Show("Password successfully changed."); this.Close(); } }
private void LoginBtn_Click(object sender, EventArgs e) { #region connectiontest try { using (var context = new EBarangayEntities()) { context.Database.Connection.Open(); context.Database.Connection.Close(); } } catch (Exception error) { MessageBox.Show(error.Message); return; } #endregion if (!canLogin()) { MessageBox.Show("Invalid Login"); return; } using (var t = new EB_LoginsEntities()) { var u = from user in t.Users where user.Username == UsernameTxt.Text && user.Password == PasswordTxt.Text select user; if (u.Count() == 0) { MessageBox.Show("User Not Found"); return; } UserManager.instance.currentUser = u.First(); } UserSuccessfullyAuthenticated = true; Close(); }