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