public async Task <IHttpActionResult> GetApplicationLocChart(int projectId)
// To Get all the application LOC Chart
{
using (_codeVortoService = new CodeVortoService())
{
var objChart = new Chart {
Charts = new List <ChartItem>()
};
//var projectId = 0;
try
{
var generalRepository =
new GeneralRepository <ChartDashboardCount>(new AppDbContext());
object[] parameters =
{
new MySqlParameter("prjId", MySqlDbType.Int32)
{
Value = projectId
}
};
var chartData = await generalRepository
.ExecuteStoreProcedure <ChartDashboardCountNew>("SpChartLOCDashboard", parameters);
if ((chartData.Count > 0) && (chartData.Count > 0))
{
#region Added Chart data
if (chartData.Count > 0)
{
for (var i = 0; i < chartData.Count; i++)
{
if (Convert.ToInt32(chartData[i].Count) != 0)
{
objChart.Charts.Add(new ChartItem
{
label = chartData[i].Extension.Replace(".", ""),
data = Convert.ToInt32(chartData[i].Count),
color = "#8669CC"
});
}
}
}
#endregion
}
}
catch (Exception exception)
{
return(InternalServerError(exception));
}
return(Ok(objChart));
}
}
public async Task <IHttpActionResult> GetProjectTickersCount(int projectId)
{
var generalRepository =
new GeneralRepository <ProjectTickersCount>(new AppDbContext());
object[] parameters =
{
new MySqlParameter("prjId", MySqlDbType.Int32)
{
Value = projectId
}
};
var dataTable = await generalRepository
.ExecuteStoreProcedure <ProjectTickersCount>("SpProjectDashboardTickers", parameters);
return(Ok(dataTable));
}
public async Task <IHttpActionResult> GetApplicationPieChart(int projectId)
// To Get all the application Pie Chart
{
using (_codeVortoService = new CodeVortoService())
{
var objChart = new Chart {
Charts = new List <ChartItem>()
};
try
{
try
{
var generalRepository =
new GeneralRepository <ChartDashboardCount>(new AppDbContext());
object[] parameters =
{
new MySqlParameter("prjId", MySqlDbType.Int32)
{
Value = projectId
}
};
var chartData = await generalRepository
.ExecuteStoreProcedure <ChartDashboardCountNew>("GetApplicationChartData", parameters);
if ((chartData.Count > 0) && (chartData.Count > 0))
{
#region Added Chart data
if (chartData.Count > 0)
{
for (var i = 0; i < chartData.Count; i++)
{
string newCol;
if (chartData[i].Extension.Replace(".", "") == "vb")
{
newCol = "#8669CC";
}
else if (chartData[i].Extension.Replace(".", "") == "config")
{
newCol = "#a6c600";
}
else if (chartData[i].Extension.Replace(".", "") == "svc")
{
newCol = "#177bbb";
}
else if (chartData[i].Extension.Replace(".", "") == "designer")
{
newCol = "#f84f9a";
}
else if (chartData[i].Extension.Replace(".", "") == "cbl")
{
newCol = "#FF0000";
}
else if (chartData[i].Extension.Replace(".", "") == "jcl")
{
newCol = "#FFA500";
}
else if (chartData[i].Extension.Replace(".", "") == "proc")
{
newCol = "#469496";
}
else
{
newCol = "#247A00";
}
objChart.Charts.Add(new ChartItem
{
label = chartData[i].Extension.Replace(".", ""),
data = Convert.ToInt32(chartData[i].Count),
color = newCol
});
}
}
#endregion
}
}
catch (Exception exception)
{
return(InternalServerError(exception));
}
}
catch (Exception exception)
{
return(InternalServerError(exception));
}
return(Ok(objChart));
}
}