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.
}
