public List <KPIEntities> GetKPIDetails() { List <KPIEntities> kpiInfo = new List <KPIEntities>(); try { SqlDataReader dr = SqlHelper.ExecuteReader( sqlConnectionString , CommandType.StoredProcedure, "usp_GetKPIDetails"); if (dr.HasRows) { while (dr.Read()) { KPIEntities entities = new KPIEntities(); entities.CASAID = Convert.ToInt32(dr["CASAID"]); entities.EmployeeCode = Convert.ToString(dr["EmployeeCode"]); entities.EmployeeName = Convert.ToString(dr["EmployeeName"]); entities.PerformanceScore = Convert.ToInt32(dr["PerformanceScore"]); entities.KPIRating = Convert.ToInt32(dr["KPIRating"]); kpiInfo.Add(entities); } } dr.Close(); } catch (Exception ex) { throw ex; } return(kpiInfo); }