public void ChartUpdate(SanjhaChartsInfo info) { List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >(); param.Add(new KeyValuePair <string, object>("@ChartNo", info.ChartNo)); param.Add(new KeyValuePair <string, object>("@ChartTypeID", info.ChartTypeID)); param.Add(new KeyValuePair <string, object>("@Colors", info.Colors)); param.Add(new KeyValuePair <string, object>("@VerticalValue", info.VerticalValue)); param.Add(new KeyValuePair <string, object>("@HorizontalValue", info.HorizontalValue)); param.Add(new KeyValuePair <string, object>("@ChartTitle", info.ChartTitle)); param.Add(new KeyValuePair <string, object>("@ShowIndex", info.ShowIndex)); param.Add(new KeyValuePair <string, object>("@ChartData", info.ChartData)); SQLHandler objSQL = new SQLHandler(); objSQL.ExecuteNonQuery("sc_Update_ChartByID", param); }
/// <summary> /// Retrieves data from database based on moduleID and sends the required data to frontend for drawing charts /// </summary> public void DrawChart() { SanjhaChartsController objCtl = new SanjhaChartsController(); SanjhaChartsInfo objInfo = new SanjhaChartsInfo(); objInfo = objCtl.ChartDataSelect(ModuleID); if (objInfo != null) { IsDataPresent = "true"; ChartData = objInfo.ChartData; ChartTypeID = objInfo.ChartTypeID; ChartTitle = objInfo.ChartTitle; VerticalValue = objInfo.VerticalValue; HorizontalValue = objInfo.HorizontalValue; ShowIndex = objInfo.ShowIndex; } else { IsDataPresent = "false"; } }
public void ChartUpdate(SanjhaChartsInfo info) { SanjhaChartDataProvider scDP = new SanjhaChartDataProvider(); scDP.ChartUpdate(info); }