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

            ViewBag.PaymentGroupList = new SelectList(PaymentGroupServices.List(db), "Id", "Name");
            if (Model.Filter.HasCriteria)
            {
                Model.List = MonthlyBalanceVwServices.Get(Model.Filter, db);
            }
            else
            {
                Model.List = new List <MonthlyBalanceVw>();
            }
            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));
            }
            MonthlyBalanceVwViewModel monthlyBalanceVwViewModel = new MonthlyBalanceVwViewModel();

            Db db = new Db(DbServices.ConnectionString);

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


            return(View(monthlyBalanceVwViewModel));
        }