public static void MyClassInitialize(TestContext testContext) { List<fPoint> pt = new List<fPoint>() { new fPoint(12, 2), new fPoint(13, 3), new fPoint((decimal)13.5, 3), new fPoint((decimal)14.44, 4), new fPoint(15, 5) }; target = new Athletes("Name", "Medal", pt,"default"); // TODO: Initialize to an appropriate value }
/// <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 static void MyClassInitialize(TestContext testContext) { List<fPoint> pt = new List<fPoint>() { new fPoint(12f, 2), new fPoint(13f, 3), new fPoint(13.5f, 3), new fPoint(14.44f, 4), new fPoint(15f, 5) }; target = new Athletes("Name","Medal",pt); // TODO: Initialize to an appropriate value }