private void ShowProfit()
{
excelworksheet = (Worksheet)excelapp.Worksheets.get_Item(2);
var year = DateTime.Now.Year;
for (int m = 2; m < 13; m++)
{
var date1 = new DateTime(year, m - 1, 1);
var date2 = new DateTime(year, m, 1);
var excelcells = (Range)excelworksheet.Cells[m, 1];
//выводим координаты ячеек
excelcells.Value2 = date2.ToShortDateString();
excelcells = (Range)excelworksheet.Cells[m, 2];
excelcells.Value2 = _ctrl.GetB().Where(x => x.DateStart <date2 && x.DateStart> date1).Select(x => x.Car.Price * (x.DateFinish - x.DateStart).Days).Sum();
}
}
private void ReloadProfits(object sender = null, EventArgs e = null)
{
if (_books != null)
{
if (dateTimePicker2.Value < dateTimePicker1.Value)
{
var t = dateTimePicker2.Value;
dateTimePicker2.Value = dateTimePicker1.Value;
dateTimePicker1.Value = t;
}
_profits = _books.FindAll(x => x.DateStart <dateTimePicker2.Value && x.DateStart> dateTimePicker1.Value).Select(x => new Profit {
Id = x.BookId, ClientName = x.User.Name, DateFinish = x.DateFinish, DateStart = x.DateStart, Model = x.Car.Model, Sum = x.Car.Price * (x.DateFinish - x.DateStart).Days
}).ToList();
profitBindingSource.DataSource = _profits;
label3.Text = _ctrl.GetB().Where(x => x.DateStart <dateTimePicker2.Value && x.DateStart> dateTimePicker1.Value).Select(x => x.Car.Price * (x.DateFinish - x.DateStart).Days).Sum().ToString();
}
}
