/// <summary>
 /// Returns a list of SettlementVw objects
 /// </summary>
 /// <returns></returns>
 public ActionResult Index(SettlementVwViewModel Model)
 {
     if (Model.Filter.HasCriteria)
     {
         Db db = new Db(DbServices.ConnectionString);
         Model.List = SettlementVwServices.Get(Model.Filter, db);
     }
     else
     {
         Model.List = new List <SettlementVw>();
     }
     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));
            }
            SettlementVwViewModel settlementVwViewModel = new SettlementVwViewModel();

            Db db = new Db(DbServices.ConnectionString);

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


            return(View(settlementVwViewModel));
        }