Notes

using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using MigraDoc.DocumentObjectModel;
using MigraDoc.Rendering;
using PdfSharpCore.Pdf;
using System.IO;
using System.Threading.Tasks;
using YourNamespace.Models;
using YourNamespace.Services;

namespace YourNamespace.Controllers
{
public class CommissionController : Controller
{
private readonly ICommissionService _commissionService;

public CommissionController(ICommissionService commissionService)
{
_commissionService = commissionService;
}

[HttpPost]
[Authorize]
public async Task<IActionResult> GeneratePdfOfEber(string startDate, string endDate)
{
string managerId = "2275221";
var model = await _commissionService.GetHourlyCommissionForAccountManagersAsync(startDate, endDate, managerId);

// Create a new PDF document
Document document = new Document();
Section section = document.AddSection();

// Add a title
Paragraph paragraph = section.AddParagraph("Commission Report");
paragraph.Format.FontSize = 18;
paragraph.Format.FontBold = true;
paragraph.Format.SpaceAfter = "1cm";
paragraph.Format.Alignment = ParagraphAlignment.Center;

// Create a table
Table table = section.AddTable();
table.Borders.Width = 0.25;
table.Borders.Color = Colors.Black;

// Define columns
Column column = table.AddColumn("2cm");
column.Format.Alignment = ParagraphAlignment.Center;
table.AddColumn("4cm");
table.AddColumn("4cm");
table.AddColumn("4cm");
table.AddColumn("4cm");
table.AddColumn("4cm");

// Create the header row
Row row = table.AddRow();
row.Cells[0].AddParagraph("S.No.");
row.Cells[1].AddParagraph("Customer");
row.Cells[2].AddParagraph("ITEM");
row.Cells[3].AddParagraph("Margen");
row.Cells[4].AddParagraph("Coef. 5%");
row.Cells[5].AddParagraph("Eber");
row.Format.FontBold = true;
row.Shading.Color = Colors.Gray;

// Fill the table with data
int srNo = 1;
if (model.CommissionModelListForHourlyEmployee != null)
{
foreach (var item in model.CommissionModelListForHourlyEmployee)
{
row = table.AddRow();
row.Cells[0].AddParagraph(srNo.ToString());
row.Cells[1].AddParagraph(item.Customer);
row.Cells[2].AddParagraph(item.ITEM);
row.Cells[3].AddParagraph(item.Margen);
row.Cells[4].AddParagraph(item.Coeff5Percent);
row.Cells[5].AddParagraph(item.Eber);
srNo++;
}
}

// Render the PDF document
PdfDocumentRenderer pdfRenderer = new PdfDocumentRenderer(false)
{
Document = document
};
pdfRenderer.RenderDocument();

// Save the PDF document to a MemoryStream
using (var memoryStream = new MemoryStream())
{
pdfRenderer.PdfDocument.Save(memoryStream);
return File(memoryStream.ToArray(), "application/pdf", "Table.pdf");
}
}
}
}

$(document).on("click", "#GeneratePDFOfEber", function () {
var hoursStartDate = $("#HoursStartDateForCommission").val();
var hoursEndDate = $("#HoursEndDateForCommission").val();
$(".openPopupForHourlyCommissionOfManagers").modal("hide");
$('.spinner').css('display', 'block');
$.ajax({
url: "/Commission/GeneratePdfOfEber",
type: 'POST',
contentType: 'application/json; charset=utf-8',
data: JSON.stringify({ startDate: hoursStartDate, endDate: hoursEndDate }),
success: function (response) {
var blob = new Blob([response], { type: 'application/pdf' });
var link = document.createElement('a');
link.href = window.URL.createObjectURL(blob);
link.download = 'Table.pdf';
link.click();
$('.spinner').css('display', 'none');
},
error: function () {
$('.spinner').css('display', 'none');
}
});
});