public IHttpActionResult UploadTemplate([FromUri] int shipOrderId, [FromUri] string operation)
{
var fileGetter = new FilesGetter();
var path = fileGetter.GetAndSaveSingleFileFromHttpRequest(@"D:\TempFiles\");
if (path == "")
{
throw new HttpResponseException(HttpStatusCode.BadRequest);
}
var extracter = new FBAExcelExtracter(path);
if (operation == FBAOperation.UploadBOL)
{
var bolDetailList = extracter.ExtractBOLTemplate();
var generator = new PDFGenerator();
var fileName = generator.GenerateFBABOL(shipOrderId, bolDetailList);
return(Ok(fileName));
}
else if (operation == FBAOperation.UploadShipOrder)
{
extracter.ExtractFBAPickingListTemplate(shipOrderId);
return(Ok("Create success!"));
}
return(Ok());
}
private void button3_Click(object sender, EventArgs e)
{
Zapisz();
var pdfGenerator = new PDFGenerator();
pdfGenerator.Generate(_zakup, _person);
}
public ActionResult GenerateVisitSchedule()
{
var visits = _context.Visits.OrderBy(x => x.Date).ToList();
var pdf = new PDFGenerator
{
ForegroundColor = "#0000CC",
BackgroundColor = "#FFFFFF",
Surgeries = visits.First().Surgeries.ToList(),
Visits = visits
};
var a = System.AppDomain.CurrentDomain.BaseDirectory;
var sb = new StringBuilder();
sb.Append(DateTime.Now);
sb.Append("-Harmonogram");
var fileName = sb.ToString().Replace(" ", "_").Replace(".", "").Replace(":", "");
var fileStream = new FileStream($"{a}/Files/{fileName}.pdf", FileMode.Create);
pdf.Save(fileStream);
fileStream.Close();
EmailSender.SendVisitsSchedule($"{a}/Files/{fileName}.pdf");
return(RedirectToAction("Index", "Home"));
}
public static void CheckPendingOrders()
{
foreach (string path in Directory.GetFiles(_pendingPath))
{
string orderNumber = Path.GetFileName(path).Substring(0, 6);
if (IsOrderInvoiced(orderNumber))
{
if (!Directory.Exists(_archivePath + orderNumber))
{
Directory.CreateDirectory(_archivePath + orderNumber);
}
Log.Append(String.Format("Order {0} has been invoiced. Creating order & invoice and copying drawing files to archive...", orderNumber));
PDFGenerator pdfObject = new PDFGenerator();
pdfObject.GenerateOrder(_archivePath + orderNumber, orderNumber);
pdfObject.GenerateInvoice(_archivePath + orderNumber, orderNumber);
CopyDrawings(orderNumber);
Log.Append(String.Format("Order {0} has been archived", orderNumber));
while (File.Exists(path))
{
try
{
File.Delete(path);
}
catch
{
}
}
}
}
}
private void button12_Click_1(object sender, EventArgs e)
{
string msg = ra.UserQuery();
PDFGenerator pg = new PDFGenerator(DateTime.Now.ToString() + " User Report: \n " + msg);
MessageBox.Show("A report has been generated. you can see the PDF file in Reports directory.");
}
public IActionResult GetPDFById([FromRoute] int id)
{
try
{
VerifyUser();
var model = _service.Read(id);
if (model == null)
{
var result = new ResultFormatter(ApiVersion, General.NOT_FOUND_STATUS_CODE, General.NOT_FOUND_MESSAGE)
.Fail();
return(NotFound(result));
}
else
{
var stream = PDFGenerator.Generate(model, _identityService.Username, _identityService.TimezoneOffset);
return(new FileStreamResult(stream, "application/pdf")
{
FileDownloadName = "Bukti Memorial.pdf"
});
}
}
catch (Exception e)
{
var result = new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, result));
}
}
public async Task<IActionResult> Resume()
{
var user = await _userManager.GetCurrentUser(HttpContext);
ProfileViewModal pVM = new ProfileViewModal();
//Personal Details
pVM.UserPersonalVM = _context.UserPersonalDetail.Where(m => m.UserId == user.Id).Select(x => new UserPersonalViewModel { FirstName = x.FirstName, LastName = x.LastName, Summary = x.Summary, DOB = x.DOB, UserPersonalDetailID = x.UserPersonalDetailId, Gender = x.Gender, CityName = x.City.CityName, CountryName = x.City.Country.CountryName }).SingleOrDefault();
pVM.UserPersonalVM.PhoneNo = user.PhoneNumber;
pVM.UserPersonalVM.Email = user.Email;
//Education
pVM.EduVMList = _context.UserEducation.Where(x => x.UserId == user.Id).Select(c => new EducationVM { Title = c.Title, Details = c.Details, SchoolName = c.SchoolName, StartDate = c.StartDate, EndDate = c.EndDate, CurrentStatusCheck = c.CurrentStatusCheck, CityId = c.CityId, CityName = c.City.CityName, CountryName = c.City.Country.CountryName, UserEducationID = c.UserEducationId }).ToList();
pVM.ExpVMList = _context.UserExperience.Where(x => x.UserId == user.Id).Select(c => new ExperienceVM { Title = c.Title, UserExperienceId = c.UserExperienceId, CityId = c.CityID, CityName = c.City.CityName, CountryName = c.City.Country.CountryName, CompanyName = c.CompanyName, CurrentWorkCheck = c.CurrentWorkCheck, Description = c.Description, StartDate = c.StartDate, EndDate = c.EndDate }).ToList();
//Get Object from parameter and generate Resume
//university = new University();
//university.Name = "CUST";
//university.Chancler = "Amir";
//university.PublishedDate = new DateTime(1990, 08, 08);
//university.City = "Islamabad";
//university.Country = "Pakistan";
//university.Students = GetStudents();
//university.Address = "Kahota Road";
PDFGenerator userPDF = new PDFGenerator(pVM);
byte[] abytes = userPDF.PrepareReport();
return File(abytes, "application/pdf");
}
public void OnGeneratePDF()
{
PDFGenerator pdfGenerator = new PDFGenerator();
Request selectedRequest = GetSelectedRequest();
pdfGenerator.PDFGenerate(selectedRequest);
}
/// <summary>
/// Get Export data from and build the export binary/objct.
/// </summary>
/// <param name="strFormat">(string) Export format</param>
/// <param name="stream">(string) Export image data in FusionCharts compressed format</param>
/// <param name="meta">{Hastable)Image meta data in keys "width", "heigth" and "bgColor"</param>
/// <returns></returns>
private MemoryStream exportProcessor(string strFormat, string stream, Hashtable meta)
{
strFormat = strFormat.ToLower();
// initilize memeory stream object to store output bytes
var exportObjectStream = new MemoryStream();
// Handle Export class as per export format
switch (strFormat)
{
case "pdf":
// Instantiate Export class for PDF, build Binary stream and store in stream object
var PDFGEN = new PDFGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportObjectStream = PDFGEN.getBinaryStream(strFormat);
break;
case "jpg":
case "jpeg":
case "png":
case "gif":
// Instantiate Export class for Images, build Binary stream and store in stream object
var IMGGEN = new ImageGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportObjectStream = IMGGEN.getBinaryStream(strFormat);
break;
default:
// In case the format is not recognized
raise_error(" Invalid Export Format.", true);
break;
}
return(exportObjectStream);
}
private void OnPdfClick(User userSelected)
{
var fbd = new FolderBrowserDialog();
DialogResult result = fbd.ShowDialog();
PDFGenerator.generate(userSelected, fbd.SelectedPath);
}
public void OnGeneratePDF()
{
PDFGenerator pdfGenerator = new PDFGenerator();
Request selectedRequest = GetSelectedRequest();
pdfGenerator.PDFGenerate(selectedRequest);
}
public IHttpActionResult Print([FromUri] int id)
{
var generator = new PDFGenerator();
generator.GeneratePickDetailPdf(id);
return(Ok());
}
public IActionResult CreatePDF(EventTypes eventType, DateTime from, DateTime to)
{
if (from == null)
{
from = DateTime.MinValue;
}
if (to == DateTime.MinValue)
{
to = DateTime.Now;
}
PDFGenerator pdfGenerator = new PDFGenerator();
switch (eventType)
{
case EventTypes.Dezynfekcja:
pdfGenerator.AddEvents <EventDezynfekcja>(
_context.EventsDezynfekcja.Where(x => x.DataZabiegu >= from && x.DataZabiegu <= to).ToList()
);
break;
case EventTypes.RejestrTransportu:
pdfGenerator.AddEvents <EventRejestrTransportu>(
_context.EventsRejestrTransportu.Where(x => x.DataIGodzinaWjazdu >= from && x.DataIGodzinaWjazdu <= to).ToList()
);
break;
case EventTypes.RejestrWejscWyjsc:
pdfGenerator.AddEvents <EventRejestrWejscWyjsc>(
_context.EventsRejestrWejscWyjsc.Where(x => x.DataIGodzinaWejścia >= from && x.DataIGodzinaWejścia <= to).ToList()
);
break;
case EventTypes.PrzegladZabezpieczen:
pdfGenerator.AddEvents <EventPrzegladZabezpieczen>(
_context.EventsPrzegladZabezpieczen.Where(x => x.DataPrzegladu >= from && x.DataPrzegladu <= to).ToList()
);
break;
case EventTypes.SpisZwierzat:
pdfGenerator.AddEvents <EventSpisZwierzat>(
_context.EventsSpisZwierzat.Where(x => x.DataSpisu >= from && x.DataSpisu <= to).ToList()
);
break;
default:
pdfGenerator.AddEvents <EventDezynfekcja>(
_context.EventsDezynfekcja.Where(x => x.DataZabiegu >= from && x.DataZabiegu <= to).ToList()
);
break;
}
_converter.Convert(pdfGenerator.GetHtmlToPdfDocument());
//return GetDownload(pdfGenerator.FilePath, $"File_{DateTime.Now.ToString("ddMMyyyHHmm")}.pdf");
return(GetDownload(pdfGenerator.FilePath, $"File.pdf"));
}
//Creates the print data and downloads the PDF to the users computer.
public ActionResult createPrintData()
{
var url = "";
PDFGenerator name = new PDFGenerator();
url = name.FillForm();
return(File(url, "application/pdf", Server.UrlEncode(name.getFileName())));
}
public static void Main()
{
IDatabase db = new Database();
//read from zip file & populate the database with more data + create updates pdf, xml & json files
var reader = new ReadExcelFromZip();
var movies = reader.SelectExcelFilesFromZip("../../../../Movies.zip");
foreach (var movie in movies)
{
Console.WriteLine(movie.Name);
}
var import = new MoviesImportToSql();
import.Import(movies);
Console.WriteLine("Importing data from xml...");
//Importing data from xml
XmlImporter.ImportXml(db);
//Console.WriteLine("Importing data to Mongo...");
//Importing data to MongoDB
//ImportToMongo.ImportToMongo.ImportData();
Console.WriteLine("Generating xml files...");
//Generating Xml file report
var generateXMLFile = new XMLGenerator();
generateXMLFile.Generate(db);
Console.WriteLine("Generating json files...");
//Generating Json file reports
var generateJsonReports = new JSONGenerator();
generateJsonReports.Generate(db);
Console.WriteLine("Generating pdf reports...");
//Generating Pdf fle reports
var generatePdfReports = new PDFGenerator();
generatePdfReports.Generate(db);
Console.WriteLine("Sending data to MySql...");
//Sending data to MySql
var sendDataToMySQL = new MySqlManager();
sendDataToMySQL.SendDataToMySql();
Console.WriteLine("Exporting data from MySql to excel file...");
//Exporting data from MySql to excel file
var mySqlExcelExport = new MySqlManager();
mySqlExcelExport.ExportDataFromMySql();
}
private void ConvertToPDF(Invoice i)
{
Customer c = i.GetHeader().GetCustomer();
List <Line> l = i.GetLines();
PDFGenerator doc = new PDFGenerator();
doc.WriteAt("GARAGE \"Twin Carburators\"", 50, 55, 10);
doc.WriteAt("NIF: 12.345.679-B", 50, 70, 10);
doc.DrawLine(3, 40, 0, 40, 842);
doc.DrawLine(3, 40, 75, 595, 75);
doc.WriteAt("Invoice num: " + i.GetHeader().GetNumInvoice(), 50, 90, 10);
doc.WriteAt("Invoice num: " + i.GetHeader().GetDate()
.Day.ToString("00") + "/" +
i.GetHeader().GetDate()
.Month.ToString("00") + "/" +
i.GetHeader().GetDate()
.Year.ToString("0000"), 50, 105, 10);
doc.WriteAt("Customer: " + c.GetName(), 50, 130, 10);
doc.WriteAt("ID: " + c.GetID(), 50, 145, 10);
doc.WriteAt("Products", 50, 170, 10);
doc.WriteAt("Amount", 250, 170, 10);
doc.WriteAt("Cost", 350, 170, 10);
doc.WriteAt("Total", 475, 170, 10);
doc.DrawLine(3, 40, 175, 595, 175);
int yncrement = 200;
double total = listOfInvoice.Get(currentRecord).CalculateTotal();
double iva = listOfInvoice.Get(currentRecord).CalculateIVA(total);
foreach (Line ll in l)
{
double subtotal = ll.GetPrice() * ll.GetAmount();
doc.WriteAt(ll.GetProduct().GetDescription(), 50, yncrement, 10);
doc.WriteAt(ll.GetAmount().ToString(), 250, yncrement, 10);
doc.WriteAt(ll.GetPrice().ToString(), 350, yncrement, 10);
doc.WriteAt(subtotal.ToString(), 475, yncrement, 10);
yncrement += 15;
}
yncrement += 10;
doc.WriteAt("BASE:", 350, yncrement, 10);
doc.WriteAt((total - iva).ToString(), 475, yncrement, 10);
yncrement += 10;
doc.WriteAt("IVA:", 350, yncrement, 10);
doc.WriteAt(iva.ToString(), 475, yncrement, 10);
yncrement += 10;
doc.WriteAt("TOTAL:", 350, yncrement, 10);
doc.WriteAt(total.ToString(), 475, yncrement, 10);
doc.SaveDocument("invoice - " +
i.GetHeader().GetDate().Year.ToString("0000") + "-" +
i.GetHeader().GetNumInvoice().ToString());
}
public ActionResult pdfTest(int id)
{
var gateway = BLLGatewayFactory.CreateOrGet();
var model = gateway.GetEvent(id);
PDFGenerator p = new PDFGenerator();
p.formatePDF(model);
ViewBag.Message = "Your application description page.";
return(View());
}
public SheetCreator Work(PDFGenerator pdf, AppraisalArchive header)
{
int freeSpaceLine = 0; // จำนวนบรรทัดที่ห่างจากชื่อลูกค้า
pdf
.BeginPage(header.Header.BankDatas.CustName, avoidNull(header.Header.JobNo), freeSpaceLine, "ชื่อหัวเรื่อง ถ้าไม่มีให้ลบออก")
.Text("ข้อความ 1")
.EndPage();
return this;
}
private void OnGeneratePdfClick()
{
var fbd = new FolderBrowserDialog();
DialogResult result = fbd.ShowDialog();
foreach (User employee in Employees)
{
PDFGenerator.generate(employee, fbd.SelectedPath);
}
}
public void PDFShouldBeCreatedWithLocalImage()
{
//arrange
PDFGenerator gen = new PDFGenerator("PDF");
//act
var result = gen.GeneratePDF("Fennec", "Content/Fennec.png", TEXT);
//assert
Assert.True(new System.IO.FileInfo(result).Length > 0);
}
public void PDFShouldBeCreatedWithInternetImage()
{
//arrange
PDFGenerator gen = new PDFGenerator("PDF");
//act
var result = gen.GeneratePDF("FennecTwo", "https://animals.sandiegozoo.org/sites/default/files/2016-10/fennec_fox_0.jpg", TEXT);
//assert
Assert.True(new System.IO.FileInfo(result).Length > 0);
}
public void TestMethodWrite()
{
List <Ticket> tickets = new List <Ticket>();
Ticket ticket = new Ticket();
tickets.Add(ticket);
Location loc = new Location();
PDFGenerator generator = new PDFGenerator(tickets, loc, "nl");
var result = generator.Write(tickets, loc);
}
public async Task ExportNotificationsToPDFAsync(IEnumerable <Notification> notifications)
{
try
{
PDFGenerator pdf = new PDFGenerator(Phrases.GlobalStockAlerts, Phrases.StockAlertsListOf);
Section section = pdf.CreateDocumentSection();
// Set title
pdf.AddParagraph(Phrases.GlobalStockAlerts, true, false, 16);
pdf.AddParagraph($"{Phrases.GlobalDate}: {DateTime.Now.ShortDate()}", false, true, null, 1);
// Create table and table columns
Table table = pdf.CreateTable();
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
// Create table header
Row row = pdf.CreateTableHeaderRow(table);
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, Phrases.GlobalDate, true);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, Phrases.GlobalReference, true);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Left, Phrases.GlobalProduct, true);
pdf.AddTableRowCell(row, 3, ParagraphAlignment.Left, Phrases.GlobalLocation, true);
pdf.AddTableRowCell(row, 4, ParagraphAlignment.Right, Phrases.StockMovementMinStock, true);
pdf.AddTableRowCell(row, 5, ParagraphAlignment.Right, Phrases.StockMovementsStock, true);
// Populate the table rows
notifications.ToList().ForEach((notification) => {
row = table.AddRow();
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, notification.CreatedAt.ShortDateWithTime());
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, notification.ProductLocation.Product.Reference);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Left, notification.ProductLocation.Product.Name);
pdf.AddTableRowCell(row, 3, ParagraphAlignment.Left, notification.ProductLocation.Location.Name);
pdf.AddTableRowCell(row, 4, ParagraphAlignment.Right, notification.ProductLocation.Stock.ToString());
pdf.AddTableRowCell(row, 5, ParagraphAlignment.Right, notification.ProductLocation.MinStock.ToString());
});
// Add the table to the section
pdf.AddTableToLastSection(table);
// Rendering the document
await pdf.GenerateAsync();
}
catch
{
OperationErrorsList errorsList = new OperationErrorsList();
errorsList.AddError("export-notifications-error", Phrases.GlobalErrorOperationDB);
throw new ServiceErrorException(errorsList);
}
}
private string GeneratePDF_ShipmentReportDetail(int OperationZoneId)
{
string pageStyleSheet = HttpContext.Current.Server.MapPath("~/Content/") + "confirm.css";
string bootStrapStyleSheet = HttpContext.Current.Server.MapPath("~/Content/") + "bootstrap.css";
string pdfLogo = HttpContext.Current.Server.MapPath("~/Content/") + "FrayteLogo.png";
var detail = new ReportSettingRepository().GetShipmentId(OperationZoneId);
FrayteShipmentReportPDF obj = new FrayteShipmentReportPDF();
obj.ShipmentReportDetail = new List <FrayteShipmentReport>();
obj.ShipmentReportDetail = detail;
obj.PageStyleSheet = pageStyleSheet;
obj.BootStrapStyleSheet = bootStrapStyleSheet;
obj.pdfLogo = pdfLogo;
string template = File.ReadAllText(HttpContext.Current.Server.MapPath("~/Templates/") + "ReportPdf.cshtml");
var EmailBody = Engine.Razor.RunCompile(template, "ShipmentReportPDF", null, obj);
string pdfFileName = "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".html";
string pdfFilePath = HttpContext.Current.Server.MapPath("~/UploadFiles/PDFGenerator/HTMLFile");
string pdfFullPath = pdfFilePath + @"\" + pdfFileName;
using (FileStream fs = new FileStream(pdfFullPath, FileMode.Create))
{
using (StreamWriter w = new StreamWriter(fs, System.Text.Encoding.UTF8))
{
w.WriteLine(EmailBody);
}
}
List <string> lstHtmlFiles = new List <string>();
lstHtmlFiles.Add(pdfFullPath);
//Before creating new PDF file, remove the earlier one.
filename = "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".PDF";
string pdfPath = HttpContext.Current.Server.MapPath("~/UploadFiles/PDFGenerator/") + "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss") + ".PDF";
if (File.Exists(pdfPath))
{
File.Delete(pdfPath);
}
string pdfFile = PDFGenerator.HtmlToPdf("~/UploadFiles/PDFGenerator", "ShipmentPODReport_" + DateTime.Now.ToString("dd_MM_yyyy_hh_mm_ss"), lstHtmlFiles.ToArray(), null);
if (System.IO.File.Exists(pdfFullPath))
{
System.IO.File.Delete(pdfFullPath);
}
return(pdfFile);
}
public void WriteResultsToPdfFile_ShouldReturnTrue()
{
//Arrange
List <Applicant> listA = new List <Applicant>();
Applicant a = new Applicant("123456", "Ion", "Pop", 9.0, 9.50, 9.0, 9.0, 0.0);
bool actual;
bool expected = true;
//Act
actual = PDFGenerator.WriteResultsToPdfFile(listA, 6, 8);
//Assert
Assert.AreEqual(expected, actual);
}
public void PDFShouldBeCreatedDirectoryTraversal()
{
const string ROOT = "PDF/Test";
const string FILE = "../FennecThree";
//arrange
PDFGenerator gen = new PDFGenerator(ROOT);
//act
var result = gen.GeneratePDF(FILE, "https://animals.sandiegozoo.org/sites/default/files/2016-10/fennec_fox_0.jpg", TEXT);
//assert
Assert.Equal($"{ROOT}/{FILE}.pdf", result);
Assert.True(new System.IO.FileInfo(result).Length > 0);
Assert.True(new System.IO.DirectoryInfo(ROOT).GetFiles().Length == 0);
}
public FileResult Create(int?votingId)
{
if (votingId == null)
{
throw new ArgumentNullException();
}
var db = new VotingContext();
var voting = db.Votings.Find(votingId);
PDFGenerator.Generate(voting);
string ReportURL = Server.MapPath("~/documents/") + $"Karta głosowania {voting.Name}.pdf";
byte[] FileBytes = System.IO.File.ReadAllBytes(ReportURL);
return(File(FileBytes, "application/pdf"));
}
public async Task ExportProductLocationsFromLocationToPDFAsync(IEnumerable <ProductLocation> productLocations)
{
try
{
string locationName = productLocations.ElementAt(0).Location.Name;
PDFGenerator pdf = new PDFGenerator($"{Phrases.GlobalProducts} {locationName}", Phrases.ProductsListOf);
Section section = pdf.CreateDocumentSection();
// Set title
pdf.AddParagraph(Phrases.GlobalProducts, true, false, 16);
pdf.AddParagraph($"{Phrases.GlobalDate}: {DateTime.Now.ShortDate()}", false, true);
pdf.AddParagraph($"{Phrases.GlobalLocation}: {locationName}", false, true, null, 1);
// Create table and table columns
Table table = pdf.CreateTable();
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
// Create table header
Row row = pdf.CreateTableHeaderRow(table);
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, Phrases.GlobalReference, true);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, Phrases.GlobalName, true);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Right, Phrases.StockMovementsStock, true);
// Populate the table rows
productLocations.ToList().ForEach((productLocation) => {
row = table.AddRow();
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, productLocation.Product.Reference);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, productLocation.Product.Name);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Right, productLocation.Stock.ToString());
});
// Add the table to the section
pdf.AddTableToLastSection(table);
// Rendering the document
await pdf.GenerateAsync();
}
catch
{
OperationErrorsList errorsList = new OperationErrorsList();
errorsList.AddError("export-location-products-error", Phrases.GlobalErrorOperationDB);
throw new ServiceErrorException(errorsList);
}
}
public ActionResult PrintTickets(String Culture)
{
CinemaViewModel model = (CinemaViewModel)TempData["model"];
List <Ticket> InsertedTickets = ((List <Ticket>)TempData["InsertedTickets"]);
var context = new EFDbContext();
var customer = context.Customers.ToList()[0];
var loc = context.Locations.ToList()[0];
Ticket t = ((List <Ticket>)TempData["InsertedTickets"])[0];
List <Ticket> tickets = context.Tickets.ToList().FindAll(tt => tt.SecretKey == t.SecretKey).ToList();
var pdf = new PDFGenerator(tickets, loc, Culture);
TempData["model"] = model;
TempData["InsertedTickets"] = InsertedTickets;
return(pdf.SendPdf());
}
static void Main()
{
var pdf = new PDFGenerator("Test");
var sheet = new SheetCreator();
sheet
.Work(pdf, _Mock.AppraisalArchive)
.Example(pdf,_Mock.AppraisalArchive)
//.Page5_19(pdf, _Mock.AppraisalArchive)
//.Sheet01(pdf, _Mock.AppraisalArchive, _Mock.LB_WorksheetModel)
//.Sheet02(pdf, _Mock.AppraisalArchive, _Mock.LB_LocationModel, _Mock.LB_LanddocModel, _Mock.LB_PriceSummaryModel)
//.Sheet03(pdf, _Mock.AppraisalArchive, _Mock.LB_BuildingModel)
//.Sheet05(pdf, _Mock.AppraisalArchive, _Mock.LB_FDetailsModel)
;
pdf.Finished();
System.Diagnostics.Process.Start(@"D:\Test.pdf");
}
public static void Main()
{
//var db = new MoviesDatabaseOfTeamSingaporeSlingEntities();
//var employees = db.Employees
// .Where(e => e.FirstName == "Tom")
// .Select(n =>
// new
// {
// FirstName = n.FirstName,
// LastName = n.LastName,
// Salary = n.Salary,
// Movies = n.Movies.Select(m => m.Name).ToList(),
// IsDirector = n.IsDirector
// }
// )
// .ToList();
//foreach (var employee in employees)
//{
// Console.WriteLine("The actor {0} {1} has participated in this movies:", employee.FirstName, employee.LastName);
// foreach (var movie in employee.Movies)
// {
// Console.WriteLine(movie);
// }
//}
var db = new Database();
//Generating Xml file report
var generateXMLFile = new XMLGenerator();
generateXMLFile.Generate(db);
//Generating Json file reports
var generateJsonReports = new JSONGenerator();
generateJsonReports.Generate(db);
//Generating Pdf fle reports
var generatePdfReports = new PDFGenerator();
generatePdfReports.Generate(db);
//XMLImporter.ImportXML();
}
public void GeneratePDF()
{
DocumentCreator creator = new DocumentCreator(view);
Wniosek document = creator.Create();
Serializer <Wniosek> serializer = new Serializer <Wniosek>();
XmlDocument xml = serializer.loadToXML(document);
Validator validator = new Validator();
bool isCorrect = validator.Validate(xml);
if (isCorrect)
{
if (view.SaveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
PDFGenerator generator = new PDFGenerator(document);
generator.GeneratePDF(view.SaveFileDialog.FileName);
}
}
;
}
private void Button_GuardarComo_Click(object sender, EventArgs e)
{
string documentName = "Entrada Serial " + string.Format("{0:dd-MM-yy}", DateTime.Now);
PDFGenerator docpdf;
SaveFileDialog svd = new SaveFileDialog {
Title = "Documentos - Guardar Como",
Filter = "Archivo Documentos|*.txt;*.pdf;*.doc;*.docx",
InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments),
FileName = documentName,
AddExtension = true,
};
try {
if (svd.ShowDialog() == DialogResult.OK)
{
if (svd.FileName.EndsWith(".pdf"))
{
docpdf = new PDFGenerator(RichTextBox_EntradaSerial.Text, svd.FileName);
docpdf.Font(RichTextBox_EntradaSerial.Font);
docpdf.Landscape(false);
docpdf.Print();
}
else
{
StreamWriter saveText = new StreamWriter(svd.FileName, false, Encoding.GetEncoding(1252));
if (File.Exists(svd.FileName))
{
saveText.Write(RichTextBox_EntradaSerial.Text);
saveText.Flush();
saveText.Close();
}
else
{
saveText.Write(RichTextBox_EntradaSerial.Text);
saveText.Flush();
saveText.Close();
}
}
}
} catch (Exception) { }
}
public SheetCreator Example(PDFGenerator pdf, AppraisalArchive header)
{
pdf
.BeginPage(header.Header.BankDatas.CustName, avoidNull(header.Header.JobNo), 0, "7.1 วิธีการประเมินมูลค่าสิทธิการเช่า")
.NewLine()
.TextBold("วิธีการประเมินมูลค่าสิทธิการเช่า โดยวิธีทางด้านรายได้ Discounted Cash Flow").NewLine(2)
.Tab(2).Text("โดยทั่วไป การประมูลค่าสิทธิการเช่าจะหมายถึงการหามูลค่าของผู้เช่า ซึ่งมูลค่าสิทธิการเช่าจะมีมูลค่าก็ต่อเมื่อผู้เช่าจ่ายค่าเช่า").NewLine()
.Text("ต่ำกว่าราคาเช่าตลาด ทำให้ผู้เช่าได้กำไรจากการเสียค่าเช่าในสัญญาต่ำกว่าราคาเช่าในตลาด").NewLine(2)
.Tab(2).Text("มูลค่าของสิทธิการเช่า").Tab(5).Text("=").Tab().Text("มูลค่าปัจจุบันทั้งหมดของกำไรจากการเช่าตลอดอายุสัญญาที่เหลือ").NewLine()
.Tab(2).Text("ซึ่งกำไรจากการเช่า").Tab(5).Text("=").Tab().Text("ค่าเช่าในราคาตลาด - ค่าเช่าที่จ่ายตามสัญญา").NewLine()
.Tab(2).Text("(ผู้เช่าจะได้รับกำไรจากการเช่าก็ต่อเมื่อ)").Tab(9).Text(":").Tab().Text("ค่าเช่าในตลาด > ค่าเช่าที่จ่ายตามในสัญญา").NewLine(2)
.Tab(2).Text("การหามูลค่ากำไรจากค่าเช่า (ซึ่งกำไรจากการเช่า = ค่าเช่าในราคาตลาด - ค่าเช่าในสัญญา) ทั้งหมดตลอดอายุสัญญาเช่าที่เหลือ").NewLine()
.Text("ในสัญญา แล้วนำมาหาเป็นมูลค่าปัจจุบัน โดยวิธี Discounted Cash Flow").NewLine()
.DrawLine().NewLine()
.CheckBox("ข้อความ A",true).NewLine()
.CheckBox("ข้อความ B",false).NewLine()
.Guidline()
.DrawRectangle(35, 350, 560, 80)
.EndPage();
return this;
}
/// <summary>
/// Initializes a new instance of the <see cref="ReportToExcelController" /> class.
/// </summary>
/// <param name="manager">The manager.</param>
public ReportToExcelController(IReportManager manager)
{
this.reportManager = manager;
this.excelProvider = new ExcelProvider();
this.pdfGenerator = new PDFGenerator();
}
/// <summary>
/// Get Export data from and build the export binary/objct.
/// </summary>
/// <param name="strFormat">(string) Export format</param>
/// <param name="stream">(string) Export image data in FusionCharts compressed format</param>
/// <param name="meta">{Hastable)Image meta data in keys "width", "heigth" and "bgColor"</param>
/// <returns></returns>
private MemoryStream ExportProcessor(string strFormat, string stream, Hashtable meta) {
if(IsDebugEnabled)
log.Debug("Chart의 exporting stream을 빌드합니다. strFormat={0}, meta={1}", strFormat, meta);
strFormat = strFormat.ToLower();
var exportStream = new MemoryStream();
switch(strFormat) {
case "pdf":
// Instantiate Export class for PDF, build Binary stream and store in stream object
var pdfGenerator = new PDFGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportStream = pdfGenerator.getBinaryStream(strFormat);
break;
case "jpg":
case "jpeg":
case "png":
case "gif":
// Instantiate Export class for Images, build Binary stream and store in stream object
var imageGenerator = new ImageGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportStream = imageGenerator.getBinaryStream(strFormat);
break;
default:
WriteLogMessage(" Invalid Export Format.", true);
break;
}
return exportStream;
}
/// <summary>
/// Get Export data from and build the export binary/objct.
/// </summary>
/// <param name="strFormat">(string) Export format</param>
/// <param name="stream">(string) Export image data in FusionCharts compressed format</param>
/// <param name="meta">{Hastable)Image meta data in keys "width", "heigth" and "bgColor"</param>
/// <returns></returns>
private MemoryStream exportProcessor(string strFormat, string stream, Hashtable meta) {
strFormat = strFormat.ToLower();
// initilize memeory stream object to store output bytes
var exportObjectStream = new MemoryStream();
// Handle Export class as per export format
switch(strFormat) {
case "pdf":
// Instantiate Export class for PDF, build Binary stream and store in stream object
var PDFGEN = new PDFGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportObjectStream = PDFGEN.getBinaryStream(strFormat);
break;
case "jpg":
case "jpeg":
case "png":
case "gif":
// Instantiate Export class for Images, build Binary stream and store in stream object
var IMGGEN = new ImageGenerator(stream, meta["width"].ToString(), meta["height"].ToString(),
meta["bgcolor"].ToString());
exportObjectStream = IMGGEN.getBinaryStream(strFormat);
break;
default:
// In case the format is not recognized
raise_error(" Invalid Export Format.", true);
break;
}
return exportObjectStream;
}
