public List <SearchInwardResponseModel> SearchInward(InwardSearchModel searchData) { try { using (var dbContext = new PMSEntities()) { var query = dbContext.tblInwardWOes.ToList(); if (query != null && query.Count > 0) { if (!string.IsNullOrEmpty(searchData.ProjectCode)) { query = query.Where(i => i.ProjectCode.Equals(searchData.ProjectCode, StringComparison.InvariantCultureIgnoreCase)).ToList(); } if (!string.IsNullOrEmpty(searchData.BranchCode)) { query = query.Where(i => i.BranchCode == searchData.BranchCode).ToList(); } if (!string.IsNullOrEmpty(searchData.ClientName)) { query = query.Where(i => i.ClientName.Contains(searchData.ClientName)).ToList(); } if (!string.IsNullOrEmpty(searchData.WorkOrderNo)) { query = query.Where(i => i.WorkOrderNo.Contains(searchData.WorkOrderNo)).ToList(); } if (query != null && query.Count > 0) { return(query.Select(i => new SearchInwardResponseModel { Id = i.Id, WOId = i.WOId, ProjectCode = i.ProjectCode, BranchCode = i.BranchCode, ClientName = i.ClientName, WorkOrderNo = i.WorkOrderNo, FilePath = i.WOPath }).ToList()); } } } } catch (Exception ex) { } return(null); }
public List <SearchInwardResponseModel> SearchInward(InwardSearchModel searchData) { return(_workOrderRepository.SearchInward(searchData)); }
public JsonResult SearchInward(InwardSearchModel searchModel) { var result = _workOrderService.SearchInward(searchModel); return(Json(result, JsonRequestBehavior.AllowGet)); }