public List <UploadLog> GetAllUploadsWithDetails(UploadSC uploadSC) { try { var query = Context.UploadLog.Include(u => u.User) .AsQueryable(); if (uploadSC != null) { if (uploadSC.UploadId > 0) { query = query.Where(u => u.Id == uploadSC.UploadId); } if (uploadSC.UploadStatusId?.Length > 0 && !uploadSC.UploadStatusId.Contains(null)) { query = query.Where(u => uploadSC.UploadStatusId.Contains(u.UploadStatus.GetValueOrDefault())); } if (uploadSC.UploadDateFrom.HasValue && uploadSC.UploadDateFrom.Value != DateTime.MinValue) { query = query.Where(u => u.CreationTime.Value.Date >= uploadSC.UploadDateFrom); } if (uploadSC.UploadDateTo.HasValue && uploadSC.UploadDateTo.Value != DateTime.MinValue) { query = query.Where(u => u.CreationTime.Value.Date <= uploadSC.UploadDateTo); } } return(query.OrderByDescending(u => u.CreationTime).ToList()); } catch (Exception e) { return(null); } }
private UploadLogVM[] SearchUploads(UploadSC uploadSC) { var model = unitOfWork.UploadLogBL.GetAllUploadsWithDetails(uploadSC) .Select(u => new UploadLogVM(u)) .ToArray(); return(model); }
public PartialViewResult _UploadsList(UploadSC uploadSC) { try { var model = SearchUploads(uploadSC); return(PartialView(model)); } catch (Exception e) { return(PartialView(null)); } }