public List <populationGenderPmpm> Map_GenderTile_Pmpm(List <List <string> > tableDetails) { List <populationGenderPmpm> objList = new List <populationGenderPmpm>(); foreach (var item in tableDetails) { populationGenderPmpm obj = new populationGenderPmpm { gender = item[0].ToString(), spend = item[1].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(), members = item[2].ToString().Replace(",", "").Trim(), pmpm = item[3].ToString().Replace(",", "").Replace("$", "").Trim(), }; objList.Add(obj); } return(objList); }
public List <populationGenderPmpm> Expected_Population_Gender_Pmpm(string customStartDate, String CustomEndDate) { List <populationGenderPmpm> objList = new List <populationGenderPmpm>(); string testString = _populationSqlScripts.ExpectedGenderPmpmDetails(customStartDate, CustomEndDate); var dt = _executor.GetDataTable(_populationSqlScripts.ExpectedGenderPmpmDetails(customStartDate, CustomEndDate)); for (int i = 0; i < dt.Rows.Count; i++) { populationGenderPmpm obj = new populationGenderPmpm { gender = dt.Rows[i]["gender"].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); }