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