public void save(SISModels.FACTURA entity)
{
using (SISCOMEntities db = new SISCOMEntities()) {
db.FACTURA.Add(entity);
db.SaveChanges();
}
}
public void save(SISModels.INSUMO entity)
{
using (SISCOMEntities db = new SISCOMEntities()) {
db.INSUMO.Add(entity);
db.SaveChanges();
}
}
public List <SISModels.INSUMO> getAll()
{
using (SISCOMEntities db = new SISCOMEntities())
{
return(db.INSUMO.ToList());
}
}
public List <InsumoViewModel> getASearch(string xModel)
{
using (SISCOMEntities db = new SISCOMEntities()) {
var list = (from d in db.INSUMO
join e in db.STOCK
on d.INSUMO_ID equals e.STOCK_ID
join p in db.PROVEEDOR
on d.PROVEEDOR_ID equals p.PROVEEDOR_ID
select new SISModels.ViewModels.InsumoViewModel
{
INSUMO_ID = d.INSUMO_ID,
DESCRIPCION = d.DESCRIPCION,
STOCK = e.CANTIDAD_DISPONIBLE,
PROVEEDOR = p.NOMBRE
}).AsQueryable();
// list.Where(p => p.DESCRIPCION.Contains(xModel));
return(list.Where(p => p.DESCRIPCION.Contains(xModel)).ToList <InsumoViewModel>());
}
}
public List <InsumoViewModel> getAllVieW()
{
using (SISCOMEntities db = new SISCOMEntities())
{
var list = (from d in db.INSUMO
join e in db.STOCK
on d.INSUMO_ID equals e.INSUMO_ID
join p in db.PROVEEDOR
on d.PROVEEDOR_ID equals p.PROVEEDOR_ID
select new SISModels.ViewModels.InsumoViewModel
{
INSUMO_ID = d.INSUMO_ID,
DESCRIPCION = d.DESCRIPCION,
STOCK = e.CANTIDAD_DISPONIBLE,
PRECIO = d.PRECIO,
PROVEEDOR = p.NOMBRE
}).AsQueryable();
return(list.ToList <InsumoViewModel>());
}
}
public SISModels.BITACORA getId(SISModels.BITACORA entity)
{
using (SISCOMEntities db = new SISCOMEntities()) {
return(db.BITACORA.Find(entity.BITACORA_ID));
}
}
public List <SISModels.BITACORA> getAll(SISModels.BITACORA entity)
{
using (SISCOMEntities db = new SISCOMEntities()) {
return(db.BITACORA.ToList());
}
}
