public int GetSearchTotal(RequestSearchRequest searchRequest)
{
var criteria = CreateSearchCriteria(searchRequest);
criteria.SetProjection(Projections.RowCount());
return((int)criteria.UniqueResult());
}
public List <Model.Models.Request> Get(RequestSearchRequest request, bool showAll)
{
var requests = _context.EmployeeRequest.AsQueryable();
if ((int)(requests.Count() / request.ItemsPerPage + 0.5) > request.ItemsPerPage)
{
return(null);
}
//if (!showAll)
// requests = requests.Where(x => x.Phase != 3);
if (request.EmployeeId != null)
{
requests = requests.Where(x => x.EmployeeId == request.EmployeeId);
}
if (request.Phase != null)
{
requests = requests.Where(x => x.Phase == request.Phase);
}
requests = requests
.Skip((request.Page - 1) * request.ItemsPerPage)
.Take(request.ItemsPerPage);
var list = requests.ToList();
return(_mapper.Map <List <Model.Models.Request> >(list));
}
protected ICriteria CreateSearchCriteria(RequestSearchRequest searchRequest)
{
ICriteria criteria = Session.CreateCriteria(typeof(Request));
SimpleExpression shortDescExp = Restrictions.Like("ShortDesc", searchRequest.RequestQuery,
MatchMode.Anywhere);
SimpleExpression longDescExp = Restrictions.Like("LongDesc", searchRequest.RequestQuery, MatchMode.Anywhere);
SimpleExpression dashboardDesc = Restrictions.Like("DashboardDescription", searchRequest.RequestQuery,
MatchMode.Anywhere);
AbstractCriterion or = Restrictions.Or(shortDescExp, longDescExp);
AbstractCriterion or1 = Restrictions.Or(or, dashboardDesc);
criteria.Add(or1);
if (searchRequest.SystemId > 0)
{
criteria.Add(Restrictions.Eq("WrmsSystem.Id", searchRequest.SystemId));
}
if (searchRequest.RequestStatusId > 0)
{
criteria.Add(Restrictions.Eq("RequestStatus.Id", searchRequest.RequestStatusId));
}
if (searchRequest.ProjectManagerId > 0)
{
criteria.Add(Restrictions.Eq("ProjectManager.Id", searchRequest.ProjectManagerId));
}
return(criteria);
}
public SearchResultFormViewModel<RequestDto, RequestSearchRequest> CreateFormViewModel(
RequestSearchRequest searchRequest)
{
var viewModel = new SearchResultFormViewModel<RequestDto, RequestSearchRequest> { SearchRequest = searchRequest };
searchRequest.Systems = _wrmsSystemManagementService.GetActiveSystems();
searchRequest.ProjectManagers = _personManagementService.GetActiveStaff();
searchRequest.RequestStatuses = _requestStatusManagementService.GetAll();
return viewModel;
}
public virtual void CanGetSearchTotal()
{
var searchRequest = new RequestSearchRequest {
RequestQuery = "casen"
};
int results = _requestRepository.GetSearchTotal(searchRequest);
Assert.That(results == 10);
}
public virtual void CanSearch()
{
var searchRequest = new RequestSearchRequest {
RequestQuery = "e"
};
IList <RequestDto> results = _requestRepository.Search(searchRequest, 0, 20);
Assert.That(results.Count > 1 && results.Count <= 20);
}
private async void frmMostActiveUsers_Load(object sender, System.EventArgs e)
{
var suppliersReport = new List <SupplierReport>();
var clientReport = new List <ClientReport>();
var userSearchRequest = new UserSearchReqeust
{
RoleId = (int)RoleId.Client
};
var clients = await _authService.GetUsers(userSearchRequest);
userSearchRequest.RoleId = (int)RoleId.Supplier;
var suppliers = await _authService.GetUsers(userSearchRequest);
foreach (var client in clients)
{
var requestSearchRequest = new RequestSearchRequest
{
StatusId = (int)EStatus.Finished,
UserId = client.Id
};
var numberOfFinishedRequests = (await _requestService.GetAll <List <Offer> >(requestSearchRequest)).Count;
clientReport.Add(new ClientReport
{
Client = $"{client.FirstName} {client.LastName}",
NumberOfFinishedRequests = numberOfFinishedRequests
});
}
foreach (var supplier in suppliers)
{
var offerRequest = new OfferSearchRequest
{
OfferStatusId = (int)EOfferStatus.Finished,
UserId = supplier.Id
};
var numberOfFinishedOffers = (await _offerService.GetAll <List <Offer> >(offerRequest)).Count;
suppliersReport.Add(new SupplierReport
{
Company = supplier.Company,
NumberOfFinishedRequests = numberOfFinishedOffers
});
}
ClientReportBindingSource.DataSource = clientReport.OrderByDescending(a => a.NumberOfFinishedRequests).ToList();
SupplierReportBindingSource.DataSource = suppliersReport.OrderByDescending(a => a.NumberOfFinishedRequests).ToList();
this.rvMostActive.RefreshReport();
}
public SearchResultFormViewModel <RequestDto, RequestSearchRequest> CreateFormViewModel(
RequestSearchRequest searchRequest)
{
var viewModel = new SearchResultFormViewModel <RequestDto, RequestSearchRequest> {
SearchRequest = searchRequest
};
searchRequest.Systems = _wrmsSystemManagementService.GetActiveSystems();
searchRequest.ProjectManagers = _personManagementService.GetActiveStaff();
searchRequest.RequestStatuses = _requestStatusManagementService.GetAll();
return(viewModel);
}
public SearchResultFormViewModel<RequestDto, RequestSearchRequest> CreateFormViewModel()
{
var searchRequest = new RequestSearchRequest();
//Set status to active by default
searchRequest.RequestStatusId = 1;
SearchResultFormViewModel<RequestDto, RequestSearchRequest> viewModel = Search(searchRequest);
searchRequest.Systems = _wrmsSystemManagementService.GetActiveSystems();
searchRequest.ProjectManagers = _personManagementService.GetActiveStaff();
searchRequest.RequestStatuses = _requestStatusManagementService.GetAll();
viewModel.SearchRequest = searchRequest;
return viewModel;
}
public SearchResultFormViewModel <RequestDto, RequestSearchRequest> CreateFormViewModel()
{
var searchRequest = new RequestSearchRequest();
//Set status to active by default
searchRequest.RequestStatusId = 1;
SearchResultFormViewModel <RequestDto, RequestSearchRequest> viewModel = Search(searchRequest);
searchRequest.Systems = _wrmsSystemManagementService.GetActiveSystems();
searchRequest.ProjectManagers = _personManagementService.GetActiveStaff();
searchRequest.RequestStatuses = _requestStatusManagementService.GetAll();
viewModel.SearchRequest = searchRequest;
return(viewModel);
}
public ActionResult Search(RequestSearchRequest searchRequest)
{
SearchResultFormViewModel <RequestDto, RequestSearchRequest> formViewModel = null;
try
{
formViewModel = _requestSearchManagementService.Search(searchRequest);
Session.Add(SEARCH_PARAMETERS, searchRequest);
}
catch (PreconditionException pde)
{
TempData[ControllerEnums.GlobalViewDataProperty.PageMessage.ToString()] = pde.Message;
formViewModel = _requestSearchManagementService.CreateFormViewModel(searchRequest);
}
return(View("Index", formViewModel));
}
private async void frmReportRequests_Load(object sender, EventArgs e)
{
var searchRequest = new RequestSearchRequest
{
StatusId = (int)EStatus.Finished
};
var requestList = await _requestService.GetAll <List <Request> >(searchRequest);
var sourceList = new List <RequestReport>();
foreach (var request in requestList)
{
var client = await _authService.GetById(request.ClientId);
var clientAddress = await _addressService.GetById <Address>((int)client.AddressId);
var requestAddress = await _addressService.GetById <Address>(request.DeliveryAddress);
var offerRequest = new OfferSearchRequest
{
OfferStatusId = (int)EOfferStatus.Finished,
RequestId = request.RequestId
};
var finishedOffer = await _offerService.GetAll <List <Offer> >(offerRequest);
var companyId = finishedOffer[0].UserId;
var company = await _authService.GetById(companyId);
var requestRow = new RequestReport
{
Client = $"{client.FirstName} {client.LastName}",
AddressFrom = clientAddress.City,
AddressTo = requestAddress.City,
Company = company.Company,
Date = request.Date,
Price = $"{request.Price} $"
};
sourceList.Add(requestRow);
}
RequestReportBindingSource.DataSource = sourceList;
this.rvRequests.RefreshReport();
}
public SearchResultFormViewModel <RequestDto, RequestSearchRequest> Search(RequestSearchRequest searchRequest)
{
//make sure at least one field set
//Check.Require(searchRequest != null, "At least one field is required");
//if (String.IsNullOrEmpty(searchRequest.RequestQuery))
//{
// Check.Require(1 == 0, "At least one field is required");
//}
if (searchRequest.CurrentPageNumber == 0)
{
searchRequest.CurrentPageNumber = 1;
}
if (string.IsNullOrEmpty(searchRequest.SortColumn))
{
searchRequest.SortColumn = DEFAULT_SORT_COLUMN;
searchRequest.SortOrder = DEFAULT_SORT_ORDER;
}
const int entriesPerPage = 20;
int offset = entriesPerPage * (searchRequest.CurrentPageNumber - 1);
IList <RequestDto> searchResultItems = _requestRepository.Search(searchRequest, offset, entriesPerPage);
var searchResultFormViewModel = CreateFormViewModel(searchRequest);
searchResultFormViewModel.PageResultItems = searchResultItems;
int resultCount = _requestRepository.GetSearchTotal(searchRequest);
searchResultFormViewModel.TotalResultCount = resultCount;
searchResultFormViewModel.CurrentPageNumber = searchRequest.CurrentPageNumber;
searchResultFormViewModel.TotalPageCount = resultCount / entriesPerPage;
if (resultCount % entriesPerPage > 0)
{
searchResultFormViewModel.TotalPageCount++;
}
return(searchResultFormViewModel);
}
public List <Model.DTO.RequestDTO> GetRequests(RequestSearchRequest req)
{
var query = _context.Requests
.Include(x => x.User)
.AsQueryable();
var role = usersService.GetCurrentUser().Role.RoleName;
if (role == "User")
{
query = query.Where(x => x.UserId == usersService.GetCurrentUser().UserId);
}
else if (req != null && req.UserId != 0)
{
query = query.Where(x => x.UserId == req.UserId);
}
var list = query.ToList();
return(_mapper.Map <List <Model.DTO.RequestDTO> >(list));
}
public SearchResultFormViewModel<RequestDto, RequestSearchRequest> Search(RequestSearchRequest searchRequest)
{
//make sure at least one field set
//Check.Require(searchRequest != null, "At least one field is required");
//if (String.IsNullOrEmpty(searchRequest.RequestQuery))
//{
// Check.Require(1 == 0, "At least one field is required");
//}
if (searchRequest.CurrentPageNumber == 0)
{
searchRequest.CurrentPageNumber = 1;
}
if (string.IsNullOrEmpty(searchRequest.SortColumn))
{
searchRequest.SortColumn = DEFAULT_SORT_COLUMN;
searchRequest.SortOrder = DEFAULT_SORT_ORDER;
}
const int entriesPerPage = 20;
int offset = entriesPerPage * (searchRequest.CurrentPageNumber - 1);
IList<RequestDto> searchResultItems = _requestRepository.Search(searchRequest, offset, entriesPerPage);
var searchResultFormViewModel = CreateFormViewModel(searchRequest);
searchResultFormViewModel.PageResultItems = searchResultItems;
int resultCount = _requestRepository.GetSearchTotal(searchRequest);
searchResultFormViewModel.TotalResultCount = resultCount;
searchResultFormViewModel.CurrentPageNumber = searchRequest.CurrentPageNumber;
searchResultFormViewModel.TotalPageCount = resultCount / entriesPerPage;
if (resultCount % entriesPerPage > 0)
{
searchResultFormViewModel.TotalPageCount++;
}
return searchResultFormViewModel;
}
private async void frmRequestsDetail_Load(object sender, EventArgs e)
{
var searchRequest = new RequestSearchRequest()
{
Page = _page,
ItemsPerPage = 4
};
var request = await _service.Get <List <EToolService.Model.Models.Request> >(searchRequest);
if (request == null)
{
return;
}
if (request.Count == 0)
{
_page--;
return;
}
ClearPanel();
for (int i = 0; i < request.Count; i++)
{
var employeeId = request[i].EmployeeId;
var employee = await new APIService("Employee").GetById <EToolService.Model.Models.Employee>(employeeId);
var control = new RequestDetail(request[i], $"{employee.FirstName} {employee.LastName}")
{
ParentForm = this
};
control.Dock = DockStyle.Top;
control.Show();
pnlRequests.Controls.Add(control);
}
lblPageCounter.Text = _page.ToString();
pnlRequests.Show();
}
public async Task Init()
{
if (CountryList.Count == 0)
{
var anyCountry = new Country
{
CountryId = -1,
Name = "Any"
};
CountryList.Add(anyCountry);
var countryList = await _countryService.GetAll <List <Country> >();
foreach (var country in countryList)
{
CountryList.Add(country);
}
SelectedCountry = anyCountry;
}
if (StatusList.Count == 0)
{
var anyStatus = new Model.Status
{
StatusId = -1,
Name = "Any"
};
StatusList.Add(anyStatus);
var statusList = await _statusService.GetAll <List <Model.Status> >();
foreach (var status in statusList)
{
StatusList.Add(status);
}
SelectedStatus = anyStatus;
}
int?maximumRoomsInt = null;
int?minimumPriceInt = null;
try
{
maximumRoomsInt = int.Parse(MaximumRooms);
}
catch (System.Exception)
{}
try
{
minimumPriceInt = int.Parse(MinimumPrice);
}
catch (System.Exception)
{ }
var searchRequest = new RequestSearchRequest
{
MaximumRooms = maximumRoomsInt,
MinimumPrice = minimumPriceInt,
ShowInactive = false
};
if (SelectedCountry != null && SelectedCountry.CountryId != -1)
{
searchRequest.CountryId = SelectedCountry.CountryId;
}
if (SelectedStatus != null && SelectedStatus.StatusId != -1)
{
searchRequest.StatusId = SelectedStatus.StatusId;
}
var requestList = await _requestService.GetAll <List <Request> >(searchRequest);
RequestList.Clear();
foreach (var request in requestList)
{
var user = await _authService.GetById(request.ClientId);
var userAddress = await _addressService.GetById <Address>((int)user.AddressId);
var userCountry = await _countryService.GetById <Country>((int)userAddress.CountryId);
var requestAddress = await _addressService.GetById <Address>(request.DeliveryAddress);
var requestCountry = await _countryService.GetById <Country>((int)requestAddress.CountryId);
var newRequest = new RequestModel
{
FromCountry = userCountry.Name,
FullName = user.FirstName + " " + user.LastName,
Price = request.Price,
RequestId = request.RequestId,
ToCountry = requestCountry.Name
};
RequestList.Add(newRequest);
}
if (RequestList.Count > 0)
{
ShowList = true;
HideList = false;
}
else
{
ShowList = false;
HideList = true;
}
}
public IList <RequestDto> Search(RequestSearchRequest searchRequest, int offset, int maxEntries)
{
ICriteria criteria = CreateSearchCriteria(searchRequest)
.CreateAlias("ProjectManager", "ProjectManager", JoinType.LeftOuterJoin)
.CreateAlias("WrmsSystem", "WrmsSystem", JoinType.LeftOuterJoin)
.CreateAlias("RequestStatus", "RequestStatus", JoinType.LeftOuterJoin)
.SetProjection(Projections.ProjectionList()
.Add(Projections.Property("Id"), "Id")
.Add(Projections.Property("ShortDesc"), "ShortDesc")
.Add(Projections.Property("LongDesc"), "LongDesc")
.Add(Projections.Property("WorkPlanId"), "WorkPlanId")
.Add(Projections.Property("CabPriority"), "CabPriority")
.Add(Projections.Property("PhaseId"), "PhaseId")
.Add(Projections.Property("BudgetedDollarAmount"), "BudgetedDollarAmount")
.Add(Projections.Property("BudgetedDollarSpent"), "BudgetedDollarSpent")
.Add(Projections.Property("BudgetLocationDeptId"), "BudgetLocationDeptId")
.Add(Projections.Property("AllocatedHoursForIT"), "AllocatedHoursForIT")
.Add(Projections.Property("AllocatedHoursForRequestor"), "AllocatedHoursForRequestor")
.Add(Projections.Property("ActualHoursForRequestor"), "ActualHoursForRequestor")
.Add(Projections.Property("IsRequestSignedOff"), "IsRequestSignedOff")
.Add(Projections.Property("RequestDate"), "RequestDate")
.Add(Projections.Property("RequestedStartDate"), "RequestedStartDate")
.Add(Projections.Property("RevisedRequestedStartDate"), "RevisedRequestedStartDate")
.Add(Projections.Property("RequestedEndDate"), "RequestedEndDate")
.Add(Projections.Property("RevisedRequestedEndDate"), "RevisedRequestedEndDate")
.Add(Projections.Property("ActualStartDate"), "ActualStartDate")
.Add(Projections.Property("ActualEndDate"), "ActualEndDate")
.Add(Projections.Property("DashboardId"), "DashboardId")
.Add(Projections.Property("DashboardDescription"), "DashboardDescription")
.Add(Projections.Property("PeriodUpdate"), "PeriodUpdate")
.Add(Projections.Property("NextPeriodProjectedReport"), "NextPeriodProjectedReport")
.Add(Projections.Property("KeyIssues"), "KeyIssues")
.Add(Projections.Property("SupportMagicIdentifier"), "SupportMagicIdentifier")
.Add(Projections.Property("SystemId"), "SystemId")
.Add(Projections.Property("ProjectManagerId"), "ProjectManagerId")
.Add(Projections.Property("StatusId"), "StatusId")
.Add(Projections.Property("RequestTypeId"), "RequestTypeId")
.Add(Projections.Property("ResponsibleOrgId"), "ResponsibleOrgId")
.Add(Projections.Property("ExecutiveSponsorPersonId"), "ExecutiveSponsorPersonId")
.Add(Projections.Property("UserLeadPersonId"), "UserLeadPersonId")
.Add(Projections.Property("WrmsSystem.Code"), "SystemCode")
.Add(Projections.Property("RequestStatus.LongDesc"), "StatusLongDesc")
.Add(Projections.Property("RequestStatus.Code"), "StatusCode")
.Add(Projections.Property("ProjectManager.FirstName"), "ProjectManagerFirstName")
.Add(Projections.Property("ProjectManager.LastName"), "ProjectManagerLastName")
.Add(Projections.Property("Itgb"), "Itgb")
);
criteria.SetResultTransformer(Transformers.AliasToBean(typeof(RequestDto)));
criteria.SetMaxResults(maxEntries).SetFirstResult(offset);
if (!String.IsNullOrEmpty(searchRequest.SortColumn))
{
if (searchRequest.SortOrder.StartsWith("A"))
{
criteria.AddOrder(Order.Asc(searchRequest.SortColumn));
}
else
{
criteria.AddOrder(Order.Desc(searchRequest.SortColumn));
}
if (searchRequest.SortColumn == "WrmsSystem.Code")
{
criteria.AddOrder(Order.Asc("ShortDesc"));
}
}
return(criteria.List <RequestDto>());
}
public ActionResult Search(RequestSearchRequest searchRequest)
{
SearchResultFormViewModel<RequestDto, RequestSearchRequest> formViewModel = null;
try
{
formViewModel = _requestSearchManagementService.Search(searchRequest);
Session.Add(SEARCH_PARAMETERS, searchRequest);
}
catch (PreconditionException pde)
{
TempData[ControllerEnums.GlobalViewDataProperty.PageMessage.ToString()] = pde.Message;
formViewModel = _requestSearchManagementService.CreateFormViewModel(searchRequest);
}
return View("Index", formViewModel);
}
public ActionResult <List <Model.DTO.RequestDTO> > GetRequests([FromQuery] RequestSearchRequest Request)
{
return(_RequestsService.GetRequests(Request));
}
public List <Model.Models.Request> Get([FromQuery] RequestSearchRequest request, bool showAll)
{
return(_requestsService.Get(request, showAll));
}
