/// <summary>
/// история статусов
/// </summary>
private void CreateOrderStatusHisotyWorksheet()
{
OrderStatusList = OrderFunction.GetAllHistoryStatus();
// шапка
OrderStatusHisotyWorksheet.Cells[1, 1].Value = "Номер заказа";
OrderStatusHisotyWorksheet.Cells[1, 2].Value = "Дата";
OrderStatusHisotyWorksheet.Cells[1, 3].Value = "Статус";
OrderStatusHisotyWorksheet.Cells[1, 4].Value = "Комментарий";
OrderStatusHisotyWorksheet.Cells[1, 5].Value = "Пользователь";
int row = 2;
foreach (var status in OrderStatusList)
{
//номер заказа
OrderStatusHisotyWorksheet.Cells[row, 1].Value = status.Orders.FirstOrDefault().Number;
//дата
OrderStatusHisotyWorksheet.Cells[row, 2].Value = status.Timestamp.ToString();
//Статус
OrderStatusHisotyWorksheet.Cells[row, 3].Value = status.Status.Name;
//коммент
OrderStatusHisotyWorksheet.Cells[row, 4].Value = status.Text;
//пользователь
OrderStatusHisotyWorksheet.Cells[row, 5].Value = status.Follower.FirstName + " " + status.Follower.LastName;
row++;
}
}