public static void AgregarProductos(Productos p1) { using (TiendaEntities db = new TiendaEntities()) { db.Productos.Add(p1); db.SaveChanges(); } }
public static void EditarProductos(Productos p1) { using (TiendaEntities db = new TiendaEntities()) { db.Entry(p1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static Productos ObtenerPorId(int id) { Productos pro = new Productos(); using (TiendaEntities db = new TiendaEntities()) { pro = db.Productos.Where(i => i.Id == id).FirstOrDefault(); } return(pro); }
public ActionResult Buscar(string id = "") { var p = new List <Producto>(); //logica using (var bd = new TiendaEntities()) { p = bd.Producto.Include("ProductoImagen").Where(x => x.Nombre.Contains(id)).ToList(); } return(View(p)); }
public Registro(int?id = null) { InitializeComponent(); this.id = id; if (id != null) { using (TiendaEntities dB = new TiendaEntities()) { CargarDatos(dB.Productos.Where(i => i.Id == id).First()); } } }
public static void ElimirProductos(int id) { using (TiendaEntities db = new TiendaEntities()) { var p1 = from a in db.Productos where a.Id == id select a; Productos p3 = db.Productos.Where(i => i.Id == id).First(); Productos p2 = p1.First(); db.Productos.Remove(p2); db.SaveChanges(); } }
public static List <Productos> ObtenerProductos() { List <Productos> pro = new List <Productos>(); using (TiendaEntities db = new TiendaEntities()) { pro = db.Productos.ToList(); var j = from k in db.Productos select k; } return(pro); }
public List <Product> FindAll() { using (TiendaEntities ctx = new TiendaEntities()) { return(ctx.ProductEntities.Select(p => new Product { Id = p.Id, Name = p.Name, Price = p.Price.Value, Quantity = p.Quantity.Value, CreationDate = p.CreationDate.Value }).ToList()); } }
public Product Find(string id) { using (TiendaEntities ctx = new TiendaEntities()) { int mid = Convert.ToInt32(id); return(ctx.ProductEntities.Where(p => p.Id == mid).Select(p => new Product { Id = p.Id, Name = p.Name, Price = p.Price.Value, Quantity = p.Quantity.Value, CreationDate = p.CreationDate.Value }).First()); } }
public bool Delete(Product product) { using (TiendaEntities ctx = new TiendaEntities()) { try { int id = Convert.ToInt32(product.Id); ProductEntity p = ctx.ProductEntities.Single(pe => pe.Id == id); ctx.ProductEntities.Remove(p); ctx.SaveChanges(); return(true); } catch { return(false); } } }
public bool Create(Product product) { using (TiendaEntities ctx = new TiendaEntities()) { try { ProductEntity p = new ProductEntity(); p.Name = product.Name; p.Price = product.Price; p.Quantity = product.Quantity; p.CreationDate = product.CreationDate; ctx.ProductEntities.Add(p); ctx.SaveChanges(); return(true); } catch { return(false); } } }
public bool Edit(Product product) { using (TiendaEntities ctx = new TiendaEntities()) { try { int id = Convert.ToInt32(product.Id); ProductEntity p = ctx.ProductEntities.Single(pe => pe.Id == id); p.Name = product.Name; p.Price = product.Price; p.Quantity = product.Quantity; p.CreationDate = product.CreationDate; ctx.ProductEntities.Add(p); ctx.SaveChanges(); return(true); } catch { return(false); } } }
private void btnBuscar_Click(object sender, EventArgs e) { if (txtBuscar.Text.Trim() != "") { using (TiendaEntities db = new TiendaEntities()) { var bus = db.Productos.Where(i => i.Producto == txtBuscar.Text.Trim()).ToList(); if (bus.Count > 0) { dgDatos.DataSource = bus; } else { } txtBuscar.Text = string.Empty; } } else { Refrescar(); } }
public AlmacenController() { var ctx = new TiendaEntities(); repo = new RepositoryEntity<Almacen, AlmacenViewModel>(ctx); }