public List <Top_Service_By_Total_Spend> Map_Top_Service_By_Total_Spend(List <List <string> > tableDetails)
{
List <Top_Service_By_Total_Spend> objList = new List <Top_Service_By_Total_Spend>();
foreach (var item in tableDetails)
{
Top_Service_By_Total_Spend obj = new Top_Service_By_Total_Spend
{
Services = item[0].ToString().Replace(",", "").ToUpper().Trim(),
Spend = item[1].ToString().Replace(",", "").Replace("$", "").Replace("K", "").Trim(),
Members = item[2].ToString().Replace(",", "").Trim(),
UtilizationPerThousand = item[3].ToString().Replace(",", "").Trim(),
PMPM = item[4].ToString().Replace(",", "").Replace("$", "").Trim()
};
objList.Add(obj);
}
objList.RemoveAt(0);
return(objList);
}
public List <Top_Service_By_Total_Spend> Expected_Top_Service_By_Total_Spend(string memberStatus)
{
List <Top_Service_By_Total_Spend> objList = new List <Top_Service_By_Total_Spend>();
var dt = _executor.GetDataTable(_dashboardSqlScripts.Top_Service_By_Total_Spend(memberStatus));
for (int i = 0; i < dt.Rows.Count; i++)
{
Top_Service_By_Total_Spend obj = new Top_Service_By_Total_Spend
{
Members = dt.Rows[i]["Members"].ToString(),
Services = dt.Rows[i]["Services"].ToString().ToUpper(),
UtilizationPerThousand = dt.Rows[i]["UtilizationPerThousand"].ToString(),
Spend = dt.Rows[i]["Spend"].ToString(),
PMPM = dt.Rows[i]["PMPM"].ToString()
};
objList.Add(obj);
}
return(objList);
}