public ActionResult CustomerActivityTypeUploadDetails(CustomerActivityTypeUploadListModelFilter filter = null, int pageNumber = 1)
{
try
{
int totalRecords;
var model = _customerActivityTypeUploadService.GetCustomerActivityTypeUploadDetails(pageNumber, _pageSize, filter, out totalRecords) ??
new CustomerActivityTypeUploadListModel();
model.Filter = filter;
var currentAction = ControllerContext.RouteData.Values["action"].ToString();
Func <int, string> urlFunc =
pn =>
Url.Action(currentAction,
new
{
pageNumber = pn,
filter.FromUploadDate,
filter.ToUploadDate,
filter.UploadedBy
});
model.PagingModel = new PagingModel(pageNumber, _pageSize, totalRecords, urlFunc);
return(View(model));
}
catch (Exception ex)
{
_logger.Error(string.Format("EligibilityUpload Details\nException occurred"));
_logger.Error(string.Format("Exception message: {0}\n\tStackTrace:{1}", ex.Message, ex.StackTrace));
var model = new CustomerActivityTypeUploadListModel {
Filter = filter
};
return(View(model));
}
}
public CustomerActivityTypeUploadListModel GetCustomerActivityTypeUploadDetails(int pageNumber, int pageSize, CustomerActivityTypeUploadListModelFilter filter, out int totalRecords)
{
var customerActivityTypeUploads = (IReadOnlyCollection <CustomerActivityTypeUpload>)_customerActivityTypeUploadRepository.GetByFilter(pageNumber, pageSize, filter, out totalRecords);
if (customerActivityTypeUploads == null || !customerActivityTypeUploads.Any())
{
return(null);
}
var successfileIds = customerActivityTypeUploads.Select(s => s.FileId).ToArray();
var failedfileIds = customerActivityTypeUploads.Where(x => x.LogFileId.HasValue).Select(s => s.LogFileId.Value).ToArray();
var fileIds = successfileIds.Concat(failedfileIds).ToArray();
IEnumerable <FileModel> fileModels = null;
if (fileIds != null && fileIds.Any())
{
var files = _fileRepository.GetByIds(fileIds);
if (files != null && files.Any())
{
fileModels = GetFileModelFromFile(files, _mediaRepository.GetCustomerActivityTypeUploadMediaFileLocation());
}
}
var customerActivityTypeUploadByIds = customerActivityTypeUploads.Select(c => c.UploadedBy).ToArray();
IEnumerable <OrderedPair <long, string> > uploadedbyNameIdPair = null;
uploadedbyNameIdPair = _organizationRoleUserRepository.GetNameIdPairofUsers(customerActivityTypeUploadByIds).ToArray();
return(GetListModel(fileModels, customerActivityTypeUploads, uploadedbyNameIdPair));
}
public IEnumerable <CustomerActivityTypeUpload> GetByFilter(int pageNumber, int pageSize, CustomerActivityTypeUploadListModelFilter filter, out int totalRecords)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var linqMetaData = new LinqMetaData(adapter);
if (filter == null)
{
totalRecords = linqMetaData.CustomerActivityTypeUpload.Count();
var entities = linqMetaData.CustomerActivityTypeUpload.OrderByDescending(p => p.UploadTime).TakePage(pageNumber, pageSize).Select(x => x).ToArray();
return(Mapper.Map <IEnumerable <CustomerActivityTypeUploadEntity>, IEnumerable <CustomerActivityTypeUpload> >(entities));
}
else
{
var query = (from c in linqMetaData.CustomerActivityTypeUpload select c);
if (filter.FromUploadDate.HasValue)
{
query = (from c in query
where c.UploadTime.Date >= filter.FromUploadDate.Value.Date
select c);
}
if (filter.ToUploadDate.HasValue)
{
query = (from c in query
where c.UploadTime.Date <= filter.ToUploadDate.Value.Date
select c);
}
if (filter.UploadedBy.HasValue && filter.UploadedBy > 0)
{
query = (from c in query
where c.UploadedBy == filter.UploadedBy
select c);
}
totalRecords = query.Count();
var entities = query.OrderByDescending(p => p.UploadTime).TakePage(pageNumber, pageSize).Select(x => x).ToArray();
return(Mapper.Map <IEnumerable <CustomerActivityTypeUploadEntity>, IEnumerable <CustomerActivityTypeUpload> >(entities));
}
}
}
