//[TestMethod]
public void TestRemoveProducto()
{
using (InventarioDbContext db = new InventarioDbContext())
{
db.Productos.Remove(db.Productos.Find(1));
db.SaveChanges();
}
}
//[TestMethod]
public void testDb()
{
InventarioDbContext inv = new InventarioDbContext();
var cli = inv.Clientes;
foreach (Cliente c in cli)
{
Console.WriteLine(cli);
}
}
/// Inicializa los objetos _issuerSigningKey y _signingCredentials con el sistema de cifrado HMAC.
/// </summary>
public async Task <bool> VerificaConexion()
{
using (var conexion = new InventarioDbContext())
{
var consulta = await(from e in conexion.TipoArticulos select e).CountAsync();
if (consulta > 0)
{
return(true);
}
}
return(false);
}
public async Task <bool> CerrarSalidaAlmacen(Guid idSalida)
{
using (var conexion = new InventarioDbContext())
{
var resul = new ResultViewModel();
var consulta = await(from e in conexion.SalidasAlmacen where e.Id == idSalida select e).FirstOrDefaultAsync();
if (consulta != null)
{
consulta.Estatus = 1;
return(await conexion.SaveChangesAsync() > 0);
}
else
{
return(false);
}
}
}
public async Task <List <Roles> > GetRoles()
{
using (var Conexion = new SqlConnection(Helpers.ContextConfiguration.ConexionString))
{
try
{
using (var cnx = new InventarioDbContext())
{
var consulta = await(from e in cnx.Roles select e).ToListAsync();
return(consulta);
}
}
catch (Exception e)
{
var m = e.Message.ToString();
throw e;
}
}
}
public async Task <List <Models.Almacen> > GetAlmacenes()
{
using (var Conexion = new SqlConnection(Helpers.ContextConfiguration.ConexionString))
{
//var resultado = new FacturasAlmacenVM() { Exito = false, Mensaje = "Existe un error en Servidor" };
try
{
using (var cnx = new InventarioDbContext())
{
var consulta = await(from e in cnx.Almacen select e).ToListAsync();
return(consulta);
}
}
catch (Exception e)
{
var m = e.Message.ToString();
throw e;
}
}
}
public async Task <List <Proveedor> > BuscarProveedor(string tipo, string valor)
{
using (var Conexion = new SqlConnection(Helpers.ContextConfiguration.ConexionString))
{
//var resultado = new FacturasAlmacenVM() { Exito = false, Mensaje = "Existe un error en Servidor" };
try
{
using (var cnx = new InventarioDbContext())
{
var consulta = await(from e in cnx.Proveedor where e.NombreProveedor.Contains(valor.Trim()) select e).ToListAsync();
return(consulta);
}
}
catch (Exception e)
{
var m = e.Message.ToString();
throw e;
}
}
}
public OwnFeesRepository(InventarioDbContext context) : base(context)
{
}
public ClientRepository(InventarioDbContext context) : base(context)
{
}
public UserRepository(InventarioDbContext context) : base(context)
{
}
public VendorRepository(InventarioDbContext context) : base(context)
{
}
public DetailRepository(InventarioDbContext context) : base(context)
{
}
public ArticuloServices(InventarioDbContext context)
{
_contextInventario = context;
}
public PriceRepository(InventarioDbContext context) : base(context)
{
}
public CreditCardRepository(InventarioDbContext context) : base(context)
{
}
public ChequeRepository(InventarioDbContext context) : base(context)
{
}
public CategoryRepository(InventarioDbContext context) : base(context)
{
}
public FeeRuleRepository(InventarioDbContext context) : base(context)
{
}
public CommissionRepository(InventarioDbContext context) : base(context)
{
}
public MiscellaneousExpensesRepository(InventarioDbContext context) : base(context)
{
}
public productoesController(InventarioDbContext context)
{
_context = context;
}
public ProductEntryRepository(InventarioDbContext context) : base(context)
{
}
public existenciasController(InventarioDbContext context)
{
_context = context;
}
public ArticulosController(InventarioDbContext context, IArticuloServices services)
{
_context = context;
_services = services;
}
