/// <summary> /// Get the Upcoming renewal record (/* Subscription expiring within 15 days from the current date */) /// </summary> /// <param name="model"></param> /// <returns></returns> public List <UpcomingRenewalReportModel> GetUpcomingRenewalReport(UpcomingRenewalReportModel model) { return(context.Usp_StratasBoardStatusReportAdmin(model.KeywordSearch, model.PageNumber, model.PageSize, 1).Select(x => new UpcomingRenewalReportModel { Sno = x.Sno, StratasBoardId = x.StratasBoardId, StratasBoardName = x.StratasBoardName, PortalLink = x.PortalLink, CreatedBy = x.CreatedBy, CreatedOn = x.CreatedOn, TotalCount = x.TotalCount.Value, STATUS = x.STATUS, UserClientId = x.UserClientId, FirstName = x.FirstName, LastName = x.LastName, EmailId = x.EmailId, ContactNumber = x.ContactNumber, ExpiryDate = x.ExpiryDate, AllowedUser = x.AllowedUser, IsSmsForAlert = x.IsSmsForAlert, IsSmsForReminder = x.IsSmsForReminder, SubscriptionId = x.SubscriptionId, SubscriptionName = x.SubscriptionName, ValidityText = x.ValidityText }).ToList()); }
private ActionResult BindUpcomingRenewalReport(UpcomingRenewalReportModel model) { try { model.PageNumber = model.PageNumber == null ? 1 : model.PageNumber; } catch { model.PageNumber = 1; } model.PageSize = Convert.ToInt32(CommonData.FetchSettingValue("Admin.PageSize.Long")); // 2 return(View(model)); }
public ActionResult UpcomingRenewalExportToCsv() { try { ConvertToCSV objCSV = new ConvertToCSV(); string FilePath = "~/Content/Resources/Reports/csvData.csv"; objCSV.fncDeleteFile(FilePath); ReportsHelper objLedgerHelper = new ReportsHelper(); UpcomingRenewalReportModel objLedgerModel = new UpcomingRenewalReportModel { PageNumber = 1, PageSize = 100000000 }; List <UpcomingRenewalReportModel> listLedgerModel = objLedgerHelper.GetUpcomingRenewalReport(objLedgerModel); DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("Email address"); dt.Columns.Add("Strata name"); dt.Columns.Add("Contact number"); dt.Columns.Add("Register on"); dt.Columns.Add("Unique name"); dt.Columns.Add("Subscription expiring on"); if (listLedgerModel.Count() != 0) { foreach (var item in listLedgerModel) { DataRow row = dt.NewRow(); row["Name"] = item.FirstName + " " + item.LastName; row["Email address"] = item.EmailId; row["Strata name"] = item.StratasBoardName; row["Contact number"] = item.ContactNumber; row["Register on"] = AppLogic.GetDateFromatForCsv(item.CreatedOn); row["Unique name"] = item.PortalLink; row["Subscription expiring on"] = AppLogic.GetDateFromatForCsv(item.ExpiryDate); dt.Rows.Add(row); } } if (dt.Rows.Count > 0) { objCSV.CreateCSVFile(dt, Server.MapPath("~/Content/Resources/Reports/") + "csvData.csv"); objCSV.FncDownLoadFiles("UpcomingRenewal_" + DateTime.Now.ToShortDateString() + ".csv", FilePath); } } catch (Exception Ex) { string Err = Ex.Message.ToString(); } return(Redirect(Url.Content("~/securehost/rootlogin/report/upcomingrenewal"))); }
public ActionResult UpcomingRenewal(UpcomingRenewalReportModel model, int?id) { model.PageNumber = 1; return(BindUpcomingRenewalReport(model)); }
public ActionResult UpcomingRenewal(UpcomingRenewalReportModel model) { return(BindUpcomingRenewalReport(model)); }