public void Data(object parameters, string css, int tipo) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); EstadisticosAfiliados Datos = new EstadisticosAfiliados(); Datos.Start = req.Start; Datos.Length = req.Length; Datos.SearchValue = req.SearchValue; Datos.OrderBy = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { Datos.OrderBy = req.Order[aux].Column; Datos.OrderDirection = req.Order[aux].Direction; } } Datos.Conexion = Comun.Conexion; Datos.TipoLista = tipo; EstadisticosAfiliados_Negocio neg = new EstadisticosAfiliados_Negocio(); neg.ObtenerEvaluacionAJAX(Datos); resultSet.draw = req.Draw; resultSet.recordsTotal = Datos.RecordTotal; resultSet.recordsFiltered = Datos.RecordFilter; foreach (EstadisticosRepresentantesSeccion Item in Datos.Lista) { var columns = new List <string>(); string ColImagen = string.Empty, ColAvance = string.Empty; if (!string.IsNullOrEmpty(Item.Imagen)) { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='data:image/jpg;base64," + Item.Imagen + @"' /></a>"; } else { ColImagen = @"<a href='#' class='thumb-sm m-r'><img class='r r-2x' src='img/anonymous.jpg'/></a>"; } ColAvance = @"<div class='progress'> <div class='progress-bar " + css + @"' role='progressbar' aria-valuenow='" + Item.Avance + @"' aria-valuemin='0' aria-valuemax='100' style='width: " + Item.Avance + @"%'> <span class=''>" + Item.Avance + @"%</span> </div> </div>"; columns.Add(ColImagen); columns.Add(Item.Seccion.ToString()); columns.Add(Item.Nombre); columns.Add(ColAvance); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public void Data(object parameters) { //Read paramater from datatable along with additional parms var req = DataTableParameters.Get(parameters); QuerySP query = new QuerySP(); DataTable table = query.QueryData(); DataView dv = table.DefaultView; //dv.Sort = "ID DESC"; foreach (var col in req.Columns) { if (req.Order.ContainsKey(col.Key)) { dv.Sort = table.Columns[req.Order[col.Key].Column].ToString() + " " + req.Order[col.Key].Direction; } } table = dv.ToTable(); var resultSet = new DataTableResultSet(); resultSet.draw = req.Draw; resultSet.recordsTotal = table.Rows.Count; resultSet.recordsFiltered = table.Rows.Count; foreach (DataRow recordFromDb in table.Select().Skip(req.Start).Take(req.Length)) { //var columns = new List<string>(); // Working var columns = new List <string>(); foreach (DataColumn col in table.Columns) { //columns.Add(recordFromDb[col.ColumnName].ToString()); - Working //columns.Add(recordFromDb[col.ColumnName] as LiteralControl); //columns.Add(((LiteralControl)recordFromDb[col.ColumnName]).Text); columns.Add(recordFromDb[col.ColumnName].ToString()); } //columns.Add("<a href='https://google.com'>Link</a>"); //columns.Add(recordFromDb[0].ToString()); //columns.Add(recordFromDb[1].ToString()); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public void CajaChicaIndex(object parameters) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); _CajaChica_Datos Datos = new _CajaChica_Datos(); CajaChicaModelsResult Resultado = Datos.ObtenerCajasChicasHistorial(req); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CajaChicaModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.FechaAperturaString); columns.Add(Item.NombreEmpleado); columns.Add(Item.MontoAperturaString); //columns.Add(Item.PersonaEntrega); columns.Add(Item.SaldoString); columns.Add(Item.TotalArqueoString); columns.Add(Item.DiferenciaString); UrlHelper urlHlp = new UrlHelper(HttpContext.Current.Request.RequestContext, RouteTable.Routes); string acciones = @" <div class='visible-md visible-lg hidden-sm hidden-xs'> <a title='Reporte' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CajaChica", action = "ReporteCajaChica", id = Item.IdCaja }) + @"' class='btn btn-green tooltips' data-placement='top' data-original-title='Reporte'><i class='fa fa-bar-chart-o'></i></a> </div> <div class='visible-xs visible-sm hidden-md hidden-lg'> <div class='btn-group'> <a class='btn btn-danger dropdown-toggle btn-sm' data-toggle='dropdown' href='#'> <i class='fa fa-cog'></i> <span class='caret'></span> </a> <ul role='menu' class='dropdown-menu pull-right dropdown-dark'> <li> <a role='menuitem' tabindex='-1' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CajaChica", action = "ReporteCajaChica", id = Item.IdCaja }) + @"'> <i class='fa fa-bar-chart-o'></i> Reporte </a> </li> </ul> </div> </div> "; columns.Add(acciones); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public ActionResult IndexAjax(object data) { try { var req = DataTableParameters.Get(data); var resultSet = new DataTableResultSet(); int _Start = req.Start; int _Length = req.Length; string _SearchValue = req.SearchValue; int _OrderBy = -1; string _OrderDirection = string.Empty; int _TipoBusqueda = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { _OrderBy = req.Order[aux].Column; _OrderDirection = req.Order[aux].Direction; } } foreach (var busq in req.Columns.Keys) { if (!string.IsNullOrEmpty(req.Columns[busq].SearchValue)) { _TipoBusqueda = busq; _SearchValue = req.Columns[busq].SearchValue; break; } } _CompraAlmacen_Datos Datos = new _CompraAlmacen_Datos(); CompraAlmacenModels Resultado = Datos.ObtenerGridComprasAJAX(Conexion, _Start, _Length, _SearchValue, _OrderBy, _OrderDirection); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CompraAlmacenModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.Sucursal.NombreSucursal); columns.Add(Item.NumFacturaNota); columns.Add(Item.Proveedor.nombreProveedor); string estatus = string.Empty; switch (Item.IDEstatusCompra) { case 1: estatus = @"<td><span class='label label-warning'>" + Item.StatusCompra + @"</span></td>"; break; case 2: estatus = @"<td><span class='label label-primary'>" + Item.StatusCompra + @"</span></td>"; break; case 3: estatus = @"<td><span class='label label-success'>" + Item.StatusCompra + @"</span></td>"; break; } columns.Add(estatus); string acciones = @""; columns.Add(acciones); resultSet.data.Add(columns); } return(Json(resultSet.ToJSON())); } catch (Exception ex) { TempData["typemessage"] = "2"; TempData["message"] = "No se pudo borrar los datos. Por favor contacte a soporte técnico"; return(Json("")); } }
public static void GetData(object parameters) { try { // Initialization. var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); List <Book> data = getBookList(); resultSet.draw = req.Draw; resultSet.recordsTotal = data.Count(); string search = req.SearchValue; int order = req.Order.Values.ElementAt(0).Column; string orderDirection = req.Order.Values.ElementAt(0).Direction; int startRec = req.Start; int pageSize = req.Length; //Search if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { // Apply search List <Book> searchResults = new List <Book>(); foreach (Book b in data) { if ( Utilities.containsStr(search, b.item_id.ToString()) || Utilities.containsStr(search, b.title) || Utilities.containsStr(search, b.author) || Utilities.containsStr(search, b.publisher) || Utilities.containsStr(search, b.publication_year.ToString()) || Utilities.containsStr(search, b.assn.ToString()) || Utilities.containsStr(search, b.isbn_10) || Utilities.containsStr(search, b.isbn_13) ) { searchResults.Add(b); } } data = searchResults; } resultSet.recordsFiltered = data.Count(); //Sorting data = SortByColumnWithOrder(order, orderDirection, data); // Apply pagination. data = data.Skip(startRec).Take(pageSize).ToList(); foreach (Book m in data) { var columns = new List <string>(); columns.Add(m.item_id.ToString()); columns.Add(m.assn.ToString()); columns.Add(m.title); columns.Add(m.author); columns.Add(m.category); columns.Add(m.publisher); columns.Add(m.publication_year.ToString()); columns.Add("<button id=" + m.item_id.ToString() + " class='mdl-button mdl-js-button mdl-button--icon' onClick='editBook(event); return false' title ='Edit'><i class= 'material-icons'>edit</i></button>" ); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); } catch (Exception ex) { // Info Console.Write(ex); } // Return info. }
public void ComprasAlmacenAjax(object parameters) { var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); int _Start = req.Start; int _Length = req.Length; string _SearchValue = req.SearchValue; int _OrderBy = -1; string _OrderDirection = string.Empty; int _TipoBusqueda = -1; if (req.Order.Count > 0) { foreach (var aux in req.Order.Keys) { _OrderBy = req.Order[aux].Column; _OrderDirection = req.Order[aux].Direction; } } foreach (var busq in req.Columns.Keys) { if (!string.IsNullOrEmpty(req.Columns[busq].SearchValue)) { _TipoBusqueda = busq; _SearchValue = req.Columns[busq].SearchValue; break; } } _CompraAlmacen_Datos Datos = new _CompraAlmacen_Datos(); CompraAlmacenModels Resultado = Datos.ObtenerGridComprasAJAX(Conexion, _Start, _Length, _SearchValue, _OrderBy, _OrderDirection); resultSet.draw = req.Draw; resultSet.recordsTotal = Resultado.TotalRecords; resultSet.recordsFiltered = Resultado.SearchRecords; foreach (CompraAlmacenModels Item in Resultado.Lista) { var columns = new List <string>(); columns.Add(Item.Sucursal.NombreSucursal); columns.Add(Item.NumFacturaNota); columns.Add(Item.Proveedor.nombreProveedor); string estatus = string.Empty; switch (Item.IDEstatusCompra) { case 1: estatus = @"<td><span class='label label-warning'>" + Item.StatusCompra + @"</span></td>"; break; case 2: estatus = @"<td><span class='label label-primary'>" + Item.StatusCompra + @"</span></td>"; break; case 3: estatus = @"<td><span class='label label-success'>" + Item.StatusCompra + @"</span></td>"; break; } columns.Add(estatus); columns.Add("<span class='pull-right'>" + Item.MontoTotalFormato + "</span>"); string acciones = "<div class='visible-md visible-lg hidden-sm hidden-xs'>"; UrlHelper urlHlp = new UrlHelper(HttpContext.Current.Request.RequestContext, RouteTable.Routes); //string aux = urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen, id2="0" }); if (Item.IDEstatusCompra == 1) { acciones += @" <a title='Editar' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Edit", id = Item.IDCompraAlmacen }) + @"' class='btn btn-yellow tooltips' data-placement='top' data-original-title='Edit'><i class='fa fa-edit'></i></a> <a title='Detalles' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"' class='btn btn-blue tooltips' data-placement='top' data-original-title='Detalles'><i class='fa fa-bars'></i></a> <a title='Procesar' class='btn btn-primary tooltips processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Procesar'><i class='fa fa-gear'></i></a> <a title='Cancelar' class='btn btn-danger tooltips deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Cancel", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Cancelar'><i class='fa fa-times'></i></a>"; } else { acciones += @" <label title='No se puede Editar' href='#' class='btn' style='background-color:gray;' data-placement='top' data-original-title='Edit'><i class='fa fa-edit' style='color:white'></i></label> <a title='Detalles' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"' class='btn btn-blue tooltips' data-placement='top' data-original-title='Detalles'><i class='fa fa-bars'></i></a> <a title='Procesar' class='btn btn-primary tooltips processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Procesar'><i class='fa fa-gear'></i></a> <a title='Cancelar' class='btn btn-danger tooltips deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Cancel", id = Item.IDCompraAlmacen }) + @"' data-placement='top' data-original-title='Cancelar'><i class='fa fa-times'></i></a>"; } acciones += @" </div> <div class='visible-xs visible-sm hidden-md hidden-lg'> <div class='btn-group'> <a class='btn btn-danger dropdown-toggle btn-sm' data-toggle='dropdown' href='#'> <i class='fa fa-cog'></i> <span class='caret'></span> </a> <ul role='menu' class='dropdown-menu pull-right dropdown-dark'>"; if (Item.IDEstatusCompra == 1) { acciones += @" <li> <a role='menuitem' tabindex='-1' href = '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Edit", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-edit'></i>Editar </a> </li> <li> <a role='menuitem' tabindex='-1' href= '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-gears'></i> Detalles </a> </li> <li> <a role='menuitem' tabindex='-1' class='processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", Item.IDCompraAlmacen }) + @"'> <i class='fa fa-caret-square-o-right'></i> Procesar </a> </li> <li> <a role='menuitem' tabindex='-1' class='deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Delete", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-trash-o'></i> Eliminar </a> </li>"; } else { acciones += @" <li> <a role='menuitem' tabindex='-1' href='#'> <i class='fa fa-edit'></i> No se puede editar </a> </li> <li> <a role='menuitem' tabindex='-1' href= '" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Detail", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-gears'></i> Detalles </a> </li> <li> <a role='menuitem' tabindex='-1' class='processRow' href='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Process", Item.IDCompraAlmacen }) + @"'> <i class='fa fa-caret-square-o-right'></i> Procesar </a> </li> <li> <a role='menuitem' tabindex='-1' class='deleteRow' id='delete-" + Item.IDCompraAlmacen + @"' data-hrefa='" + urlHlp.RouteUrl("Admin_default", new { controller = "CompraAlmacen", action = "Delete", id = Item.IDCompraAlmacen }) + @"'> <i class='fa fa-trash-o'></i> Eliminar </a> </li>"; } acciones += @"</ul></div></div>"; columns.Add(acciones); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); }
public static void GetData(object parameters) { try { // Initialization. var req = DataTableParameters.Get(parameters); var resultSet = new DataTableResultSet(); List <Member> data = Utilities.getMemberList(); resultSet.draw = req.Draw; resultSet.recordsTotal = data.Count(); string search = req.SearchValue; int order = req.Order.Values.ElementAt(0).Column; string orderDirection = req.Order.Values.ElementAt(0).Direction; int startRec = req.Start; int pageSize = req.Length; //Search if (!string.IsNullOrEmpty(search) && !string.IsNullOrWhiteSpace(search)) { // Apply search List <Member> searchResults = new List <Member>(); foreach (Member m in data) { if ( Utilities.containsStr(search, m.member_id.ToString()) || Utilities.containsStr(search, m.last_name) || Utilities.containsStr(search, m.first_name) || Utilities.containsStr(search, m.guardian_name) || Utilities.containsStr(search, m.phone) || Utilities.containsStr(search, m.email) ) { searchResults.Add(m); } } data = searchResults; } resultSet.recordsFiltered = data.Count(); //Sorting data = SortByColumnWithOrder(order, orderDirection, data); // Apply pagination. data = data.Skip(startRec).Take(pageSize).ToList(); foreach (Member m in data) { var columns = new List <string>(); columns.Add(m.member_id.ToString()); columns.Add(m.last_name); columns.Add(m.first_name); columns.Add(m.phone); columns.Add(m.email); columns.Add(m.guardian_name); columns.Add(m.restricted_to_tech.ToString()); columns.Add("<button id=" + m.member_id.ToString() + " class='mdl-button mdl-js-button mdl-button--icon' onClick='editMember(event); return false' title ='Edit'><i class= 'material-icons'>edit</i></button>" ); resultSet.data.Add(columns); } SendResponse(HttpContext.Current.Response, resultSet); } catch (Exception ex) { // Info Console.Write(ex); } // Return info. }