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; }
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); }
internal RateRow(DataRowBuilder rb) : base(rb) { this.tableRate = ((RateDataTable)(this.Table)); }
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(); } }