/// <summary>
        /// Returns a list of EmployeeVw objects
        /// </summary>
        /// <returns></returns>
        public ActionResult Index(EmployeeVwViewModel Model)
        {
            Db db = new Db(DbServices.ConnectionString);

            ViewBag.Department = new SelectList(DepartmentServices.List(db), "Id", "Name");
            ViewBag.Category   = new SelectList(CategoryServices.List(db), "Id", "Name");

            if (Model.Filter.HasCriteria)
            {
                Model.List = EmployeeVwServices.Get(Model.Filter, db);
            }
            else
            {
                Model.List = new List <EmployeeVw>();
            }
            return(View(Model));
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public ActionResult Details(Nullable <int> id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmployeeVwViewModel employeeVwViewModel = new EmployeeVwViewModel();

            Db db = new Db(DbServices.ConnectionString);

            // employeeVwViewModel.Instance = EmployeeVwServices.Get(id.Value, db);
            employeeVwViewModel.Instance = EmployeeVwServices.GetChildren(id.Value, db);
            if (employeeVwViewModel.Instance == null)
            {
                return(HttpNotFound());
            }


            @ViewBag.DebtVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Debt", "ModuleNamePlural");
            // employeeVwViewModel.DebtVwViewModel.List = DebtVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.DebtVwViewModel.List = employeeVwViewModel.Instance.DebtVwList;


            @ViewBag.GuarantorVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Guarantor", "ModuleNamePlural");
            // employeeVwViewModel.GuarantorVwViewModel.List = GuarantorVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.GuarantorVwViewModel.List = employeeVwViewModel.Instance.GuarantorVwList;


            @ViewBag.MonthlyBalanceVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "MonthlyBalance", "ModuleNamePlural");
            // employeeVwViewModel.MonthlyBalanceVwViewModel.List = MonthlyBalanceVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.MonthlyBalanceVwViewModel.List = employeeVwViewModel.Instance.MonthlyBalanceVwList;


            @ViewBag.PaymentVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Payment", "ModuleNamePlural");
            // employeeVwViewModel.PaymentVwViewModel.List = PaymentVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.PaymentVwViewModel.List = employeeVwViewModel.Instance.PaymentVwList;


            @ViewBag.PayOrderVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "PayOrder", "ModuleNamePlural");
            // employeeVwViewModel.PayOrderVwViewModel.List = PayOrderVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.PayOrderVwViewModel.List = employeeVwViewModel.Instance.PayOrderVwList;


            @ViewBag.ProductVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Product", "ModuleNamePlural");
            // employeeVwViewModel.ProductVwViewModel.List = ProductVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.ProductVwViewModel.List = employeeVwViewModel.Instance.ProductVwList;


            @ViewBag.ProfileVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Profile", "ModuleName");
            if (employeeVwViewModel.Instance.ProfileVw != null)
            {
                employeeVwViewModel.ProfileVwViewModel.List.Add(employeeVwViewModel.Instance.ProfileVw);
            }
            // employeeVwViewModel.ProfileVwViewModel.Instance = employeeVwViewModel.Instance.ProfileVw;

            @ViewBag.SubscriptionVwTitle = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "Subscription", "ModuleNamePlural");
            // employeeVwViewModel.SubscriptionVwViewModel.List = SubscriptionVwServices.GetByEmployeeId(id.Value, db);
            employeeVwViewModel.SubscriptionVwViewModel.List = employeeVwViewModel.Instance.SubscriptionVwList;


            return(View(employeeVwViewModel));
        }