public TractoresController(
ILogger <TractoresController> logger,
ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
public PuntoventaController(
ILogger <PuntoventaController> logger,
ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
//Constructor
public CentrosLavadoController(
ILogger <CentrosLavadoController> logger,
ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
public EmpresasController(
ILogger <EmpresasController> logger,
ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
public ActionResult LoadData()
{
try
{
using (var ctx = new ContextoAplicacion())
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault();
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
//Get Notification
var notificationData = (from tempNotification in ctx.CTE_NOTIFICACION
select tempNotification);
//Sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir)))
{
notificationData = notificationData.OrderBy(sortColumn + " " + sortColumnDir);
}
//Search
if (!string.IsNullOrEmpty(searchValue))
{
notificationData = notificationData.Where(m => m.TITULO == searchValue ||
m.CUERPO_NOTIFICACION == searchValue);
}
//total number of rows count
recordsTotal = notificationData.Count();
//Paging
var data = notificationData.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
}
catch (Exception ex)
{
throw;
}
}
public ActionResult Create()
{
try
{
using (var ctx = new ContextoAplicacion())
{
var clientes = new SelectList(ctx.CTE_CUENTA_USUARIO.ToList(), "CuentaUsuarioId", "NOMBRE_USUARIO");
ViewData["Clientes"] = clientes;
}
}
catch (Exception ex)
{
throw;
}
return(PartialView());
}
public PreciosController(ILogger <CategoriasController> logger, ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
public AbonosPrepagoController(ContextoAplicacion contexto, ILogger <AbonosPrepagoController> logger)
{
db = contexto;
log = logger;
}
public ServicioConfiguracionPuntoVenta(ContextoAplicacion db)
{
this.db = db;
}
public CobrosServiciosController(ILogger <CobrosServiciosController> logger, ContextoAplicacion contexto)
{
db = contexto;
log = logger;
}
public UserService(ContextoAplicacion contexto)
{
this.db = contexto;
}
public CRUDController(ContextoAplicacion contexto)
{
_contexto = contexto;
}
