public List <populationGender> Map_GenderTile(List <List <string> > tableDetails) { List <populationGender> objList = new List <populationGender>(); foreach (var item in tableDetails) { populationGender obj = new populationGender { gender = item[0].ToString(), spend = item[1].ToString().Replace(",", "").Replace("K", "").Replace("$", "").Trim(), members = item[2].ToString().Replace(",", "").Trim() }; objList.Add(obj); } return(objList); }
//database part public List <populationGender> Expected_Pharmacy_Gender(string customStartDate, string customEndDate) { List <populationGender> objList = new List <populationGender>(); var dt = _executor.GetDataTable(_pharmacySqlScripts.ExpectedGenderDetails(customStartDate, customEndDate)); for (int i = 0; i < dt.Rows.Count; i++) { populationGender obj = new populationGender { gender = dt.Rows[i]["gender"].ToString(), spend = dt.Rows[i]["p1_total_paid"].ToString().ToUpper(), members = dt.Rows[i]["p1_member_count"].ToString() }; objList.Add(obj); } return(objList); }