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