private double GetCarMark(int CarId)
{
var rr = _ctrl.GetCarMarks(CarId);
if (rr.Count > 0)
{
return(rr.Average());
}
else
{
return(0);
}
}
private void ShowRating()
{
excelworksheet = (Worksheet)excelapp.Worksheets.get_Item(3);
var cars = _ctrl.GetCars();
for (int m = 0; m < cars.Count; m++)
{
var excelcells = (Range)excelworksheet.Cells[m + 2, 1];
//выводим координаты ячеек
excelcells.Value2 = cars[m].Model;
excelcells = (Range)excelworksheet.Cells[m + 2, 2];
var marks = _ctrl.GetCarMarks(cars[m].CarId);
if (marks.Count > 0)
{
excelcells.Value2 = marks.Average();
}
else
{
excelcells.Value2 = 0;
}
}
}
