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);
}
