public async Task <IActionResult> Edit(int?id, [Bind("Id,Task_Name,Task_Detail,Date_Open,Date_Close,ZadachiParentId,StatusId")] Zadachi zadachi)
{
if (id != zadachi.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(zadachi);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ZadachiExists(zadachi.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["StatusId"] = new SelectList(_context.Statuses, "Id", "Status_name", zadachi.StatusId);
ViewData["ZadachiParentId"] = new SelectList(_context.Zadachis, "Id", "View", zadachi.ZadachiParentId);
return(View(zadachi));
}
public async Task <IActionResult> Create([Bind("Task_Name,Task_Detail,Date_Open,Date_Close,ZadachiParentId,StatusId")] Zadachi zadachi)
{
_context.Statuses.Load();
if (ModelState.IsValid)
{
_context.Add(zadachi);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StatusId"] = new SelectList(_context.Statuses, "Id", "Status_name", zadachi.StatusId);
ViewData["ZadachiParentId"] = new SelectList(_context.Zadachis, "Id", "View", zadachi.ZadachiParentId);
return(View(zadachi));
}
// Тут вывод в файл
public IActionResult Export(Zadachi zadachi)
{
using (var workbook = new XLWorkbook())
{
_context.Statuses.Load();
var worksheet = workbook.Worksheets.Add("Zadachi");
var currentRow = 1;
#region Header
worksheet.ColumnWidth = 30;
worksheet.Range("A1:F1").Style.Font.Bold = true;
worksheet.Range("A1:F1").Style.Fill.BackgroundColor = XLColor.Yellow;
worksheet.Range("A1:F100").Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
worksheet.Cell(currentRow, 1).Value = "Название задачи";
worksheet.Cell(currentRow, 2).Value = "Описание задачи";
worksheet.Cell(currentRow, 3).Value = "Дата открытия";
worksheet.Cell(currentRow, 4).Value = "Дата закрытия";
worksheet.Cell(currentRow, 5).Value = "Главная задача";
worksheet.Cell(currentRow, 6).Value = "Статус";
#endregion
#region Body
foreach (var zadachii in _context.Zadachis.Where(e => e.Status.Status_name == "Завершен").ToList())
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = zadachii.Task_Name;
worksheet.Cell(currentRow, 2).Value = zadachii.Task_Detail;
worksheet.Cell(currentRow, 3).Value = zadachii.Date_Open;
worksheet.Cell(currentRow, 4).Value = zadachii.Date_Close;
worksheet.Cell(currentRow, 5).Value = zadachii.ZadachiParent?.Task_Name;
worksheet.Cell(currentRow, 6).Value = zadachii.Status.Status_name;
}
#endregion
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(
content,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"Zadachi.xlsx"
));
}
}
}
