public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(PresupuestosModel), ContextService) as PresupuestosService)
{
var result = new ResultBusquedas <PresupuestosModel>()
{
values = service.getAll().Select(f => (PresupuestosModel)f),
columns = new[]
{
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true
},
new ColumnDefinition()
{
field = "Fecha", displayName = "Fecha", visible = true
},
new ColumnDefinition()
{
field = "Fkclientes", displayName = "Cod. Cliente", visible = true
},
new ColumnDefinition()
{
field = "Nombrecliente", displayName = "Cliente", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(CuentasModel), ContextService) as CuentasService)
{
var terceros = service.GetCuentasTercerosArticulos();
var result = new ResultBusquedas <CuentasModel>()
{
values = terceros,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Cuenta", visible = true,
filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}, width = 150
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true,
filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(BaseTablasVariasModel), ContextService) as TablasVariasService)
{
var list = service.GetListComentariosAsientos();
var result = new ResultBusquedas <TablasVariasGeneralModel>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Valor", displayName = "Codigo", visible = true,
filter = new Dom.ControlsUI.Busquedas.Filter()
{
condition = ColumnDefinition.STARTS_WITH
}, width = 150
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true,
filter = new Dom.ControlsUI.Busquedas.Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(SeriesModel),ContextService) )
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipodocumento = nvc["tipodocumento"];
var vector = service.getAll().Select(f => (SeriesModel) f).Where(f=>f.Bloqueado==false && (string.IsNullOrEmpty(f.Fkejercicios) || f.Fkejercicios== ContextService.Ejercicio));
if (!string.IsNullOrEmpty(tipodocumento))
{
vector = vector.Where(f => f.Tipodocumento == tipodocumento);
}
var result = new ResultBusquedas<SeriesModel>()
{
values = vector,
columns = new[]
{
new ColumnDefinition() { field = "Id", displayName = "Id", visible = true, filter = new Filter() { condition = ColumnDefinition.STARTS_WITH }},
new ColumnDefinition() { field = "Descripcion", displayName = "Descripción", visible = true },
new ColumnDefinition() { field = "Fkejerciciosdescripcion", displayName = "Ejercicio", visible = true },
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return response;
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipoasignacion = nvc["tipoasignacion"];
using (var service = FService.Instance.GetService(typeof(CuentasModel), ContextService) as CuentasService)
{
var result = new ResultBusquedas <CuentasBusqueda>()
{
values = service.GetCuentasAsistenteAsignacionCobrosPagos(tipoasignacion),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipo = nvc["tipo"];
using (var service = new SituacionesTesoreriaService(ContextService))
{
var listsituaciones = appService.GetListSituaciones();
var result = new ResultBusquedas <SituacionesTesoreriaModel>()
{
values = tipo.Equals("0") ? service.getAll().Select(f => (SituacionesTesoreriaModel)f).ToList().Where(f => f.Prevision == TipoPrevision.Ambos || f.Prevision == TipoPrevision.Cobros) :
service.getAll().Select(f => (SituacionesTesoreriaModel)f).ToList().Where(f => f.Prevision == TipoPrevision.Ambos || f.Prevision == TipoPrevision.Pagos).ToList(),
columns = new[]
{
new ColumnDefinition()
{
field = "Cod", displayName = "Cod", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(PuertosModel), ContextService) as PuertosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var codigopais = nvc["codigopais"];
var result = new ResultBusquedas <PuertosModel>()
{
values = service.getAll().Select(f => (PuertosModel)f).Where(f => f.Fkpaises == codigopais),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(TiposRetencionesModel), ContextService))
{
var result = new ResultBusquedas <TiposRetencionesModel>()
{
values = service.getAll().Select(f => (TiposRetencionesModel)f),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(BancosMandatosLinModel), ContextService) as BancosMandatosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var cuenta = nvc["fkcuenta"];
var item = service.GetBancosMandatos(cuenta);
var result = new ResultBusquedas <BancosMandatosLinModel>()
{
values = item,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var codigopais = nvc["codigopais"];
using (var service = FService.Instance.GetService(typeof(ProvinciasModel), ContextService) as ProvinciasService)
{
var result = new ResultBusquedas <ProvinciasModel>()
{
values = service.GetProvinciasPais(codigopais),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true
},
new ColumnDefinition()
{
field = "Nombre", displayName = "Nombre", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
using (var service = new CuentastesoreriaService(ContextService))
{
var listcuentas = service.getCuentasTesoreria();
var result = new ResultBusquedas <CuentasModel>()
{
values = listcuentas,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Cuenta", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(ProspectosModel), ContextService) as ProspectosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var primeracarga = Funciones.Qbool(nvc[Constantes.Primeracarga]);
var result = new ResultBusquedas <CuentasBusqueda>()
{
values = service.GetProspectos(primeracarga),//service.getAll().Where(f=> primeracarga || !((ClientesModel)f).Bloqueado).Select(f => (ClientesModel)f),
columns = new[]
{
new ColumnDefinition()
{
field = "Fkcuentas", displayName = "Cuentas", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipoasignacion = nvc["tipoasignacion"];
var soloinicialescobropago = nvc["soloinicialescobropago"];
using (var service = new CircuitosTesoreriaCobrosService(ContextService))
{
var listsituaciones = appService.GetListSituaciones();
var result = new ResultBusquedas <CircuitoTesoreriaCobrosModel>()
{
values = soloinicialescobropago == "1" ? service.GetCircuitosTesoreria(tipoasignacion, true) : service.GetCircuitosTesoreria(tipoasignacion, false),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripcion", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
// GET: api/MonedasApi
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
bool mostrarTodas;
bool.TryParse(nvc["todas"], out mostrarTodas);
using (var service = FService.Instance.GetService(typeof(MonedasModel), ContextService))
{
var result = new ResultBusquedas <MonedasModel>()
{
values = mostrarTodas? service.getAll().Select(f => (MonedasModel)f) : service.getAll().Where(f => ((MonedasModel)f).Activado).Select(f => (MonedasModel)f),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
new ColumnDefinition()
{
field = "Abreviatura", displayName = "Abraviatura", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(SeccionesanaliticasModel), ContextService))
{
//var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
// var tipodocumento = nvc["tipodocumento"];
var vector = service.getAll().
Select(f => (SeccionesanaliticasModel)f);
var result = new ResultBusquedas <SeccionesanaliticasModel>()
{
values = vector,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Nombre", displayName = "Nombre", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(MaterialesModel), ContextService) as MaterialesService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var articulos = nvc["fkarticulos"];
var material = ArticulosService.GetCodigoMaterial(articulos);
var model = service.get(material) as MaterialesModel;
var result = new ResultBusquedas <MaterialesLinModel>()
{
values = model.Lineas,
columns = new[]
{
new ColumnDefinition()
{
field = "Codigovariedad", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(ObrasModel), ContextService))
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var fkentidad = nvc["cliente"];
var list = service.getAll().Select(f => (ObrasModel)f);
if (!string.IsNullOrEmpty(fkentidad))
{
list = list.Where(f => f.Fkclientes == fkentidad);
}
var result = new ResultBusquedas <ObrasModel>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Fkclientes", displayName = "Cliente", visible = true
},
new ColumnDefinition()
{
field = "Nombrecliente", displayName = "Nombre", visible = true
},
new ColumnDefinition()
{
field = "Nombreobra", displayName = "Nombre de obra", visible = true
},
new ColumnDefinition()
{
field = "Poblacion", displayName = "Población", visible = true
},
new ColumnDefinition()
{
field = "Fechainiciocadena", displayName = "Fecha de inicio", visible = true
},
new ColumnDefinition()
{
field = "Fechafincadena", displayName = "Fecha de fin", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var articulo = nvc["articulo"];
using (var service = new ArticulosService(ContextService))
{
var articuloModel = service.get(articulo) as ArticulosModel;
var result = new ResultBusquedas <ArticulosComponentesModel>()
{
values = articuloModel.ArticulosComponentes,
columns = new[]
{
new ColumnDefinition()
{
field = "IdComponente", displayName = "IdComponente", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "FkArticulo", displayName = "Componente", visible = true
},
new ColumnDefinition()
{
field = "DescripcionComponente", displayName = "Descripcion", visible = true
},
new ColumnDefinition()
{
field = "Piezas", displayName = "Piezas", visible = true
},
new ColumnDefinition()
{
field = "Largo", displayName = "Largo", visible = true
},
new ColumnDefinition()
{
field = "Ancho", displayName = "Ancho", visible = true
},
new ColumnDefinition()
{
field = "Grueso", displayName = "Grueso", visible = true
},
new ColumnDefinition()
{
field = "Merma", displayName = "Merma", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(DireccionesLinModel), ContextService) as DireccionesService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var fkentidad = nvc["fkentidad"];
var tipocuenta = Funciones.Qint(nvc["tipotercero"]) ?? 0;
var result = new ResultBusquedas <DireccionesLinModel>()
{
values = service.GetDirecciones(ContextService.Empresa, tipocuenta, fkentidad).ToList(),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = false, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Título", visible = true, width = 200
},
new ColumnDefinition()
{
field = "Direccion", displayName = "Dirección", visible = true, width = 300
},
new ColumnDefinition()
{
field = "Poblacion", displayName = "Población", visible = true
},
new ColumnDefinition()
{
field = "Cp", displayName = "Cp", visible = true
},
new ColumnDefinition()
{
field = "Telefono", displayName = "Teléfono", visible = true
},
new ColumnDefinition()
{
field = "Telefonomovil", displayName = "Móvil", visible = true
},
new ColumnDefinition()
{
field = "Email", displayName = "Email", visible = true, width = 200
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(VencimientosModel), ContextService) as VencimientosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipoasignacion = nvc["Tipoasignacion"];
var circuitotesoreria = nvc["Circuitotesoreria"];
var fkcuentas = nvc["Fkcuentas"];
var importe = nvc["Importe"];
var result = new ResultBusquedas <VencimientosModel>()
{
values = service.getVencimientos(tipoasignacion, circuitotesoreria, fkcuentas, importe),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = false
},
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true, width = 150
},
new ColumnDefinition()
{
field = "Traza", displayName = "Doc.", visible = true, width = 150
},
new ColumnDefinition()
{
field = "FechaStrfactura", displayName = "Fecha Factura", visible = true, width = 200
},
new ColumnDefinition()
{
field = "FechaStrvencimiento", displayName = "Fecha Vencimiento", visible = true, width = 200
},
new ColumnDefinition()
{
field = "Importegiro", displayName = "Importe", visible = true, width = 100
},
new ColumnDefinition()
{
field = "FormaPago", displayName = "Forma de pago", visible = true, width = 450
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(PresupuestosModel), ContextService) as PresupuestosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var cliente = nvc["cliente"];
//Todo EL: Crear un nuevo metodo en presupuestosservice que nos devuelva los presupuestos que se pueden importar, con un parametro de entrada del cliente
var listpresupuestos = service.BuscarPresupuestosImportar(cliente);
var estadosService = new EstadosService(ContextService);
var estados = estadosService.GetStates(DocumentoEstado.PresupuestosVentas);
var result = new ResultBusquedas <PresupuestosModel>()
{
values = string.IsNullOrEmpty(cliente)? listpresupuestos : listpresupuestos.Where(f => f.Fkclientes == cliente),
columns = new[]
{
new ColumnDefinition()
{
field = "Fkseries", displayName = "Serie", visible = true
},
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true
},
new ColumnDefinition()
{
field = "Fechadocumentocadena", displayName = "Fecha", visible = true
},
new ColumnDefinition()
{
field = "Estadodescripcion", displayName = "Estado", visible = true, filter = new Filter()
{
type = "select", selectOptions = estados.Select(f => new ComboListItem()
{
label = f.Descripcion, value = f.Descripcion
}).ToList()
}
},
new ColumnDefinition()
{
field = "Fechavalidezcadena", displayName = "F. Validez", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
// GET: api/Supercuentas/5
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(AlbaranesComprasModel), ContextService) as AlbaranesComprasService)
{
service.EjercicioId = ContextService.Ejercicio;
var list = service.GetDocumentosCompras().OrderBy(f => f.Fecha);
var result = new ResultBusquedas <StDocumentosCompras>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Tipo", displayName = "Tipo", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Fechadocumento", displayName = "Fecha", visible = true
},
new ColumnDefinition()
{
field = "Proveedor", displayName = "Proveedor", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Base", displayName = "Base", visible = true
}
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8,
"application/json");
return(response);
}
}
// GET: api/Supercuentas/5
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(RecepcionesStockModel), ContextService) as RecepcionStockService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var almacenActual = nvc["Fkalmacen"];
var list = service.GetAll <RecepcionesStockModel>().Where(f => f.Fkalmacen == almacenActual);
var result = new ResultBusquedas <RecepcionesStockModel>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Fechadocumentocadena", displayName = "Fecha", visible = true
},
new ColumnDefinition()
{
field = "Fkproveedores", displayName = "Cód. Proveedor", visible = true
},
new ColumnDefinition()
{
field = "Nombreproveedor", displayName = "Proveedor", visible = true
},
new ColumnDefinition()
{
field = "Estadodescripcion", displayName = "Estado", visible = true
},
new ColumnDefinition()
{
field = "Importebaseimponible", displayName = "Base", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8,
"application/json");
return(response);
}
}
// GET api/<controller>
public HttpResponseMessage Get()
{
var items = new ResultBusquedas <TestResult>
{
columns = new [] { new ColumnDefinition()
{
field = "nombre", displayName = "Nombre", visible = true
} },
values = _vector
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(items), Encoding.UTF8, "application/json");
return(response);
}
// GET: api/Supercuentas/5
public HttpResponseMessage Get()
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var almacen = nvc["fkalmacen"];
using (var service = FService.Instance.GetService(typeof(AlmacenesModel), ContextService) as AlmacenesService)
{
var almacenModel = service.get(almacen) as AlmacenesModel;
var list = almacenModel?.Lineas;
var result = new ResultBusquedas <AlmacenesZonasModel>()
{
values = list,
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Coordenadas", displayName = "Coordenadas", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8,
"application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = new FormasPagoService(ContextService))
{
var listformaspago = appService.GetListGruposFormasPago();
var result = new ResultBusquedas <FormasPagoModel>()
{
values = service.getAll().Select(f => (FormasPagoModel)f).ToList(),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Nombre", displayName = "Nombre", visible = true
},
new ColumnDefinition()
{
field = "Gruposformaspago", displayName = "Grupo", visible = true, filter = new Filter()
{
selectOptions = listformaspago.Select(f => new ComboListItem()
{
value = f.Descripcion, label = f.Descripcion
}).ToList(), type = "select"
}
}
}
};
foreach (var item in result.values)
{
item.Gruposformaspago =
listformaspago.FirstOrDefault(f => f.Valor == item.FkGruposformaspago)?.Descripcion;
}
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
// GET: api/ReferenciasDocumentosRelacionadosApi
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(SeguimientosModel), ContextService) as SeguimientosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var primeracarga = true;
if (nvc[Constantes.Primeracarga] != null)
{
primeracarga = Funciones.Qbool(nvc[Constantes.Primeracarga]);
}
var tipodocumento = nvc["tipodocumento"];
var tercero = nvc["tercero"];
var result = new ResultBusquedas <SeguimientosModel>()
{
values = service.getDocumentosRelacionados(tipodocumento, tercero),
columns = new[]
{
new ColumnDefinition()
{
field = "Referencia", displayName = "Referencia", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Fecha", displayName = "Fecha documento", visible = true
},
new ColumnDefinition()
{
field = "Baseimponible", displayName = "Base imponible", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(CuentasModel), ContextService) as CuentasService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var tipocuenta = nvc["tipocuenta"];
IEnumerable <CuentasModel> items = null;
try
{
var inttipocuenta = (TiposCuentas)Funciones.Qint(tipocuenta).Value;
var totalitems = service.GetCuentasClientes(inttipocuenta);
items = totalitems.Where(f => (f.Tiposcuentas == (int)inttipocuenta || (f.Tiposcuentas == 0 || !f.Tiposcuentas.HasValue)) && f.Bloqueado == false);
}
catch (Exception)
{
}
var result = new ResultBusquedas <CuentasModel>()
{
values = items ?? Enumerable.Empty <CuentasModel>(),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Cuentas", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(ContactosLinModel), ContextService) as ContactosService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var fkentidad = nvc["fkentidad"];
var ocultaremail = Funciones.Qbool(nvc["ocultaremailvacio"]);
var result = new ResultBusquedas <ContactosLinModel>()
{
values = service.GetContactos(fkentidad).Where(f => !ocultaremail || f.Email != "").ToList(),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Id", visible = false, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Nombre", displayName = "Nombre", visible = true, width = 200
},
new ColumnDefinition()
{
field = "Email", displayName = "Email", visible = true, width = 200
},
new ColumnDefinition()
{
field = "Telefono", displayName = "Teléfono", visible = true
},
new ColumnDefinition()
{
field = "Telefonomovil", displayName = "Móvil", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage Get()
{
using (var service = FService.Instance.GetService(typeof(CuentasModel), ContextService) as CuentasService)
{
var nvc = HttpUtility.ParseQueryString(Request.RequestUri.Query);
var primeracarga = true;
if (nvc[Constantes.Primeracarga] != null)
{
primeracarga = Funciones.Qbool(nvc[Constantes.Primeracarga]);
}
var tipocuenta = nvc["tipocuenta"];
if (tipocuenta == null)
{
tipocuenta = "99";
}
var result = new ResultBusquedas <CuentasBusqueda>()
{
values = service.GetCuentas((TiposCuentas)Funciones.Qint(tipocuenta).Value).Where(f => primeracarga && f.Bloqueado == false),
columns = new[]
{
new ColumnDefinition()
{
field = "Id", displayName = "Cuentas", visible = true, filter = new Filter()
{
condition = ColumnDefinition.STARTS_WITH
}
},
new ColumnDefinition()
{
field = "Descripcion", displayName = "Descripción", visible = true
},
}
};
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(JsonConvert.SerializeObject(result), Encoding.UTF8, "application/json");
return(response);
}
}
