예제 #1
0
        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);
        }