//public IDbConnection Connection //{ // get // { // return new SqlConnection(_configuration.GetConnectionString("dbConn")); // } //} public Dashboard2Response GetCyclewisepercentage(SurveyScore surveyScore) { DbConnection c = new DbConnection(_configuration); using (IDbConnection con = c.Connection) { con.Open(); var param = new DynamicParameters(); param.Add("@EMPID", surveyScore.EMPID); param.Add("@Role", surveyScore.Role); param.Add("@CompetencyID", surveyScore.CompetencyID); param.Add("@OrderBy", surveyScore.OrderBy); Dashboard2Response desboard2Response = new Dashboard2Response(); List <Dashboard2Modal> castDeshboardData; List <Fields> fields = new List <Fields>(); using (var qList = con.QueryMultiple("dbo.usp_Dashboard2SurveyData", param, commandType: CommandType.StoredProcedure)) { castDeshboardData = qList.Read <Dashboard2Modal>().AsList(); fields = qList.Read <Fields>().AsList(); desboard2Response.data = castDeshboardData; desboard2Response.Fields = fields; } return(desboard2Response); } }
public Dashboard2Response GetCyclewisepercentage([FromBody] SurveyScore surveyScore) { Dashboard2Response dashboardData = new Dashboard2Response(); try { Dashboard2Response desboard2 = this._dashboard2Services.GetCyclewisepercentage(surveyScore); if (desboard2 != null) { dashboardData.Result = true; dashboardData.data = desboard2.data; dashboardData.Fields = desboard2.Fields; dashboardData.Message = "Success"; } else { dashboardData.Result = false; } } catch (Exception ex) { throw; } return(dashboardData); }