public async Task <ActionResult> DataGrid(DataTableSearchModel model) { if (model == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GridSearchRestltDTO <Employee> data = await employeeService.FindByCriteriaAsync(model.Search.Value, model.Start, model.Length); IEnumerable <EmployeeViewModel> items = null; if (data.Items != null) { items = data.Items.Select(e => new EmployeeViewModel { Id = e.Id, UserName = e.UserName, Age = e.Age, Email = e.Email, FullName = e.FullName, PhoneNumber = e.PhoneNumber, Profession = e.Profession }); } else { items = new List <EmployeeViewModel>(); } DataTableModel <EmployeeViewModel> result = new DataTableModel <EmployeeViewModel> { Data = items, DecordsFiltered = data.FilteredResultsCount, RecordsTotal = data.TotalResultsCount, Draw = model.Draw }; return(new JsonCustomResult(result)); }
protected int Take(DataTableSearchModel searchModel, out int skip) { skip = Skip(searchModel); int?take = searchModel.Page * searchModel.RowsPerPage - skip; return(take ?? 0);; }
public ActionResult Index(DataTableSearchModel searchModel) { searchModel.Created_By = LogedInUser.Id; var response = reconciliationService.GetResponse(searchModel); return(Json(response, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDataPager(DataTableSearchModel searchInput) { if (searchInput.ActionType == "group_action") { if (string.IsNullOrEmpty(searchInput.CustomActionValue) || searchInput.id == null || searchInput.id.Count == 0) { return(Json(new { actionType = searchInput.ActionType, customActionStatus = false, customActionMsg = "无效参数" })); } try { _reportAppService.BatchUpdateStatusAsync(searchInput.id, bool.Parse(searchInput.CustomActionValue)); return(Json(new { actionType = searchInput.ActionType, customActionStatus = true, customActionMsg = "" })); } catch (Exception e) { return(Json(new { actionType = searchInput.ActionType, customActionStatus = false, customActionMsg = "无效参数" })); } } int pageIndex = 0; GetReportInput defaultInput = new GetReportInput() { MaxResultCount = CarFactoryConsts.MaxPageSize, SkipCount = pageIndex * CarFactoryConsts.MaxPageSize, Sorting = "CreationTime", Page = pageIndex + 1 }; if (searchInput != null && searchInput.ActionType == "filter") { defaultInput.Id = searchInput.FilterId; defaultInput.BeginDate = searchInput.FilterDateFrom; defaultInput.EndDate = searchInput.FilterDateTo; defaultInput.FilterText = searchInput.FilterName ?? ""; defaultInput.Status = searchInput.FilterStatus; } var list = _reportAppService.GetPagedReportsAsync(defaultInput).Result; var pagedProducts = new StaticPagedList <ReportListDto>(list.Items, defaultInput.Page.Value, defaultInput.MaxResultCount, list.TotalCount); var viewModelList = GenerateTablePagerData(pagedProducts, "/admin/reports/detail/"); return(Json(new { draw = Request.Form["draw"], recordsTotal = pagedProducts.TotalItemCount, recordsFiltered = pagedProducts.Count, data = viewModelList }, JsonRequestBehavior.AllowGet)); }
public DataTableResponse <Payment> GetResponse(DataTableSearchModel searchModel) { try { var take = Take(searchModel, out int skip); if (!string.IsNullOrEmpty(searchModel.SearchTerm)) { System.Linq.Expressions.Expression <Func <Tbl_Transaction, bool> > filter = b => b.TransactionType == (int)TransactionType.Expense && ( b.Date.ToString().Contains(searchModel.SearchTerm) || b.Tbl_Account.AccountName.Contains(searchModel.SearchTerm) || b.Tbl_Vendor.Name.Contains(searchModel.SearchTerm) || b.Tbl_Category.Name.Contains(searchModel.SearchTerm)); var tableResponse = UnitOfWork.TransactionRepository.GetPagination <Tbl_Transaction>(take, skip, filter, c => c.OrderBy(o => o.Date)); var response = new DataTableResponse <Payment> { data = tableResponse.data.Select(p => p.MapForPayment()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } else { System.Linq.Expressions.Expression <Func <Tbl_Transaction, bool> > filter = b => b.TransactionType == (int)TransactionType.Expense; var tableResponse = UnitOfWork.TransactionRepository.GetPagination <Tbl_Transaction>(take, skip, filter, c => c.OrderBy(o => o.Date)); var response = new DataTableResponse <Payment> { data = tableResponse.data.Select(p => p.MapForPayment()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } } catch (Exception ex) { return(new DataTableResponse <Payment>()); } }
public DataTableResponse <Reconciliation> GetResponse(DataTableSearchModel searchModel) { try { var take = Take(searchModel, out int skip); if (!string.IsNullOrEmpty(searchModel.SearchTerm)) { System.Linq.Expressions.Expression <Func <Tbl_Reconciliation, bool> > filter = b => b.Created_By == searchModel.Created_By && (b.Tbl_Account.AccountName.ToString().Contains(searchModel.SearchTerm) || b.StartDate.ToString().Contains(searchModel.SearchTerm) || b.EndDate.ToString().Contains(searchModel.SearchTerm)); var tableResponse = UnitOfWork.ReconciliationRepository.GetPagination <Tbl_Reconciliation>(take, skip, filter, c => c.OrderByDescending(o => o.Created_At)); var response = new DataTableResponse <Reconciliation> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } else { System.Linq.Expressions.Expression <Func <Tbl_Reconciliation, bool> > filter = b => b.Created_By == searchModel.Created_By; var tableResponse = UnitOfWork.ReconciliationRepository.GetPagination <Tbl_Reconciliation>(take, skip, filter, c => c.OrderByDescending(o => o.Created_At)); var response = new DataTableResponse <Reconciliation> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } } catch (Exception ex) { return(new DataTableResponse <Reconciliation>()); } }
public DataTableResponse <Customers> GetResponse(DataTableSearchModel searchModel) { try { var currentUser = HttpContext.Current.Session["UserDetail"] as User ?? new User(); var take = Take(searchModel, out int skip); if (!string.IsNullOrEmpty(searchModel.SearchTerm)) { System.Linq.Expressions.Expression <Func <Repository.Edmx.Tbl_Customer, bool> > filter = b => b.Name.ToString().Contains(searchModel.SearchTerm) || (b.Email.Contains(searchModel.SearchTerm) && b.Email != currentUser.Email); var tableResponse = UnitOfWork.CustomerRepository.GetPagination <Repository.Edmx.Tbl_Customer>(take, skip, filter, c => c.OrderBy(o => o.Name)); var response = new DataTableResponse <Customers> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } else { var tableResponse = UnitOfWork.CustomerRepository.GetPagination <Repository.Edmx.Tbl_Customer>(take, skip, x => x.Email != currentUser.Email, c => c.OrderBy(o => o.Name)); var response = new DataTableResponse <Customers> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } } catch (Exception ex) { return(new DataTableResponse <Customers>()); } }
public DataTableResponse <Invoice> GetResponse(DataTableSearchModel searchModel) { try { var take = Take(searchModel, out int skip); if (!string.IsNullOrEmpty(searchModel.SearchTerm)) { System.Linq.Expressions.Expression <Func <Tbl_Invoice, bool> > filter = b => b.Tbl_Customer.Name.ToString().Contains(searchModel.SearchTerm) || b.InvoiceNumber.ToString().Contains(searchModel.SearchTerm) || b.InvoiceDate.ToString().Contains(searchModel.SearchTerm) || b.DueDate.ToString().Contains(searchModel.SearchTerm); var tableResponse = UnitOfWork.InvoiceRepository.GetPagination <Tbl_Invoice>(take, skip, filter, c => c.OrderByDescending(o => o.InvoiceNumber)); var response = new DataTableResponse <Invoice> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } else { var tableResponse = UnitOfWork.InvoiceRepository.GetPagination <Tbl_Invoice>(take, skip, null, c => c.OrderByDescending(o => o.InvoiceNumber)); var response = new DataTableResponse <Invoice> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } } catch (Exception ex) { return(new DataTableResponse <Invoice>()); } }
public async Task <ActionResult> DataGrid(DataTableSearchModel model) { if (model == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GridSearchRestltDTO <Role> data = await roleService.FindByCriteriaAsync(model.Search.Value, model.Start, model.Length); DataTableModel <Role> result = new DataTableModel <Role> { Data = data.Items, DecordsFiltered = data.FilteredResultsCount, RecordsTotal = data.TotalResultsCount, Draw = model.Draw }; return(new JsonCustomResult(result)); }
public DataTableResponse <Branch> GetResponse(DataTableSearchModel searchModel) { try { var take = Take(searchModel, out int skip); if (!string.IsNullOrEmpty(searchModel.SearchTerm)) { System.Linq.Expressions.Expression <Func <Repository.Edmx.Tbl_Branch, bool> > filter = b => b.Name.ToString().Contains(searchModel.SearchTerm) || b.Email.Contains(searchModel.SearchTerm); var tableResponse = UnitOfWork.BranchRepository.GetPagination <Repository.Edmx.Tbl_Branch>(take, skip, filter, c => c.OrderBy(o => o.Name)); var response = new DataTableResponse <Branch> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } else { var tableResponse = UnitOfWork.BranchRepository.GetPagination <Repository.Edmx.Tbl_Branch>(take, skip, null, c => c.OrderBy(o => o.Name)); var response = new DataTableResponse <Branch> { data = tableResponse.data.Select(p => p.MapFrom()).ToList(), recordsFiltered = tableResponse.recordsFiltered, recordsTotal = tableResponse.recordsTotal }; return(response); } } catch (Exception ex) { return(new DataTableResponse <Branch>()); } }
public async Task <JsonCustomResult> DataGrid(DataTableSearchModel model) { GridSearchRestltDTO <Domain> data = await domainService.FindByCriteriaAsync(model.Search.Value, model.Start, model.Length); IEnumerable <DomainViewModel> items = new List <DomainViewModel>(); if (data.Items != null) { items = data.Items.Select(d => new DomainViewModel { Id = d.Id, Name = d.Name, Description = d.Description }); } DataTableModel <DomainViewModel> result = new DataTableModel <DomainViewModel> { Data = items, DecordsFiltered = data.FilteredResultsCount, RecordsTotal = data.TotalResultsCount, Draw = model.Draw }; return(new JsonCustomResult(result)); }
public ActionResult Index(DataTableSearchModel searchModel) { DataTableResponse <Tax> response = taxService.GetResponse(searchModel); return(Json(response, JsonRequestBehavior.AllowGet)); }
private int Skip(DataTableSearchModel searchModel) { var skip = searchModel.Page * searchModel.RowsPerPage - searchModel.RowsPerPage; return(skip ?? 0); }
public ActionResult GetResponse(DataTableSearchModel searchModel) { var respsonse = _branchService.GetResponse(searchModel); return(Json(respsonse, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(DataTableSearchModel searchModel) { var response = invoiceService.GetResponse(searchModel); return(Json(response, JsonRequestBehavior.AllowGet)); }