public IHttpActionResult Get(string local = null, DateTime?min_date = null, DateTime?max_date = null, bool show_success_records = false, int?page = 0, int?pageSize = 25)
{
int currentPage = page.Value;
int currentPageSize = pageSize.Value;
IEnumerable <EMemberRegistration> mbrs = EMemberRegistrationRepository.GetAll();
if (this.TokenId.IsSuperAdmin && local != null)
{
mbrs = mbrs.Where(u => u.LocalNumber == local);
}
if (!this.TokenId.IsSuperAdmin)
{
mbrs = mbrs.Where(u => u.LocalNumber == this.TokenId.LocalNumber);
}
if (min_date != null)
{
mbrs = mbrs.Where(e => e.CreatedOn >= min_date.Value);
}
if (max_date != null)
{
mbrs = mbrs.Where(e => e.CreatedOn <= max_date.Value);
}
if (min_date == null && max_date == null)
{
if (!show_success_records)
{
mbrs = mbrs.Where(e => !e.Success_Flag);
}
}
var mbrList = mbrs.OrderByDescending(u => u.CreatedOn).Skip(currentPage * currentPageSize).Take(currentPageSize).ToList();
var mbrsCount = mbrs;
int totalCount = mbrsCount.Count();
IEnumerable <EMemberRegistrationModel> mbrVMs = Mapper.Map <IEnumerable <EMemberRegistration>, IEnumerable <EMemberRegistrationModel> >(mbrList);
PaginationSet <EMemberRegistrationModel> pagedSet = new PaginationSet <EMemberRegistrationModel>()
{
Page = currentPage,
TotalCount = totalCount,
TotalPages = (int)Math.Ceiling((decimal)totalCount / currentPageSize),
Items = mbrVMs
};
return(Ok(pagedSet));
}
// GET: EMemberRegistrations
public async Task <ActionResult> Index()
{
logger.Info("Registration List Called");
IQueryable <EMemberRegistration> mbrs = EMemberRegistrationRepository.GetAll();
if (!this.TokenId.IsSuperAdmin)
{
mbrs = mbrs.Where(u => u.LocalNumber == this.TokenId.LocalNumber);
}
mbrs = mbrs.Where(e => !e.Success_Flag);
var mbrList = await mbrs.OrderByDescending(u => u.CreatedOn).ToListAsync();
IEnumerable <EMemberRegistrationViewModel> mbrVMs = Mapper.Map <IEnumerable <EMemberRegistration>, IEnumerable <EMemberRegistrationViewModel> >(mbrList);
HelperFunctions.FindTimssId(mbrVMs);
ViewData["DuesCardsPath"] = LocalSettingsConfig.LocalSettings.DuesCardsPath;
return(View(mbrVMs));
}
public ActionResult GetPendingCardsReport()
{
IQueryable <EMemberRegistration> mbrs = EMemberRegistrationRepository.GetAll();
if (!this.TokenId.IsSuperAdmin)
{
mbrs = mbrs.Where(u => u.LocalNumber == this.TokenId.LocalNumber);
}
mbrs = mbrs.Where(e => !e.Success_Flag);
var mbrList = mbrs.OrderByDescending(u => u.CreatedOn).ToList();
IEnumerable <EMemberRegistrationViewModel> mbrVMs = Mapper.Map <IEnumerable <EMemberRegistration>, IEnumerable <EMemberRegistrationViewModel> >(mbrList);
HelperFunctions.FindTimssId(mbrVMs);
string fileName = "L" + LocalSettingsConfig.LocalSettings.LocalNumber + "_PendingCards" + DateTime.UtcNow.ToString("_yyyymmdd_HHmmssfff");
fileName = HelperFunctions.PrepareExcelFile(mbrVMs, fileName);
return(File(fileName, "text/csv", Path.GetFileName(fileName)));
}
//private void FindTimssId(IEnumerable<EMemberRegistrationViewModel> mbrList) {
// foreach(var mbr in mbrList) {
// var timssId = TimssData.GetMemberId(mbr.Ssn);
// mbr.IsNewMember = timssId == string.Empty ? true : false;
// }
//}
public async Task <ActionResult> History(string local = null, DateTime?min_date = null, DateTime?max_date = null, string searchFilter = null, int?page = 0, int?pageSize = 20, bool?includeDiscarded = true)
{
int currentPage = page.Value;
int currentPageSize = pageSize.Value;
if (currentPage == 0)
{
currentPage = 1;
}
ViewBag.CurrentFilter = searchFilter;
ViewBag.MinDate = min_date;
ViewBag.MaxDate = max_date;
ViewBag.IncludeDiscarded = includeDiscarded;
IQueryable <EMemberRegistration> mbrs = EMemberRegistrationRepository.GetAll();
if (this.TokenId.IsSuperAdmin && local != null)
{
mbrs = mbrs.Where(u => u.LocalNumber == local);
}
if (!this.TokenId.IsSuperAdmin)
{
mbrs = mbrs.Where(u => u.LocalNumber == this.TokenId.LocalNumber);
}
if (min_date != null)
{
mbrs = mbrs.Where(e => e.CreatedOn >= min_date.Value);
}
if (max_date != null)
{
mbrs = mbrs.Where(e => e.CreatedOn <= max_date.Value);
}
if (searchFilter != null)
{
var values = searchFilter.Split(' ');
if (values.Length > 1 && values[0].Trim().Length > 0 && values[1].Trim().Length > 0)
{
//Search is by Name
string firstPart = values[0].Trim();
string secondPart = values[1].Trim();
mbrs = mbrs.Where(m =>
(m.First_Name.StartsWith(firstPart) && m.Last_Name.StartsWith(secondPart)) ||
(m.Last_Name.StartsWith(firstPart) && m.First_Name.StartsWith(secondPart)));
}
else
{
mbrs = mbrs.Where(m => m.Last_Name.Contains(searchFilter) || m.First_Name.Contains(searchFilter) ||
m.Ssn.Replace("-", "").Contains(searchFilter) || m.Member_Union_Id.Contains(searchFilter));
}
}
mbrs = mbrs.Where(e => e.Success_Flag);
if (includeDiscarded.HasValue && includeDiscarded.Value == false)
{
mbrs = mbrs.Where(e => e.Processed_Flag); // Skips the DISCARDED records
}
var mbrList = await mbrs.OrderByDescending(u => u.Processed_Date).ToListAsync();
var mbrVMs = Mapper.Map <IEnumerable <EMemberRegistration>, IEnumerable <EMemberRegistrationViewModel> >(mbrList);
return(View(mbrVMs.ToPagedList(currentPage, currentPageSize)));
}