public ActionResult <IEnumerable <IEmpresa> > Gets([FromBody] DataTablesResponseViewModel model)
{
string filtro = model.Search.Value;
int ordernar = model.Order[0].Column;
string ordernarDirecao = model.Order[0].Dir;
int _draw = model.Draw;
int startRec = model.Start;
int pageSize = model.Length;
IsolationLevel isolationLevel = IsolationLevel.ReadUncommitted;
Services <IEmpresa> services = Services <IEmpresa> .Create(FactoryServices.Create(isolationLevel).getEmpresa());
IList <IEmpresa> empresas = services.Gets(startRec, filtro, pageSize);
IList <EmpresaTableViewModel> tablesEempresa = converterEmpresaViewModelParaEmpresaTableViewModel(empresas);
List <EmpresaTableViewModel> empresasOrdenadas = ordenacaoTableEmpresa(ordernar, ordernarDirecao, tablesEempresa);
int totalRegistros = services.totalDeRegistros;
var retorno = this.Json(new { draw = _draw, recordsTotal = totalRegistros, recordsFiltered = totalRegistros, data = empresasOrdenadas });
return(retorno);
}
public async Task <ActionResult <IEnumerable <IdentityUser> > > Gets([FromBody] DataTablesResponseViewModel model)
{
string filtro = model.Search.Value;
int ordernar = model.Order[0].Column;
string ordernarDirecao = model.Order[0].Dir;
int _draw = model.Draw;
int startRec = model.Start;
int pageSize = model.Length;
GerenciarUsuario gerenciarUsuario = GerenciarUsuario.Create(this._userManager);
IList <IdentityUser> usuarios = await gerenciarUsuario.Gets(startRec, filtro, pageSize, model.empresaUsuarioFuncao.EmpresaId);
IList <UsuarioTableViewModel> tableUsuario = ((List <IdentityUser>)usuarios).ConvertAll(new Converter <IdentityUser, UsuarioTableViewModel>(UsuarioConverter.converterIdentityUserParaUsuarioTableViewModel));
List <UsuarioTableViewModel> usuariosOrdenados = UsuarioConfiguracao.ordenacaoTableUsuario(ordernar, ordernarDirecao, tableUsuario);
int totalRegistros = gerenciarUsuario.totalRegistro;
var retorno = this.Json(new { draw = _draw, recordsTotal = totalRegistros, recordsFiltered = totalRegistros, data = usuariosOrdenados });
return(retorno);
}
public async Task <IActionResult> GetProducts([FromBody] DtParameters dtParameters, int categoryId)
{
var orderString = DataTablesHelper.GetOrderStringFromDtParams(nameof(ProductViewModel.Id), dtParameters, new Dictionary <string, string>()
{
{ nameof(ProductViewModel.Id), nameof(ProductViewModel.Id) }
});
int totalCount = 0;
var products = _productService.GetProducts(categoryId, Constants.PageSize, dtParameters.Start, orderString, out totalCount);
var productsViewModelList = new List <ProductViewModel>();
products.ForEach(p =>
{
var viewModel = mapper.Map <Product, ProductViewModel>(p);
viewModel.CategoryNameEn = p.Category.NameEn;
viewModel.CategoryNameAr = p.Category.NameAr;
productsViewModelList.Add(viewModel);
});
var data = new DataTablesResponseViewModel(dtParameters.Draw, productsViewModelList, totalCount, totalCount);
return(Json(data));
}
public async Task <ActionResult <IEnumerable <IdentityRole> > > Gets([FromBody] DataTablesResponseViewModel model)
{
string filtro = model.Search.Value;
int ordernar = model.Order[0].Column;
string ordernarDirecao = model.Order[0].Dir;
int _draw = model.Draw;
int startRec = model.Start;
int pageSize = model.Length;
FuncaoManager funcaoManager = FuncaoManager.Create(_roleManager);
IList <IdentityRole> funcoes = await funcaoManager.Gets(startRec, filtro, pageSize);
//IList<EmpresaTableViewModel> tablesEempresa = converterEmpresaViewModelParaEmpresaTableViewModel(empresas);
List <IdentityRole> funcoesOrdenadas = FuncaoConfiguracao.ordenacaoTableFuncoes(ordernar, ordernarDirecao, funcoes);
int totalRegistros = funcaoManager.totalRegistro;
var retorno = this.Json(new { draw = _draw, recordsTotal = totalRegistros, recordsFiltered = totalRegistros, data = funcoesOrdenadas });
return(retorno);
}
public async Task <ActionResult <IEnumerable <RequisicaoTableViewModel> > > getUsuarioRequisicao([FromBody] DataTablesResponseViewModel model)
{
string filtro = model.Search.Value;
int ordernar = model.Order[0].Column;
string ordernarDirecao = model.Order[0].Dir;
int _draw = model.Draw;
int startRec = model.Start;
int pageSize = model.Length;
IsolationLevel _isolationLevel = IsolationLevel.ReadUncommitted;
ISqlBase sqlBase = SqlServerFactory.Create();
GerenciarUsuario gerenciarUsuario = GerenciarUsuario.Create(sqlBase, _isolationLevel);
IList <IdentityUserClaim <string> > usuarios = await gerenciarUsuario.getRequisicoes(startRec, filtro, pageSize, model.empresaUsuarioFuncao.EmpresaId, model.empresaUsuarioFuncao.UsuarioId);
IList <RequisicaoTableViewModel> tableRequisicao = ((List <IdentityUserClaim <string> >)usuarios).ConvertAll(new Converter <IdentityUserClaim <string>, RequisicaoTableViewModel>(UsuarioConverter.converterIdentityUserClaimParaClaim));
List <RequisicaoTableViewModel> requisicoesOrdenadas = UsuarioConfiguracao.ordenacaoTableUsuarioRequisicoes(ordernar, ordernarDirecao, tableRequisicao);
int totalRegistros = gerenciarUsuario.totalRegistro;
var retorno = this.Json(new { draw = _draw, recordsTotal = totalRegistros, recordsFiltered = totalRegistros, data = requisicoesOrdenadas });
return(retorno);
}
public async Task <ActionResult <IEnumerable <RequisicaoTableViewModel> > > getsRequisicoes([FromBody] DataTablesResponseViewModel model)
{
string filtro = model.Search.Value;
int ordernar = model.Order[0].Column;
string ordernarDirecao = model.Order[0].Dir;
int _draw = model.Draw;
int startRec = model.Start;
int pageSize = model.Length;
IsolationLevel _isolationLevel = IsolationLevel.ReadUncommitted;
ISqlBase sqlBase = SqlServerFactory.Create();
FuncaoManager funcaoManager = FuncaoManager.Create(sqlBase, _isolationLevel);
List <IdentityRoleClaim <string> > funcoesRequisicoes = await funcaoManager.getsRequisicoes(model.empresaUsuarioFuncao.FuncaoId, startRec, filtro, pageSize);
IList <RequisicaoTableViewModel> tableFuncaoRequisicao = funcoesRequisicoes.ConvertAll(new Converter <IdentityRoleClaim <string>, RequisicaoTableViewModel>(FuncaoConverter.converterIdentityRoleClaimParaClaim));
IList <RequisicaoTableViewModel> funcoesRequisicoesOrdenadas = FuncaoConfiguracao.ordenacaoTableFuncoesRequisicoes(ordernar, ordernarDirecao, tableFuncaoRequisicao);
int totalRegistros = funcaoManager.totalRegistro;
var retorno = this.Json(new { draw = _draw, recordsTotal = totalRegistros, recordsFiltered = totalRegistros, data = funcoesRequisicoesOrdenadas });
return(retorno);
}