public ActionResult Index(StrataBoardModel strataBoardModel) { ModelState["ExpiredOnTo"].Errors.Clear(); ModelState["ExpiredOnFrom"].Errors.Clear(); ModelState["Keyword"].Errors.Clear(); return(BindList(strataBoardModel)); }
public static string FncSendReminderMailToClient(string emailAddress, string AdminEmailIds, long stratasBoardId, string message) { try { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel = strataBoardHelper.GetStratasBoardByID(stratasBoardId); //string url = ConfigurationManager.AppSettings["WebsiteRootPath"].ToString(); //EmailSender objClsMail = GetCommonDataForSendMail(emailAddress, "Reminder from StratasFair"); //StringBuilder mailBody = new StringBuilder(); //mailBody.Append(getConfigValue("stratasboard-reminder-mail").Replace("{NAME}", strataBoardModel.StratasBoardName)); //mailBody.Replace("{BASEPATH}", url); //mailBody.Replace("{MESSAGE}", message); //objClsMail.Body = mailBody.ToString(); //objClsMail.Bcc = AdminEmailIds; //for attachment //objClsMail.AttachmentList = new ArrayList(1); //objClsMail.AttachmentList.Add(System.Web.HttpContext.Current.Server.MapPath(objOrder.InvoiceFilePath)); //objClsMail = FncSendMail(objClsMail); //return objClsMail.ErrorMessage; return("success"); } catch { return(""); } }
public ActionResult Add() { ViewBag.StatusList = AppLogic.BindDDStatus(1); StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel.Status = 1; return(View(strataBoardModel)); }
public ActionResult Add(StrataBoardModel strataBoardModel) { if (ModelState.IsValid) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); long stratasBoardId = strataBoardHelper.AddUpdate(strataBoardModel); if (stratasBoardId > 0) { // stratas board admin added successfully try { // send mail to stratas board admin with auto generate password. string result = EmailSender.FncSend_StratasBoard_RegistrationMail_ToClient(stratasBoardId); if (result == "success") { TempData["CommonMessage"] = AppLogic.setMessage(0, "Record added successfully."); } else { TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, while sending email to stratasboard administrator. Resend mail again."); } } catch (Exception ex) { new AppError().LogMe(ex); } return(RedirectToAction("Index")); } else if (stratasBoardId == -4) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Stratasboard name already exists."); ViewBag.StatusList = AppLogic.BindDDStatus(1); return(View(strataBoardModel)); } else if (stratasBoardId == -5) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name already exists."); ViewBag.StatusList = AppLogic.BindDDStatus(1); return(View(strataBoardModel)); } else if (stratasBoardId == -6) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Email address already exists."); ViewBag.StatusList = AppLogic.BindDDStatus(1); return(View(strataBoardModel)); } else { ViewBag.StatusList = AppLogic.BindDDStatus(1); TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, Please try again."); return(View(strataBoardModel)); } } ViewBag.StatusList = AppLogic.BindDDStatus(1); return(View(strataBoardModel)); }
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 Edit(long?Id) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id.Value); ViewBag.StatusList = AppLogic.BindDDStatus(Convert.ToInt32(strataBoardModel.Status)); return(View(strataBoardModel)); }
public List <StrataBoardModel> GetAll(StrataBoardModel model) { var myQuery = context.vw_GetStratasBoard.ToList(); if (model.ExpiredOnFrom.Year > 1900 && model.ExpiredOnTo.Year > 1900) { myQuery = myQuery.Where(x => (x.ExpiryDate >= model.ExpiredOnFrom && x.ExpiryDate <= model.ExpiredOnTo)).ToList(); } else if (model.ExpiredOnFrom.Year > 1900) { myQuery = myQuery.Where(x => x.ExpiryDate >= model.ExpiredOnFrom).ToList(); } else if (model.ExpiredOnTo.Year > 1900) { myQuery = myQuery.Where(x => x.ExpiryDate <= model.ExpiredOnTo).ToList(); } if (model.Keyword != null && model.Keyword != "") { myQuery = myQuery.Where(x => x.StratasBoardName.Contains(model.Keyword) //|| x.FirstName.Contains(model.Keyword) //|| x.LastName.Contains(model.Keyword) || x.PortalLink.Contains(model.Keyword) || x.EmailId.Contains(model.Keyword) ).ToList(); } return(myQuery //.Where(x => x.LicenseType == (model.LicenseType > 0 ? model.LicenseType : x.LicenseType)) .OrderByDescending(x => x.CreatedOn) .Select(x => new StrataBoardModel() { StratasBoardId = x.StratasBoardId, StratasBoardName = x.StratasBoardName, PortalLink = x.PortalLink, FirstName = x.FirstName, LastName = x.LastName, EmailId = x.EmailId, ContactNumber = x.ContactNumber, CreatedOn = x.CreatedOn.Value, SubscriptionId = x.SubscriptionId.Value, ExpiryDate = x.ExpiryDate.ToString(), AllowedUser = x.AllowedUser.Value, Status = x.STATUS.Value, SubscriptionName = x.SubscriptionName, ValidityText = x.ValidityText, IsSmsForAlert = x.IsSmsForAlert.Value, IsSmsForReminder = x.IsSmsForReminder.Value, RequestPortalLink = x.RequestPortalLink, RequestMessage = x.RequestMessage, RequestCreatedOn = x.RequestCreatedOn.ToString(), RequestCounter = x.RequestCounter, RequestCreatedBy = x.RequestCreatedBy }).ToList()); }
public long AddUpdate(StrataBoardModel objectModel) { if (objectModel.StratasBoardId > 0) { if (objectModel.PortalLink != objectModel.OldPortalLink && context.tblUserClients.Where(x => x.StratasBoardId == objectModel.StratasBoardId && x.RoleName.ToLower() != "a").Count() > 0) { // unique name can't be updated when a sub-admin or Owner has already assigned to this StratasBoardId. return(-7); } else if (context.tblStratasBoards.Any(x => x.StratasBoardName == objectModel.StratasBoardName && x.StratasBoardId != objectModel.StratasBoardId)) { // stratasboard name already exists return(-4); } else if (context.tblStratasBoards.Any(x => x.PortalLink == objectModel.PortalLink && x.StratasBoardId != objectModel.StratasBoardId)) { // portal link already exists return(-5); } else if (context.tblUserClients.Any(x => x.EmailId == objectModel.EmailId && x.StratasBoardId != objectModel.StratasBoardId)) { // registered emailid already exists return(-6); } else { return(update(objectModel)); } } else { if (context.tblStratasBoards.Any(x => x.StratasBoardName == objectModel.StratasBoardName)) { // stratasboard name already exists return(-4); } else if (context.tblStratasBoards.Any(x => x.PortalLink == objectModel.PortalLink)) { // portal link already exists return(-5); } else if (context.tblUserClients.Any(x => x.EmailId == objectModel.EmailId)) { // registered emailid already exists return(-6); } else { return(update(objectModel)); } } }
public ActionResult Edit(StrataBoardModel strataBoardModel) { ModelState.Remove("SubscriptionId"); if (ModelState.IsValid) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); long stratasBoardId = strataBoardHelper.AddUpdate(strataBoardModel); if (stratasBoardId > 0) { // send mail to stratas board admin with updated unique URL. if (strataBoardModel.OldPortalLink.Trim() != strataBoardModel.PortalLink.Trim()) { string result = EmailSender.FncSend_StratasBoard_UniqueURLUpdate_ToClient(stratasBoardId); } TempData["CommonMessage"] = AppLogic.setMessage(0, "Record updated successfully."); return(RedirectToAction("Index")); } else if (stratasBoardId == -4) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Stratasboard name already exists."); } else if (stratasBoardId == -5) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name already exists."); } else if (stratasBoardId == -6) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Email address already exists."); } else if (stratasBoardId == -7) { TempData["CommonMessage"] = AppLogic.setMessage(1, "Unique name can't be updated."); } else { TempData["CommonMessage"] = AppLogic.setMessage(2, "Error, Please try again."); } } ViewBag.StatusList = AppLogic.BindDDStatus(Convert.ToInt32(strataBoardModel.Status)); return(View(strataBoardModel)); }
public int Delete(StrataBoardModel objectModel) { int count = -1; // check the user exists on this strata, if exists then return... if (context.tblUserClients.Any(o => o.StratasBoardId == objectModel.StratasBoardId && o.RoleName.ToLower() != "a")) { count = -2; return(count); } // Delete the users on this strata if (context.tblUserClients.Any(x => x.StratasBoardId == objectModel.StratasBoardId)) { context.tblUserClients.RemoveRange(context.tblUserClients.Where(x => x.StratasBoardId == objectModel.StratasBoardId)); context.SaveChanges(); count = 0; } // Delete the subscription details on this strata if (context.tblStratasBoardSubscriptions.Any(x => x.StratasBoardId == objectModel.StratasBoardId)) { context.tblStratasBoardSubscriptions.RemoveRange(context.tblStratasBoardSubscriptions.Where(x => x.StratasBoardId == objectModel.StratasBoardId)); context.SaveChanges(); count = 0; } tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId; context.Entry(tblStratasBoardDb).State = EntityState.Deleted; count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }
public ActionResult Deactive(long Id) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id); strataBoardModel.Status = 0; int count = strataBoardHelper.ActDeact(strataBoardModel); if (count == 0) { TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deactivated successfully."); } else { TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deactivation failed."); } return(RedirectToAction("Index")); }
public int ActDeact(StrataBoardModel objectModel) { tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId; tblStratasBoardDb.Status = objectModel.Status; context.tblStratasBoards.Attach(tblStratasBoardDb); context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true; int count = context.SaveChanges(); if (count == 1) { count = 0; } else { count = -1; } return(count); }
public ActionResult Delete(long Id) { StrataBoardHelper strataBoardHelper = new StrataBoardHelper(); StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel = strataBoardHelper.GetStratasBoardByID(Id); int count = strataBoardHelper.Delete(strataBoardModel); if (count == 0) { TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deleted successfully."); } else if (count == -2) { TempData["CommonMessage"] = AppLogic.setMessage(count, "Record can't be deleted as other users exists."); } else { TempData["CommonMessage"] = AppLogic.setMessage(count, "Record deletion failed."); } return(RedirectToAction("Index")); }
public ActionResult Index() { if (ClientSessionData.UserClientId != 0) { StrataBoardModel strataBoardModel = new StrataBoardModel(); strataBoardModel = strataBoardHelper.GetStratasBoardByID(ClientSessionData.ClientStrataBoardId); if (ClientSessionData.ClientRoleName.ToLower() == "owner") { if (!ClientSessionData.ClientIsProfileCompleted) { return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/logon/completeprofile"))); } else { return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/dashboard/dashboardowner"))); } } else { return(Redirect(Url.Content("~/" + strataBoardModel.PortalLink + "/dashboard"))); } } else { string PortalUrl = clientLoginHelper.GetPortalUrlFromCurrentUrl(); var IsExistPortalUrl = _context.tblStratasBoards.Where(x => x.PortalLink == PortalUrl && x.Status == 0); if (IsExistPortalUrl.Count() > 0) { return(Redirect(Url.Content("~/" + PortalUrl + "/logon/invalidportallink"))); } else { return(View()); } } }
public long update(StrataBoardModel objectModel) { long count = -2; long stratasBoardId = 0; long userClientId = 0; if (objectModel.StratasBoardId > 0) { using (var transaction = context.Database.BeginTransaction()) { try { // Table StratasBoard tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardId = objectModel.StratasBoardId; tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName; tblStratasBoardDb.BuildingName = objectModel.BuildingName; tblStratasBoardDb.PortalLink = objectModel.PortalLink.Trim(); tblStratasBoardDb.Status = objectModel.Status; tblStratasBoardDb.ModifiedBy = AdminSessionData.AdminUserId; tblStratasBoardDb.ModifiedOn = DateTime.UtcNow; tblStratasBoardDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress; if (objectModel.PortalLink == objectModel.RequestPortalLink) { tblStratasBoardDb.RequestCounter = 1; } context.tblStratasBoards.Attach(tblStratasBoardDb); context.Entry(tblStratasBoardDb).Property(x => x.StratasBoardName).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.BuildingName).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.PortalLink).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.Status).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.ModifiedBy).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.ModifiedOn).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.ModifiedFromIP).IsModified = true; context.Entry(tblStratasBoardDb).Property(x => x.RequestCounter).IsModified = true; // Table UserClient count = context.SaveChanges(); if (count >= 0) { tblUserClient tblUserClientDb = new tblUserClient(); tblUserClientDb.UserClientId = objectModel.UserClientId; tblUserClientDb.FirstName = objectModel.FirstName; tblUserClientDb.LastName = objectModel.LastName; tblUserClientDb.EmailId = objectModel.EmailId; tblUserClientDb.ContactNumber = objectModel.ContactNumber; tblUserClientDb.ModifiedBy = AdminSessionData.AdminUserId; tblUserClientDb.ModifiedOn = DateTime.UtcNow; tblUserClientDb.ModifiedFromIP = HttpContext.Current.Request.UserHostAddress; context.tblUserClients.Attach(tblUserClientDb); context.Entry(tblUserClientDb).Property(x => x.FirstName).IsModified = true; context.Entry(tblUserClientDb).Property(x => x.LastName).IsModified = true; //context.Entry(tblUserClientDb).Property(x => x.EmailId).IsModified = true; context.Entry(tblUserClientDb).Property(x => x.ContactNumber).IsModified = true; context.Entry(tblUserClientDb).Property(x => x.ModifiedBy).IsModified = true; context.Entry(tblUserClientDb).Property(x => x.ModifiedOn).IsModified = true; context.Entry(tblUserClientDb).Property(x => x.ModifiedFromIP).IsModified = true; count = context.SaveChanges(); if (count >= 0) { transaction.Commit(); count = objectModel.StratasBoardId; } else { transaction.Rollback(); count = -2; // any error is there } } else { transaction.Rollback(); count = -2; // any error is there } } catch (Exception ex) { new AppError().LogMe(ex); transaction.Rollback(); count = -2; // any error is there } } } else { using (var transaction = context.Database.BeginTransaction()) { var subscriptionDetails = context.tblSubscriptions.Where(x => x.SubscriptionId == objectModel.SubscriptionId).FirstOrDefault(); try { // Table StratasBoard tblStratasBoard tblStratasBoardDb = new tblStratasBoard(); tblStratasBoardDb.StratasBoardName = objectModel.StratasBoardName; tblStratasBoardDb.BuildingName = objectModel.BuildingName; tblStratasBoardDb.PortalLink = objectModel.PortalLink; tblStratasBoardDb.CreatedBy = AdminSessionData.AdminUserId; tblStratasBoardDb.CreatedOn = DateTime.UtcNow; tblStratasBoardDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress; tblStratasBoardDb.Status = objectModel.Status; context.tblStratasBoards.Add(tblStratasBoardDb); context.SaveChanges(); stratasBoardId = tblStratasBoardDb.StratasBoardId; if (stratasBoardId > 0) { // Table UserClient tblUserClient tblUserClientDb = new tblUserClient(); tblUserClientDb.FirstName = objectModel.FirstName; tblUserClientDb.LastName = objectModel.LastName; tblUserClientDb.EmailId = objectModel.EmailId; tblUserClientDb.Password = AppLogic.EncryptPassword(); tblUserClientDb.ContactNumber = objectModel.ContactNumber; tblUserClientDb.StratasBoardId = stratasBoardId; tblUserClientDb.RoleName = "A"; // StratasBoard Admin tblUserClientDb.IsEmailNotification = true; tblUserClientDb.IsSMSNotification = true; tblUserClientDb.IsProfileComplete = false; tblUserClientDb.Status = 1; // It will be active in both the cases tblUserClientDb.CreatedBy = AdminSessionData.AdminUserId; tblUserClientDb.CreatedOn = DateTime.UtcNow; tblUserClientDb.LastLogin = DateTime.UtcNow; tblUserClientDb.CurrentLogin = DateTime.UtcNow; tblUserClientDb.CreatedFromIP = HttpContext.Current.Request.UserHostAddress; context.tblUserClients.Add(tblUserClientDb); context.SaveChanges(); userClientId = tblUserClientDb.UserClientId; if (userClientId > 0) { // Table StratasBoard Subscription tblStratasBoardSubscription tblStratasBoardSubscriptionDb = new tblStratasBoardSubscription(); tblStratasBoardSubscriptionDb.StratasBoardId = stratasBoardId; tblStratasBoardSubscriptionDb.SubscriptionId = objectModel.SubscriptionId; tblStratasBoardSubscriptionDb.Validity = subscriptionDetails.Validity; tblStratasBoardSubscriptionDb.IsSmsForAlert = subscriptionDetails.IsSmsForAlert; tblStratasBoardSubscriptionDb.IsSmsForReminder = subscriptionDetails.IsSmsForReminder; tblStratasBoardSubscriptionDb.AllowedUser = subscriptionDetails.AllowedUser; tblStratasBoardSubscriptionDb.ExpiryDate = AppLogic.CalculateSubscriptionExpiryDate(DateTime.UtcNow, subscriptionDetails.Validity); tblStratasBoardSubscriptionDb.CreatedBy = AdminSessionData.AdminUserId; tblStratasBoardSubscriptionDb.CreatedOn = DateTime.UtcNow; tblStratasBoardSubscriptionDb.Status = 1; context.tblStratasBoardSubscriptions.Add(tblStratasBoardSubscriptionDb); context.SaveChanges(); int stratasBoardSubscriptionId = tblStratasBoardSubscriptionDb.StratasBoardSubscriptionId; if (stratasBoardSubscriptionId > 0) { transaction.Commit(); count = stratasBoardId; } else { transaction.Rollback(); count = -2; // any error is there } } else { transaction.Rollback(); count = -2; // any error is there } } else { transaction.Rollback(); count = -2; // any error is there } } catch (Exception ex) { new AppError().LogMe(ex); transaction.Rollback(); count = -2; // any error is there } } } return(count); }
// GET: Administrator/Client public ActionResult Index() { StrataBoardModel strataBoardModel = new StrataBoardModel(); return(BindList(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"))); }