public List <PopulationPlanType> Map_PlanTypeTile(List <List <string> > tableDetails)
        {
            List <PopulationPlanType> objList = new List <PopulationPlanType>();

            foreach (var item in tableDetails)
            {
                PopulationPlanType obj = new PopulationPlanType
                {
                    planType = item[0].ToString(),
                    spend    = item[1].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(),
                    members  = item[2].ToString().Replace(",", "").Trim()
                };
                objList.Add(obj);
            }
            return(objList);
        }
        //plantype
        public List <PopulationPlanType> Expected_Population_PlanType(string customStartDate, string customEndDate)
        {
            List <PopulationPlanType> objList = new List <PopulationPlanType>();
            var dt = _executor.GetDataTable(_populationSqlScripts.ExpectedPlanTypeDetails(customStartDate, customEndDate));

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                PopulationPlanType obj = new PopulationPlanType
                {
                    planType = dt.Rows[i]["plan_type_desc"].ToString(),
                    spend    = dt.Rows[i]["p1_total_paid"].ToString().ToUpper(),
                    members  = dt.Rows[i]["p1_member_count"].ToString()
                };
                objList.Add(obj);
            }
            return(objList);
        }