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