コード例 #1
0
        /// <summary>
        /// Return the queryDetails used to build the request.
        /// </summary>
        /// <param name="queryDetails">The query details adapted from the class used to read the app.config</param>
        /// <returns>The queryDetails adapted from app.config.</returns>
        public GtQueryDetails ConvertToGtQueryDetails(GtSettingsHandler.QueryDetailsElement queryDetails)
        {
            GtQueryDetails        details     = new GtQueryDetails();
            List <GtQueryDetails> detailsList = new List <GtQueryDetails>();

            details.Name       = queryDetails.Name;
            details.Tittle     = queryDetails.Tittle;
            details.TableId    = queryDetails.TableId;
            details.From       = Convert.ToDateTime(queryDetails.From);
            details.To         = Convert.ToDateTime(queryDetails.To);
            details.Max        = Convert.ToInt32(queryDetails.Max);
            details.Sort       = (queryDetails.Sort);
            details.Offset     = Convert.ToInt32(queryDetails.Offset);
            details.Metrics    = queryDetails.Metrics;
            details.Dimensions = queryDetails.Dimensions;
            return(details);
        }
コード例 #2
0
        /// <summary>
        /// Returns the list of queries configured in the app.config.
        /// </summary>
        /// <param name="queryDetailsList">String list of queries</param>
        /// <returns>The list of queryDetails adapted from app.config.</returns>
        public List <GtQueryDetails> ConvertToGtQueryDetailsList(GtSettingsHandler.QueryDetailsCollection queryDetailsList)
        {
            GtQueryDetails        details;
            List <GtQueryDetails> detailsList = new List <GtQueryDetails>();

            foreach (GtSettingsHandler.QueryDetailsElement queryDetails in queryDetailsList)
            {
                details         = new GtQueryDetails();
                details.Name    = queryDetails.Name;
                details.Tittle  = queryDetails.Tittle;
                details.TableId = queryDetails.TableId;
                details.Offset  = Convert.ToInt32(queryDetails.Offset);
                if (queryDetails.From == "")
                {
                    if (queryDetails.To == "")
                    {
                        details.To = DateTime.Now;
                    }
                    else
                    {
                        details.To = Convert.ToDateTime(queryDetails.To);
                    }
                    int      hours     = DateTime.Now.Hour;
                    int      minutes   = DateTime.Now.Minute;
                    int      seconds   = DateTime.Now.Second;
                    TimeSpan substract = new TimeSpan(details.Offset, 0, 0, 0);
                    DateTime dateTo    = new DateTime();
                    DateTime date      = new DateTime();
                    dateTo          = Convert.ToDateTime(details.To);
                    date            = dateTo.Subtract(substract);
                    details.From    = date;
                    details.Max     = Convert.ToInt32(queryDetails.Max);
                    details.Sort    = (queryDetails.Sort);
                    details.Metrics = queryDetails.Metrics;
                    if (queryDetails.Dimensions != "")
                    {
                        details.Dimensions = queryDetails.Dimensions;
                    }
                    else
                    {
                        details.Dimensions = "";
                    }

                    detailsList.Add(details);
                }
                else
                {
                    details.From = Convert.ToDateTime(queryDetails.From);
                    try
                    {
                        if (queryDetails.To == "")
                        {
                            details.To = DateTime.Now;
                        }
                        else
                        {
                            details.To = Convert.ToDateTime(queryDetails.To);
                        }
                    }
                    catch (Exception e)
                    {
                        throw e;
                    }
                    details.Max     = Convert.ToInt32(queryDetails.Max);
                    details.Sort    = (queryDetails.Sort);
                    details.Metrics = queryDetails.Metrics;
                    if (queryDetails.Dimensions != "")
                    {
                        details.Dimensions = queryDetails.Dimensions;
                    }
                    else
                    {
                        details.Dimensions = "";
                    }
                    detailsList.Add(details);
                }
            }

            return(detailsList);
        }