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