public void AddFranchiseVM(Franchise franchise)
 {
     FranchiseList.Add(new FranchiseViewModel()
     {
         Data = franchise
     });
 }
 public Schema()
     : base()
 {
     InstanceType = typeof(__Corporat__);
     Properties.ClearExposed();
     Html = Add <__TString__>("Html");
     Html.DefaultValue = "/Ahsan/Corporation/CorporationJson.html";
     Html.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__Html__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__Html__ = (System.String)_v_; }, false);
     Name = Add <__TString__>("Name");
     Name.DefaultValue = "";
     Name.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__Name__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__Name__ = (System.String)_v_; }, false);
     FranchiseNameToAdd = Add <__TString__>("FranchiseNameToAdd$", bind: "FranchiseNameToAdd");
     FranchiseNameToAdd.DefaultValue = "";
     FranchiseNameToAdd.Editable     = true;
     FranchiseNameToAdd.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__FranchiseNameToAdd__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__FranchiseNameToAdd__ = (System.String)_v_; }, false);
     AddFranchise = Add <__TLong__>("AddFranchise$");
     AddFranchise.DefaultValue = 0L;
     AddFranchise.Editable     = true;
     AddFranchise.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__AddFranchise__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__AddFranchise__ = (System.Int64)_v_; }, false);
     AddFranchise.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.AddFranchise()
         {
             App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value
         }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.AddFranchise)input); });
     SortOnNumberOfHomes = Add <__TLong__>("SortOnNumberOfHomes$");
     SortOnNumberOfHomes.DefaultValue = 0L;
     SortOnNumberOfHomes.Editable     = true;
     SortOnNumberOfHomes.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnNumberOfHomes__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnNumberOfHomes__ = (System.Int64)_v_; }, false);
     SortOnNumberOfHomes.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnNumberOfHomes()
         {
             App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value
         }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnNumberOfHomes)input); });
     SortOnTotalComission = Add <__TLong__>("SortOnTotalComission$");
     SortOnTotalComission.DefaultValue = 0L;
     SortOnTotalComission.Editable     = true;
     SortOnTotalComission.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnTotalComission__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnTotalComission__ = (System.Int64)_v_; }, false);
     SortOnTotalComission.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnTotalComission()
         {
             App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value
         }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnTotalComission)input); });
     SortOnAverageComission = Add <__TLong__>("SortOnAverageComission$");
     SortOnAverageComission.DefaultValue = 0L;
     SortOnAverageComission.Editable     = true;
     SortOnAverageComission.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnAverageComission__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnAverageComission__ = (System.Int64)_v_; }, false);
     SortOnAverageComission.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnAverageComission()
         {
             App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value
         }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnAverageComission)input); });
     SortOnTrend = Add <__TLong__>("SortOnTrend$");
     SortOnTrend.DefaultValue = 0L;
     SortOnTrend.Editable     = true;
     SortOnTrend.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__SortOnTrend__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__SortOnTrend__ = (System.Int64)_v_; }, false);
     SortOnTrend.AddHandler((Json pup, Property <Int64> prop, Int64 value) => { return(new Input.SortOnTrend()
         {
             App = (CorporationViewModel)pup, Template = (TLong)prop, Value = value
         }); }, (Json pup, Starcounter.Input <Int64> input) => { ((CorporationViewModel)pup).Handle((Input.SortOnTrend)input); });
     FranchiseList = Add <__TArray__>("FranchiseList");
     FranchiseList.SetCustomAccessors((_p_) => { return(((__Corporat__)_p_).__bf__FranchiseList__); }, (_p_, _v_) => { ((__Corporat__)_p_).__bf__FranchiseList__ = (__Arr__)_v_; }, false);
 }
        void SortFranchiseList(SortType type)
        {
            try
            {
                if (Data != null)
                {
                    string TypeString = "";
                    switch (type)
                    {
                    case SortType.NumberOfHomes:
                        TypeString = "NumberOfHomesSold";
                        break;

                    case SortType.TotalCommission:
                        TypeString = "TotalCommission";
                        break;

                    case SortType.AverageCommission:
                        TypeString = "AverageCommision";
                        break;

                    case SortType.Trend:
                        TypeString = "Trend";
                        break;
                    }

                    string QueryString = string.Format("SELECT f FROM Franchise f WHERE f.Corporation = ? ORDER BY f.{0}", TypeString);
                    FranchiseList.Clear();
                    QueryResultRows <Franchise> FranchiseLists = Db.SQL <Franchise>(QueryString, Data);
                    foreach (var franchise in FranchiseLists)
                    {
                        AddFranchiseVM(franchise);
                    }
                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.ToString());
            }
        }