public List <MorrisLineChart> dataMorrisLineChartSumEDW()
{
List <MorrisLineChart> lst_linechart = new List <MorrisLineChart>();
OraManager oraManager = new OraManager();
DataTable dt = new DataTable();
MorrisLineChart obj_linechart;
try
{
string strQuery = string.Empty;
strQuery = " select today ,yesterday , ROUND(average) as average ";
strQuery += " from report_summary_edw_02_concurr ";
dt = oraManager.GetDataEDW(strQuery);
for (int i = 0; i < dt.Rows.Count; i++)
{
obj_linechart = new MorrisLineChart();
obj_linechart.Today = Int16.Parse(dt.Rows[i]["today"].ToString());
obj_linechart.Yesterday = Int16.Parse(dt.Rows[i]["yesterday"].ToString());
obj_linechart.Average = Int16.Parse(dt.Rows[i]["average"].ToString());
lst_linechart.Add(obj_linechart);
}
}
catch (Exception e)
{
Console.Out.WriteLine(e.Message.ToString());
}
return(lst_linechart);
}
public List <MorrisLineChart> dataMorrisLineChartEDW()
{
List <MorrisLineChart> lst_linechart = new List <MorrisLineChart>();
OraManager oraManager = new OraManager();
DataTable dt = new DataTable();
MorrisLineChart obj_linechart;
try
{
string strQuery = string.Empty;
strQuery = " select display as name_ ,cnt_job as value_ ";
strQuery += " from report_summary_edw_01_concurr ";
dt = oraManager.GetDataEDW(strQuery);
for (int i = 0; i < dt.Rows.Count; i++)
{
obj_linechart = new MorrisLineChart();
obj_linechart.Name = dt.Rows[i]["name_"].ToString();
obj_linechart.Value = dt.Rows[i]["value_"].ToString();
lst_linechart.Add(obj_linechart);
}
}
catch (Exception e)
{
Console.Out.WriteLine(e.Message.ToString());
}
return(lst_linechart);
}
