public QuoteResponse GetAllQuotes(QuoteSearchRequest searchRequest) { int fromRow = (searchRequest.PageNo - 1) * searchRequest.PageSize; int toRow = searchRequest.PageSize; Expression <Func <Quote, bool> > query = s => searchRequest.HasPermissionToViewAll ? ( (string.IsNullOrEmpty(searchRequest.Subject) || (s.Subject).Contains(searchRequest.Subject)) && (string.IsNullOrEmpty(searchRequest.ReferenceNumber) || (s.QuoteReferenceNo).Contains(searchRequest.ReferenceNumber)) && (string.IsNullOrEmpty(searchRequest.EmployeeUserId) || (s.CreatedBy).Equals(searchRequest.EmployeeUserId)) ): ( (string.IsNullOrEmpty(searchRequest.Subject) || (s.Subject).Contains(searchRequest.Subject)) && ((s.CreatedBy).Equals(searchRequest.CurrentUserId)) && (string.IsNullOrEmpty(searchRequest.ReferenceNumber) || (s.QuoteReferenceNo).Contains(searchRequest.ReferenceNumber)) ); IEnumerable <Quote> quotes = searchRequest.IsAsc ? DbSet .Where(query) .OrderBy(sortClause[searchRequest.OrderByColumn]).Skip(fromRow) .Take(toRow) .ToList() : DbSet .Where(query) .OrderByDescending(sortClause[searchRequest.OrderByColumn]).Skip(fromRow) .Take(toRow) .ToList(); return(new QuoteResponse { Quotes = quotes.ToList(), TotalCount = DbSet.Count(query), FilteredCount = quotes.Count() }); }
private async Task LoadQuotes() { QuoteSearchRequest request = new QuoteSearchRequest { MovieAndTvshowId = _MTVS.Id }; var list = await _serviceQuote.GetAll <List <Quote> >(request); dgvQuotes.DataSource = list; }
public QuoteViewModel() { Contacts = new List <ContactModel>(); Employees = new List <EmployeeDDL>(); Products = new List <Models.Product>(); ProductModels = new List <ProductModel>(); Exclusions = new List <ExclusionModel>(); QuoteExclusions = new List <QuoteExclusionModel>(); data = new List <TMD.Web.Models.QuoteModel>(); quoteSearchRequest = new QuoteSearchRequest(); }
public JsonResult Index(QuoteSearchRequest searchRequest) { string[] userPermissionsSet = (string[])Session["UserPermissionSet"]; searchRequest.HasPermissionToViewAll = userPermissionsSet.Contains("ViewAllInquiries"); searchRequest.CurrentUserId = User.Identity.GetUserId(); var contactResponse = quoteService.GetAllQuotes(searchRequest); var quoteList = contactResponse.Quotes.ToList().Select(x => x.MapServerToClientSearch()).ToList(); var model = new QuoteViewModel() { data = quoteList, recordsFiltered = contactResponse.FilteredCount, recordsTotal = contactResponse.TotalCount }; return(Json(model, JsonRequestBehavior.AllowGet)); //return null; }
public QuoteResponse GetAllQuotes(QuoteSearchRequest searchRequest) { var inquiries = quoteRepository.GetAllQuotes(searchRequest); return(inquiries); }