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