public IActionResult Export()
{
var exportReportViewModel = new ExportReportViewModel
{
ListofReportType = ReportTypeList(),
ListofReports = ReportsList()
};
return(View(exportReportViewModel));
}
public IActionResult Export(ExportReportViewModel exportReportViewModel)
{
if (ModelState.IsValid)
{
if (exportReportViewModel.ReportsId == 1 && exportReportViewModel.ReportTypeId == 1)
{
var results = _excelGenerator.SummaryDownloadReport(exportReportViewModel.Fromdate,
exportReportViewModel.Todate);
return(File(results.ExcelBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", results.ExcelName));
}
if (exportReportViewModel.ReportsId == 1 && exportReportViewModel.ReportTypeId == 2)
{
var results = _excelGenerator.DetailsDownloadReport(exportReportViewModel.Fromdate,
exportReportViewModel.Todate);
return(File(results.ExcelBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", results.ExcelName));
}
}
exportReportViewModel.ListofReportType = ReportTypeList();
exportReportViewModel.ListofReports = ReportsList();
return(View(exportReportViewModel));
}
public IActionResult PrintReport([FromBody] ExportReportViewModel model)
{
var electronicBook = _context.ElectronicBooks
.Include(x => x.User)
.Include(x => x.ElectronicBookFiles)
.Where(x => x.Id == model.electronicBookId)
.FirstOrDefault();
System.Console.WriteLine("in printtttt");
if (!Directory.Exists(_environment.WebRootPath + "//Uploads//"))
{
Directory.CreateDirectory(_environment.WebRootPath + "//Uploads//"); //สร้าง Folder Upload ใน wwwroot
}
var filePath = _environment.WebRootPath + "/Uploads/";
var filePath2 = _environment.WebRootPath + "/Signature/";
var filename = "สมุดตรวจราชการอิเล็กทรอนิกส์" + DateTime.Now.ToString("dd MM yyyy") + ".docx";
var createfile = filePath + filename;
var myImageFullPath = filePath + "logo01.png";
System.Console.WriteLine("3");
System.Console.WriteLine("in create");
using (DocX document = DocX.Create(createfile))
{
Image image = document.AddImage(myImageFullPath);
Picture picture = image.CreatePicture(85, 85);
var logo = document.InsertParagraph();
logo.AppendPicture(picture).Alignment = Alignment.center;
document.SetDefaultFont(new Xceed.Document.NET.Font("ThSarabunNew"));
document.AddHeaders();
document.AddFooters();
// Force the first page to have a different Header and Footer.
document.DifferentFirstPage = true;
// Force odd & even pages to have different Headers and Footers.
document.DifferentOddAndEvenPages = true;
// Insert a Paragraph into the first Header.
document.Footers.First.InsertParagraph("วันที่ออกรายงาน: ").Append(DateTime.Now.ToString("dd MMMM yyyy HH:mm", new CultureInfo("th-TH"))).Append(" น.").Alignment = Alignment.right;
// Insert a Paragraph into the even Header.
document.Footers.Even.InsertParagraph("วันที่ออกรายงาน: ").Append(DateTime.Now.ToString("dd MMMM yyyy HH:mm", new CultureInfo("th-TH"))).Append(" น.").Alignment = Alignment.right;
// Insert a Paragraph into the odd Header.
document.Footers.Odd.InsertParagraph("วันที่ออกรายงาน: ").Append(DateTime.Now.ToString("dd MMMM yyyy HH:mm", new CultureInfo("th-TH"))).Append(" น.").Alignment = Alignment.right;
// Add the page number in the first Footer.
document.Headers.First.InsertParagraph("").AppendPageNumber(PageNumberFormat.normal).Alignment = Alignment.center;
// Add the page number in the even Footers.
document.Headers.Even.InsertParagraph("").AppendPageNumber(PageNumberFormat.normal).Alignment = Alignment.center;
// Add the page number in the odd Footers.
document.Headers.Odd.InsertParagraph("").AppendPageNumber(PageNumberFormat.normal).Alignment = Alignment.center;
System.Console.WriteLine("5");
// Add a title
var reportType = document.InsertParagraph("สมุดตรวจราชการอิเล็กทรอนิกส์");
reportType.FontSize(18d);
reportType.SpacingBefore(15d);
reportType.SpacingAfter(5d);
reportType.Bold();
reportType.Alignment = Alignment.center;
System.Console.WriteLine("6");
Thread.CurrentThread.CurrentCulture = new CultureInfo("th-TH");
var testDate = electronicBook.StartDate.Value.ToString("dddd dd MMMM yyyy");
var printDate = DateTime.Now.ToString("dd MMMM yyyy");
// Insert a title paragraph.
var title = document.InsertParagraph("วันที่ตรวจราชการ: " + testDate);
title.Alignment = Alignment.center;
title.SpacingAfter(15d);
title.FontSize(16d);
title.Bold();
//var printReport = document.InsertParagraph("วันที่ออกรายงาน: " + printDate);
//printReport.Alignment = Alignment.center;
//printReport.SpacingAfter(25d);
//printReport.FontSize(16d);
//printReport.Bold();
System.Console.WriteLine("7");
//var year = document.InsertParagraph("ตรวจ ณ สถานที่: ");
//year.Alignment = Alignment.center;
//year.SpacingAfter(10d);
//year.FontSize(16d);
//System.Console.WriteLine("8");
var subjectTitle = document.InsertParagraph("เรื่อง/ประเด็น/โครงการที่ตรวจติดตาม");
subjectTitle.Alignment = Alignment.left;
//subjectTitle.SpacingAfter(10d);
subjectTitle.FontSize(16d);
subjectTitle.Bold();
System.Console.WriteLine("8");
var subject = document.InsertParagraph("");
int s = 0;
for (var i = 0; i < model.subjectData.Length; i++)
{
s += 1;
subject.FontSize(16d).Append(s.ToString()).Append(") ").Append(model.subjectData[i] + "\n").FontSize(16d);
}
var detailTitle = document.InsertParagraph("ผลการตรวจ");
detailTitle.SpacingBefore(10d);
detailTitle.FontSize(16d);
detailTitle.Bold();
var detail = document.InsertParagraph(electronicBook.Detail);
detail.SpacingBefore(5d);
detail.FontSize(16d);
// detail.UnderlineColor(Color.Black);
// detail.UnderlineStyle(UnderlineStyle.dotted);
var suggestionTitle = document.InsertParagraph("ปัญหาและอุปสรรค");
suggestionTitle.SpacingBefore(15d);
suggestionTitle.FontSize(16d);
suggestionTitle.Bold();
var suggestion = document.InsertParagraph(electronicBook.Problem);
suggestion.SpacingBefore(5d);
suggestion.FontSize(16d);
// suggestion.UnderlineColor(Color.Black);
// suggestion.UnderlineStyle(UnderlineStyle.dotted);
var commandTitle = document.InsertParagraph("ข้อเสนอแนะ");
commandTitle.SpacingBefore(15d);
commandTitle.FontSize(16d);
commandTitle.Bold();
var command = document.InsertParagraph(electronicBook.Suggestion);
command.SpacingBefore(5d);
command.FontSize(16d);
// command.UnderlineColor(Color.Black);
// command.UnderlineStyle(UnderlineStyle.dotted);
//command.InsertPageBreakAfterSelf();
System.Console.WriteLine("11");
//System.Console.WriteLine("9");
//var region = document.InsertParagraph("เขตตรวจราชการที่: " + model.reportData2[i].region + "(จังหวัด: " + model.reportData2[i].province + ")");
//region.Alignment = Alignment.center;
//region.SpacingAfter(30d);
//region.FontSize(16d);
//var statusReport = document.InsertParagraph("สถานะของรายงาน: " + exportData.Status);
//statusReport.FontSize(16d);
//statusReport.Alignment = Alignment.right;
//var monitorTopic = document.InsertParagraph("หัวข้อการตรวจติดตาม: " + exportData.MonitoringTopics);
//monitorTopic.SpacingBefore(15d);
//monitorTopic.FontSize(16d);
//monitorTopic.Bold();
//System.Console.WriteLine("99");
var inspectorTitle = document.InsertParagraph("คำแนะนำผู้ตรวจราชการ");
inspectorTitle.SpacingBefore(30d);
inspectorTitle.SpacingAfter(5d);
inspectorTitle.FontSize(16d);
inspectorTitle.Bold();
int dataCount = 0;
dataCount = model.printReport.Count();
dataCount += 1;
System.Console.WriteLine("Data Count: " + dataCount);
// Add a table in a document of 1 row and 3 columns.
var columnWidths = new float[] { 40f, 250f, 90f, 120f, };
var t = document.InsertTable(dataCount, columnWidths.Length);
//System.Console.WriteLine("8");
//// Set the table's column width and background
t.SetWidths(columnWidths);
t.AutoFit = AutoFit.Contents;
t.Alignment = Alignment.center;
var row = t.Rows.First();
//System.Console.WriteLine("9");
// Fill in the columns of the first row in the table.
//for (int i = 0; i < row.Cells.Count; ++i)
//{
row.Cells[0].Paragraphs.First().Append("ลำดับ").FontSize(16d).Alignment = Alignment.center;
row.Cells[1].Paragraphs.First().Append("คำแนะนำหรือสั่งการของผู้ตรวจ").FontSize(16d).Alignment = Alignment.center;
row.Cells[2].Paragraphs.First().Append("ความเห็นผู้ตรวจ").FontSize(16d).Alignment = Alignment.center;
row.Cells[3].Paragraphs.First().Append("ลายมือชื่อผู้ตรวจ").FontSize(16d).Alignment = Alignment.center;
System.Console.WriteLine("10");
//}
// Add rows in the table.
int j = 0;
for (int k = 0; k < model.printReport.Length; k++)
{
j += 1;
System.Console.WriteLine("10.1");
System.Console.WriteLine("9.1: " + model.printReport[k].inspectorDescription);
t.Rows[j].Cells[0].Paragraphs[0].Append(j.ToString()).FontSize(16d).Alignment = Alignment.center;
t.Rows[j].Cells[1].Paragraphs[0].Append(model.printReport[k].inspectorDescription).FontSize(16d);
t.Rows[j].Cells[2].Paragraphs[0].Append(model.printReport[k].approve).FontSize(16d);
if (model.printReport[k].inspectorSign != null && model.printReport[k].inspectorSign != "null" && model.printReport[k].inspectorSign != "")
{
System.Console.WriteLine("9.3: " + model.printReport[k].inspectorSign);
var myImageFullPath2 = filePath2 + model.printReport[k].inspectorSign;
Image image2 = document.AddImage(myImageFullPath2);
System.Console.WriteLine("JJJJJ: ");
Picture picture2 = image2.CreatePicture(30, 30);
t.Rows[j].Cells[3].Paragraphs[0].AppendPicture(picture2).SpacingBefore(3d).Append("\n" + model.printReport[k].inspectorName).FontSize(16d).Alignment = Alignment.center;
}
else
{
System.Console.WriteLine("9.4: ");
t.Rows[j].Cells[3].Paragraphs[0].Append(model.printReport[k].inspectorName).FontSize(16d).Alignment = Alignment.center;
}
System.Console.WriteLine("10");
}
// Set a blank border for the table's top/bottom borders.
var blankBorder = new Border(BorderStyle.Tcbs_none, 0, 0, Color.White);
//t.SetBorder(TableBorderType.Bottom, blankBorder);
//t.SetBorder(TableBorderType.Top, blankBorder);
// document.InsertSectionPageBreak();
System.Console.WriteLine("IN DEPARTMENT");
var departmentTitle = document.InsertParagraph("การดำเนินการของหน่วยรับตรวจ");
departmentTitle.SpacingBefore(30d);
departmentTitle.SpacingAfter(5d);
departmentTitle.FontSize(16d);
departmentTitle.Bold();
System.Console.WriteLine("IN DEPARTMENT2");
int dataCount2 = 0;
dataCount2 = model.printReport2.Count();
dataCount2 += 1;
System.Console.WriteLine("Data Count department: " + dataCount2);
// Add a table in a document of 1 row and 3 columns.
var columnWidths2 = new float[] { 40f, 250f, 80f, 120f, };
var t2 = document.InsertTable(dataCount2, columnWidths2.Length);
//System.Console.WriteLine("8");
//// Set the table's column width and background
t2.SetWidths(columnWidths2);
t2.AutoFit = AutoFit.Contents;
t2.Alignment = Alignment.center;
var row2 = t2.Rows.First();
//System.Console.WriteLine("9");
// Fill in the columns of the first row in the table.
//for (int i = 0; i < row.Cells.Count; ++i)
//{
row2.Cells[0].Paragraphs.First().Append("ลำดับ").FontSize(16d).Alignment = Alignment.center;
row2.Cells[1].Paragraphs.First().Append("การดำเนินการของหน่วยรับตรวจ").FontSize(16d).Alignment = Alignment.center;
row2.Cells[2].Paragraphs.First().Append("หน่วยรับตรวจ").FontSize(16d).Alignment = Alignment.center;
row2.Cells[3].Paragraphs.First().Append("ลายมือชื่อผู้รับตรวจ").FontSize(16d).Alignment = Alignment.center;
System.Console.WriteLine("10");
//}
// Add rows in the table.
int j2 = 0;
for (int k = 0; k < model.printReport2.Length; k++)
{
j2 += 1;
t2.Rows[j2].Cells[0].Paragraphs[0].Append(j2.ToString()).FontSize(16d).Alignment = Alignment.center;
t2.Rows[j2].Cells[1].Paragraphs[0].Append(model.printReport2[k].departmentDescription).FontSize(16d);
t2.Rows[j2].Cells[2].Paragraphs[0].Append(model.printReport2[k].department).FontSize(16d);
if (model.printReport2[k].departmentSign != null && model.printReport2[k].departmentSign != "null" && model.printReport2[k].departmentSign != "")
{
var myImageFullPath3 = filePath2 + model.printReport2[k].departmentSign;
Image image3 = document.AddImage(myImageFullPath3);
System.Console.WriteLine("JJJJJ: ");
Picture picture2 = image3.CreatePicture(30, 30);
t2.Rows[j2].Cells[3].Paragraphs[0].AppendPicture(picture2).SpacingBefore(3d).Append("\n" + model.printReport2[k].departmentName).FontSize(16d).Alignment = Alignment.center;
}
else
{
t2.Rows[j2].Cells[3].Paragraphs[0].Append(model.printReport2[k].departmentName).FontSize(16d);
}
System.Console.WriteLine("10");
}
// Set a blank border for the table's top/bottom borders.
var blankBorder2 = new Border(BorderStyle.Tcbs_none, 0, 0, Color.White);
document.Save();
Console.WriteLine("\tCreated: InsertHorizontalLine.docx\n");
}
return(Ok(new { data = filename }));
}
