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);
}
}
}
