protected void FlatGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
PdfExport exp = new PdfExport();
exp.Export(FlatGrid.Model, (IEnumerable)FlatGrid.DataSource, "Export.pdf", true, true, "flat-lime");
}
protected void FlatGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
exp.Export(FlatGrid.Model, (IEnumerable)FlatGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime");
}
protected void gvDepartment_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
try
{
PdfExport exp = new PdfExport();
for (var i = 0; i < this.gvDepartment.Columns.Count(); i++)
{
if (this.gvDepartment.Columns[i].HeaderText == "Action") // use the template column HeaderText here.
{
gvDepartment.Model.Columns.RemoveAt(i); // remove the respective column
i--;
}
}
PdfDocument doc = new PdfDocument();
doc.PageSettings.Orientation = PdfPageOrientation.Landscape;
doc.PageSettings.Size = PdfPageSize.A4;
doc.PageSettings.Width = 750;
RectangleF rect = new RectangleF(0, 0, doc.PageSettings.Width, 15);
//create a header pager template
PdfPageTemplateElement header = new PdfPageTemplateElement(rect);
//create a footer pager template
PdfPageTemplateElement footer = new PdfPageTemplateElement(rect);
//Font f = new System.Drawing.Font("Helvetica", 10, FontStyle.Bold);
// PdfFont font = new PdfTrueTypeFont(f, true);
// header.Graphics.DrawString(ReportTitle, font, PdfBrushes.Black, new Point(300, 0)); //Add custom text to the Header
// doc.Template.Top = header; //Append custom template to the document
// footer.Graphics.DrawString("Report Generated Date: " + DateTime.Now.ToString("dd-MMM-yyyy hh:mm tt"), font, PdfBrushes.Gray, new Point(280, 0));//Add Custom text to footer
doc.Template.Bottom = footer;//Add the footer template to document
doc.DocumentInformation.Title = ReportTitle;
doc.DocumentInformation.Keywords = "PDF";
doc.DocumentInformation.Subject = ReportTitle;
doc.DocumentInformation.Producer = "SMS";
doc.DocumentInformation.CreationDate = DateTime.Now;
// doc.DocumentInformation.Author = CU.CurrentUserFullName;
doc.ViewerPreferences.FitWindow = true;
doc.ViewerPreferences.PageLayout = PdfPageLayout.SinglePage;
doc.ViewerPreferences.PageScaling = PageScalingMode.AppDefault;
exp.Export(gvDepartment.Model, (IEnumerable)gvDepartment.DataSource, ExportFileName + ".pdf", false, false, "flat-saffron", false, doc, "");
}
catch (Exception ex)
{
// CU.LogError(ex);
}
}
protected void gvDepartment_ServerRowSelected(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
if (hlAction.Value == this.addAction)
{
gvDepartment.SelectedRowIndices.Clear();
gvDepartment.SelectedRowIndex = -1;
}
else
{
GetSelectedRowValues(e.Arguments["data"]);
hlAction.Value = this.updateAction;
}
}
protected void gvDepartment_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
try
{
ExcelExport exp = new ExcelExport();
IWorkbook book = exp.Export(gvDepartment.Model, (IEnumerable)gvDepartment.DataSource, ExportFileName + ".xlsx", ExcelVersion.Excel2010, false, false, "flat-lime", true);
//Creating a new style with cell back color, fill pattern and font attribute
Syncfusion.XlsIO.IStyle headerStyle = book.Styles.Add("NewStyle");
headerStyle.Font.Bold = true;
headerStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;//set text alignment
headerStyle.Color = Color.FromArgb(229, 255, 204);
headerStyle.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin;
headerStyle.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin;
headerStyle.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin;
headerStyle.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;
// Inserted new row for adding title
book.ActiveSheet.InsertRow(1);
// Merging the sheet from Range A1 to D1 for adding title space
book.ActiveSheet.Range["A1:D1"].Merge();
book.ActiveSheet.Range["E1:H1"].Merge();
//Adding the title using Text property
book.ActiveSheet.Range["A1"].Text = ReportTitle;
book.ActiveSheet.Range["A1"].CellStyle = headerStyle;
book.ActiveSheet.Range["E1"].Value = "Report Generated Date: " + DateTime.Now.ToString("dd-MMM-yyyy hh:mm tt");
book.ActiveSheet.Range["E1"].CellStyle = headerStyle;
book.ActiveSheet.Name = "Master Dept";
//Adding footer using SetValue method
book.SaveAs(ExportFileName + ".xlsx", ExcelSaveType.SaveAsXLS, System.Web.HttpContext.Current.Response, ExcelDownloadType.Open);
}
catch (Exception ex)
{
// CU.LogError(ex);
}
}
protected void Grid1_ServerCommandButtonClick(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please Select Document Number ');", true);
}
protected void grdFamilyDocDetails_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
}
protected void grdPaymentNote_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
PdfExport exp = new PdfExport();
dsPaymentNotes = dbPaymentNotesData.getAllPaymentNotes();
if (dsPaymentNotes.Tables[0].Rows.Count > 0)
{
DataTable FamilyDetails1 = dsPaymentNotes.Tables[0];
//List<DataRow> list = FamilyDetails.AsEnumerable().ToList();
List <DataRow> list = new List <DataRow>(FamilyDetails1.Select());
PdfPageSettings pageSettings = new PdfPageSettings(50f);
pageSettings.Margins.Left = 15;
pageSettings.Margins.Right = 15;
pageSettings.Margins.Top = 10;
pageSettings.Margins.Bottom = 10;
PdfDocument pdfDocument = exp.Export(grdPaymentNote.Model, (IEnumerable)list, "PaymentNoteAll.pdf", true, true, "flat-lime", true);
RectangleF rect = new RectangleF(0, 0, pdfDocument.PageSettings.Width, 50);
RectangleF rect1 = new RectangleF(0, 0, pdfDocument.PageSettings.Width, 50);
//create a header pager template
PdfPageTemplateElement header = new PdfPageTemplateElement(rect);
PdfPageTemplateElement header1 = new PdfPageTemplateElement(rect1);
//create a footer pager template
PdfPageTemplateElement footer = new PdfPageTemplateElement(rect);
Font f = new Font("Arial", 11, FontStyle.Bold);
PdfFont font = new PdfTrueTypeFont(f, true);
PdfBrush brush = new PdfSolidBrush(Color.Black);
//Add the fields in composite fields
//PdfCompositeField compositeField = new PdfCompositeField(font, brush, "Land Aquisition - SEZ Thane");
//PdfCompositeField compositeField1 = new PdfCompositeField(font, brush, "Family Details");
//PdfCompositeField compositeField2 = new PdfCompositeField(font, brush, "Report");
//PdfCompositeField compositeField3 = new PdfCompositeField(font, brush, "Family Details");
//compositeField.Bounds = header.Bounds;
////Draw the composite field in footer
//compositeField.Draw(footer.Graphics, new PointF(200, 0));
//compositeField1.Draw(footer.Graphics, new PointF(230, 10));
//compositeField2.Draw(footer.Graphics, new PointF(205, 20));
//compositeField3.Draw(footer.Graphics, new PointF(228, 40));
//Add the footer template at the bottom
pdfDocument.Template.Top = header;
footer.Graphics.DrawString("CopyRights", font, PdfBrushes.Gray, new Point(250, 0)); //Add Custom text to footer
pdfDocument.Template.Bottom = footer; //Add the footer template to document
pdfDocument.Save("PaymentNoteAll.pdf", Response, HttpReadType.Save);
}
else
{
}
}
protected void Grid1_ServerEditRow(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
EditAction(e.EventType, e.Arguments["data"]);
}
protected void Grid1_ServerWordExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
WordExport exp = new WordExport();
exp.Export(Grid1.Model, (IEnumerable)Grid1.DataSource, "CCP-Export.docx", true, true, "flat-lime");
}
