public List <PopulationRelation> Map_RelationTile(List <List <string> > tableDetails)
{
List <PopulationRelation> objList = new List <PopulationRelation>();
foreach (var item in tableDetails)
{
PopulationRelation obj = new PopulationRelation
{
relation = item[0].ToString(),
spend = item[1].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(),
members = item[2].ToString().Replace(",", "").Trim()
};
objList.Add(obj);
}
return(objList);
}
//relationship
public List <PopulationRelation> Expected_Population_Relation(string customStartDate, string customEndDate)
{
List <PopulationRelation> objList = new List <PopulationRelation>();
var dt = _executor.GetDataTable(_populationSqlScripts.ExpectedRelationDetails(customStartDate, customEndDate));
for (int i = 0; i < dt.Rows.Count; i++)
{
PopulationRelation obj = new PopulationRelation
{
relation = dt.Rows[i]["mbr_relationship_desc"].ToString(),
spend = dt.Rows[i]["p1_total_paid"].ToString().ToUpper(),
members = dt.Rows[i]["p1_member_count"].ToString()
};
objList.Add(obj);
}
return(objList);
}
