private void Window_Loaded(object sender, RoutedEventArgs e) { using (var context = new HrDBContext()) { var list = context.Employees.ToList(); DGVEmployees.ItemsSource = list; } }
public MainWindow() { InitializeComponent(); using (var context = new HrDBContext()) { foreach (var employee in context.Employees) { Employee emp = new Employee() { EmployeeID = employee.EmployeeID, PayRate = employee.PayRate }; _employee.Add(emp); } } roomSeries.ItemsSource = _employee; }
private void btnSignUp_Click(object sender, RoutedEventArgs e) { using (var context = new HrDBContext()) { var user = new User() { UserName = txtUserName.Text, FirstName = txtFN.Text, LastName = txtLN.Text, Position = txtPosition.Text, CreateDate = DateTime.Now, Email = txtEmail.Text, Password = PasswordCrypt.SimpleEncrypt(txtPW.Text) }; context.Users.Add(user); context.SaveChanges(); } closeFrm(); }
private void btnAddEmployee(object sender, RoutedEventArgs e) { using (var context = new HrDBContext()){ var employee = new Employee() { FirstName = "test", LastName = "test", HireDate = DateTime.Now, Position = "test", Email = "test", PayRate = 2.25, Picture = bytePic }; context.Configuration.AutoDetectChangesEnabled = false; context.Employees.Add(employee); context.SaveChanges(); } }
private void btnSignIn_Click(object sender, RoutedEventArgs e) { var password = PasswordCrypt.SimpleEncrypt(txtPW.Password); using (var context = new HrDBContext()) { var username = txtID.Text; try { var user = context.Users.Where(un => un.UserName == username).Where(pw => pw.Password == password).First(); MainWindow form = new MainWindow(); form.Tag = this; form.Show(); Hide(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }