public List <SearchCorrespondenceModel> SearchCorrespondence(CorrespondenceSearchModel searchData)
{
try
{
using (var dbContext = new PMSEntities())
{
var query = dbContext.tblCorrespondences.ToList();
if (query != null && query.Count > 0)
{
if (!string.IsNullOrEmpty(searchData.ProjectCode))
{
query = query.Where(i => i.ProjectCode == searchData.ProjectCode).ToList();
}
if (searchData.CorrespondenceType > 0)
{
query = query.Where(i => i.CorrespondenceType == searchData.CorrespondenceType).ToList();
}
if (!string.IsNullOrEmpty(searchData.LetterNo))
{
query = query.Where(i => i.LetterNo == searchData.LetterNo).ToList();
}
if (!string.IsNullOrEmpty(searchData.Keywords))
{
query = query.Where(i => i.Keywords.Contains(searchData.Keywords)).ToList();
}
if (query != null && query.Count > 0)
{
return(query.Select(i => new SearchCorrespondenceModel
{
Id = i.Id,
CorrespondenceId = i.CorrespondenceId,
CorrespondenceType = (i.CorrespondenceType == 1 ? "InWard" : "OutWard"),
ProjectCode = i.ProjectCode,
Department = i.Department,
Subject = i.Subject,
LetterNo = i.LetterNo,
LetterDate = i.LetterDate,
FilePath = i.FilePath
}).ToList());
}
}
}
}
catch (Exception ex)
{
}
return(null);
}
public List <SearchCorrespondenceModel> SearchCorrespondence(CorrespondenceSearchModel searchData)
{
return(_correspondenceRepository.SearchCorrespondence(searchData));
}
public JsonResult SearchCorrespondence(CorrespondenceSearchModel correspondenceSearchModel)
{
var result = _correspondenceService.SearchCorrespondence(correspondenceSearchModel);
return(Json(result, JsonRequestBehavior.AllowGet));
}
