private ActionResult BindList(StrataBoardModel strataBoardModel) { StrataBoardHelper _Helper = new StrataBoardHelper(); var List = _Helper.GetAll(strataBoardModel); ActiveList = List.Where(x => x.Status == 1).ToList(); InActiveList = List.Where(x => x.Status == 0).ToList(); return(View(Tuple.Create(ActiveList, InActiveList, strataBoardModel))); }
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"))); }
public ActionResult ClientExportToCsv(string dfrom, string dto, string kw) { try { ConvertToCSV objCSV = new ConvertToCSV(); string FilePath = "~/Content/Resources/Reports/csvData.csv"; objCSV.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) { objCSV.CreateCSVFile(dt, Server.MapPath("~/Content/Resources/Reports/") + "csvData.csv"); objCSV.FncDownLoadFiles("stratasboard_" + DateTime.Now.ToShortDateString() + ".csv", FilePath); } } catch (Exception Ex) { string Err = Ex.Message.ToString(); } return(Redirect(Url.Content(ConfigurationManager.AppSettings["WebsiteRootPath"] + "securehost/rootlogin/client"))); }