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(); } }