public List <PopulationPlanTypePmpm> Map_PlanTypeTile_Pmpm(List <List <string> > tableDetails)
        {
            List <PopulationPlanTypePmpm> objList = new List <PopulationPlanTypePmpm>();

            foreach (var item in tableDetails)
            {
                PopulationPlanTypePmpm obj = new PopulationPlanTypePmpm
                {
                    planType = item[0].ToString(),
                    spend    = item[1].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(),
                    members  = item[2].ToString().Replace(",", "").Trim(),
                    pmpm     = item[3].ToString().Replace(",", "").Replace("$", "").Replace("K", "").Trim()
                };
                objList.Add(obj);
            }
            return(objList);
        }
        //PLANTYPEPMPM

        public List <PopulationPlanTypePmpm> Expected_Population_PlanType_Pmpm(string customStartDate, string customEndDate)
        {
            List <PopulationPlanTypePmpm> objList = new List <PopulationPlanTypePmpm>();
            string test = _populationSqlScripts.ExpectedPlanTypePmpmDetails(customStartDate, customEndDate);
            var    dt   = _executor.GetDataTable(_populationSqlScripts.ExpectedPlanTypePmpmDetails(customStartDate, customEndDate));

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                PopulationPlanTypePmpm obj = new PopulationPlanTypePmpm
                {
                    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(),
                    pmpm     = dt.Rows[i]["pm"].ToString()
                };
                objList.Add(obj);
            }
            return(objList);
        }