/// <summary> /// Add a new search tab to the tab control /// </summary> private void AddSearchTab() { CloseableTabItem cti = new CloseableTabItem(); cti.Header = "New Search " + _searchNumber.ToString(CultureInfo.CurrentCulture); _searchNumber++; Grid g = new Grid(); Frame f = new Frame(); SearchView sv = new SearchView(); SearchViewModel svm = sv.DataContext as SearchViewModel; if (!string.IsNullOrEmpty(Properties.Settings.Default.SavedSearch)) { MemoryStream ms = new MemoryStream(Encoding.ASCII.GetBytes(Properties.Settings.Default.SavedSearch)); XmlSerializer xml = new XmlSerializer(typeof(DrawingSearchModel)); DrawingSearchModel dsm = xml.Deserialize(ms) as DrawingSearchModel; svm.Model = dsm; } f.Navigate(sv); g.Children.Add(f); cti.Content = g; tabControl1.Items.Add(cti); tabControl1.SelectedItem = cti; }
public List <SearchDrawingResponseModel> Search(DrawingSearchModel searchData) { try { List <FilterEntity> listFilters = _filterService.GetFilters(); var listDepartment = listFilters.Where(filter => filter.FilterType == "Department").ToList(); using (var dbContext = new PMSEntities()) { var query = dbContext.tblDrawings.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.DrawingTitle)) { query = query.Where(i => i.DrawingTitle.Contains(searchData.DrawingTitle)).ToList(); } if (searchData.Department > 0) { query = query.Where(i => i.Department == searchData.Department).ToList(); } if (!string.IsNullOrEmpty(searchData.DrawingNo)) { query = query.Where(i => i.DrawingNo.Contains(searchData.DrawingNo)).ToList(); } if (query != null && query.Count > 0) { return(query.Select(i => new SearchDrawingResponseModel { Id = i.Id, DrawingId = i.DrawingId, ProjectCode = i.ProjectCode, Department = listDepartment.Where(x => x.FilterCode == i.Department.Value.ToString()).FirstOrDefault().FilterName, DrawingNo = i.DrawingNo, DrawingDate = i.DrawingDate.HasValue?i.DrawingDate.Value.ToString("dd-MM-yyyy"):"", DrawingTitle = i.DrawingTitle, FilePath = i.FilePath }).ToList()); } } } } catch (Exception ex) { } return(null); }
public JsonResult SearchDrawing(DrawingSearchModel searchModel) { var result = _drawingService.Search(searchModel); return(Json(result, JsonRequestBehavior.AllowGet)); }
public List <SearchDrawingResponseModel> Search(DrawingSearchModel searchData) { return(_drawingRepository.Search(searchData)); }