public static DataForEnergy GetEnergyBarData(string fromDate, string selectedShift) { DateTime fromdateTime = DateTime.ParseExact(fromDate, "dd-MM-yyyy", CultureInfo.InvariantCulture); fromDate = fromdateTime.ToString("yyyy-MM-dd"); DataTable dt = DataBaseAccess.GetDataForDateShift(fromDate, selectedShift, true); DataForEnergy chartForEnergy = new DataForEnergy(); try { chartForEnergy.TitleEnergy = "Energy Graph"; chartForEnergy.xAxisTitleEnergy = "Machine"; chartForEnergy.yAxisTitleEnergy = "Energy(KwH)"; chartForEnergy.EnergyCategories = new List <string>(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dataRow in dt.Rows) { chartForEnergy.EnergyCategories.Add(dataRow[0].ToString()); } chartForEnergy.seriesEnergy = new List <ChartSeries>(); ChartSeries series1 = new ChartSeries(); ChartSeries series2 = new ChartSeries(); series1.name = dt.Columns["Energy"].ColumnName; series2.name = dt.Columns["Target"].ColumnName; series1.data = new List <double>(); series2.data = new List <double>(); for (int i = 0; i < dt.Rows.Count; i++) { series1.data.Add(Convert.ToDouble(dt.Rows[i]["Energy"].ToString())); series2.data.Add(Convert.ToDouble(dt.Rows[i]["Target"].ToString())); } chartForEnergy.seriesEnergy.Add(series1); chartForEnergy.seriesEnergy.Add(series2); } else { chartForEnergy.seriesEnergy = new List <ChartSeries> { new ChartSeries { name = "Energy", data = new List <double> { 34, 54, 35, 23, 53, 23, 32, 35, 75, 76, 56, 36, 76, 86, 34, 54, 35, 23, 53, 23, 32, 35, 75, 76, 89 } }, }; for (int i = 0; i <= 24; i++) { chartForEnergy.EnergyCategories.Add("FANUC"); } } } catch (Exception ex) { Logger.WriteErrorLog(ex.Message); } return(chartForEnergy); }
public static DataForEnergy GetHourwiseEnergy(string machine, string date, string shift) { List <HourwiseMonitoringData> hourwiseMonitoringDatas = new List <HourwiseMonitoringData>(); DateTime fromdateTime = DateTime.ParseExact(date, "dd-MM-yyyy", CultureInfo.InvariantCulture); date = fromdateTime.ToString("yyyy-MM-dd"); hourwiseMonitoringDatas = DataBaseAccess.GetHourWiseEnergyData(machine, date, shift, true); DataForEnergy chartForEnergy = new DataForEnergy(); try { chartForEnergy.TitleEnergy = "Energy Graph"; chartForEnergy.xAxisTitleEnergy = "Hours"; chartForEnergy.yAxisTitleEnergy = "Energy(KwH)"; chartForEnergy.EnergyCategories = new List <string>(); ChartSeries series1 = new ChartSeries(); ChartSeries series2 = new ChartSeries(); if (hourwiseMonitoringDatas != null && hourwiseMonitoringDatas.Count > 0) { series1.name = "Energy"; series2.name = "Target"; series1.data = new List <double>(); series2.data = new List <double>(); foreach (HourwiseMonitoringData data in hourwiseMonitoringDatas) { chartForEnergy.EnergyCategories.Add(data.ShiftHourID); series1.data.Add(Convert.ToDouble(data.Energy)); series2.data.Add(Convert.ToDouble(data.Target)); } chartForEnergy.seriesEnergy = new List <ChartSeries>(); chartForEnergy.seriesEnergy.Add(series1); chartForEnergy.seriesEnergy.Add(series2); } } catch (Exception ex) { Logger.WriteErrorLog(ex.Message); } return(chartForEnergy); }