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
}
