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