public List <Top_Condtion_By_Total_spend> Map_Object(List <List <string> > tableDetails)
{
List <Top_Condtion_By_Total_spend> objList = new List <Top_Condtion_By_Total_spend>();
foreach (var item in tableDetails)
{
Top_Condtion_By_Total_spend obj = new Top_Condtion_By_Total_spend
{
Conditions = item[0].ToString(),
P_Spend = item[1].ToString().Replace("%", "").Trim(),
Spend = item[2].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(),
P_Change = item[3].ToString().Replace("%", "").Trim(),
Members = item[4].ToString().Replace(",", "").Trim()
};
objList.Add(obj);
}
return(objList);
}
public List <Top_Condtion_By_Total_spend> Expected_Top_Condition_By_Total_Spend(string memberStatus)
{
List <Top_Condtion_By_Total_spend> objList = new List <Top_Condtion_By_Total_spend>();
var dt = _executor.GetDataTable(_dashboardSqlScripts.Top_Condition_By_Total_Spend(StartDate(), EndDate(), memberStatus));
for (int i = 0; i < dt.Rows.Count; i++)
{
Top_Condtion_By_Total_spend obj = new Top_Condtion_By_Total_spend
{
Conditions = dt.Rows[i]["disease_name"].ToString(),
P_Spend = dt.Rows[i]["P_spend"].ToString(),
Spend = dt.Rows[i]["Spend"].ToString(),
P_Change = dt.Rows[i]["P_chnage"].ToString(),
Members = dt.Rows[i]["Members"].ToString()
};
objList.Add(obj);
}
return(objList);
}
