/************************************************************************************* * 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(); }
private void Page_Load(object sender, System.EventArgs e) { int rowCnt = 1; int rowCtr = 0; int cellCtr = 0; int cellCnt = 4; string sFName; long lACount; long LAWatson; long LAArchive; long lCount = 0; Object[] yValues = new Object[7]; Object[] xValues = new Object[7]; SqlConnection cn = new SqlConnection("Persist Security Info=False;Pwd=ocarpts@2;User ID=ocarpts;Initial Catalog=SnapShot;Data Source=TKWUCDSQLA02"); SqlCommand cm = new SqlCommand(); SqlDataReader dr; string sPath; 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 oChart, oChart1; OWC.ChartSpaceClass oSpace = new OWC.ChartSpaceClass(); OWC.ChartSpaceClass oSpace1 = new OWC.ChartSpaceClass(); OWC.WCSeries oSeries, oSeries1; cn.Open(); cm.CommandType = CommandType.StoredProcedure; cm.CommandTimeout = 240; cm.CommandText = "GetDailySnapshot"; cm.Connection = cn; cm.Parameters.Add("@CreatedDate", System.Data.SqlDbType.DateTime); cm.Parameters["@CreatedDate"].Value = dDate.AddDays(-1); dr = cm.ExecuteReader(); try { dr.Read(); LAWatson = dr.GetInt32(0); LAArchive = dr.GetInt32(1); } catch { LAWatson = 0; LAArchive = 0; } oSpace.Clear(); oSpace.Refresh(); oChart = oSpace.Charts.Add(0); oChart.Type = OWC.ChartChartTypeEnum.chChartTypeBarClustered; oSeries = oChart.SeriesCollection.Add(0); lACount = rpt.GetDailyCount(dDate.AddDays(-1)); xValues.SetValue(lACount.ToString(), 0); xValues.SetValue(LAWatson.ToString(), 1); xValues.SetValue(LAArchive.ToString(), 2); yValues.SetValue("Database", 0); yValues.SetValue("Watson", 1); yValues.SetValue("Archive", 2); oChart.HasTitle = true; oChart.Title.Caption = "Database - Server Comparison Chart"; oSeries.Caption = dDate.Date.ToString(); //chDimCategories oSeries.SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, yValues); oSeries.SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xValues); oSeries.Type = OWC.ChartChartTypeEnum.chChartTypeColumnClustered; sFName = "Daily"; sPath = Server.MapPath(sFName); try { oSpace.ExportPicture(sPath, "gif", 707, 476); imgWeekly.ImageUrl = sFName; } catch { } // Response.Write(Server.MapPath(sFName)); oSpace1.Clear(); oSpace1.Refresh(); oChart1 = oSpace1.Charts.Add(0); oChart1.Type = OWC.ChartChartTypeEnum.chChartTypeBarClustered; oSeries1 = oChart1.SeriesCollection.Add(0); for (rowCtr = 0; rowCtr <= rowCnt; rowCtr++) { TableRow tRow = new TableRow(); tblUploads.Rows.Add(tRow); 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 = "DB Count"; break; case 3: tCell.Text = "Watson"; break; case 4: tCell.Text = "Archive"; break; default: tCell.Text = "0"; break; } tCell.Style["font-size"] = "small"; } else { switch (cellCtr) { case 1: tCell.Text = dDate.AddDays(-1).ToShortDateString(); break; case 2: tCell.Text = lACount.ToString(); break; case 3: tCell.Text = LAWatson.ToString(); break; case 4: tCell.Text = LAArchive.ToString(); break; default: tCell.Text = "0"; break; } tCell.Style["background-color"] = "white"; tCell.Style["font-size"] = "x-small"; tCell.Style["color"] = "#6487dc"; tCell.Style["font-weight"] = "Bold"; } tCell.Style["font-family"] = "Tahoma"; tRow.Cells.Add(tCell); } } for (rowCtr = 0; rowCtr <= rowCnt; rowCtr++) { TableRow tRow = new TableRow(); tblDifference.Rows.Add(tRow); 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 = "Archive vs Watson"; break; case 3: tCell.Text = "SQL vs Archive"; break; case 4: tCell.Text = "SQL vs Watson"; break; default: tCell.Text = "0"; break; } tCell.Style["font-size"] = "small"; } else { switch (cellCtr) { case 1: tCell.Text = dDate.AddDays(-1).ToShortDateString(); break; case 2: lCount = LAArchive - LAWatson; tCell.Text = lCount.ToString(); break; case 3: lCount = lACount - LAArchive; tCell.Text = lCount.ToString();; break; case 4: lCount = lACount - LAWatson; tCell.Text = lCount.ToString(); break; default: tCell.Text = "0"; break; } tCell.Style["background-color"] = "white"; tCell.Style["font-size"] = "x-small"; tCell.Style["color"] = "#6487dc"; tCell.Style["font-weight"] = "Bold"; } tCell.Style["font-family"] = "Tahoma"; tRow.Cells.Add(tCell); } } }
/************************************************************************************* * 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 }
/************************************************************************************* * module: frmSolutionStatus.cs - TLoadData * * author: Tim Ragain * date: Jan 24, 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 l_SpecificSolutions = 0, l_GeneralSolutions = 0, l_StopCodes = 0, l_TotalRecords = 0; //***********Total Record Count*************** UpdateStatus(); statusBar1.Text = "Getting Specific Solutions for " + dDate.AddDays(x).Date.ToString(); lDate[x] = dDate.AddDays(x); try { l_SpecificSolutions = rpt.GetSpecificSolutions(dDate.AddDays(x)); } catch { l_SpecificSolutions = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)1; axMSChart1.RowLabel = dDate.AddDays(x).ToShortDateString(); //+ dDate.Date.ToString(); axMSChart1.Data = l_SpecificSolutions.ToString(); lSpecific[x] = l_SpecificSolutions; } UpdateStatus(); statusBar1.Text = "Getting General Solutions for " + dDate.AddDays(x).Date.ToString(); try { l_GeneralSolutions = rpt.GetGeneralSolutions(dDate.AddDays(x)); } catch { l_GeneralSolutions = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)2; axMSChart1.Data = l_GeneralSolutions.ToString(); lGeneral[x] = l_GeneralSolutions; } UpdateStatus(); statusBar1.Text = "Getting Stop Code Troubleshooters for " + dDate.AddDays(x).Date.ToString(); try { l_StopCodes = rpt.GetStopCodeSolutions(dDate.AddDays(x)); } catch { l_StopCodes = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)3; axMSChart1.Data = l_StopCodes.ToString(); lStopCode[x] = l_StopCodes; } UpdateStatus(); statusBar1.Text = "Getting No Solution incidents for " + dDate.AddDays(x).Date.ToString(); try { l_TotalRecords = rpt.GetDailyCount(dDate.AddDays(x)); } catch { l_TotalRecords = -1; } lock (this) { axMSChart1.Row = sCount; axMSChart1.Column = (short)4; l_TotalRecords = l_TotalRecords - (l_StopCodes + l_GeneralSolutions + l_SpecificSolutions); axMSChart1.Data = l_TotalRecords.ToString(); lNoSolution[x] = l_TotalRecords; } UpdateStatus(); this.Refresh(); }
private void Calendar1_SelectionChanged(object sender, System.EventArgs e) { int x = -1; int y = 0; int rowCnt = 7; int rowCtr = 0; int cellCtr = 0; int cellCnt = 4; string sFName; long[] lACount = new long[7]; long[] LAWatson = new long[7]; long[] LAArchive = new long[7]; long lCount = 0, lArchive = 0, lWatson = 0; Object[] yValues = new Object[7]; Object[] LAGraph = new Object[3]; Object[] xValues = new Object[7]; Object[] yValues1 = new Object[3]; Object[] xValues1 = new Object[3]; 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 oChart, oChart1; OWC.ChartSpaceClass oSpace = new OWC.ChartSpaceClass(); OWC.ChartSpaceClass oSpace1 = new OWC.ChartSpaceClass(); OWC.WCSeries oSeries1; SqlConnection cn = new SqlConnection("Persist Security Info=False;Pwd=ocarpts@2;User ID=ocarpts;Initial Catalog=SnapShot;Data Source=TKWUCDSQLA02"); SqlCommand cm = new SqlCommand(); SqlDataReader dr; Response.CacheControl = "no-cache"; Response.AddHeader("Pragma", "no-cache"); Response.AddHeader("Expires", "-1"); Response.Expires = -1; oSpace.Clear(); oSpace.Refresh(); oChart = oSpace.Charts.Add(0); oChart.HasLegend = true; oChart.HasTitle = true; for (x = 0; x < 3; x++) { oChart.SeriesCollection.Add(x); } dDate = Calendar1.SelectedDate; for (x = 0, y = 6; x < 7; x++, y--) { lACount[x] = rpt.GetDailyCount(dDate.AddDays(y)); } cn.Open(); cm.CommandType = CommandType.StoredProcedure; cm.CommandTimeout = 240; cm.CommandText = "GetSnapshot"; cm.Connection = cn; cm.Parameters.Add("@CreatedDate", System.Data.SqlDbType.DateTime); cm.Parameters["@CreatedDate"].Value = dDate.AddDays(6); dr = cm.ExecuteReader(); dr.Read(); for (x = 0; x < 7; x++) { try { // if(dr.GetDateTime(1) == dDate.AddDays((x + 1))) // { LAWatson[x] = dr.GetInt32(2); LAArchive[x] = dr.GetInt32(3); dr.Read(); // } // else // { // LAWatson[x] = 0; // LAArchive[x] = 0; // } } catch { LAWatson[x] = 0; LAArchive[x] = 0; } } //********************************************************************************************************** oChart.Title.Caption = "Database - Server Comparison Chart"; for (x = 0; x < 7; x++) { xValues[x] = lACount[x].ToString(); } oChart.SeriesCollection[0].Caption = "Database"; oChart.SeriesCollection[0].SetData((OWC.ChartDimensionsEnum)OWC.ChartDimensionsEnum.chDimValues, -1, xValues); OWC.ChartDimensionsEnum c = OWC.ChartDimensionsEnum.chDimValues; oChart.SeriesCollection[0].SetData(c, -1, xValues); for (x = 0; x < 7; x++) { xValues[x] = LAWatson[x].ToString(); } oChart.SeriesCollection[1].Caption = "Watson"; oChart.SeriesCollection[1].SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xValues); for (x = 0; x < 7; x++) { xValues[x] = LAArchive[x].ToString(); } oChart.SeriesCollection[2].Caption = "Archive"; oChart.SeriesCollection[2].SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xValues); for (x = 0, y = 6; x < 7; x++, y--) { yValues.SetValue(dDate.AddDays((y)).ToShortDateString(), x); } oChart.SeriesCollection[0].SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, yValues); //********************************************************************************************************** sFName = "Weekly"; try { oSpace.ExportPicture(Server.MapPath(sFName + ".gif"), "gif", 707, 476); } catch { } imgWeekly.EnableViewState = false; imgWeekly.Page.EnableViewState = false; Page.EnableViewState = false; imgWeekly.ImageUrl = sFName + ".gif"; oSpace1.Clear(); oSpace1.Refresh(); oChart1 = oSpace1.Charts.Add(0); oChart1.Type = OWC.ChartChartTypeEnum.chChartTypeBarClustered; oSeries1 = oChart1.SeriesCollection.Add(0); for (x = 0; x < 7; x++) { lCount = lCount + lACount[x]; lWatson = lWatson + LAWatson[x]; lArchive = lArchive + LAArchive[x]; } lCount = lCount / x; lWatson = lWatson / x; lArchive = lArchive / x; xValues1.SetValue(lCount.ToString(), 0); xValues1.SetValue(lWatson.ToString(), 1); xValues1.SetValue(lArchive.ToString(), 2); yValues1.SetValue("Database", 0); yValues1.SetValue("Watson", 1); yValues1.SetValue("Archive", 2); oChart1.HasTitle = true; oChart1.Title.Caption = "Database - Average Weekly Uploads"; oSeries1.Caption = "Average Weekly"; //chDimCategories oSeries1.SetData(OWC.ChartDimensionsEnum.chDimCategories, -1, yValues1); oSeries1.SetData(OWC.ChartDimensionsEnum.chDimValues, -1, xValues1); oSeries1.Type = OWC.ChartChartTypeEnum.chChartTypeColumnStacked; sFName = "Avg"; try { oSpace1.ExportPicture(Server.MapPath(sFName), "gif", 707, 476); imgAvg.ImageUrl = sFName; } catch { } for (rowCtr = 0, y = 7; rowCtr <= rowCnt; rowCtr++, y--) { TableRow tRow = new TableRow(); tblUploads.Rows.Add(tRow); 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 = "DB Count"; break; case 3: tCell.Text = "Watson"; break; case 4: tCell.Text = "Archive"; break; default: tCell.Text = "0"; break; } tCell.Style["font-size"] = "small"; } else { switch (cellCtr) { case 1: tCell.Text = dDate.AddDays(y).ToShortDateString(); break; case 2: tCell.Text = lACount[rowCtr - 1].ToString(); break; case 3: tCell.Text = LAWatson[rowCtr - 1].ToString(); break; case 4: tCell.Text = LAArchive[rowCtr - 1].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); } } for (rowCtr = 0, y = 7; rowCtr <= rowCnt; rowCtr++, y--) { TableRow tRowDiff = new TableRow(); tblDifference.Rows.Add(tRowDiff); 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 = "Archive vs Watson"; break; case 3: tCell.Text = "SQL vs Archive"; break; case 4: tCell.Text = "SQL vs Watson"; break; default: tCell.Text = "0"; break; } tCell.Style["font-size"] = "small"; } else { switch (cellCtr) { case 1: tCell.Text = dDate.AddDays(y).ToShortDateString(); break; case 2: lCount = LAArchive[rowCtr - 1] - LAWatson[rowCtr - 1]; tCell.Text = lCount.ToString(); break; case 3: lCount = lACount[rowCtr - 1] - LAWatson[rowCtr - 1]; tCell.Text = lCount.ToString(); break; case 4: lCount = lACount[rowCtr - 1] - LAArchive[rowCtr - 1]; tCell.Text = lCount.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"; tRowDiff.Cells.Add(tCell); } } }
/************************************************************************************* * module: frmWeekly.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(); string strArchive, strWatson; int y = 0; RegistryKey regArchive = Registry.CurrentUser.OpenSubKey("software").OpenSubKey("microsoft", true).CreateSubKey("OCATools").CreateSubKey("OCAReports").CreateSubKey("Archive"); RegistryKey regWatson = Registry.CurrentUser.OpenSubKey("software").OpenSubKey("microsoft", true).CreateSubKey("OCATools").CreateSubKey("OCAReports").CreateSubKey("Watson"); System.DateTime dDate = new System.DateTime(monthCalendar1.SelectionStart.Year, monthCalendar1.SelectionStart.Month, monthCalendar1.SelectionStart.Day); long lngCount = 0, l_WatsonCount = 0, l_ArchiveCount = 0; statusBar1.Text = "Getting Daily Count for " + dDate.AddDays(x).Date.ToShortDateString() + " from database"; lDate[x] = dDate.AddDays(x).Date; try { lngCount = rpt.GetDailyCount(dDate.AddDays(x)); } catch { // MessageBox.Show("Error: " + e.Message.ToString(), iLast.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } lock (this) { lCount[x] = lngCount; axMSChart1.Column = 1; axMSChart1.Row = sCount; axMSChart1.RowLabel = dDate.AddDays(x).ToShortDateString(); axMSChart1.Data = lngCount.ToString(); } UpdateStatus(); statusBar1.Text = "Getting Daily Count for " + dDate.AddDays(x).Date.ToString() + " from Watson Server"; #if (FILE_SERVER) for (y = 0; y < 10; y++) { if (regWatson.GetValue("Loc" + y.ToString()).ToString().Length > 0) { strWatson = regWatson.GetValue("Loc" + y.ToString()).ToString(); l_WatsonCount = rpt.GetFileCount(OCAData.ServerLocation.Watson, strWatson, dDate.AddDays(x)); if (l_WatsonCount > 0) { y = 10; } } else { l_WatsonCount = 0; } } //l_WatsonCount = rpt.GetFileCount(OCAData.ServerLocation.Watson, "Z:\\", dDate.AddDays(x)); #elif (FILE_LOCAL) l_WatsonCount = rpt.GetFileCount(OCAData.ServerLocation.Watson, "C:\\MiniDumps\\Watson\\", dDate.AddDays(x)); #endif lock (this) { lWatson[x] = l_WatsonCount; axMSChart1.Column = 2; axMSChart1.Row = sCount; axMSChart1.Data = l_WatsonCount.ToString(); } UpdateStatus(); statusBar1.Text = "Getting Daily Count for " + dDate.AddDays(x).Date.ToString() + " from Archive Server"; #if (FILE_SERVER) try { for (y = 0; y < 10; y++) { if (regArchive.GetValue("Loc" + y.ToString()).ToString().Length > 0) { strArchive = regArchive.GetValue("Loc" + y.ToString()).ToString(); l_ArchiveCount = rpt.GetFileCount(OCAData.ServerLocation.Archive, strArchive, dDate.AddDays(x)); if (l_ArchiveCount > 0) { y = 10; } } else { l_ArchiveCount = 0; } } //l_ArchiveCount = rpt.GetFileCount(OCAData.ServerLocation.Archive, "Y:\\", dDate.AddDays(x)); } catch { l_ArchiveCount = 0; } #elif (FILE_LOCAL) l_ArchiveCount = rpt.GetFileCount(OCAData.ServerLocation.Archive, "C:\\MiniDumps\\Archive\\", dDate.AddDays(x)); #endif // if(l_ArchiveCount == 0) // { //#if(FILE_SERVER) // l_ArchiveCount = rpt.GetFileCount(OCAData.ServerLocation.Archive, "X:\\", dDate.AddDays(x)); //#elif(FILE_LOCAL) // l_ArchiveCount = rpt.GetFileCount(OCAData.ServerLocation.Archive, "C:\\MiniDumps\\Archive\\", dDate.AddDays(x)); //#endif // } lock (this) { lArchive[x] = l_ArchiveCount; axMSChart1.Column = 3; axMSChart1.Row = sCount; axMSChart1.Data = l_ArchiveCount.ToString(); } UpdateStatus(); this.Refresh(); }