public ActionResult getTableBataSacVentaAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_sac_venta] == null) { List <Ent_Bata_Sac_Venta> listdoc = new List <Ent_Bata_Sac_Venta>(); Session[_session_sac_venta] = listdoc; } //if (!String.IsNullOrEmpty(dniEliminar)) //{ // List<Ent_BataClub_Cupones> listAct = (List<Ent_BataClub_Cupones>)(Session[_session_lista_clientes_cupon]); // listAct.Remove(listAct.Where(w => w.dniCliente == dniEliminar).FirstOrDefault()); // Session[_session_lista_clientes_cupon] = listAct; //} //Traer registros IQueryable <Ent_Bata_Sac_Venta> membercol = ((List <Ent_Bata_Sac_Venta>)(Session[_session_sac_venta])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Bata_Sac_Venta> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.tienda.ToUpper().Contains(param.sSearch.ToUpper()) || m.numdoc.ToUpper().Contains(param.sSearch.ToUpper()) || m.pedido.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.canal, a.tienda, a.tipodoc, a.numdoc, a.fecha, a.estado, a.pedido, a.fc_nint, a.cod_tda }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getGuiaAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_listguia_private] == null) { List <Ent_Consultar_Guia> listdoc = new List <Ent_Consultar_Guia>(); Session[_session_listguia_private] = listdoc; } //Traer registros // string tda_destino = Request["tda_destino"]; // string num_guia = Request["num_guia"]; // List<Ent_Consultar_Guia> mGuia = datGuia.get_lista(tda_destino, num_guia); // IQueryable<Ent_Consultar_Guia> membercol = ((List<Ent_Consultar_Guia>)(mGuia)).AsQueryable(); //lista().AsQueryable(); IQueryable <Ent_Consultar_Guia> membercol = ((List <Ent_Consultar_Guia>)(Session[_session_listguia_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Consultar_Guia> filteredMembers = membercol; //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.desc_almac, a.num_gudis, a.num_guia, a.tienda_origen, a.tienda_destino, a.fecha_des, a.desc_send_tda, a.fec_env, a.mc_id, a.fec_recep, a.cant_despd, a.cant_fmd, a.con_id, a.con_des }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableconsdocDetAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_consultadoc_mov_det] == null) { List <Ent_MovDoc_Consulta_Detalle_Articulo> listdoc_det = new List <Ent_MovDoc_Consulta_Detalle_Articulo>(); Session[_session_lista_consultadoc_mov_det] = listdoc_det; } //if (!String.IsNullOrEmpty(dniEliminar)) //{ // List<Ent_BataClub_Cupones> listAct = (List<Ent_BataClub_Cupones>)(Session[_session_lista_clientes_cupon]); // listAct.Remove(listAct.Where(w => w.dniCliente == dniEliminar).FirstOrDefault()); // Session[_session_lista_clientes_cupon] = listAct; //} //Traer registros IQueryable <Ent_MovDoc_Consulta_Detalle_Articulo> membercol = ((List <Ent_MovDoc_Consulta_Detalle_Articulo>)(Session[_session_lista_consultadoc_mov_det])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_MovDoc_Consulta_Detalle_Articulo> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.articulo.ToUpper().Contains(param.sSearch.ToUpper()) || m.linea.ToUpper().Contains(param.sSearch.ToUpper()) || m.categoria.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.articulo, a.calidad, a.linea, a.categoria, a.list_talla, a.total, //a.talla, //a.cantidad, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableStockCategoriaAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_stock_articulo_categoria] == null) { List <Ent_Articulo_Categoria_Stock> liststock = new List <Ent_Articulo_Categoria_Stock>(); Session[_session_stock_articulo_categoria] = liststock; } //} //Traer registros IQueryable <Ent_Articulo_Categoria_Stock> membercol = ((List <Ent_Articulo_Categoria_Stock>)(Session[_session_stock_articulo_categoria])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Articulo_Categoria_Stock> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.categoria.ToUpper().Contains(param.sSearch.ToUpper()) || m.codigo.ToUpper().Contains(param.sSearch.ToUpper()) || m.descripcion.ToUpper().Contains(param.sSearch.ToUpper()) || m.tempo.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.categoria, a.foto, a.codigo, a.descripcion, a.tempo, a.precio, a.total, a.list_talla }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getListPromotor(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_listPromotor_private] == null) { List <Ent_Promotor> listdoc = new List <Ent_Promotor>(); Session[_session_listPromotor_private] = listdoc; } //Traer registros IQueryable <Ent_Promotor> membercol = ((List <Ent_Promotor>)(Session[_session_listPromotor_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Promotor> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.prmt_NroDoc.ToUpper().Contains(param.sSearch.ToUpper()) || m.prmt_ApePater.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Promotor, string> orderingFunction = ( m => sortIdx == 0 ? m.prmt_NroDoc : m.prmt_ApePater ); 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.prmt_NroDoc, a.prmt_Nombre1, a.prmt_Nombre2, a.prmt_ApePater, a.prmt_ApeMater, a.prmt_Correo, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTablePromTipoAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_prom_tipo] == null) { List <Ent_Promotion_Orce_Atributos> listdoc = new List <Ent_Promotion_Orce_Atributos>(); Session[_session_lista_prom_tipo] = listdoc; } //if (!String.IsNullOrEmpty(dniEliminar)) //{ // List<Ent_BataClub_Cupones> listAct = (List<Ent_BataClub_Cupones>)(Session[_session_lista_clientes_cupon]); // listAct.Remove(listAct.Where(w => w.dniCliente == dniEliminar).FirstOrDefault()); // Session[_session_lista_clientes_cupon] = listAct; //} //Traer registros IQueryable <Ent_Promotion_Orce_Atributos> membercol = ((List <Ent_Promotion_Orce_Atributos>)(Session[_session_lista_prom_tipo])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Promotion_Orce_Atributos> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.promotion_id.ToUpper().Contains(param.sSearch.ToUpper()) || m.deal_id.ToUpper().Contains(param.sSearch.ToUpper()) || m.tipo.ToUpper().Contains(param.sSearch.ToUpper()) || m.attribute_name.ToUpper().Contains(param.sSearch.ToUpper()) || m.attribute_value.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.promotion_id, a.deal_id, a.tipo, a.attribute_name, a.attribute_value, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getDataPagsLiqs(Ent_jQueryDataTableParams param, bool checking = false, string checkVal = "") { /*verificar si esta null*/ if (Session[_sessionPagsLiqs] == null) { List <Ent_Pag_Liq> listPed = new List <Ent_Pag_Liq>(); Session[_sessionPagsLiqs] = listPed; } if (checking) { List <Ent_Pag_Liq> list = (List <Ent_Pag_Liq>)Session[_sessionPagsLiqs]; list.Where(w => w.dtv_transdoc_id == checkVal).Select(s => { s.checks = !s.checks; return(s); }).ToList(); Session[_sessionPagsLiqs] = list; } //Traer registros IQueryable <Ent_Pag_Liq> membercol = ((List <Ent_Pag_Liq>)(Session[_sessionPagsLiqs])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Pag_Liq> filteredMembers = membercol; var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.dtv_transdoc_id, a.dtv_concept_id, a.cov_description, //document_date_desc = a.document_date_desc.ToString("dd/MM/yyyy hh:mm"), a.document_date_desc, a.dtd_document_date, a.debito, a.credito, a.val, a.TIPO, a.active, a.checks, a.von_increase, a.Flag, monto = a.val * a.von_increase }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result, total = membercol.Where(w => w.checks).Sum(s => s.val * s.von_increase) }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableArticuloPrecioAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_articulo_precio] == null) { List <Ent_Articulo_Precio> listarticulo_precio = new List <Ent_Articulo_Precio>(); Session[_session_lista_articulo_precio] = listarticulo_precio; } //} //Traer registros IQueryable <Ent_Articulo_Precio> membercol = ((List <Ent_Articulo_Precio>)(Session[_session_lista_articulo_precio])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Articulo_Precio> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.articulo.ToUpper().Contains(param.sSearch.ToUpper()) || m.Art_Temporada.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.tipo, a.tipodes, a.articulo, a.descripcion, a.precioigv, a.precion, a.Art_Temporada, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
//Dropdownlist - cambio de fechas public ActionResult getDropdrowlistFecha(Ent_jQueryDataTableParams param, string valor_tienda) { ViewBag.Fecha = datInv.get_ListaFecha(valor_tienda); //return Json(new[] { // ViewBag.Fecha //}, JsonRequestBehavior.AllowGet); return(Json( ViewBag.Fecha , JsonRequestBehavior.AllowGet)); }
public ActionResult getTablePremioArticuloListaAjax(Ent_jQueryDataTableParams param, string actualizar, string idpremio) { List <Ent_Lista_PremiosXArticulos> liststock = new List <Ent_Lista_PremiosXArticulos>(); if (!String.IsNullOrEmpty(actualizar)) { liststock = premio.lista_premiosXarticulo(Convert.ToInt32(idpremio)); //listAtributos = datOE.get_lista_atributos(); Session[_session_lista_premios_lista_articulos] = liststock; } /*verificar si esta null*/ if (Session[_session_lista_premios_lista_articulos] == null) { liststock = new List <Ent_Lista_PremiosXArticulos>(); Session[_session_lista_premios_lista_articulos] = liststock; } //} //Traer registros IQueryable <Ent_Lista_PremiosXArticulos> membercol = ((List <Ent_Lista_PremiosXArticulos>)(Session[_session_lista_premios_lista_articulos])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Lista_PremiosXArticulos> filteredMembers = membercol; //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.id, a.articulo, a.talla, a.cantidad, a.entregado, a.stock }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTablePremiosListaAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_premios] == null) { List <Ent_Premios> listpremios = new List <Ent_Premios>(); Session[_session_lista_premios] = premio.lista_premios(); } //} //Traer registros IQueryable <Ent_Premios> membercol = ((List <Ent_Premios>)(Session[_session_lista_premios])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Premios> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.descripcion.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.id, a.descripcion, a.monto, a.stock, a.stockingresado, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getGuiaErrorAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_consulta_guiaerrores] == null) { List <Ent_Consulta_GuiaError> listdoc = new List <Ent_Consulta_GuiaError>(); Session[_session_consulta_guiaerrores] = listdoc; } //Traer registros IQueryable <Ent_Consulta_GuiaError> membercol = ((List <Ent_Consulta_GuiaError>)(Session[_session_consulta_guiaerrores])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Consulta_GuiaError> filteredMembers = membercol; //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.Codigo, a.Caja, a.TK_xstore, a.Tienda, a.Fec_Documento, a.Num_Documento, a.Articulo, a.Calidad, a.Cantidad, a.Fec_Ingreso, a.Fec_Act, a.Mantis_Nro, a.Estado, a.TK_soporte_Bata }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableCuponCompartirAjax(Ent_jQueryDataTableParams param, string dniEliminar) { /*verificar si esta null*/ if (Session[_session_listcompartir_private_cupones] == null) { List <Ent_Barra_Compartir> listdoc = new List <Ent_Barra_Compartir>(); Session[_session_listcompartir_private_cupones] = listdoc; } //Traer registros IQueryable <Ent_Barra_Compartir> membercol = ((List <Ent_Barra_Compartir>)(Session[_session_listcompartir_private_cupones])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Barra_Compartir> filteredMembers = membercol; //if (!string.IsNullOrEmpty(param.sSearch)) //{ // filteredMembers = membercol // .Where(m => // m.correo.ToUpper().Contains(param.sSearch.ToUpper()) || // m.nombresCliente.ToUpper().Contains(param.sSearch.ToUpper()) || // m.dniCliente.ToUpper().Contains(param.sSearch.ToUpper()) || m.apellidosCliente.ToUpper().Contains(param.sSearch.ToUpper()) || // (m.nombresCliente.Trim() + " " + m.apellidosCliente.Trim()).ToUpper().Contains(param.sSearch.ToUpper()) // ); //} //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.barra, a.estado, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getGuiaAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_doc_transac_private] == null) { List <Ent_Documento_Transac> listdoc = new List <Ent_Documento_Transac>(); Session[_session_doc_transac_private] = listdoc; } //Traer registros IQueryable <Ent_Documento_Transac> membercol = ((List <Ent_Documento_Transac>)(Session[_session_doc_transac_private])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Documento_Transac> filteredMembers = membercol; //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.cod_entid, a.tienda_origen, a.tran_id, a.fecha_des, a.flg_novell, a.fec_env }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableArticuloSinStockAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_pedido_sin_stock] == null) { List <Ent_Articulo_Sin_Stock> liststock = new List <Ent_Articulo_Sin_Stock>(); Session[_session_pedido_sin_stock] = liststock; } //} //Traer registros IQueryable <Ent_Articulo_Sin_Stock> membercol = ((List <Ent_Articulo_Sin_Stock>)(Session[_session_pedido_sin_stock])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Articulo_Sin_Stock> filteredMembers = membercol; //Manejador de orden var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.pedido, a.dni, a.nombres, a.articulo, a.talla, a.estado, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
/** Lista Documentos **/ public ActionResult getListDocumentosDev(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_listDocDev_private] == null) { List <Ent_Documentos_Dev> listPed = new List <Ent_Documentos_Dev>(); Session[_session_listDocDev_private] = listPed; } //Traer registros IQueryable <Ent_Documentos_Dev> membercol = ((List <Ent_Documentos_Dev>)(Session[_session_listDocDev_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Documentos_Dev> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.TIPODOC.ToUpper().Contains(param.sSearch.ToUpper()) || m.NDOC.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); if (param.iSortingCols > 0) { if (Request["sSortDir_0"].ToString() == "asc") { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderBy(o => o.TIPODOC); break; case 1: filteredMembers = filteredMembers.OrderBy(o => o.NDOC); break; case 2: filteredMembers = filteredMembers.OrderBy(o => Convert.ToDateTime(o.FDOC)).ThenBy(to => Convert.ToDecimal(to.FDOC)); break; //case 3: filteredMembers = filteredMembers.OrderBy(o => o.Pares); break; //case 4: filteredMembers = filteredMembers.OrderBy(o => o.Estado); break; //case 5: filteredMembers = filteredMembers.OrderBy(o => o.Ganancia); break; //case 6: filteredMembers = filteredMembers.OrderBy(o => o.Subtotal); break; //case 7: filteredMembers = filteredMembers.OrderBy(o => o.N_C); break; //case 8: filteredMembers = filteredMembers.OrderBy(o => o.Total); break; //case 9: filteredMembers = filteredMembers.OrderBy(o => o.Percepcion); break; //case 10: filteredMembers = filteredMembers.OrderBy(o => o.TotalPagar); break; } } else { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderByDescending(o => o.TIPODOC); break; case 1: filteredMembers = filteredMembers.OrderByDescending(o => o.NDOC); break; case 2: filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToDateTime(o.FDOC)).ThenBy(to => Convert.ToDecimal(to.FDOC)); break; //case 3: filteredMembers = filteredMembers.OrderByDescending(o => o.Pares); break; //case 4: filteredMembers = filteredMembers.OrderByDescending(o => o.Estado); break; //case 5: filteredMembers = filteredMembers.OrderByDescending(o => o.Ganancia); break; //case 6: filteredMembers = filteredMembers.OrderByDescending(o => o.Subtotal); break; //case 7: filteredMembers = filteredMembers.OrderByDescending(o => o.N_C); break; //case 8: filteredMembers = filteredMembers.OrderByDescending(o => o.Total); break; //case 9: filteredMembers = filteredMembers.OrderByDescending(o => o.Percepcion); break; //case 10: filteredMembers = filteredMembers.OrderByDescending(o => o.TotalPagar); break; } } } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.TIPODOC, a.NDOC, a.FDOC, a.SUBTOTAL, a.IGV, a.TOTAL, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getAnalisisMov(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_listanalisisDetalle_private] == null) { List <Ent_Analisis_Mov> listdoc = new List <Ent_Analisis_Mov>(); Session[_session_listanalisisDetalle_private] = listdoc; } //Traer registros IQueryable <Ent_Analisis_Mov> membercol = ((List <Ent_Analisis_Mov>)(Session[_session_listanalisisDetalle_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Analisis_Mov> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.tipo_doc.ToUpper().Contains(param.sSearch.ToUpper()) || m.num_doc.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Analisis_Mov, string> orderingFunction = ( m => sortIdx == 0 ? m.tipo_doc : m.num_doc ); 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.item, a.fecha, a.tipo_doc, a.num_doc, a.origen, a.destino, a.inicial, a.ingreso, a.salida, a.saldo, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getconsultadocmov(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_consultadoc_mov] == null) { List <Ent_MovDoc_Consulta> lisprom = new List <Ent_MovDoc_Consulta>(); Session[_session_lista_consultadoc_mov] = lisprom; } //Traer registros IQueryable <Ent_MovDoc_Consulta> membercol = ((List <Ent_MovDoc_Consulta>)(Session[_session_lista_consultadoc_mov])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_MovDoc_Consulta> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.tipo_doc.ToUpper().Contains(param.sSearch.ToUpper()) || m.tipo_transac.ToUpper().Contains(param.sSearch.ToUpper()) || m.num_doc.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); //Func<Models_Guia, string> orderTO = (m => m.TIENDA_ORI); //Func<Models_Guia, string> orderNumero = (m => m.NUMERO); //Func<Models_Guia, DateTime> orderFecha = (m => Convert.ToDateTime(m.FECHA)); //Func<Models_Guia, int> orderPares = (m => Convert.ToInt32(m.PARES)); //Func<Models_Guia, double> orderVC = (m => Convert.ToDouble(m.VCALZADO)); //Func<Models_Guia, int> orderNC = (m => Convert.ToInt32(m.NOCALZADO)); //Func<Models_Guia, double> orderVNC = (m => Convert.ToDouble(m.VNOCALZADO)); //Func<Models_Guia, string> orderEstado = (m => m.ESTADO); var sortDirection = Request["sSortDir_0"]; if (sortDirection == "asc") { switch (sortIdx) { case 1: filteredMembers = filteredMembers.OrderBy(o => o.tipo_transac); break; case 2: filteredMembers = filteredMembers.OrderBy(o => o.tipo_doc); break; case 3: filteredMembers = filteredMembers.OrderBy(o => o.num_doc); break; case 4: filteredMembers = filteredMembers.OrderBy(o => Convert.ToDateTime(o.fecha_doc)); break; case 5: filteredMembers = filteredMembers.OrderBy(o => o.cant); break; case 6: filteredMembers = filteredMembers.OrderBy(o => o.tda_ori); break; case 7: filteredMembers = filteredMembers.OrderBy(o => o.tda_des); break; default: break; } } else { switch (sortIdx) { case 1: filteredMembers = filteredMembers.OrderByDescending(o => o.tipo_transac); break; case 2: filteredMembers = filteredMembers.OrderByDescending(o => o.tipo_doc); break; case 3: filteredMembers = filteredMembers.OrderByDescending(o => o.num_doc); break; case 4: filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToDateTime(o.fecha_doc)); break; case 5: filteredMembers = filteredMembers.OrderByDescending(o => o.cant); break; case 6: filteredMembers = filteredMembers.OrderByDescending(o => o.tda_ori); break; case 7: filteredMembers = filteredMembers.OrderByDescending(o => o.tda_des); break; default: break; } } var displayMembers = filteredMembers.Skip(param.iDisplayStart).Take(param.iDisplayLength); var result = from a in displayMembers select new { a.mc_id, a.tienda, a.tipo_transac, a.tipo_doc, a.num_doc, a.fecha_doc, a.cant, a.tda_des, a.tda_ori, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTableInventAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_tabla_inventCons_private] == null) { List <Ent_Inventario_Consulta> listdoc = new List <Ent_Inventario_Consulta>(); Session[_session_tabla_inventCons_private] = listdoc; } //Traer registros IQueryable <Ent_Inventario_Consulta> membercol = ((List <Ent_Inventario_Consulta>)(Session[_session_tabla_inventCons_private])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Inventario_Consulta> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.articulo.ToUpper().Contains(param.sSearch.ToUpper()) || m.calidad.ToUpper().Contains(param.sSearch.ToUpper()) || // m.des_entid.ToUpper().Contains(param.sSearch.ToUpper()) || m.diferencia.ToUpper().Contains(param.sSearch.ToUpper()) || m.talla.ToUpper().Contains(param.sSearch.ToUpper()) || // m.fecha_inv.ToUpper().Contains(param.sSearch.ToUpper()) || m.teorico.ToUpper().Contains(param.sSearch.ToUpper()) || m.fisico.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Inventario_Consulta, string> orderingFunction = ( //m => sortIdx == 0 ? m.fec_doc : // m.fec_doc m => sortIdx == 0 ? m.fecha_inv : sortIdx == 1 ? m.articulo : sortIdx == 2 ? m.talla : sortIdx == 3 ? m.fisico : m.diferencia ); 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.articulo, a.calidad, a.des_entid, a.diferencia, a.fecha_inv, a.fisico, a.teorico, a.talla }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getInvArtAjax(Ent_jQueryDataTableParams param, bool corteInventario, string tienda, string fecha)//, string _art_mod, bool ordenar, bool _all_check, bool _all_check_val) { /*verificar si esta null*/ if (corteInventario) { List <Ent_Inv_Ajuste_Articulos> list = datInv.getListaTeorico(tienda, Convert.ToDateTime(fecha)); Session[_session_lista_articulos_inv] = list; } if (Session[_session_lista_articulos_inv] == null) { List <Ent_Inv_Ajuste_Articulos> list = new List <Ent_Inv_Ajuste_Articulos>(); Session[_session_lista_articulos_inv] = list; } IQueryable <Ent_Inv_Ajuste_Articulos> membercol = ((List <Ent_Inv_Ajuste_Articulos>)Session[_session_lista_articulos_inv]).AsQueryable(); //lista().AsQueryable(); //displayMembers.Select(a => { a.ESTADO_CONEXION_CAJA_XST = dat_storeTda.PingHost(a.IP); return a; }).ToList(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Inv_Ajuste_Articulos> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.ARTICULO.ToUpper().Contains(param.sSearch.ToUpper()) || m.MEDIDA.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Inv_Ajuste_Articulos, string> orderingFunction = ( m => sortIdx == 0 ? m.ARTICULO : m.CALIDAD.ToString()); Func <Ent_Inv_Ajuste_Articulos, string> orderingCodigo = (m => m.ARTICULO); Func <Ent_Inv_Ajuste_Articulos, string> orderingCalidad = (m => m.CALIDAD); Func <Ent_Inv_Ajuste_Articulos, string> orderingMedida = (m => m.MEDIDA); Func <Ent_Inv_Ajuste_Articulos, decimal?> orderingFisico = (m => m.STOCK); Func <Ent_Inv_Ajuste_Articulos, decimal?> orderingTeorico = (m => m.TEORICO); Func <Ent_Inv_Ajuste_Articulos, decimal?> orderingDiferencia = (m => m.DIFERENCIA); var sortDirection = Request["sSortDir_0"]; if (sortDirection == "asc") { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderBy(orderingCodigo); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderBy(orderingCalidad); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderBy(orderingMedida); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderBy(orderingFisico); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderBy(orderingTeorico); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderBy(orderingDiferencia); } } else { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderByDescending(orderingCodigo); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderByDescending(orderingCalidad); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderByDescending(orderingMedida); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderByDescending(orderingFisico); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderByDescending(orderingTeorico); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderByDescending(orderingDiferencia); } } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.ARTICULO, a.CALIDAD, a.MEDIDA, a.TEORICO, a.STOCK, a.DIFERENCIA }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getListaAjustesInvAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_lista_ajuste_inv] == null) { List <Ent_Inventario_Ajuste> list = new List <Ent_Inventario_Ajuste>(); Session[_session_lista_ajuste_inv] = list; } IQueryable <Ent_Inventario_Ajuste> membercol = ((List <Ent_Inventario_Ajuste>)Session[_session_lista_ajuste_inv]).AsQueryable(); //lista().AsQueryable(); int totalCount = membercol.Count(); IEnumerable <Ent_Inventario_Ajuste> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.TIENDA.ToUpper().Contains(param.sSearch.ToUpper()) || m.DESCRIPCION.ToUpper().Contains(param.sSearch.ToUpper()) || m.FECHA_INV.ToUpper().Contains(param.sSearch.ToUpper()) || m.CODIGO.ToString().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Inventario_Ajuste, decimal> orderingCodigo = (m => m.CODIGO); Func <Ent_Inventario_Ajuste, string> orderingTienda = (m => m.TIENDA); Func <Ent_Inventario_Ajuste, string> orderingDescripcion = (m => m.DESCRIPCION); Func <Ent_Inventario_Ajuste, DateTime> orderingFecha = (m => Convert.ToDateTime(m.FECHA_INV)); Func <Ent_Inventario_Ajuste, decimal> orderingFisico = (m => m.FISICO); Func <Ent_Inventario_Ajuste, decimal> orderingTeorico = (m => m.TEORICO); Func <Ent_Inventario_Ajuste, decimal> orderingDiferencia = (m => m.DIFERENCIA); var sortDirection = Request["sSortDir_0"]; if (sortDirection == "asc") { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderBy(orderingCodigo); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderBy(orderingTienda); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderBy(orderingDescripcion); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderBy(orderingFecha); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderBy(orderingFisico); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderBy(orderingTeorico); } else if (sortIdx == 6) { filteredMembers = filteredMembers.OrderBy(orderingDiferencia); } } else { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderByDescending(orderingCodigo); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderByDescending(orderingTienda); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderByDescending(orderingDescripcion); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderByDescending(orderingFecha); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderByDescending(orderingFisico); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderByDescending(orderingTeorico); } else if (sortIdx == 6) { filteredMembers = filteredMembers.OrderByDescending(orderingDiferencia); } } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.CODIGO, a.TIENDA, a.DESCRIPCION, a.FECHA_INV, a.FISICO, a.TEORICO, a.DIFERENCIA }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getDetalleAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_doc_transac_doc_private] == null) { List <Ent_Documento_TransacDoc> listdoc = new List <Ent_Documento_TransacDoc>(); Session[_session_doc_transac_doc_private] = listdoc; } //Traer registros IQueryable <Ent_Documento_TransacDoc> membercol = ((List <Ent_Documento_TransacDoc>)(Session[_session_doc_transac_doc_private])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Documento_TransacDoc> filteredMembers = membercol; //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Documento_TransacDoc, string> orderingFunction = ( m => sortIdx == 0 ? m.NUM_FAC : m.NUM_FAC ); if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.NUM_FAC.ToUpper().Contains(param.sSearch.ToUpper()) || m.TIPO_DOC.ToUpper().Contains(param.sSearch.ToUpper())); } var sortDirection = Request["sSortDir_0"]; if (sortDirection == "desc") { filteredMembers = filteredMembers.OrderBy(orderingFunction); } else { filteredMembers = filteredMembers.OrderByDescending(orderingFunction); } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //var displayMembers = filteredMembers // .Skip(param.iDisplayStart) // .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.TIPO_DOC, a.NUM_FAC, a.SERIE, a.TOTAL, a.ESTADO }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult ListarConsultaMovimiento_DataTable(Ent_jQueryDataTableParams param) { if (Session["Lista_Consulta_Movimiento"] == null) { List <Ent_Consulta_Movimiento> liststoreConf = new List <Ent_Consulta_Movimiento>(); Session["Lista_Consulta_Movimiento"] = liststoreConf; } IQueryable <Ent_Consulta_Movimiento> membercol = ((List <Ent_Consulta_Movimiento>)(Session["Lista_Consulta_Movimiento"])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Consulta_Movimiento> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.FECHA.ToUpper().Contains(param.sSearch.ToUpper()) || m.FECHA.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Consulta_Movimiento, DateTime> orderingFunction = ( m => Convert.ToDateTime(m.FECHA)); filteredMembers = filteredMembers.OrderBy(orderingFunction); //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.TIENDA, a.FECHA, a.INI_CALZADO, a.INI_NO_CALZADO, a.VEN_CALZADO, a.VEN_NO_CALZADO, a.ING_CALZADO, a.ING_NO_CALZADO, a.SAL_CALZADO, a.SAL_NO_CALZADO, a.SALDO_CALZADO, a.SALDO_NO_CALZADO }; return(Json(new { sEcho = param.sEcho, iTotalRecords = membercol.Count(), iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getComAjax(Ent_jQueryDataTableParams param, string noLeidos) { /*verificar si esta null*/ if (Session[_session_listcom_private] == null) { List <Ent_Comunicado> listcom = new List <Ent_Comunicado>(); if (Session["Tienda"] != null) { listcom = listaCom(Session["Tienda"].ToString()); } Session[_session_listcom_private] = listcom; } //Traer registros // string tda_destino = Request["tda_destino"]; // string num_guia = Request["num_guia"]; // List<Ent_Consultar_Guia> mGuia = datGuia.get_lista(tda_destino, num_guia); // IQueryable<Ent_Consultar_Guia> membercol = ((List<Ent_Consultar_Guia>)(mGuia)).AsQueryable(); //lista().AsQueryable(); IQueryable <Ent_Comunicado> membercol = ((List <Ent_Comunicado>)(Session[_session_listcom_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Comunicado> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.descripcion.ToUpper().Contains(param.sSearch.ToUpper()) || m.archivo.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden //0 = ID //5 = fecha envio //6 = fecha leido var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Comunicado, DateTime> orderingFunctionFE = (m => Convert.ToDateTime(m.fecha_hora_mod)); Func <Ent_Comunicado, decimal> orderingFunctionID = (m => m.id); Func <Ent_Comunicado, string> orderingFunctionFL = (m => m.file_leido_fecha); var sortDirection = Request["sSortDir_0"]; Boolean order_colum = false; if (param != null) { if (param.sEcho != "1") { order_colum = true; } } if (order_colum) { if (sortDirection == "asc") { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderBy(orderingFunctionID); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderBy(orderingFunctionFE); } else { filteredMembers = filteredMembers.OrderBy(orderingFunctionFL); } } else { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderByDescending(orderingFunctionID); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderByDescending(orderingFunctionFE); } else { filteredMembers = filteredMembers.OrderByDescending(orderingFunctionFL); } } } if (Convert.ToBoolean(noLeidos)) { filteredMembers = filteredMembers.Where(m => m.file_leido == false).OrderByDescending(orderingFunctionFE); } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.id, a.tienda, a.archivo, a.descripcion, a.url, a.fecha, a.fecha_hora_mod, a.file_leido_fecha, a.file_leido, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getValeCompra(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_listValeCompraDetalle_private] == null) { List <Reporte_Resultado> listValeCompra = new List <Reporte_Resultado>(); Session[_session_listValeCompraDetalle_private] = listValeCompra; } //Traer registros IQueryable <Reporte_Resultado> membercol = ((List <Reporte_Resultado>)(Session[_session_listValeCompraDetalle_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Reporte_Resultado> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.Codigo_tda.ToUpper().Contains(param.sSearch.ToUpper()) || m.Desc_tda.ToUpper().Contains(param.sSearch.ToUpper()) || m.Codigo.ToUpper().Contains(param.sSearch.ToUpper()) || m.Numero.ToUpper().Contains(param.sSearch.ToUpper()) || m.Estado.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Reporte_Resultado, string> orderingFunction = ( m => sortIdx == 0 ? m.Codigo_tda : sortIdx == 1 ? m.Desc_tda : sortIdx == 2 ? m.Codigo : sortIdx == 3 ? m.Numero : 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.Institucion, a.Codigo, a.Numero, a.soles, a.Estado, a.Codigo_tda, a.Desc_tda, a.Documento, a.Fecha_doc, a.DNI, a.Cliente }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getListaAplicacionAjax(Ent_jQueryDataTableParams param, string actualizar) { List <Ent_Aplicacion> listaplicacion = new List <Ent_Aplicacion>(); if (!String.IsNullOrEmpty(actualizar)) { listaplicacion = lista(); //listAtributos = datOE.get_lista_atributos(); Session[_session_listaplicacion_private] = listaplicacion; } /*verificar si esta null*/ if (Session[_session_listaplicacion_private] == null) { listaplicacion = new List <Ent_Aplicacion>(); listaplicacion = lista(); //datOE.get_lista_atributos(); if (listaplicacion == null) { listaplicacion = new List <Ent_Aplicacion>(); } Session[_session_listaplicacion_private] = listaplicacion; } //Traer registros IQueryable <Ent_Aplicacion> membercol = ((List <Ent_Aplicacion>)(Session[_session_listaplicacion_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Aplicacion> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.apl_id.ToUpper().Contains(param.sSearch.ToUpper()) || m.apl_nombre.ToString().ToUpper().Contains(param.sSearch.ToUpper()) || m.apl_orden.ToString().ToUpper().Contains(param.sSearch.ToUpper()) || m.apl_controller.ToString().ToUpper().Contains(param.sSearch.ToUpper()) || m.apl_action.ToString().ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; if (param.iSortingCols > 0) { if (sortDirection == "asc") { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderBy(o => o.apl_id); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderBy(o => o.apl_nombre); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderBy(o => o.apl_orden); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderBy(o => o.apl_controller); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderBy(o => o.apl_action); } } else { if (sortIdx == 0) { filteredMembers = filteredMembers.OrderByDescending(o => o.apl_id); } else if (sortIdx == 1) { filteredMembers = filteredMembers.OrderByDescending(o => o.apl_nombre); } else if (sortIdx == 2) { filteredMembers = filteredMembers.OrderByDescending(o => o.apl_orden); } else if (sortIdx == 3) { filteredMembers = filteredMembers.OrderByDescending(o => o.apl_controller); } else if (sortIdx == 4) { filteredMembers = filteredMembers.OrderByDescending(o => o.apl_action); } } } //Func<Ent_Funcion, DateTime> orderingFunction = // ( // m => Convert.ToDateTime(m.FECHA_CREACION) // ); //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.apl_id, a.apl_nombre, a.apl_orden, a.apl_controller, a.apl_action, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getListPedSepAjax(Ent_jQueryDataTableParams param, string actualizar) { List <Ent_Pedido_Separado> listpedido = new List <Ent_Pedido_Separado>(); if (!String.IsNullOrEmpty(actualizar)) { listpedido = lista(); //listAtributos = datOE.get_lista_atributos(); Session[_session_listPedidoSeparado_private] = listpedido; } /*verificar si esta null*/ if (Session[_session_listPedidoSeparado_private] == null) { listpedido = new List <Ent_Pedido_Separado>(); listpedido = lista(); //datOE.get_lista_atributos(); if (listpedido == null) { listpedido = new List <Ent_Pedido_Separado>(); } Session[_session_listPedidoSeparado_private] = listpedido; } //Traer registros IQueryable <Ent_Pedido_Separado> membercol = ((List <Ent_Pedido_Separado>)(Session[_session_listPedidoSeparado_private])).AsQueryable(); //lista().AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Pedido_Separado> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.asesor.ToUpper().Contains(param.sSearch.ToUpper()) || m.lider.ToUpper().Contains(param.sSearch.ToUpper()) || m.pedido.ToUpper().Contains(param.sSearch.ToUpper()) || m.promotor.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); if (param.iSortingCols > 0) { if (Request["sSortDir_0"].ToString() == "asc") { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderBy(o => o.asesor); break; case 1: filteredMembers = filteredMembers.OrderBy(o => o.lider); break; case 2: filteredMembers = filteredMembers.OrderBy(o => o.promotor); break; case 4: filteredMembers = filteredMembers.OrderBy(o => Convert.ToInt32(o.tcantidad)); break; case 5: filteredMembers = filteredMembers.OrderBy(o => Convert.ToInt32(o.subtotal)); break; case 8: filteredMembers = filteredMembers.OrderBy(o => Convert.ToInt32(o.dias_pedido)); break; } } else { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderByDescending(o => o.asesor); break; case 1: filteredMembers = filteredMembers.OrderByDescending(o => o.lider); break; case 2: filteredMembers = filteredMembers.OrderByDescending(o => o.promotor); break; case 4: filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToInt32(o.tcantidad)); break; case 5: filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToInt32(o.subtotal)); break; case 8: filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToInt32(o.dias_pedido)); break; } } } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.asesor, a.lider, a.promotor, a.pedido, a.tcantidad, a.fecha_ing, a.fecha_cad, a.dias_pedido, a.telefono, a.celular, a.ubicacion, a.subtotal, }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public JsonResult getLisXCenter_NC(Ent_jQueryDataTableParams param, string FechaInicio, string FechaFin, string Tienda, string Num_Doc, bool isOkUpdate) { Ent_Extender_NC _ent = new Ent_Extender_NC(); _ent.Tienda = Tienda; _ent.Num_Doc = Num_Doc; _ent.FechaInicio = DateTime.Parse(FechaInicio); _ent.FechaFin = DateTime.Parse(FechaFin); if (isOkUpdate) { Session[_session_LisXCenter_NC] = datGuia.LisXCenter_NC(_ent).ToList(); } /*verificar si esta null*/ if (Session[_session_LisXCenter_NC] == null) { List <Ent_Extender_NC> ListarXCenter_NC = new List <Ent_Extender_NC>(); Session[_session_LisXCenter_NC] = ListarXCenter_NC; } IQueryable <Ent_Extender_NC> entDocTrans = ((List <Ent_Extender_NC>)(Session[_session_LisXCenter_NC])).AsQueryable(); //Manejador de filtros int totalCount = entDocTrans.Count(); IEnumerable <Ent_Extender_NC> filteredMembers = entDocTrans; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = entDocTrans .Where(m => m.Serial_Nbr.ToUpper().Contains(param.sSearch.ToUpper()) || m.String_Value.ToUpper().Contains(param.sSearch.ToUpper()) ); } //Manejador de ordene var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); if (param.iSortingCols > 0) { if (Request["sSortDir_0"].ToString() == "asc") { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderBy(o => o.Serial_Nbr); break; case 1: filteredMembers = filteredMembers.OrderBy(o => o.Organization_Id); break; case 2: filteredMembers = filteredMembers.OrderBy(o => o.Rtl_Loc_Id); break; case 3: filteredMembers = filteredMembers.OrderBy(o => o.Wkstn_Id); break; case 4: filteredMembers = filteredMembers.OrderBy(o => o.Trans_Seq); break; case 5: filteredMembers = filteredMembers.OrderBy(o => o.String_Value); break; case 6: filteredMembers = filteredMembers.OrderBy(o => o.Business_Date); break; case 7: filteredMembers = filteredMembers.OrderBy(o => o.Expr_Date); break; } } else { switch (sortIdx) { case 0: filteredMembers = filteredMembers.OrderByDescending(o => o.Serial_Nbr); break; case 1: filteredMembers = filteredMembers.OrderByDescending(o => o.Organization_Id); break; case 2: filteredMembers = filteredMembers.OrderByDescending(o => o.Rtl_Loc_Id); break; case 3: filteredMembers = filteredMembers.OrderByDescending(o => o.Wkstn_Id); break; case 4: filteredMembers = filteredMembers.OrderByDescending(o => o.Trans_Seq); break; case 5: filteredMembers = filteredMembers.OrderByDescending(o => o.String_Value); break; case 6: filteredMembers = filteredMembers.OrderByDescending(o => o.Business_Date); break; case 7: filteredMembers = filteredMembers.OrderByDescending(o => o.Expr_Date); break; } } } var Result = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = Result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getDetAjax(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_contabilidad_num_private] == null) { List <Ent_Contabilidad_EstadoDocumento> listdoc = new List <Ent_Contabilidad_EstadoDocumento>(); Session[_session_contabilidad_num_private] = listdoc; } //Traer registros IQueryable <Ent_Contabilidad_EstadoDocumento> membercol = ((List <Ent_Contabilidad_EstadoDocumento>)(Session[_session_contabilidad_num_private])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Contabilidad_EstadoDocumento> filteredMembers = membercol; //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); Func <Ent_Contabilidad_EstadoDocumento, string> orderingFunction = ( m => sortIdx == 0 ? m.fecha : m.fecha ); if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.estado.ToUpper().Contains(param.sSearch.ToUpper()) || m.fecha.ToUpper().Contains(param.sSearch.ToUpper()) || m.numero.ToUpper().Contains(param.sSearch.ToUpper()) || m.serie.ToUpper().Contains(param.sSearch.ToUpper()) || m.tienda.ToUpper().Contains(param.sSearch.ToUpper()) || m.tipo_doc.ToUpper().Contains(param.sSearch.ToUpper()) || m.ruc.ToUpper().Contains(param.sSearch.ToUpper()) || m.login_ws.ToUpper().Contains(param.sSearch.ToUpper()) || m.clave_ws.ToUpper().Contains(param.sSearch.ToUpper()) || m.tipodoc.ToUpper().Contains(param.sSearch.ToUpper()) || m.folio.ToUpper().Contains(param.sSearch.ToUpper()) || m.total.ToUpper().Contains(param.sSearch.ToUpper())); } var sortDirection = Request["sSortDir_0"]; if (sortDirection == "desc") { 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.estado, a.fecha, a.numero, a.serie, a.tienda, a.tipo_doc, a.total, a.ruc, a.login_ws, a.clave_ws, a.tipodoc, a.folio }; //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult getTablaCuponesRetorno(Ent_jQueryDataTableParams param) { /*verificar si esta null*/ if (Session[_session_cupones_retorno] == null) { List <Ent_Ticket_Retorno> listdoc = new List <Ent_Ticket_Retorno>(); Session[_session_cupones_retorno] = listdoc; } //Traer registros IQueryable <Ent_Ticket_Retorno> membercol = ((List <Ent_Ticket_Retorno>)(Session[_session_cupones_retorno])).AsQueryable(); //Manejador de filtros int totalCount = membercol.Count(); IEnumerable <Ent_Ticket_Retorno> filteredMembers = membercol; if (!string.IsNullOrEmpty(param.sSearch)) { filteredMembers = membercol .Where(m => m.codigo.ToUpper().Contains(param.sSearch.ToUpper()) || m.estado.ToUpper().Contains(param.sSearch.ToUpper()) || m.tiendaGen.ToUpper().Contains(param.sSearch.ToUpper()) || m.fechaGen.ToUpper().Contains(param.sSearch.ToUpper()) || m.tiendaUso.ToUpper().Contains(param.sSearch.ToUpper()) || m.fechaUso.ToUpper().Contains(param.sSearch.ToUpper())); } //Manejador de orden var sortIdx = Convert.ToInt32(Request["iSortCol_0"]); var sortDirection = Request["sSortDir_0"]; if (param.iSortingCols > 0) { if (sortDirection == "asc") { if (sortIdx == 1) { filteredMembers = filteredMembers.OrderBy(o => o.estado); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderBy(o => Convert.ToDateTime(o.fechaGen)); } else if (sortIdx == 9) { filteredMembers = filteredMembers.OrderBy(o => Convert.ToDateTime(o.fechaUso)); } } else { if (sortIdx == 1) { filteredMembers = filteredMembers.OrderByDescending(o => o.estado); } else if (sortIdx == 5) { filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToDateTime(o.fechaGen)); } else if (sortIdx == 9) { filteredMembers = filteredMembers.OrderByDescending(o => Convert.ToDateTime(o.fechaUso)); } } } var displayMembers = filteredMembers .Skip(param.iDisplayStart) .Take(param.iDisplayLength); var result = from a in displayMembers select new { a.codigo, a.estado, a.montoDscto, a.impreso, a.tiendaGen, a.fechaGen, a.montoGen, a.serieGen, a.numeroGen, a.tiendaUso, a.fechaUso, a.montoUso, a.serieUso, a.numeroUso, a.nroReimp, }; var numvariable1 = filteredMembers.Count(n => n.estado.ToUpper() == "CONSUMIDO"); var numvariable2 = filteredMembers.Count(n => n.estado.ToUpper() == "DISPONIBLE"); var numvariable3 = filteredMembers.Count(n => n.estado.ToUpper() == "CADUCADO"); // param.variable1 = lblConsumidos; param.variable1 = numvariable1.ToString(); param.variable2 = numvariable2.ToString(); param.variable3 = numvariable3.ToString(); //Se devuelven los resultados por json return(Json(new { sEcho = param.sEcho, iTotalRecords = totalCount, iTotalDisplayRecords = filteredMembers.Count(), aaData = result, variable1 = param.variable1, variable2 = param.variable2, variable3 = param.variable3 }, JsonRequestBehavior.AllowGet)); }