public static void Main(string[] args)
{
//// ***********************************************************
//// GroupDocs.Conversion Cloud API Examples
//// ***********************************************************
//TODO: Get your ClientId and ClientSecret at https://dashboard.groupdocs.cloud (free registration is required).
Constants.MyClientId = "XXXX-XXXX-XXXX-XXXX";
Constants.MyClientSecret = "XXXXXXXXXXXXXXXX";
// Uploading sample test files from local disk to cloud storage
Constants.UploadSampleTestFiles();
#region Info API Examples
GetSupportedConversions.Run();
GetDocumentInformation.Run();
#endregion
#region License API Examples
GetLicenseConsumption.Run();
#endregion
#region Document conversion examples with conversion options
ConvertToPdf.Run();
ConvertToPdfResponseBody.Run();
ConvertToWordProcessing.Run();
ConvertToHtml.Run();
ConvertToImage.Run();
ConvertToPresentation.Run();
ConvertToSpreadsheet.Run();
ConvertToPdfDirect.Run();
ConvertToPdfDirectOptions.Run();
#endregion
#region Document conversion examples with common options
AddWatermark.Run();
ConvertConsecutivePages.Run();
ConvertSpecificPages.Run();
ConvertUsingCustomFont.Run();
#endregion
#region Document conversion examples with loading options
ConvertCadAndSpecifyLoadOptions.Run();
ConvertCsvByConvertingDateTimeAndNumericData.Run();
ConvertCsvBySpecifyingDelimiter.Run();
ConvertCsvBySpecifyingEncoding.Run();
ConvertEmailWithAlteringFieldsVisibility.Run();
ConvertEmailWithAttachments.Run();
ConvertEmailWithTimezoneOffset.Run();
ConvertEmailWithFieldLabels.Run();
ConvertEmailWithOriginalDate.Run();
ConvertHtmlWithPageNumbering.Run();
ConvertNoteBySpecifyingFontSubstitution.Run();
ConvertPdfAndFlattenAllFields.Run();
ConvertPdfAndHideAnnotations.Run();
ConvertPdfAndRemoveEmbeddedFiles.Run();
ConvertPresentationByHidingComments.Run();
ConvertPresentationBySpecifyingFontSubstitution.Run();
ConvertPresentationWithHiddenSlidesIncluded.Run();
ConvertSpreadsheetAndHideComments.Run();
ConvertSpreadsheetByShowingGridLines.Run();
ConvertSpreadsheetBySkippingEmptyRowsAndColumns.Run();
ConvertSpreadsheetBySpecifyingFontsubstitution.Run();
ConvertSpreadsheetBySpecifyingRange.Run();
ConvertSpreadsheetWithHiddenSheetsIncluded.Run();
ConvertTxtByControllingLeadingSpacesBehavior.Run();
ConvertTxtByControllingTrailingSpacesBehavior.Run();
ConvertTxtBySpecifyingEncoding.Run();
ConvertWordProcessingByHidingComments.Run();
ConvertWordProcessingByHidingTrackedChanges.Run();
ConvertWordProcessingBySpecifyingFontSubstitution.Run();
#endregion
Console.WriteLine("Completed!");
Console.ReadKey();
}
public ActionResult ClientExportToPdf(string dfrom, string dto, string kw)
{
try
{
ConvertToPdf convertToPdf = new ConvertToPdf();
string filename = "stratasboard_" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Year.ToString() + ".pdf";
string FilePath = "~/Content/Resources/Reports/" + filename;
convertToPdf.FncDeleteFile(FilePath);
StrataBoardHelper objLedgerHelper = new StrataBoardHelper();
StrataBoardModel objLedgerModel = new StrataBoardModel
{
PageNumber = 1,
PageSize = 100000000
};
objLedgerModel.ExpiredOnFrom = DateTime.Parse(dfrom);
objLedgerModel.ExpiredOnTo = DateTime.Parse(dto);
objLedgerModel.Keyword = kw;
List <StrataBoardModel> listLedgerModel = objLedgerHelper.GetAll(objLedgerModel);
DataTable dt = new DataTable();
dt.Columns.Add("Stratasboard name");
dt.Columns.Add("Unique name");
dt.Columns.Add("Name");
dt.Columns.Add("Email address");
dt.Columns.Add("Contact number");
dt.Columns.Add("Created on");
dt.Columns.Add("Subscription name");
dt.Columns.Add("Validity");
dt.Columns.Add("Expiration date");
dt.Columns.Add("Allowed user");
dt.Columns.Add("IsSmsForAlert");
dt.Columns.Add("IsSmsForReminder");
dt.Columns.Add("Status");
if (listLedgerModel.Count() != 0)
{
foreach (var item in listLedgerModel)
{
DataRow row = dt.NewRow();
row["Stratasboard name"] = item.StratasBoardName;
row["Unique name"] = item.PortalLink;
row["Name"] = item.FirstName + " " + item.LastName;
row["Email address"] = item.EmailId;
row["Contact number"] = item.ContactNumber;
row["Created on"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.CreatedOn));
row["Subscription name"] = item.SubscriptionName;
row["Validity"] = item.ValidityText;
row["Expiration date"] = AppLogic.GetDateFromatForCsv(Convert.ToDateTime(item.ExpiryDate));
row["Allowed user"] = item.AllowedUser;
row["IsSmsForAlert"] = AppLogic.GetYesNo(item.IsSmsForAlert);
row["IsSmsForReminder"] = AppLogic.GetYesNo(item.IsSmsForReminder);
row["Status"] = AppLogic.GetStatus(item.Status.ToString());
dt.Rows.Add(row);
}
}
if (dt.Rows.Count > 0)
{
FileStream fs = new FileStream(Server.MapPath(FilePath), FileMode.Create, FileAccess.Write, FileShare.None);
iTextSharp.text.Rectangle rec = new iTextSharp.text.Rectangle(PageSize.A4);
//Rectangle rec = new Rectangle(PageSize.A4.Rotate());
//rec.BackgroundColor = new BaseColor(System.Drawing.Color.WhiteSmoke);
//rec2.BackgroundColor = new CMYKColor(25, 90, 25, 0);
//72 points = 1 inch
//Left Margin: 36pt => 0.5 inch
//Right Margin: 72pt => 1 inch
//Top Margin: 108pt => 1.5 inch
//Bottom Margini: 180pt => 2.5 inch
Document doc = new Document(rec, 18, 18, 72, 72);
PdfWriter writer = PdfWriter.GetInstance(doc, fs);
doc.Open();
doc.AddTitle("stratasboard listing");
doc.AddCreator("stratafair");
//doc.AddSubject("This is an Example 4 of Chapter 1 of Book 'iText in Action'");
//doc.AddKeywords("Metadata, iTextSharp 5.4.4, Chapter 1, Tutorial");
//doc.AddAuthor("pankaj jain");
//doc.AddHeader("Nothing", "No Header");
//Paragraph para = new Paragraph("Hello World");
// Setting paragraph's text alignment using iTextSharp.text.Element class
// para.Alignment = Element.ALIGN_JUSTIFIED;
// Adding this 'para' to the Document object
// doc.Add(para);
PdfPTable table = new PdfPTable(13);
table.HorizontalAlignment = 0;
table.TotalWidth = 550f;
table.LockedWidth = true;
// Font fontHeader = FontFactory.GetFont("ARIAL", 8);
// sum must equal to Total Width of table
// number of sizes must equal to number of columns
float[] widths = new float[] { 80f, 80f, 50f, 80f, 50f, 80f, 80f, 40f, 50f, 50f, 50f, 40f, 40f };
table.SetWidths(widths);
int iColCount = dt.Columns.Count;
for (int i = 0; i < iColCount; i++)
{
//PdfPCell pdfPCell = new PdfPCell(new Phrase(new Chunk(dt.Columns[i].ToString(), fontHeader)));
//table.AddCell(pdfPCell);
ConvertToPdf.AddHeaderCell(table, dt.Columns[i].ToString(), 1, 7, "C", "C");
}
foreach (DataRow dr in dt.Rows)
{
for (int i = 0; i < iColCount; i++)
{
ConvertToPdf.AddCell(table, dr[i].ToString(), 1, 7, "C", "C");
}
}
doc.Add(table);
doc.Close();
convertToPdf.FncDownLoadPDFFile(FilePath);
}
}
catch (Exception Ex)
{
string Err = Ex.Message.ToString();
}
return(Redirect(Url.Content(ConfigurationManager.AppSettings["WebsiteRootPathAdmin"] + "securehost/rootlogin/client")));
}
