/// <summary> /// Obtiene todas los Ciudades /// </summary> /// <param name="param">The parameter.</param> /// <returns></returns> public ActionResult getRoles(jQueryDataTableParams param) { DAL dal = new DAL(); string user_owner = User.Identity.GetUserId(); IQueryable <IdentityRole> listRoles = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context)).Roles.AsQueryable(); int totalCount = listRoles.Count(); IEnumerable <IdentityRole> filtroMembers = listRoles; if (!string.IsNullOrEmpty(param.sSearch)) { filtroMembers = listRoles .Where(m => m.Id.ToString().Contains(param.sSearch.ToUpper()) || m.Name.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; // asc or desc Func <IdentityRole, string> orderingFunction = (m => sortIdx == 0 ? m.Id : m.Name); if (sortDirection == "asc") { filtroMembers = filtroMembers.OrderBy(orderingFunction); } else { filtroMembers = filtroMembers.OrderByDescending(orderingFunction); } var displayedMembers = filtroMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Manejardo de resultados var result = from a in displayedMembers select new { a.Id, a.Name }; //Se devuelven los resultados por json return(Json(new { draw = param.sEcho, recordsTotal = totalCount, recordsFiltered = filtroMembers.Count(), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getPersonal(jQueryDataTableParams param) { //Traer registros IQueryable <Personal> membercol = ((List <Personal>)(Session[_session_listpersonal_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Personal> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.nombres.ToUpper().Contains(param.sSearch.ToUpper()) || m.dni_ruc.ToUpper().Contains(param.sSearch.ToUpper()) || m.telefono.ToUpper().Contains(param.sSearch.ToUpper()) || m.celular.ToUpper().Contains(param.sSearch.ToUpper()) || m.correo.ToUpper().Contains(param.sSearch.ToUpper()) || m.tipo_usuario.ToUpper().Contains(param.sSearch.ToUpper()) || m.estado.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Personal, string> orderingFunction = ( m => sortIdx == 0 ? m.nombres : sortIdx == 1 ? m.dni_ruc : sortIdx == 2 ? m.telefono : sortIdx == 3 ? m.celular : sortIdx == 4 ? m.correo : sortIdx == 5 ? m.tipo_usuario : m.estado ); var sortDirection = Request["sSortDir_0"]; if (sortDirection == "asc") { filteredMembers = filteredMembers.OrderBy(orderingFunction); } else { filteredMembers = filteredMembers.OrderByDescending(orderingFunction); } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.bas_id, a.nombres, a.dni_ruc, a.telefono, a.celular, a.correo, a.tipo_usuario, a.estado }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Gets the permissions by role. /// </summary> /// <param name="param">The parameter.</param> /// <returns></returns> public ActionResult get_permissions_by_role(jQueryDataTableParams param) { DAL dal = new DAL(); string user_owner = User.Identity.GetUserId(); string idRol = ""; int idMenu = 0; if (Request.QueryString["idRol"] != "") { idRol = Request.QueryString["idRol"]; } if (Request.QueryString["idMenu"] != "") { idMenu = Convert.ToInt32(Request.QueryString["idMenu"]); } IQueryable <PermissionModel> listPermisos = dal.get_permissions_by_role(idRol, idMenu).AsQueryable(); int totalCount = listPermisos.Count(); IEnumerable <PermissionModel> filtroMembers = listPermisos; if (!string.IsNullOrEmpty(param.sSearch)) { filtroMembers = listPermisos .Where(m => m.Name.ToUpper().Contains(param.sSearch.ToUpper()) || m.Opciones.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; // asc or desc if (sortIdx == 0) { Func <PermissionModel, int> orderingFunction = (m => m.Orden); if (sortDirection == "asc") { filtroMembers = filtroMembers.OrderBy(orderingFunction); } else { filtroMembers = filtroMembers.OrderByDescending(orderingFunction); } } else { Func <PermissionModel, string> orderingFunction = (m => sortIdx == 1 ? m.Name : m.Opciones); if (sortDirection == "asc") { filtroMembers = filtroMembers.OrderBy(orderingFunction); } else { filtroMembers = filtroMembers.OrderByDescending(orderingFunction); } } var displayedMembers = filtroMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Manejardo de resultados var result = from a in displayedMembers select new { a.Id, a.Name, a.Opciones, a.Permisos, a.Enable, a.Orden }; //Se devuelven los resultados por json return(Json(new { draw = param.sEcho, recordsTotal = totalCount, recordsFiltered = filtroMembers.Count(), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetDataCustomers(jQueryDataTableParams param) { //Traer registros IQueryable <Customers> memberCol = db.Customers.AsQueryable(); //Manejador de filtros int totalCount = memberCol.Count(); IEnumerable <Customers> filteredMembers = memberCol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = memberCol .Where(m => m.CompanyName.Contains(param.sSearch) || m.ContactName.Contains(param.sSearch) || m.ContactTitle.Contains(param.sSearch) || m.Address.Contains(param.sSearch) || m.City.Contains(param.sSearch) || m.Region.Contains(param.sSearch) || m.PostalCode.Contains(param.sSearch) || m.Country.Contains(param.sSearch) || m.Phone.Contains(param.sSearch) || m.Fax.Contains(param.sSearch)); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Customers, string> orderingFunction = ( m => sortIdx == 0 ? m.CompanyName : sortIdx == 1 ? m.ContactName : sortIdx == 2 ? m.ContactTitle : sortIdx == 3 ? m.Address : sortIdx == 4 ? m.City : sortIdx == 5 ? m.Region : sortIdx == 6 ? m.PostalCode : sortIdx == 7 ? m.Country : sortIdx == 8 ? m.Phone : sortIdx == 9 ? m.Fax : m.CustomerID ); var sortDirection = Request["sSortDir_0"]; // asc or desc if (sortDirection == "asc") { filteredMembers = filteredMembers.OrderBy(orderingFunction); } else { filteredMembers = filteredMembers.OrderByDescending(orderingFunction); } var displayedMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Manejardo de resultados var result = from a in displayedMembers select new { a.CompanyName, a.ContactName, a.ContactTitle, a.Address, a.City, a.Region, a.PostalCode, a.Country, a.Phone, a.Fax }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Gets the parametros generales. /// </summary> /// <param name="param">The parameter.</param> /// <returns></returns> public ActionResult getParametrosGenerales(jQueryDataTableParams param) { int id = -1; if (Request.QueryString["ppadre"].ToString() != "") { id = Convert.ToInt32(Request.QueryString["ppadre"]); } DAL dal = new DAL(); IQueryable <mParametrosGenerales> list = dal.getParametrosGenerales(id); int totalCount = list.Count(); IEnumerable <mParametrosGenerales> filtroMembers = list; if (!string.IsNullOrEmpty(param.sSearch)) { filtroMembers = list .Where(m => m.idParametro.ToString().ToUpper().Contains(param.sSearch.ToUpper()) || m.Parametro.ToUpper().Contains(param.sSearch.ToUpper()) || m.Descripcion.ToUpper().Contains(param.sSearch.ToUpper()) || m.idTipoParametro.ToString().ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; // asc or desc if (sortIdx == 0 || sortIdx == 3) { Func <mParametrosGenerales, int> orderingFunction = (m => sortIdx == 0 ? m.idParametro : sortIdx == 3 ? m.idTipoParametro : m.idParametro ); if (sortDirection == "asc") { filtroMembers = filtroMembers.OrderBy(orderingFunction); } else { filtroMembers = filtroMembers.OrderByDescending(orderingFunction); } } else { Func <mParametrosGenerales, string> orderingFunction = (m => sortIdx == 1 ? m.Parametro : sortIdx == 2 ? m.Descripcion : m.Parametro ); if (sortDirection == "asc") { filtroMembers = filtroMembers.OrderBy(orderingFunction); } else { filtroMembers = filtroMembers.OrderByDescending(orderingFunction); } } var displayedMembers = filtroMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Manejardo de resultados var result = from a in displayedMembers select new { a.idParametro, a.Parametro, a.Descripcion, a.idTipoParametro }; //Se devuelven los resultados por json return(Json(new { draw = param.sEcho, recordsTotal = totalCount, recordsFiltered = filtroMembers.Count(), data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetSorteosSeleccion(jQueryDataTableParams param) { var sorteos = dal.get_AllSorteosSeleccion(); // Manejador de Filtros int totalCount = sorteos.Count(); IEnumerable <mSorteo> filteredSorteos = sorteos; if (!string.IsNullOrEmpty(param.sSearch)) { filteredSorteos = sorteos .Where(m => m.Ano.ToString().Contains(param.sSearch) || m.Mes.ToString().Contains(param.sSearch) || m.MesString.Contains(param.sSearch) || m.Dia.ToString().Contains(param.sSearch) || m.Despacho1.Contains(param.sSearch) || m.Despacho2.Contains(param.sSearch)); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <mSorteo, string> orderingFunction = ( m => sortIdx == 0 ? m.Ano.ToString() : sortIdx == 1 ? m.Ano.ToString() : sortIdx == 2 ? m.Mes.ToString() : sortIdx == 3 ? m.Dia.ToString() : sortIdx == 4 ? m.Despacho1 : sortIdx == 5 ? m.Despacho2 : m.Ano.ToString() ); var sortDirection = Request["sSortDir_0"]; // asc or desc if (sortDirection == "asc") { filteredSorteos = filteredSorteos.OrderBy(orderingFunction); } else { filteredSorteos = filteredSorteos.OrderByDescending(orderingFunction); } var displayedMembers = filteredSorteos .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Manejardo de resultados var result = from a in displayedMembers select new { a.Ano, a.Mes, a.MesString, a.Dia, a.Despacho1, a.Despacho2 }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredSorteos.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }