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);
}
