/************************************************************************************* * module: frmAnonCust.cs - TLoadData * * author: Tim Ragain * date: Jan 22, 2002 * * Purpose: Takes two variables the x represents the day as an integer and the sCount is a * short representing the column of the Calendar control. This initializes the OCAData.dll * control and calls the GetDailyCount and GetDailyAnon procedures. The anonymous count is * subtracted from the total count to get the customer count. The appropriate column * and row is updated. *************************************************************************************/ private void TLoadData(int x, short sCount) { OCAData.CCountDailyClass rpt = new OCAData.CCountDailyClass(); System.DateTime dDate = new System.DateTime(monthCalendar1.SelectionStart.Year, monthCalendar1.SelectionStart.Month, monthCalendar1.SelectionStart.Day); long lngCount = 0, l_AnonUploads = 0; UpdateStatus(); //***********Total Record Count*************** statusBar1.Text = "Getting Daily Count for " + dDate.AddDays(x).Date.ToString(); lngCount = rpt.GetDailyCount(dDate.AddDays(x)); lDate[x] = dDate.AddDays(x); //***********Total Anon Count*************** UpdateStatus(); statusBar1.Text = "Getting Anon Users for " + dDate.AddDays(x).Date.ToString(); l_AnonUploads = rpt.GetDailyAnon(dDate.AddDays(x)); lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = 1; axMSChart1.RowLabel = dDate.AddDays(x).Date.ToShortDateString(); //+ dDate.Date.ToString(); axMSChart1.Data = l_AnonUploads.ToString(); } UpdateStatus(); //***********Calculate Customer Count*************** statusBar1.Text = "Calculating Customer Count for " + dDate.AddDays(x).Date.ToString(); if (l_AnonUploads > lngCount) { lngCount = l_AnonUploads - lngCount; } else { lngCount = lngCount - l_AnonUploads; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = 2; lAnonymous[x] = l_AnonUploads; lCustomer[x] = lngCount; axMSChart1.Data = lngCount.ToString(); } //********************************** UpdateStatus(); this.Refresh(); }
/************************************************************************************* * module: anoncustomer.aspx.cs - Page_Load * * author: Tim Ragain * date: Jan 22, 2002 * * Purpose: to Create both gif charts from the Office Watson Controls and set the images to those * files. Create OCAData object and return data for anonymous versus customer uploads. Set the information * in the tables to correspond to the graphs. *************************************************************************************/ private void Page_Load(object sender, System.EventArgs e) { int x = -1; int rowCnt = 7; int rowCtr = 0; int cellCtr = 0; int cellCnt = 3; string sFName; long[] LACustomer = new long[7]; long[] LAAnon = new long[7]; long lTemp = 0, lTotalAnon = 0, lTotalCustomer = 0; Object[] yCustomerCol = new Object[7]; Object[] xAonCol = new Object[7]; Object[] yCustomerValues = new Object[2]; Object[] xAnonValues = new Object[2]; OCAData.CCountDailyClass rpt = new OCAData.CCountDailyClass(); System.DateTime dDate = new System.DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month, System.DateTime.Now.Day); OWC.WCChart oWeeklyChart, oRatioChart; OWC.ChartSpaceClass oSpace = new OWC.ChartSpaceClass(); OWC.ChartSpaceClass oSpace1 = new OWC.ChartSpaceClass(); OWC.WCSeries oSeries1; OWC.WCDataLabels oLabels; OWC.WCDataLabelsCollection oLabelCollection; oSpace.Clear(); oSpace.Refresh(); oWeeklyChart = oSpace.Charts.Add(0); oWeeklyChart.HasLegend = true; //Begin Image One for (x = 0; x < 2; x++) { oWeeklyChart.SeriesCollection.Add(x); } for (x = 0; x < 7; x++) { LACustomer[x] = rpt.GetDailyCount(dDate.AddDays(-(x + 1))); try { LAAnon[x] = rpt.GetDailyAnon(dDate.AddDays(-(x + 1))); } catch { LAAnon[x] = 0; } if (LACustomer[x] > LAAnon[x]) { // xAonCol.SetValue((LACustomer[x] - LAAnon[x]), 0); lTotalCustomer = lTotalCustomer + (LACustomer[x] - LAAnon[x]); } else { // xAonCol.SetValue((LAAnon[x] - LACustomer[x]), 0); lTotalCustomer = lTotalCustomer + (LAAnon[x] - LACustomer[x]); } lTotalAnon = lTotalAnon + LAAnon[x]; } //******************************************************************************************************* oWeeklyChart.HasTitle = true; oWeeklyChart.Title.Caption = "Database - Anonymouse vs Customer"; for (x = 0; x < 6; x++) { xAonCol[x] = LAAnon[x].ToString(); } oWeeklyChart.SeriesCollection[0].Caption = "Anonymous"; oWeeklyChart.SeriesCollection[0].SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xAonCol); for (x = 0; x < 6; x++) { if (LACustomer[x] > LAAnon[x]) { lTemp = LACustomer[x] - LAAnon[x]; xAonCol[x] = lTemp.ToString(); } else { lTemp = LAAnon[x] - LACustomer[x]; xAonCol[x] = lTemp.ToString(); } } oWeeklyChart.SeriesCollection[1].Caption = "Customer"; oWeeklyChart.SeriesCollection[1].SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xAonCol); for (x = 0; x < 6; x++) { xAonCol.SetValue(dDate.AddDays(x).ToShortDateString(), x); } oWeeklyChart.SeriesCollection[0].SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, xAonCol); //******************************************************************************************************* sFName = "Anon"; try { oSpace.ExportPicture(Server.MapPath(sFName), "gif", 707, 476); imgAnonDaily1.ImageUrl = sFName; } catch { } //End Image one //Begin Image Two oSpace1.Clear(); oSpace1.Refresh(); oRatioChart = oSpace1.Charts.Add(0); oRatioChart.Type = OWC.ChartChartTypeEnum.chChartTypeBarClustered; oRatioChart.HasLegend = true; lTemp = lTotalCustomer + lTotalAnon; oSeries1 = oRatioChart.SeriesCollection.Add(0); oLabelCollection = oSeries1.DataLabelsCollection; oLabels = oLabelCollection.Add(); oLabels.HasPercentage = true; oLabels.HasValue = false; xAnonValues.SetValue(lTotalAnon.ToString(), 0); xAnonValues.SetValue(lTotalCustomer.ToString(), 1); yCustomerValues.SetValue("Anonymous", 0); yCustomerValues.SetValue("Customer", 1); oRatioChart.HasTitle = true; oRatioChart.Title.Caption = "Database - Average Weekly Uploads"; oSeries1.Caption = "Average Weekly"; //chDimCategories oSeries1.SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, yCustomerValues); oSeries1.SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xAnonValues); oSeries1.Type = OWC.ChartChartTypeEnum.chChartTypePie; sFName = "AnonPer"; try { oSpace1.ExportPicture(Server.MapPath(sFName), "gif", 707, 476); imgAnonTotal.ImageUrl = sFName; } catch { } //End Image Two //Begin Table for (rowCtr = 0; rowCtr <= rowCnt; rowCtr++) { TableRow tRow = new TableRow(); tblAnonCustomer.Rows.Add(tRow); //tRow.CssClass = "clsTRMenu"; for (cellCtr = 1; cellCtr <= cellCnt; cellCtr++) { TableCell tCell = new TableCell(); if (rowCtr == 0) { switch (cellCtr) { case 1: tCell.Text = "Date"; break; case 2: tCell.Text = "Anonymous"; break; case 3: tCell.Text = "Customer"; break; default: tCell.Text = "0"; break; } tCell.Style["font-size"] = "small"; } else { switch (cellCtr) { case 1: tCell.Text = dDate.AddDays(-rowCtr).ToShortDateString(); break; case 2: tCell.Text = LAAnon[rowCtr - 1].ToString(); break; case 3: if (LAAnon[rowCtr - 1] > LACustomer[rowCtr - 1]) { lTemp = LAAnon[rowCtr - 1] - LACustomer[rowCtr - 1]; } else { lTemp = LACustomer[rowCtr - 1] - LAAnon[rowCtr - 1]; } tCell.Text = lTemp.ToString(); break; default: tCell.Text = "0"; break; } tCell.Style["background-color"] = "white"; tCell.Style["font-size"] = "small-x"; tCell.Style["color"] = "#6487dc"; tCell.Style["font-weight"] = "Bold"; } tCell.Style["font-family"] = "Tahoma"; tRow.Cells.Add(tCell); } } //End Table }