public ViewModelEmployee(MainWindow Handle) { _Handle = Handle; using (_EmpContext = new finalDBEContext(MainWindow.ConnectionString)) { _Handle.LabelHost.Content = _EmpContext.Database.Connection.DataSource.ToString(); _Handle.LabelDatabase.Content = _EmpContext.Database.Connection.Database.ToString(); } }
public bool BindToClass() { try { using (_EmpContext = new finalDBEContext(MainWindow.ConnectionString)) { foreach (var D in _EmpContext.Departments) { _DeptCol.Add(new CDepartment(D as Department)); } } } catch { _Handle.InfoBox.Content = "An Error has Occured while loading Departments"; return false; } try { using (_EmpContext = new finalDBEContext(MainWindow.ConnectionString)) { foreach (var D in _EmpContext.DepartmentPositions) { _DeptPosCol.Add(new CPosition(D as DepartmentPosition)); } } } catch { _Handle.InfoBox.Content = "An Error has Occured while loading Department Positions"; return false; } try { using (_EmpContext = new finalDBEContext(MainWindow.ConnectionString)) { foreach (var E in _EmpContext.Employees) { CEmployee Emp = new CEmployee(E as Employee); foreach (CPosition P in _DeptPosCol) { if (P.PositionID == E.PositionID) { Emp.Position = P; break; } } foreach (CDepartment D in _DeptCol) { if (D.ID == Emp.Position.DepartmentID) { Emp.Dept = D; break; } } _EmpCol.Add(Emp); } } } catch(SyntaxErrorException e) { _Handle.InfoBox.Content = "An Error has Occured while loading Employees. Message:" + e.Message; return false; } _Handle.InfoBox.Content = "Employee Loading: Successiful"; return true; }