Esempio n. 1
0
        public bool Create(IRepositoryAsync<Log> LogRepository, ChartAreaDto ChartAreaDto, string ChartID, ContestViewParmsDTO ContestViewParmsDTO, string username)
        {
            bool bOK = true;
            this.ChartType = ChartAreaDto.charttype;



            // Check if table is cached
            //if (HttpRuntime.Cache[ContestViewParmsDTO.SerTablename] == null)
            //{
                //remove previous chart
                ////string OldTableName = Session[SeriesNum + ChartID] as String;
                ////if (!string.IsNullOrEmpty(OldTableName))
                ////{
                ////    Session.Remove(SeriesNum + ChartID);
                ////    HttpRuntime.Cache.Remove(OldTableName);
                ////}


                double FudgeInterval; //Shifts column bars to the right for axis alignment
                if (this.ChartType == SeriesChartType.Column)
                {
                    FudgeInterval = ChartAreaDto.ChartPointtInterval * -.25;
                }
                else
                {
                    FudgeInterval = 0;
                }

                //SqlDataReader QSOReader  = QSOCommand.ExecuteReader();
                //fill Calll Qsos, Table has  holes wgere no qsos were made
                IList<ChartQsoRateDTO> QsoRateList = DTFunc(LogRepository, ContestViewParmsDTO, username);

                //this.SetCustomProperty("DrawingStyle" , "Cylinder");
                //TmpDT = new RateDataTable(QSOsdt, Ctestinfo.startTime, Ctestinfo.endTime,
                //                            IntvTime, Interval, MixedYears);

                //HttpRuntime.Cache[TableName] = new RateDataTable(QSOsdt, Ctestinfo.startTime, Ctestinfo.endTime, IntvTime, Interval, MixedYears);
                //System.Web.HttpContext.Current.Cache[TableName] = new RateDataTable(QSOsdt, Ctestinfo.startTime, Ctestinfo.endTime, IntvTime, Interval, MixedYears);
#if false               
                System.Web.HttpContext.Current.Cache.Insert(
                    ContestViewParmsDTO.SerTablename,
                    new RateDataTable(QSOsdt, ContestInfoDTO.startTime, ContestInfoDTO.endTime, ContestViewParmsDTO.sIntvTime, ChartAreaDto.ChartPointtInterval,
                        ChartAreaDto.MixedYears, FudgeInterval, ContestViewParmsDTO.bSum),
                    null,
                    Cache.NoAbsoluteExpiration,
                    new TimeSpan(0, 5, 0));
                //Add session state
                ////Session.Add(SeriesNum + ChartID, ContestViewParmsDTO.SerTablename);
#else
                RateDataTable RateDataTable = new RateDataTable(QsoRateList, ContestInfoDTO.startTime, ContestInfoDTO.endTime, ContestViewParmsDTO.sIntvTime, ChartAreaDto.ChartPointtInterval,
                        ChartAreaDto.MixedYears, FudgeInterval, ContestViewParmsDTO.bSum);

#endif
                //QsoRateList.();
            //}

            //not retained on draw. Needs to be set each time
            if (this.ChartType == SeriesChartType.Line)
            {
                this.MarkerStyle = System.Web.UI.DataVisualization.Charting.MarkerStyle.Circle;
            }
            if (this.ChartType == SeriesChartType.Spline)
            {
                this.BorderWidth = 2; // linrwdth
            }


            //OleDbDataReader rdr = TmpDT.CreateDataReader();

            //DataView dv = new DataView(TmpDT);
            //this.Points.DataBindXY(
            //    dv, IntvTime,
            //    dv, sQCnt);    
            //DataTableReader dr = ((DataTable)HttpRuntime.Cache[TableName]).CreateDataReader();
#if false
            DataTableReader dr = ((DataTable)System.Web.HttpContext.Current.Cache[ContestViewParmsDTO.SerTablename]).CreateDataReader();
#else
            //DataTableReader dr = RateDataTable.CreateDataReader();
#endif
           //List<ChartQsoRateDTO> ChartQsoRateDTOs = new List<ChartQsoRateDTO>();
            this.Points.DataBindXY(
                RateDataTable.QsoRateFullList.Select(x => x.IntvTime).ToList<DateTime>(),
                RateDataTable.QsoRateFullList.Select(x => x.N).ToList<int>());
   

            //this.Points.DataBindXY()
            //    dr, ContestViewParmsDTO.sIntvTime,
            //    dr, ContestViewParmsDTO.sQCnt);

            return bOK;
        }
Esempio n. 2
0
 private void InitClass() {
     this.DataSetName = "DatasetRoam";
     this.Prefix = "";
     this.Namespace = "http://tempuri.org/DatasetRoam.xsd";
     this.Locale = new System.Globalization.CultureInfo("en-US");
     this.CaseSensitive = false;
     this.EnforceConstraints = true;
     this.tableCountryCode = new CountryCodeDataTable();
     this.Tables.Add(this.tableCountryCode);
     this.tableCDR = new CDRDataTable();
     this.Tables.Add(this.tableCDR);
     this.tablePartner = new PartnerDataTable();
     this.Tables.Add(this.tablePartner);
     this.tableTAP = new TAPDataTable();
     this.Tables.Add(this.tableTAP);
     this.tableTariff = new TariffDataTable();
     this.Tables.Add(this.tableTariff);
     this.tableRate = new RateDataTable();
     this.Tables.Add(this.tableRate);
     this.tableTag = new TagDataTable();
     this.Tables.Add(this.tableTag);
 }
Esempio n. 3
0
 internal RateRow(DataRowBuilder rb) : 
         base(rb) {
     this.tableRate = ((RateDataTable)(this.Table));
 }
Esempio n. 4
0
 internal void InitVars() {
     this.tableCountryCode = ((CountryCodeDataTable)(this.Tables["CountryCode"]));
     if ((this.tableCountryCode != null)) {
         this.tableCountryCode.InitVars();
     }
     this.tableCDR = ((CDRDataTable)(this.Tables["CDR"]));
     if ((this.tableCDR != null)) {
         this.tableCDR.InitVars();
     }
     this.tablePartner = ((PartnerDataTable)(this.Tables["Partner"]));
     if ((this.tablePartner != null)) {
         this.tablePartner.InitVars();
     }
     this.tableTAP = ((TAPDataTable)(this.Tables["TAP"]));
     if ((this.tableTAP != null)) {
         this.tableTAP.InitVars();
     }
     this.tableTariff = ((TariffDataTable)(this.Tables["Tariff"]));
     if ((this.tableTariff != null)) {
         this.tableTariff.InitVars();
     }
     this.tableRate = ((RateDataTable)(this.Tables["Rate"]));
     if ((this.tableRate != null)) {
         this.tableRate.InitVars();
     }
     this.tableTag = ((TagDataTable)(this.Tables["Tag"]));
     if ((this.tableTag != null)) {
         this.tableTag.InitVars();
     }
 }