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