public ReturnResult <SearchCaseResult> GetCaseswithNoAnalyst(CaseSearch caseSearch, int UserID)
{
ReturnResult <SearchCaseResult> result = new ReturnResult <SearchCaseResult>();
try
{
result = _dbHandler.GetCaseswithNoAnalyst(caseSearch, UserID);
return(result);
}
catch (Exception ex)
{
result.status = _eHandler.HandleException(ex);
return(result);
}
}
public ReturnResult <SearchCaseResult> GetCaseSearch(CaseSearch caseSearch)
{
ReturnResult <SearchCaseResult> result = new ReturnResult <SearchCaseResult>();
try
{
result = _dbHandler.GetCaseSearch(caseSearch);
return(result);
}
catch (Exception ex)
{
result.status = _eHandler.HandleException(ex);
return(result);
}
}
public async Task <PagedEntity <Case> > SearchCases(CaseSearch caseSearch, int pageIndex, int pageSize)
{
var query = Set.Include(c => c.City.Region.Country)
.Include(c => c.District);
if (!string.IsNullOrEmpty(caseSearch.CaseName))
{
query = query.Where(c => c.Name.Contains(caseSearch.CaseName));
}
if (!string.IsNullOrEmpty(caseSearch.Phone))
{
query = query.Where(c => c.Phone.Contains(caseSearch.Phone));
}
if (caseSearch.CaseType.HasValue && caseSearch.CaseType.Value > 0)
{
query = query.Where(c => c.CaseType == caseSearch.CaseType.Value);
}
if (caseSearch.CountryId > 0)
{
query = query.Where(c => c.City.Region.CountryId == caseSearch.CountryId);
}
if (caseSearch.RegionId > 0)
{
query = query.Where(c => c.City.RegionId == caseSearch.RegionId);
}
if (caseSearch.CityId > 0)
{
query = query.Where(c => c.CityId == caseSearch.CityId);
}
if (caseSearch.DistrictId > 0)
{
query = query.Where(c => c.DistrictId == caseSearch.DistrictId);
}
if (caseSearch.CaseStatus.HasValue && caseSearch.CaseStatus.Value > 0)
{
query = query.Where(c => c.CaseStatus == caseSearch.CaseStatus.Value);
}
int totalItemCount = await query.CountAsync();
var items = await query.OrderBy(c => c.Name)
.Skip(pageIndex * pageSize).Take(pageSize)
.ToListAsync();
return(new PagedEntity <Case>(items, totalItemCount));
}
public async Task <PagedEntity <CaseViewModel> > GetCases(SearchCaseViewModel searchViewModel)
{
if (searchViewModel == null)
{
throw new ArgumentNullException(nameof(searchViewModel));
}
var caseSearch = new CaseSearch
{
CaseName = searchViewModel.CaseName,
CaseStatus = (Sanable.Cases.Domain.Model.CaseStatus)searchViewModel.CaseStatus,
CaseType = (Sanable.Cases.Domain.Model.CaseTypes)searchViewModel.CaseType,
CityId = searchViewModel.CityId,
CountryId = searchViewModel.CountryId,
DistrictId = searchViewModel.DistrictId,
Phone = searchViewModel.Phone,
};
PagedEntity <Case> result = await _caseUnitOfWork.CaseRepository
.SearchCases(caseSearch
, searchViewModel.PageIndex, searchViewModel.PageSize);
return(new PagedEntity <CaseViewModel>(result.Items.Select(c => GetCaseViewModel(c)), result.TotalCount));
}
public HttpResponseMessage GetCaseswithNoAnalyst([FromBody] CaseSearch caseSearch, [FromUri] int UserID)
{
//Appl accService = new AccountManagementService();
HttpStatusCode ReturnCode = HttpStatusCode.OK;
TranInfo <SearchCaseResult> transaction = new TranInfo <SearchCaseResult>();
ReturnResult <SearchCaseResult> result = new ReturnResult <SearchCaseResult>();
try
{
result = _service.GetCaseswithNoAnalyst(caseSearch, UserID);
if (result.status.Status == StatusEnum.Success)
{
transaction.data = result.result;
transaction.status = true;
}
else
{
transaction.status = false;
transaction.AddException(result.status.StatusMessage);
}
}
catch (Exception ex)
{
transaction.status = false;
transaction.AddException(ex.Message);
ReturnCode = HttpStatusCode.InternalServerError;
result.status = _eHandler.HandleException(ex);
_commonService.LogError(result.status);
//if (ex.InnerException != null) { InnerExceptionMessage = ex.InnerException.Message; }
//LogHelper.Instance.Error(CorrelationID, Username, Request.GetRequestContext().VirtualPathRoot, ex.Message, InnerExceptionMessage, 0, ex);
}
return(Request.CreateResponse <TranInfo <SearchCaseResult> >(ReturnCode, transaction));
}
public ReturnResult <SearchCaseResult> GetCaseSearch(CaseSearch caseSearch)
{
ReturnResult <SearchCaseResult> result = new ReturnResult <SearchCaseResult>();
try
{
SearchCaseResult searchResult = new SearchCaseResult();
//List<CustomerInfo accounts = new CustomerInfo();
using (DashboardDataContext db = new DashboardDataContext(_connString))
{
string errorMessage = "";
int? TotalCount = 0;
var Resultdb = db.USP_SearchCase_Get(caseSearch.FirstName, caseSearch.LastName, caseSearch.APNNumber,
caseSearch.Analyst.UserID, caseSearch.HearingOfficer.UserID, caseSearch.FromDate, caseSearch.ToDate, caseSearch.AddressLine1,
caseSearch.AddressLine2, caseSearch.Zip, caseSearch.PhoneNumber, caseSearch.CaseNumber, caseSearch.CaseStatus,
caseSearch.SortBy, caseSearch.SortReverse,
caseSearch.PageSize, caseSearch.CurrentPage, ref TotalCount, ref errorMessage);
foreach (var item in Resultdb)
{
SearchResultCaseInfo caseInfo = new SearchResultCaseInfo();
caseInfo.C_ID = Convert.ToInt32(item.C_ID);
caseInfo.CaseID = item.CaseID;
caseInfo.RankNo = Convert.ToInt32(item.RankNo);
caseInfo.ActivityID = Convert.ToInt32(item.ActivityID);
caseInfo.ActivityName = Convert.ToString(item.ActivityName);
caseInfo.CreatedDate = Convert.ToDateTime(item.CreatedDate);
caseInfo.LastModifiedDate = Convert.ToDateTime(item.LastModifiedDate);
caseInfo.Analyst = Convert.ToString(item.Analyst);
caseInfo.HearingOfficer = Convert.ToString(item.HearingOfficer);
caseInfo.TenantName = Convert.ToString(item.TenantName);
caseInfo.ApplicantAddressLine1 = Convert.ToString(item.ApplicantAddressLine1);
caseInfo.ApplicantAddressLine2 = Convert.ToString(item.ApplicantAddressLine2);
caseInfo.ApplicantCity = Convert.ToString(item.ApplicantCity);
caseInfo.ApplicantStateID = Convert.ToInt32(item.ApplicantStateID);
caseInfo.ApplicantStateCode = Convert.ToString(item.ApplicantStateCode);
caseInfo.ApplicantZip = Convert.ToString(item.ApplicantZip);
caseInfo.OwnerName = Convert.ToString(item.OwnerName);
caseInfo.OPOwnerName = Convert.ToString(item.OPOwnerName);
caseInfo.OPAddressLine1 = Convert.ToString(item.OPAddressLine1);
caseInfo.OPAddressLine2 = Convert.ToString(item.OPAddressLine2);
caseInfo.OPStateCode = Convert.ToString(item.OPStateCode);
caseInfo.OPCity = Convert.ToString(item.OPCity);
caseInfo.OPOwnerZip = Convert.ToString(item.OPOwnerZip);
caseInfo.OwnerTenantName = Convert.ToString(item.OwnerTenantName);
caseInfo.PetitionCategoryID = Convert.ToInt32(item.PetitionCategoryID);
searchResult.List.Add(caseInfo);
}
searchResult.PageSize = caseSearch.PageSize;
searchResult.SortBy = caseSearch.SortBy;
searchResult.SortReverse = caseSearch.SortReverse;
searchResult.CurrentPage = caseSearch.CurrentPage;
searchResult.TotalCount = (int)TotalCount;
}
result.result = searchResult;
result.status = new OperationStatus()
{
Status = StatusEnum.Success
};
return(result);
}
catch (Exception ex)
{
IExceptionHandler eHandler = new ExceptionHandler();
result.status = eHandler.HandleException(ex);
commondbHandler.SaveErrorLog(result.status);
return(result);
}
}
