/// <summary>
/// Get the Expired membership record (/* Subscription expired as compared to the current date */)
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <ExpiredMembershipReportModel> GetExpiredMembershipReport(ExpiredMembershipReportModel model)
{
return(context.Usp_StratasBoardStatusReportAdmin(model.KeywordSearch, model.PageNumber, model.PageSize, 2).Select(x => new ExpiredMembershipReportModel
{
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 BindExpiredMembershipReport(ExpiredMembershipReportModel 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 ExpiredMembershipExportToCsv()
{
try
{
ConvertToCSV objCSV = new ConvertToCSV();
string FilePath = "~/Content/Resources/Reports/csvData.csv";
objCSV.fncDeleteFile(FilePath);
ReportsHelper objLedgerHelper = new ReportsHelper();
ExpiredMembershipReportModel objLedgerModel = new ExpiredMembershipReportModel
{
PageNumber = 1,
PageSize = 100000000
};
List <ExpiredMembershipReportModel> listLedgerModel = objLedgerHelper.GetExpiredMembershipReport(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 expired 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 expired 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("ExpiredMembership_" + DateTime.Now.ToShortDateString() + ".csv", FilePath);
}
}
catch (Exception Ex)
{
string Err = Ex.Message.ToString();
}
return(Redirect(Url.Content("~/securehost/rootlogin/report/expiredmembership")));
}
public ActionResult ExpiredMembership(ExpiredMembershipReportModel model, int?id)
{
model.PageNumber = 1;
return(BindExpiredMembershipReport(model));
}
public ActionResult ExpiredMembership(ExpiredMembershipReportModel model)
{
return(BindExpiredMembershipReport(model));
}
