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