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"); }