public Task <DataResult <IPagedListResult <DTOQuotationItem> > > GetQuotationItemsWithPagingAsync(string quotationId, string searchTerm, string sortName, string sortDirection, int pageIndex, int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() =>
{
var searchQuery = new SearchQuery <QuotationItem>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
searchQuery.IncludeProperties = "Quotation,Accessary,Accessary.Unit,Service,Service.Unit,Employee";
var sort = new FieldSortCriteria <QuotationItem>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
searchQuery.AddFilter(x => x.QuotationId == quotationId);
if (!string.IsNullOrEmpty(searchTerm))
{
searchQuery.AddFilter(x => x.Service.Name.Contains(searchTerm) || x.Accessary.Name.Contains(searchTerm));
}
var pagedQuotationItems = _unitOfWork.GetRepository <QuotationItem>().Search(searchQuery);
return new DataResult <IPagedListResult <DTOQuotationItem> >
{
Errors = new List <ErrorDescriber>(),
Target = GetDefaultPagingDtoResult <DTOQuotationItem, QuotationItem>(_mapper, pagedQuotationItems)
};
}, cancellationToken));
}
public Task <DataResult <IPagedListResult <DTOCustomerExchange> > > GetCustomersLookupWithPagingAsync(List <Expression <Func <CustomerExchange, bool> > > searchTerm,
string sortName, string sortDirection, int pageIndex, int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() =>
{
var searchQuery = new SearchQuery <CustomerExchange>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
searchQuery.IncludeProperties = "Car,Customer";
var sort = new FieldSortCriteria <CustomerExchange>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
foreach (var searchCondition in searchTerm)
{
searchQuery.AddFilter(searchCondition);
}
var pagedCustomerWithCar = customerExchangeRepository.Search(searchQuery);
var pagedCustomerWithCarDTOs = GetDefaultPagingDtoResult <DTOCustomerExchange, CustomerExchange>(_mapper, pagedCustomerWithCar);
// Mapping customer, car and quotations to DTO
pagedCustomerWithCarDTOs.DTOs = MappingCustomerAndCarDTO(pagedCustomerWithCar.DTOs.ToList(), pagedCustomerWithCarDTOs.DTOs.ToList());
return new DataResult <IPagedListResult <DTOCustomerExchange> >
{
Errors = new List <ErrorDescriber>(),
Target = pagedCustomerWithCarDTOs
};
}, cancellationToken));
}
public Task <DataResult <IPagedListResult <DTOCustomer> > > GetCustomersWithPagingAsync(string searchTerm, string sortName, string sortDirection, int pageIndex, int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() => {
var searchQuery = new SearchQuery <Customer>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
searchQuery.IncludeProperties = "Branch,CustomerType";
var sort = new FieldSortCriteria <Customer>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
if (!string.IsNullOrEmpty(searchTerm))
{
searchQuery.AddFilter(x => x.Name.Contains(searchTerm) ||
x.Phone.Contains(searchTerm) ||
x.Id.Contains(searchTerm));
}
var pagedCustomers = customerRepository.Search(searchQuery);
return new DataResult <IPagedListResult <DTOCustomer> >
{
Errors = new List <ErrorDescriber>(),
Target = GetDefaultPagingDtoResult <DTOCustomer, Customer>(_mapper, pagedCustomers)
};
}, cancellationToken));
}
public Task <DataResult <IPagedListResult <DTOManufacturer> > > GetManufacturersWithPagingAsync(string searchTerm, string sortName, string sortDirection, int pageIndex, int pageSize, CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() => {
var searchQuery = new SearchQuery <Manufacturer>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
var sort = new FieldSortCriteria <Manufacturer>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
if (!string.IsNullOrEmpty(searchTerm))
{
searchQuery.AddFilter(x => x.Name.Contains(searchTerm) || x.Description.Contains(searchTerm));
}
var pagedManufacturers = _unitOfWork.GetRepository <Manufacturer>().Search(searchQuery);
return new DataResult <IPagedListResult <DTOManufacturer> >
{
Errors = new List <ErrorDescriber>(),
Target = GetDefaultPagingDtoResult <DTOManufacturer, Manufacturer>(_mapper, pagedManufacturers)
};
}, cancellationToken));
}
public Task <DataResult <IPagedListResult <DTOQuotation> > > GetQuotationsLookupWithPagingAsync(List <Expression <Func <Quotation, bool> > > searchTerm,
string sortName, string sortDirection, int pageIndex, int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() =>
{
var searchQuery = new SearchQuery <Quotation>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
searchQuery.IncludeProperties = "Branch,Status,CustomerExchange,CustomerExchange.Customer,CustomerExchange.Car";
var sort = new FieldSortCriteria <Quotation>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
foreach (var searchCondition in searchTerm)
{
searchQuery.AddFilter(searchCondition);
}
var pagedQuotations = _unitOfWork.GetRepository <Quotation>().Search(searchQuery);
return new DataResult <IPagedListResult <DTOQuotation> >
{
Errors = new List <ErrorDescriber>(),
Target = GetDefaultPagingDtoResult <DTOQuotation, Quotation>(_mapper, pagedQuotations)
};
}, cancellationToken));
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid) {
var query = new SearchQuery<UserModel>();
// query.AddFilter(product => product.UserName =="");
//this is the same as the following
query.AddFilter(c => c.UserName == model.UserName);
query.Take = 1;
var result = unitOfWork.UserRepository.Search(query).Entities.FirstOrDefault();
if (result != null)
{
if (result.Password == model.Password)
{
FormsAuthentication.SetAuthCookie(model.UserName, false);
return RedirectToAction("Index", "Location");
} ModelState.AddModelError("", "Login data is incorrect!");
return View(model);
}
ModelState.AddModelError("", "Login data is incorrect!");
return View(model);
}
return View();
}
public Task <DataResult <IPagedListResult <DTOPaySlipBill> > > GetPayslipsWithPagingAsync(string searchTerm, string sortName, string sortDirection, int pageIndex, int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
return(Task.Run(() => {
var searchQuery = new SearchQuery <PaySlipBill>();
searchQuery.CurrentPage = pageIndex;
searchQuery.Skip = pageSize * (pageIndex - 1);
searchQuery.Take = pageSize;
searchQuery.IncludeProperties = "Quotation";
var sort = new FieldSortCriteria <PaySlipBill>(sortName, (SortDirection)Enum.Parse(typeof(SortDirection), sortDirection));
searchQuery.AddSortCriteria(sort);
if (!string.IsNullOrEmpty(searchTerm))
{
searchQuery.AddFilter(x => x.Id == int.Parse(searchTerm) || x.QuotationId == searchTerm);
}
var pagedPayslips = paySlipBillRepository.Search(searchQuery);
return new DataResult <IPagedListResult <DTOPaySlipBill> >
{
Errors = new List <ErrorDescriber>(),
Target = GetDefaultPagingDtoResult <DTOPaySlipBill, PaySlipBill>(_mapper, pagedPayslips)
};
}, cancellationToken));
}
public UserDTO GetUser(Guid userId)
{
var querySearch = new SearchQuery <User>();
querySearch.AddFilter(x => x.Id == userId);
var user = _userRepository.Search(querySearch).FirstOrDefault();
return(Mapper.Map <User, UserDTO>(user));
}
public bool Exists(Guid userId)
{
var querySearch = new SearchQuery <User>();
querySearch.AddFilter(x => x.Id == userId);
var user = _userRepository.Search(querySearch).FirstOrDefault();
return(user != null);
}
public StaticPagedList<LocationModel> getLocations(int? pageNo)
{
//create the query
var query = new SearchQuery<LocationModel>();
// query.AddFilter(product => product.UserName =="");
//this is the same as the following
query.AddFilter(c => c.IsDelete == false);
var pageNumber = pageNo ?? 1;
query.Take = 10;
query.Skip = pageNumber - 1;
var result = unitOfWork.LocationRepository.Search(query);
return new StaticPagedList<LocationModel>(result.Entities, pageNumber, query.Take, result.Count);
}
public PagedListResult <KnowledgeArea> Search(string term, string searchFieldName, int page)
{
var repo = new GenericRepository <KnowledgeArea>(_context);
var query = new SearchQuery <KnowledgeArea>();
query.AddFilter(a => searchFieldName == Resource.KnowledgeAreaNameFieldName && a.Name.Contains(term) ||
searchFieldName == "Id" && a.Id.ToString().Contains(term) ||
string.IsNullOrEmpty(searchFieldName));
query.AddSortCriteria(new DynamicFieldSortCriteria <KnowledgeArea>("Order"));
query.Take = 8;
query.Skip = (page - 1) * 8;
return(repo.Search(query));
}
public PagedListResult <Classroom> Search(string term, string searchFieldName, int page)
{
var repo = new GenericRepository <Classroom>(_context);
var query = new SearchQuery <Classroom>();
query.AddFilter(a => searchFieldName == Resource.ClassroomNameFieldName && a.Name.Contains(term) ||
searchFieldName == Resource.CourseName &&
a.Courses.Any(c => c.Course.Name.Contains(term)) ||
string.IsNullOrEmpty(searchFieldName));
query.AddSortCriteria(new DynamicFieldSortCriteria <Classroom>("Name"));
query.Take = 8;
query.Skip = (page - 1) * 8;
return(repo.Search(query));
}
public PagedListResult <Teacher> ListTeachers(string term, string searchFieldName, int page)
{
var repo = new GenericRepository <Teacher>(_context);
var query = new SearchQuery <Teacher>();
query.AddFilter(a => searchFieldName == Resource.TeacherNameFieldName && a.Name.Contains(term) ||
searchFieldName == Resource.TeacherEmailFieldName && a.Email.Contains(term) ||
searchFieldName == "Id" && a.Id.ToString().Contains(term) ||
string.IsNullOrEmpty(searchFieldName));
query.AddSortCriteria(new DynamicFieldSortCriteria <Teacher>("Name"));
query.Take = 8;
query.Skip = (page - 1) * 8;
return(repo.Search(query));
}
public StaticPagedList<ProductModel> getProducts(int? pageNo)
{
//create the query
var query = new SearchQuery<ProductModel>();
// query.AddFilter(product => product.UserName =="");
//this is the same as the following
query.AddFilter(c => c.IsDelete == false);
query.AddSortCriteria(new FieldSortCriteria<ProductModel>("LastUpdate", SortDirection.Descending));
var pageNumber = pageNo ?? 1;
query.Take = 10;
query.Skip = pageNumber - 1;
var result = unitOfWork.ProductRepository.Search(query);
return new StaticPagedList<ProductModel>(result.Entities, pageNumber, query.Take, result.Count);
}
public void SearchUserGroup()
{
Task.Factory.StartNew(ProgressBarService.Show);
var task = Task.Factory.StartNew(() =>
{
UserGroups.Clear();
var searchQuery = new SearchQuery <UserGroupEntity>();
if (!string.IsNullOrEmpty(CurrentUserGroupSearch.UserGroupName))
{
searchQuery.AddFilter(ug => ug.UserGroupName.Contains(CurrentUserGroupSearch.UserGroupName));
}
UserGroups.AddRange(_employeeUnitOfWork.UserGroupRepository.GetUserGroups(searchQuery));
});
task.ContinueWith(arg => Task.Factory.StartNew(ProgressBarService.Hide));
}
// [OutputCache(Duration=60,VaryByParam="none",Location=System.Web.UI.OutputCacheLocation.Client)]
public ActionResult Index(int? pageNo)
{
var query = new SearchQuery<UserModel>();
// query.AddFilter(product => product.UserName =="");
//this is the same as the following
query.AddFilter(c => c.IsDelete == false);
var pageNumber = pageNo ?? 1;
query.Take = 10;
query.Skip = pageNumber - 1;
var result = unitOfWork.UserRepository.Search(query);
ViewBag.List = new StaticPagedList<UserModel>(result.Entities, pageNumber, query.Take, result.Count); ;
return View();
}
