private void BindBarChart()
{
BarChart barChart = new BarChart();
if (Request["PrjRep_Issues"] != null)
PrjRep_Issues(barChart);
else if (Request["OverPrjSnap_Issues"] != null)
OverPrjSnap_Issues(barChart);
else if (Request["OverPrjSnap_TaskToDo"] != null)
OverPrjSnap_TaskToDo(barChart);
////////////Dashboard//////////////////////////////////////////////////////////////
else if (Request["Dash_Prj_Stat"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Stat");
else if (Request["Dash_Prj_Prior"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Prior");
else if (Request["Dash_Prj_Typ"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Typ");
else if (Request["Dash_Prj_Man"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Man");
else if (Request["Dash_Prj_GenCat"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_GenCat");
else if (Request["Dash_Prj_PrjCat"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_PrjCat");
else if (Request["Dash_Prj_PrjGrp"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_PrjGrp");
else if (Request["Dash_Prj_Phas"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Phas");
else if (Request["Dash_Prj_Clnt"] != null)
Dash_Prj_Item_Gist(barChart, "Dash_Prj_Clnt");
//////////////////Dashboard - Issues////////////////////////////////////////////////////////
else if (Request["Dash_Iss_Stat"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Stat");
else if (Request["Dash_Iss_Prior"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Prior");
else if (Request["Dash_Iss_Typ"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Typ");
else if (Request["Dash_Iss_Prj"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Prj");
else if (Request["Dash_Iss_Man"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Man");
else if (Request["Dash_Iss_Sev"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_Sev");
else if (Request["Dash_Iss_GenCat"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_GenCat");
else if (Request["Dash_Iss_IssCat"] != null)
Dash_Iss_Item_Gist(barChart, "Dash_Iss_IssCat");
System.IO.MemoryStream tmpStream = new System.IO.MemoryStream();
barChart.Draw(tmpStream, System.Drawing.Imaging.ImageFormat.Png);
byte[] tmpBuffer = tmpStream.GetBuffer();
this.Response.OutputStream.Write(tmpBuffer, 0, tmpBuffer.Length);
}
private void Dash_Prj_Item_Gist(BarChart barChart, string sItem)
{
prop_col["Dashboard_GraphView"] = sItem;
//gist.Width = 250;
//gist.Height = 60;
barChart.Sort = false;
barChart.BorderWidth = 0;
DataTable dt = new DataTable();
switch (sItem)
{
case "Dash_Prj_Stat":
dt = Project.GetProjectStatisticByStatusDataTable();
break;
case "Dash_Prj_Prior":
dt = Project.GetProjectStatisticByPriorityDataTable();
break;
case "Dash_Prj_Typ":
dt = Project.GetProjectStatisticByTypeDataTable();
break;
case "Dash_Prj_Man":
dt = Project.GetProjectStatisticByManagerDataTable();
break;
case "Dash_Prj_GenCat":
dt = Project.GetProjectStatisticByGeneralCategoryDataTable();
break;
case "Dash_Prj_PrjCat":
dt = Project.GetProjectStatisticByProjectCategoryDataTable();
break;
case "Dash_Prj_PrjGrp":
dt = Project.GetProjectStatisticByProjectGroupDataTable();
break;
case "Dash_Prj_Phas":
dt = Project.GetProjectStatisticByPhaseDataTable();
break;
case "Dash_Prj_Clnt":
dt = Project.GetProjectStatisticByClientDataTable();
break;
}
string[] titles = new string[dt.Rows.Count];
double[] values = new double[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
titles[i] = dt.Rows[i]["ItemName"].ToString();
values[i] = Convert.ToDouble(dt.Rows[i]["Count"]);
}
barChart.CollectDataPoints(titles, values);
}
private void Dash_Iss_Item_Gist(BarChart barChart, string sItem)
{
prop_col["Dashboard_GraphView"] = sItem;
LocRM = new ResourceManager("Mediachase.UI.Web.App_GlobalResources.Incidents.Resources.strIncidents", typeof(ChartImage).Assembly);
barChart.Sort = false;
barChart.BorderWidth = 0;
DataTable dt = new DataTable();
bool _IsPrj = false;
switch (sItem)
{
case "Dash_Iss_Stat":
dt = Incident.GetListIncidentStatisticByStatusDataTable();
DataRow[] _dr = dt.Select("ItemId=" + ((int)ObjectStates.ReOpen).ToString());
if (_dr.Length > 0)
{
int iCount = (int)_dr[0]["Count"];
dt.Rows.Remove(_dr[0]);
_dr = dt.Select("ItemId=" + ((int)ObjectStates.Active).ToString());
if (_dr.Length > 0)
{
_dr[0]["Count"] = (int)_dr[0]["Count"] + iCount;
}
}
break;
case "Dash_Iss_Prior":
dt = Incident.GetListIncidentStatisticByPriorityDataTable();
break;
case "Dash_Iss_Typ":
dt = Incident.GetListIncidentStatisticByTypeDataTable();
break;
case "Dash_Iss_Prj":
dt = Incident.GetListIncidentStatisticByProjectDataTable();
_IsPrj = true;
break;
case "Dash_Iss_Man": //IssueBox
dt = Incident.GetListIncidentStatisticByIncidentBoxDataTable();
break;
case "Dash_Iss_Sev":
dt = Incident.GetListIncidentStatisticBySeverityDataTable();
break;
case "Dash_Iss_GenCat":
dt = Incident.GetListIncidentStatisticByGeneralCategoryDataTable();
break;
case "Dash_Iss_IssCat":
dt = Incident.GetListIncidentStatisticByIncidentCategoryDataTable();
break;
}
string[] titles = new string[dt.Rows.Count];
double[] values = new double[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (_IsPrj && dt.Rows[i]["ItemName"] == DBNull.Value)
titles[i] = LocRM.GetString("tNoProject");
else
titles[i] = dt.Rows[i]["ItemName"].ToString();
values[i] = Convert.ToDouble(dt.Rows[i]["Count"]);
}
barChart.CollectDataPoints(titles, values);
}
private void PrjRep_Issues(BarChart barChart)
{
LocRM = new ResourceManager("Mediachase.UI.Web.App_GlobalResources.Projects.Resources.strProjectReports", typeof(ChartImage).Assembly);
barChart.Title = LocRM.GetString("oIssuesGraphTitle");
barChart.Width = 250;
barChart.Height = 60;
barChart.Sort = false;
barChart.BorderWidth = 0;
int inew = 0;
int iactive = 0;
int isuspended = 0;
int iclosed = 0;
int ioncheck = 0;
int itotal = 0;
int ProjId = int.Parse(Request["ProjectId"].ToString());
using (IDataReader rdr = Incident.GetIncidentStatistic(ProjId))
{
/// IncidentCount, Pop3IncidentCount, NewIncidentCount, ActiveIncidentCount,
/// ClosedIncidentCount, AvgTimeInNewState, AvgTimeInActiveState,
/// AvgTimeForResolveClosed, AvgTimeForResolveAll,
/// OnCheckIncidentCount, ReOpenIncidentCount, SuspendedIncidentCount
if (rdr.Read())
{
inew = (int)rdr["NewIncidentCount"];
iactive = (int)rdr["ActiveIncidentCount"] + (int)rdr["ReOpenIncidentCount"];
isuspended = (int)rdr["SuspendedIncidentCount"];
iclosed = (int)rdr["ClosedIncidentCount"];
ioncheck = (int)rdr["OnCheckIncidentCount"];
itotal = inew + iactive + isuspended + iclosed + ioncheck;
}
}
if (itotal > 0)
{
string[] titles = new string[] { LocRM.GetString("oNew"), LocRM.GetString("oOpen"), LocRM.GetString("oSuspended"), LocRM.GetString("oClosed"), LocRM.GetString("oOnCheck") };
double[] values = new double[] { Convert.ToDouble(inew), Convert.ToDouble(iactive), Convert.ToDouble(isuspended), Convert.ToDouble(iclosed), Convert.ToDouble(ioncheck) };
barChart.CollectDataPoints(titles, values);
}
else
barChart.CollectDataPoints(new string[0], new double[0]);
}
private void OverPrjSnap_TaskToDo(BarChart barChart)
{
LocRM = new ResourceManager("Mediachase.UI.Web.App_GlobalResources.Reports.Resources.strProjectSnapshot", typeof(ChartImage).Assembly);
barChart.Title = LocRM.GetString("oTaskGraphTitle");
barChart.Width = 320;
barChart.Height = 100;
barChart.Sort = false;
int itotal = 0;
int icompleted = 0;
int iactive = 0;
int ipastdue = 0;
int ProjId = int.Parse(Request["ProjectId"].ToString());
using (IDataReader rdr = Report.GetToDoAndTaskTrackingReport(ProjId))
{
if (rdr.Read())
{
itotal = (int)rdr["Total"];
icompleted = (int)rdr["Completed"];
iactive = (int)rdr["Active"];
ipastdue = (int)rdr["PastDue"];
}
}
if (itotal > 0)
{
string[] titles = new string[] { LocRM.GetString("oTotal"), LocRM.GetString("oCompleted"), LocRM.GetString("oActive"), LocRM.GetString("oPastDue") };
double[] values = new double[] { Convert.ToDouble(itotal), Convert.ToDouble(icompleted), Convert.ToDouble(iactive), Convert.ToDouble(ipastdue) };
barChart.CollectDataPoints(titles, values);
}
else
barChart.CollectDataPoints(new string[0], new double[0]);
}
private void OverPrjSnap_Issues(BarChart barChart)
{
LocRM = new ResourceManager("Mediachase.UI.Web.App_GlobalResources.Reports.Resources.strProjectSnapshot", typeof(ChartImage).Assembly);
barChart.Title = LocRM.GetString("oIssuesGraphTitle");
barChart.Width = 320;
barChart.Height = 100;
barChart.Sort = false;
int inew = 0;
int itotal = 0;
int iactive = 0;
int iopen = 0;
int ietc = 0;
int ProjId = int.Parse(Request["ProjectId"].ToString());
using (IDataReader rdr = Incident.GetIncidentStatistic(ProjId))
{
if (rdr.Read())
{
inew = (int)rdr["NewIncidentCount"];
iactive = (int)rdr["ActiveIncidentCount"];
itotal = (int)rdr["IncidentCount"];
iopen = inew + iactive;
ietc = itotal - iopen;
}
}
if (itotal > 0)
{
string[] titles = new string[] { LocRM.GetString("oNew"), LocRM.GetString("oOpen"), LocRM.GetString("oActive"), LocRM.GetString("oEtc") };
double[] values = new double[] { Convert.ToDouble(inew), Convert.ToDouble(iopen), Convert.ToDouble(iactive), Convert.ToDouble(ietc) };
barChart.CollectDataPoints(titles, values);
}
else
barChart.CollectDataPoints(new string[0], new double[0]);
}
