public CreateTrendline(List<fPoint> searchMaxMin,string eventType) { EventType = eventType; MaxMin = new List<fPoint>(searchMaxMin.Count); foreach (fPoint a in searchMaxMin) { MaxMin.Add(a); } //MaxMin = searchMaxMin; if (MaxMin.Count >= 2) { //method to find the largest and smallest values fPoint smallest = MaxMin[0], largest = MaxMin[0]; foreach (fPoint f in MaxMin) { if (largest.getX_Age().CompareTo(f.getX_Age()) < 0 && f.getX_Age().CompareTo(1111) != 0) { largest = f; } if (smallest.getX_Age().CompareTo(f.getX_Age()) > 0) { smallest = f; } } decimal x = smallest.getX_Age(); //starting x value decimal range = largest.getX_Age() - smallest.getX_Age(); //range decimal maxRange = range * 50; //the maximum amount of range points decimal delta = (decimal)0.02; //the increment of age //method to set hundreds of values in a list between the Min and Max values //double rangeMM = largest.getX_Age() - smallest.getX_Age(); //double maxRange = rangeMM * 50; //rangeMM = 0.02; Range = new List<fPoint>((int)maxRange); for (int i = 0; i < maxRange; i++) { Range.Add(fPoint.ConstructDefault()); } //double percentValue = smallest.getX_Age() + rangeMM; //Range[0] = smallest; //Range[(int)(maxRange-1)] = largest; //get ABC off the x,y user data. PolynomialGraph pg = new PolynomialGraph(); decimal[] tempABC = pg.Polynomial(MaxMin); for (int i = 0; i < maxRange; i++) { decimal x_val = x; Range[i] = new fPoint(x_val, tempABC[0] * (x_val * x_val) + tempABC[1] * x_val + tempABC[2]); x = x_val + delta; } int p = 0; p++; } }
public void fPointConstructorTest2() { fPoint target = new fPoint(); DateTime dt = new DateTime(2000, 1, 1, 0, 18, 31, 0); Assert.AreEqual(target.getX_Age(), 1111f); Assert.AreEqual(target.getY_Value_AsDate(), dt); }
public void fPointConstructorTest1() { double x = 10F; // TODO: Initialize to an appropriate value double y = 10F; // TODO: Initialize to an appropriate value DateTime dt = new DateTime(2000, 1, 1, 0, 0, 10, 0); fPoint target = new fPoint(x, y); Assert.AreEqual(target.getX_Age(), 10); Assert.AreEqual(target.getY_Value_AsDate(), dt); }
public CreateTrendline(List<fPoint> searchMaxMin) { MaxMin = searchMaxMin; if (MaxMin.Count >= 2) { //method to find the largest and smallest values fPoint smallest = MaxMin[0], largest = MaxMin[0]; foreach (fPoint f in MaxMin) { if (largest.getX_Age().CompareTo(f.getX_Age()) < 0 && f.getX_Age().CompareTo(1111)!=0) { largest = f; } if (smallest.getX_Age().CompareTo(f.getX_Age()) > 0) { smallest = f; } } //method to set hundreds of values in a list between the Min and Max values double rangeMM = largest.getX_Age() - smallest.getX_Age(); double maxRange = rangeMM * 50; rangeMM = 0.02; Range = new List<fPoint>((int)maxRange); for (int i = 0; i < maxRange; i++) { Range.Add(new fPoint()); } double percentValue = smallest.getX_Age()+rangeMM; Range[0] = smallest; Range[(int)(maxRange - 1)] = largest; for (int i = 1; i < maxRange; i++) { Range[i] = new fPoint((float)percentValue, 1111f); percentValue += rangeMM; } //get ABC off the x,y user data. PolynomialGraph pg = new PolynomialGraph(); float[] tempABC = pg.Polynomial(searchMaxMin); //MessageBox.Show(searchMaxMin[2].getX_Age()+""); //MessageBox.Show("A: "+tempABC[0] + " B: " + tempABC[1] + " C: " + tempABC[2]); //use ABC + equation on range to get Y string temp = ""; foreach (fPoint p in Range) { p.setY_Value(tempABC[0] * (p.getX_Age() * p.getX_Age()) + tempABC[1] * p.getX_Age() + tempABC[2]); temp += "\r\n" + p.getX_Age()+ " " + p.getY_Value_AsFloat(); } //MessageBox.Show(temp); //MessageBox.Show(Range.Count()+" "+ Range[Range.Count - 1].getX_Age()); } }
/// <summary> /// adds athletes from the excel sheet to a list within the C# program /// to be used to display lines in the graph /// </summary> private void addValuesToListofAthletes() { excelWrapper1.Workbook.ActiveSheet.Unprotect("1500kosmin"); int rowCount = excelWrapper1.Workbook.ActiveSheet.UsedRange.Rows.Count - 1; Microsoft.Office.Interop.Excel.Range last1 = excelWrapper1.Workbook.ActiveSheet.Cells.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeLastCell, Type.Missing); Microsoft.Office.Interop.Excel.Range range1 = excelWrapper1.Workbook.ActiveSheet.Range("C1", "C" + rowCount); Microsoft.Office.Interop.Excel.Range last2 = excelWrapper1.Workbook.ActiveSheet.Cells.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeLastCell, Type.Missing); Microsoft.Office.Interop.Excel.Range range2 = excelWrapper1.Workbook.ActiveSheet.Range("G1", "G" + rowCount); Microsoft.Office.Interop.Excel.Range last3 = excelWrapper1.Workbook.ActiveSheet.Cells.SpecialCells(Microsoft.Office.Interop.Excel.XlCellType.xlCellTypeLastCell, Type.Missing); Microsoft.Office.Interop.Excel.Range range3 = excelWrapper1.Workbook.ActiveSheet.Range("K1", "K" + rowCount); List<fPoint> temp = new List<fPoint> { fPoint.ConstructDefault(), fPoint.ConstructDefault(), fPoint.ConstructDefault() }; Athletes at = new Athletes(); for (int f = 0; f < 150; f++) { ListOfAthletes.Add(at); } int i = 0;//counter of 3 int j = 2;//counter of rows int k = 0;//counter of Athletes foreach (Microsoft.Office.Interop.Excel.Range r in range1) { if (excelWrapper1.Workbook.ActiveSheet.Range["C" + j].Value.ToString().CompareTo(".") == 0) { j++; } if (excelWrapper1.Workbook.ActiveSheet.Range["C" + j].Value.ToString().CompareTo(".") == 0 || excelWrapper1.Workbook.ActiveSheet.Range["C" + j] == null) { break; } temp[i] = new fPoint((double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["C" + j].Value.ToString()), (double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["D" + j].Value.ToString())); i++; if (i == 3) { ListOfAthletes[k] = new Athletes(excelWrapper1.Workbook.ActiveSheet.Range["A" + j].Value.ToString(), excelWrapper1.Workbook.ActiveSheet.Range["B" + j].Value2.ToString(), temp,PerformanceEG); k++; i = 0; } j++; } i = 0;//counter of 3 j = 2;//counter of rows foreach (Microsoft.Office.Interop.Excel.Range r in range2) { if (excelWrapper1.Workbook.ActiveSheet.Range["G" + j].Value.ToString().CompareTo(".") == 0) { j++; } if (excelWrapper1.Workbook.ActiveSheet.Range["G" + j].Value.ToString().CompareTo(".") == 0 || excelWrapper1.Workbook.ActiveSheet.Range["G" + j] == null) { break; } temp[i] = new fPoint((double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["G" + j].Value.ToString()), (double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["H" + j].Value.ToString())); i++; if (i == 3) { ListOfAthletes[k] = new Athletes(excelWrapper1.Workbook.ActiveSheet.Range["E" + j].Value.ToString(), excelWrapper1.Workbook.ActiveSheet.Range["F" + j].Value2.ToString(), temp, PerformanceEG); k++; i = 0; } j++; } i = 0;//counter of 3 j = 2;//counter of rows foreach (Microsoft.Office.Interop.Excel.Range r in range3) { if (excelWrapper1.Workbook.ActiveSheet.Range["K" + j].Value.ToString().CompareTo(".") == 0) { j++; } if (excelWrapper1.Workbook.ActiveSheet.Range["K" + j].Value.ToString().CompareTo(".") == 0 || excelWrapper1.Workbook.ActiveSheet.Range["K" + j] == null) { break; } temp[i] = new fPoint((double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["K" + j].Value.ToString()), (double)Convert.ToDouble(excelWrapper1.Workbook.ActiveSheet.Range["L" + j].Value.ToString())); i++; if (i == 3) { ListOfAthletes[k] = new Athletes(excelWrapper1.Workbook.ActiveSheet.Range["I" + j].Value.ToString(), excelWrapper1.Workbook.ActiveSheet.Range["J" + j].Value2.ToString(), temp, PerformanceEG); k++; i = 0; } j++; } excelWrapper1.Workbook.ActiveSheet.Protect("1500kosmin", false); }
public void getY_Value_AsDateTest() { fPoint target = new fPoint(13, 71.5f); // TODO: Initialize to an appropriate value DateTime expected = new DateTime(2000, 1, 1, 0, 1, 11, 50); // TODO: Initialize to an appropriate value DateTime actual = target.getY_Value_AsDate(); Assert.AreEqual(expected, actual); }
private void button5_Click(object sender, EventArgs e) { for (int i = 0; i < 44; i++) { dataGridView1.Rows.Add(); } dataGridView1[0, 0].Value = "19.79"; dataGridView1[0, 1].Value = "17.88"; dataGridView1[0, 2].Value = "18.76"; dataGridView1[0, 3].Value = "18.68"; dataGridView1[0, 4].Value = "19.72"; dataGridView1[0, 5].Value = "18.53"; dataGridView1[0, 6].Value = "18.78"; dataGridView1[0, 7].Value = "19.68"; dataGridView1[0, 8].Value = "19.83"; dataGridView1[0, 9].Value = "19.85"; dataGridView1[0, 10].Value = "17.89"; dataGridView1[0, 11].Value = "18.7"; dataGridView1[0, 12].Value = "19.2"; dataGridView1[0, 13].Value = "19.78"; dataGridView1[0, 14].Value = "19.87"; dataGridView1[0, 15].Value = "17.77"; dataGridView1[0, 16].Value = "18.57"; dataGridView1[0, 17].Value = "18.7"; dataGridView1[0, 18].Value = "19.16"; dataGridView1[0, 19].Value = "19.16"; dataGridView1[0, 20].Value = "19.37"; dataGridView1[0, 21].Value = "19.37"; dataGridView1[0, 22].Value = "18.43"; dataGridView1[0, 23].Value = "18.87"; dataGridView1[0, 24].Value = "18.84"; dataGridView1[0, 25].Value = "19.2"; dataGridView1[0, 26].Value = "19.41"; dataGridView1[0, 27].Value = "19.87"; dataGridView1[0, 28].Value = "18.87"; dataGridView1[0, 29].Value = "19.71"; dataGridView1[0, 30].Value = "17.48"; dataGridView1[0, 31].Value = "17.59"; dataGridView1[0, 32].Value = "17.88"; dataGridView1[0, 33].Value = "18.8"; dataGridView1[0, 34].Value = "17.86"; dataGridView1[0, 35].Value = "17.4"; dataGridView1[0, 36].Value = "17.41"; dataGridView1[0, 37].Value = "17.57"; dataGridView1[0, 38].Value = "17.82"; dataGridView1[0, 39].Value = "17.72"; dataGridView1[0, 40].Value = "18.85"; dataGridView1[0, 41].Value = "16.9"; dataGridView1[0, 42].Value = "17.55"; dataGridView1[0, 43].Value = "17.74"; dataGridView1[0, 44].Value = "17.78"; dataGridView1[1, 0].Value = "1.86"; dataGridView1[1, 1].Value = "1.85"; dataGridView1[1, 2].Value = "1.85"; dataGridView1[1, 3].Value = "1.84"; dataGridView1[1, 4].Value = "1.84"; dataGridView1[1, 5].Value = "1.83"; dataGridView1[1, 6].Value = "1.82"; dataGridView1[1, 7].Value = "1.82"; dataGridView1[1, 8].Value = "1.82"; dataGridView1[1, 9].Value = "1.82"; dataGridView1[1, 10].Value = "1.81"; dataGridView1[1, 11].Value = "1.81"; dataGridView1[1, 12].Value = "1.81"; dataGridView1[1, 13].Value = "1.81"; dataGridView1[1, 14].Value = "1.81"; dataGridView1[1, 15].Value = "1.8"; dataGridView1[1, 16].Value = "1.8"; dataGridView1[1, 17].Value = "1.8"; dataGridView1[1, 18].Value = "1.8"; dataGridView1[1, 19].Value = "1.8"; dataGridView1[1, 20].Value = "1.8"; dataGridView1[1, 21].Value = "1.8"; dataGridView1[1, 22].Value = "1.79"; dataGridView1[1, 23].Value = "1.79"; dataGridView1[1, 24].Value = "1.78"; dataGridView1[1, 25].Value = "1.78"; dataGridView1[1, 26].Value = "1.78"; dataGridView1[1, 27].Value = "1.77"; dataGridView1[1, 28].Value = "1.76"; dataGridView1[1, 29].Value = "1.76"; dataGridView1[1, 30].Value = "1.75"; dataGridView1[1, 31].Value = "1.75"; dataGridView1[1, 32].Value = "1.75"; dataGridView1[1, 33].Value = "1.75"; dataGridView1[1, 34].Value = "1.74"; dataGridView1[1, 35].Value = "1.73"; dataGridView1[1, 36].Value = "1.73"; dataGridView1[1, 37].Value = "1.73"; dataGridView1[1, 38].Value = "1.73"; dataGridView1[1, 39].Value = "1.71"; dataGridView1[1, 40].Value = "1.71"; dataGridView1[1, 41].Value = "1.7"; dataGridView1[1, 42].Value = "1.7"; dataGridView1[1, 43].Value = "1.7"; dataGridView1[1, 44].Value = "1.69"; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { float a = (float)Convert.ToDouble(dataGridView1[0, i].Value.ToString()); float b = (float)Convert.ToDouble(dataGridView1[1, i].Value.ToString()); ListOfUserDataPoints[i] = new fPoint(a, b); } dataGridView1[0, 0].Value = "2/26/2011 "; dataGridView1[0, 1].Value = "3/28/2009 "; dataGridView1[0, 2].Value = "2/13/2010 "; dataGridView1[0, 3].Value = "1/16/2010 "; dataGridView1[0, 4].Value = "1/28/2011 "; dataGridView1[0, 5].Value = "11/21/2009"; dataGridView1[0, 6].Value = "2/20/2010 "; dataGridView1[0, 7].Value = "1/15/2011 "; dataGridView1[0, 8].Value = "3/12/2011 "; dataGridView1[0, 9].Value = "3/19/2011 "; dataGridView1[0, 10].Value = "4/3/2009 "; dataGridView1[0, 11].Value = "1/23/2010 "; dataGridView1[0, 12].Value = "7/23/2010 "; dataGridView1[0, 13].Value = "2/19/2011 "; dataGridView1[0, 14].Value = "3/26/2011 "; dataGridView1[0, 15].Value = "2/15/2009 "; dataGridView1[0, 16].Value = "12/5/2009 "; dataGridView1[0, 17].Value = "1/22/2010 "; dataGridView1[0, 18].Value = "7/9/2010 "; dataGridView1[0, 19].Value = "7/10/2010 "; dataGridView1[0, 20].Value = "9/23/2010 "; dataGridView1[0, 21].Value = "9/25/2010 "; dataGridView1[0, 22].Value = "10/15/2009"; dataGridView1[0, 23].Value = "3/27/2010 "; dataGridView1[0, 24].Value = "3/14/2010 "; dataGridView1[0, 25].Value = "7/25/2010 "; dataGridView1[0, 26].Value = "10/10/2010"; dataGridView1[0, 27].Value = "3/25/2011 "; dataGridView1[0, 28].Value = "3/26/2010 "; dataGridView1[0, 29].Value = "1/25/2011 "; dataGridView1[0, 30].Value = "11/1/2008 "; dataGridView1[0, 31].Value = "12/13/2008"; dataGridView1[0, 32].Value = "3/28/2009 "; dataGridView1[0, 33].Value = "2/27/2010 "; dataGridView1[0, 34].Value = "3/21/2009 "; dataGridView1[0, 35].Value = "10/4/2008 "; dataGridView1[0, 36].Value = "10/7/2008 "; dataGridView1[0, 37].Value = "12/6/2008 "; dataGridView1[0, 38].Value = "3/7/2009 "; dataGridView1[0, 39].Value = "1/31/2009 "; dataGridView1[0, 40].Value = "3/18/2010 "; dataGridView1[0, 41].Value = "4/4/2008 "; dataGridView1[0, 42].Value = "11/29/2008"; dataGridView1[0, 43].Value = "2/7/2009 "; dataGridView1[0, 44].Value = "2/20/2009 "; }
private void button4_Click(object sender, EventArgs e) { dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1[0, 0].Value = "16.59"; dataGridView1[0, 1].Value = "21.22"; dataGridView1[0, 2].Value = "25.84"; dataGridView1[1, 0].Value = "1.89"; dataGridView1[1, 1].Value = "1.98"; dataGridView1[1, 2].Value = "2.01"; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { float a = (float)Convert.ToDouble(dataGridView1[0, i].Value.ToString()); float b = (float)Convert.ToDouble(dataGridView1[1, i].Value.ToString()); ListOfUserDataPoints[i] = new fPoint(a, b); } dataGridView1[0, 0].Value = "1/1/2006"; dataGridView1[0, 1].Value = "1/1/2011"; dataGridView1[0, 2].Value = "1/1/2015"; }
private void button3_Click(object sender, EventArgs e) { dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1[0, 0].Value = "15"; dataGridView1[0, 1].Value = "16"; dataGridView1[0, 2].Value = "17"; dataGridView1[0, 3].Value = "18"; dataGridView1[0, 4].Value = "19"; dataGridView1[0, 5].Value = "20"; dataGridView1[0, 6].Value = "21"; dataGridView1[0, 7].Value = "22"; dataGridView1[0, 8].Value = "23"; dataGridView1[0, 9].Value = "24"; dataGridView1[1, 0].Value = "1873"; dataGridView1[1, 1].Value = "1546"; dataGridView1[1, 2].Value = "1359"; dataGridView1[1, 3].Value = "1200"; dataGridView1[1, 4].Value = "547"; dataGridView1[1, 5].Value = "468"; dataGridView1[1, 6].Value = "512"; dataGridView1[1, 7].Value = "983"; dataGridView1[1, 8].Value = "1569"; dataGridView1[1, 9].Value = "1804"; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { float a = (float)Convert.ToDouble(dataGridView1[0, i].Value.ToString()); float b = (float)Convert.ToDouble(dataGridView1[1, i].Value.ToString()); ListOfUserDataPoints[i] = new fPoint(a, b); } dataGridView1[0, 0].Value = "1/1/2005"; dataGridView1[0, 1].Value = "1/1/2006"; dataGridView1[0, 2].Value = "1/1/2007"; dataGridView1[0, 3].Value = "1/1/2008"; dataGridView1[0, 4].Value = "1/1/2009"; dataGridView1[0, 5].Value = "1/1/2010"; dataGridView1[0, 6].Value = "1/1/2011"; dataGridView1[0, 7].Value = "1/1/2012"; dataGridView1[0, 8].Value = "1/1/2013"; dataGridView1[0, 9].Value = "1/1/2014"; }
private void button2_Click(object sender, EventArgs e) { dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1.Rows.Add(); dataGridView1[0, 0].Value = "1"; dataGridView1[0, 1].Value = "2"; dataGridView1[0, 2].Value = "3"; dataGridView1[0, 3].Value = "4"; dataGridView1[1, 0].Value = "1"; dataGridView1[1, 1].Value = "2"; dataGridView1[1, 2].Value = "3"; dataGridView1[1, 3].Value = "4"; for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { float a = (float)Convert.ToDouble(dataGridView1[0, i].Value.ToString()); float b = (float)Convert.ToDouble(dataGridView1[1, i].Value.ToString()); ListOfUserDataPoints[i] = new fPoint(a, b); } dataGridView1[0, 0].Value = "1/1/1991"; dataGridView1[0, 1].Value = "1/1/1992"; dataGridView1[0, 2].Value = "1/1/1993"; dataGridView1[0, 3].Value = "1/1/1994"; }
public void getX_AgeTest() { fPoint target = new fPoint(); // TODO: Initialize to an appropriate value float expected = 1111f; // TODO: Initialize to an appropriate value float actual; actual = target.getX_Age(); Assert.AreEqual(expected, actual); }
public void fPointConstructorTest() { fPoint target = new fPoint(); Assert.AreEqual(target.getX_Age(), 1111f); Assert.AreEqual(target.getY_Value_AsFloat(), 1111f); }
public void setY_ValueTest() { fPoint target = new fPoint(); // TODO: Initialize to an appropriate value float performance = 1230F; // TODO: Initialize to an appropriate value target.setY_Value(performance); Assert.AreEqual(target.getY_Value_AsFloat(), performance); }
public void setX_AgeTest() { fPoint target = new fPoint(); // TODO: Initialize to an appropriate value float date = 120F; // TODO: Initialize to an appropriate value target.setX_Age(date); Assert.AreEqual(target.getX_Age(), date); }
public CreateTrendline(List<fPoint> searchMaxMin,string eventType) { EventType = eventType; MaxMin = new List<fPoint>(searchMaxMin.Count); foreach (fPoint a in searchMaxMin) { MaxMin.Add(a); } //MaxMin = searchMaxMin; if (MaxMin.Count >= 2) { //method to find the largest and smallest values fPoint smallest = MaxMin[0], largest = MaxMin[0]; foreach (fPoint f in MaxMin) { if (largest.getX_Age().CompareTo(f.getX_Age()) < 0 && f.getX_Age().CompareTo(1111) != 0) { largest = f; } if (smallest.getX_Age().CompareTo(f.getX_Age()) > 0) { smallest = f; } } double x = smallest.getX_Age(); //starting x value double range = largest.getX_Age() - smallest.getX_Age(); //range double maxRange = range * 50; //the maximum amount of range points double delta = 0.02f; //the increment of age //method to set hundreds of values in a list between the Min and Max values //double rangeMM = largest.getX_Age() - smallest.getX_Age(); //double maxRange = rangeMM * 50; //rangeMM = 0.02; Range = new List<fPoint>((int)maxRange); for (int i = 0; i < maxRange; i++) { Range.Add(fPoint.ConstructDefault()); } //double percentValue = smallest.getX_Age() + rangeMM; Range[0] = smallest; //Range[(int)(maxRange-1)] = largest; //get ABC off the x,y user data. PolynomialGraph pg = new PolynomialGraph(); double[] tempABC = pg.Polynomial(MaxMin); for (int i = 1; i < maxRange; i++) { double x_val = x; Range[i] = new fPoint(x_val, tempABC[0] * (x_val * x_val) + tempABC[1] * x_val + tempABC[2]); x = x_val + delta; } int p = 0; p++; //MessageBox.Show(searchMaxMin[2].getX_Age()+""); //MessageBox.Show("A: "+tempABC[0] + " B: " + tempABC[1] + " C: " + tempABC[2]); //use ABC + equation on range to get Y //string temp = ""; //foreach (fPoint g in Range) //{ // temp += g.getX_Age() + " " + g.getY_Value_AsDate().Minute + ":" + g.getY_Value_AsDate().Second + "." + g.getY_Value_AsDate().Millisecond + "\r\n"; //} //MessageBox.Show(temp); } }