// used to config the display so both pannels would show ------ Test Method
        private static List<ClientViewModel> TestGetClients()
        {
            ExpenseDb db = new ExpenseDb();
            ClientViewModel viewModel = new ClientViewModel();

            var clients = db.Clients
                .Join(db.Project, a => a.Id, b => b.ClientID, (a, b) => new { a = a, b = b })
                .Where(x => x.a.Id == 1)
                .Select(x => new ClientViewModel() {
                ClientName = x.a.ClientName,
                ClientId = x.b.ClientID,
                ProjectName= x.b.ProjectName,
                ProjectId=x.b.Id
                }).ToList();

            return clients;
        }
        // method used to get list of Projects
        private static List<ClientViewModel> getProjects(int clientID)
        {
            ExpenseDb db = new ExpenseDb();
            ClientViewModel viewModel = new ClientViewModel();

            var projects = db.Project
                .Where(x => x.ClientID == clientID)
                .Select(x => new ClientViewModel()

                {
                    ProjectId = x.Id,
                    ProjectName = x.ProjectName
                }).ToList();
            return projects;
        }