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