public List <SearchReportsResponseModel> Search(ReportsSearchModel searchData)
{
try
{
List <FilterEntity> listFilters = _filterService.GetFilters();
var listDepartment = listFilters.Where(filter => filter.FilterType == "Department").ToList();
using (var dbContext = new PMSEntities())
{
var query = dbContext.tblReports.ToList();
if (query != null && query.Count > 0)
{
if (!string.IsNullOrEmpty(searchData.ProjectCode))
{
query = query.Where(i => i.ProjectCode.Contains(searchData.ProjectCode)).ToList();
}
if (!string.IsNullOrEmpty(searchData.ReportTitle))
{
query = query.Where(i => i.ReportTitle.Contains(searchData.ReportTitle)).ToList();
}
if (searchData.Department > 0)
{
query = query.Where(i => i.Department == searchData.Department).ToList();
}
if (!string.IsNullOrEmpty(searchData.ReportNo))
{
query = query.Where(i => i.ReportNo.Contains(searchData.ReportNo)).ToList();
}
if (query != null && query.Count > 0)
{
return(query.Select(i => new SearchReportsResponseModel
{
Id = i.Id,
ReportId = i.ReportId,
ProjectCode = i.ProjectCode,
Department = listDepartment.Where(x => x.FilterCode == i.Department.Value.ToString()).FirstOrDefault().FilterName,
ReportNo = i.ReportNo,
ReportDate = i.ReportDate.HasValue ? i.ReportDate.Value.ToString("dd-MM-yyyy") : "",
ReportTitle = i.ReportTitle,
FilePath = i.FilePath
}).ToList());
}
}
}
}
catch (Exception ex)
{
}
return(new List <SearchReportsResponseModel>());
}
public JsonResult SearchReports(ReportsSearchModel searchModel)
{
var result = _reportsService.Search(searchModel);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public IActionResult Search(ReportsSearchModel model)
{
model.Search();
return(View(model));
}
public List <SearchReportsResponseModel> Search(ReportsSearchModel searchData)
{
return(_reportsRepository.Search(searchData));
}
