public IActionResult EditarArticulo(int?id)
{
int idProducto = Convert.ToInt32(id);
ArticuloDao articuloDao = new ArticuloDao();
Articulo Articulo = ArticuloDao.get(_context, idProducto);
ArticuloModel model = new ArticuloModel(HttpContext, _context, Articulo);
model.llenarDatosGenerales(HttpContext, _context);
return(View(model));
}
public IActionResult EfectuarCompra(OrdenPedidoGeneralModelAndView model)
{
if (ModelState.IsValid)
{
Producto producto = ProductoDAo.get(_context, model.productoId);
OrdenPedido ordenPedido = new OrdenPedido
{
EstadoPedido = Enum.EstadoPedido.PENDIENTE,
Total = model.cantidad * producto.Precio,
Negocio = NegocioDao.get(_context, producto.NegocioID),
Usuario = UsuarioDao.getUsuario(_context, HttpContext.Session.GetObjectFromJson <Usuario>("usuarioEnSession").ID),
Producto = producto
};
OrdenPedidoDao.grabar(_context, ordenPedido);
Articulo articulo = ArticuloDao.get(_context, model.Producto.ID);
return(RedirectToAction("Perfil", "Usuario"));
}
return(View());
}
public MainWindow() : base(Gtk.WindowType.Toplevel)
{
Build();
App.Instance.Connection = new MySqlConnection("server=localhost;database=dbprueba;user=root;password=sistemas");
App.Instance.Connection.Open();
TreeViewHelper.Fill(treeView, ArticuloDao.SelectAll);
treeView.Selection.Changed += delegate
{
bool hasSelected = treeView.Selection.CountSelectedRows() > 0;
};
newAction.Activated += delegate
{
Articulo articulo = new Articulo();
new ArticuloWindow(articulo);
};
editAction.Activated += delegate
{
object id = TreeViewHelper.GetId(treeView);
Articulo articulo = ArticuloDao.Load(id);
new ArticuloWindow(articulo);
};
refreshAction.Activated += delegate
{
TreeViewHelper.Fill(treeView, ArticuloDao.SelectAll);
};
deleteAction.Activated += delegate
{
if (WindowHelper.Confirm(this, "¿Quieres eliminar el registro?"))
{
object id = TreeViewHelper.GetId(treeView);
ArticuloDao.Delete(id);
}
};
}
public MainWindow() : base(Gtk.WindowType.Toplevel)
{
Build();
App.Instance.Connection = new MySqlConnection("server=localhost;database=dbprueba;user=root;password=sistemas");
App.Instance.Connection.Open();
TreeViewHelper.Fill(treeView, ArticuloDao.SelectAll);
newAction.Activated += delegate {
Articulo articulo = new Articulo();
new ArticuloWindow(articulo);
};
editAction.Activated += delegate {
object id = TreeViewHelper.GetId(treeView);
Articulo articulo = ArticuloDao.Load(id);
new ArticuloWindow(articulo);
};
refreshAction.Activated += delegate {
TreeViewHelper.Fill(treeView, ArticuloDao.SelectAll);
};
}
public ArticulosBusiness(MardisContext mardisContext)
{
_articuloDao = new ArticuloDao(mardisContext);
}
public long CountArticulo()
{
return(ArticuloDao.Count());
}
public long CountArticulo(Expression <Func <Articulo, bool> > criteria)
{
return(ArticuloDao.Count(criteria));
}
public string GetSiguienteCodigoArticulo()
{
return(ArticuloDao.GetNextAlphanumericCorrelative());
}
public bool CodigoBarraArticuloExiste(string codigoBarra, int idEmpresaSel)
{
Articulo articulo = ArticuloDao.Get(x => x.Codigodebarra == codigoBarra && x.Idempresa == idEmpresaSel);
return(articulo != null);
}
public List <Articulo> GetAllArticulo(string orders)
{
return(ArticuloDao.GetAll(orders));
}
public List <Articulo> GetAllArticulo(Expression <Func <Articulo, bool> > criteria)
{
return(ArticuloDao.GetAll(criteria));
}
public List <Articulo> GetAllArticulo()
{
return(ArticuloDao.GetAll());
}
public void DeleteArticulo(int id)
{
ArticuloDao.Delete(id);
}
public void UpdateArticulo(Articulo entity)
{
ArticuloDao.Update(entity);
}
public int SaveArticulo(Articulo entity)
{
return(ArticuloDao.Save(entity));
}
public bool CodigoArticuloExiste(string codigo)
{
return(ArticuloDao.ExistsAlphanumericCorrelative(codigo));
}
public List <Articulo> GetAllArticulo(string conditions, string orders)
{
return(ArticuloDao.GetAll(conditions, orders));
}
public decimal ObtenerStockAlmacen(int idArticulo, DateTime fechaInicial, DateTime fechaFinal, int?idAlmacen)
{
return(ArticuloDao.ObtenerStockAlmacen(idArticulo, fechaInicial, fechaFinal, idAlmacen));
}
public Articulo GetArticulo(int id)
{
return(ArticuloDao.Get(id));
}
public Articulo GetArticulo(Expression <Func <Articulo, bool> > criteria)
{
return(ArticuloDao.Get(criteria));
}
public ArticuloService()
{
oArticuloDao = new ArticuloDao();
}
