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)); }