public System.Collections.IList getDescripciones()
{
using (dbEntities context = new dbEntities())
{
var query = from d in context.descripcions select d;
return(query.ToList());
}
}
public void guardarLenguaje(lenguaje lenguaje)
{
using (var context = new dbEntities())
{
context.lenguajes.Add(lenguaje);
context.SaveChanges();
}
}
public System.Collections.IList getUnidadesDeMedida()
{
using (dbEntities context = new dbEntities())
{
var query = from um in context.unidad_med select um;
return(query.ToList());
}
}
public System.Collections.IList getRegistroById(int id)
{
using (dbEntities context = new dbEntities())
{
var query = from r in context.registros where r.registro_id == id select r;
return(query.ToList());
}
}
public System.Collections.IList getBomsById(int id)
{
using (dbEntities context = new dbEntities())
{
var query = from b in context.boms where b.bom_id == id select b;
return(query.ToList());
}
}
public System.Collections.IList getRegistros()
{
using (dbEntities context = new dbEntities())
{
var query = from r in context.registros select r;
return(query.ToList());
}
}
public System.Collections.IList getArticulos()
{
using (dbEntities context = new dbEntities())
{
var query = from a in context.articuloes select a;
return(query.ToList());
}
}
public System.Collections.IList getUnidadMedidaById(int id)
{
using (dbEntities context = new dbEntities())
{
var query = from um in context.unidad_med where um.unidad_id == id select um;
return(query.ToList());
}
}
public System.Collections.IList getArticuloById(int id)
{
using (dbEntities context = new dbEntities())
{
var query = from a in context.articuloes where a.articulo_id == id select a;
return(query.ToList());
}
}
public System.Collections.IList listarLenguajes()
{
using (dbEntities context = new dbEntities())
{
var query = from c in context.lenguajes select c;
return(query.ToList());
}
}
public System.Collections.IList getDescripcionById(int id)
{
using (dbEntities context = new dbEntities())
{
var query = from d in context.descripcions where d.descripcion_id == id select d;
return(query.ToList());
}
}
public System.Collections.IList getBoms()
{
using (dbEntities context = new dbEntities())
{
var query = from b in context.boms
select b;
return(query.ToList());
}
}
public void borrarLenguaje(int id)
{
using (dbEntities context = new dbEntities())
{
lenguaje leng = context.lenguajes.First(l => l.lenguaje_id == id);
context.lenguajes.Remove(leng);
context.SaveChanges();
}
}
public void deleteArticulo(int id)
{
using (dbEntities context = new dbEntities())
{
articulo art = context.articuloes.First(a => a.articulo_id == id);
context.articuloes.Remove(art);
context.SaveChanges();
}
}
public System.Collections.IList getBomsByWeek(int week)
{
using (dbEntities context = new dbEntities())
{
var query = from b in context.boms
where b.semana_inicio == week
select b;
return(query.ToList());
}
}
public System.Collections.IList getArticuloDescripcion()
{
using (dbEntities context = new dbEntities())
{
var query = from a in context.articuloes
from d in context.descripcions
where a.descripcion_id == d.descripcion_id
select new { a.articulo_id, d.descripcion_str };
return(query.ToList());
}
}
public void updateArticulo(articulo art)
{
using (dbEntities context = new dbEntities())
{
articulo articulo = context.articuloes.First(a => a.articulo_id == art.articulo_id);
context.articuloes.Attach(context.articuloes.Single(a => a.articulo_id == art.articulo_id));
((IObjectContextAdapter)context).ObjectContext.ApplyCurrentValues("articulos", art);
context.SaveChanges();
}
}
public System.Collections.IList getDescripcionUM()
{
using (dbEntities context = new dbEntities())
{
var query = from um in context.unidad_med
from d in context.descripcions
where um.descripcion_id == d.descripcion_id
select new { um.unidad_id, d.descripcion_str };
return(query.ToList());
}
}
public int addRegistro()
{
using (dbEntities context = new dbEntities())
{
registro reg = new registro();
context.registros.Add(reg);
context.SaveChanges();
return(reg.registro_id);
}
}
public System.Collections.IList buscarArticulos(string nombre)
{
using (dbEntities context = new dbEntities())
{
var query = from a in context.articuloes
from d in context.descripcions
where a.descripcion_id == d.descripcion_id
where d.descripcion_str.Contains(nombre)
select new { d.descripcion_str, a.articulo_id };
return(query.ToList());
}
}
public System.Collections.IList getBomsByWeek(DateTime date)
{
int week = WeekOfTheYear(date);
using (dbEntities context = new dbEntities())
{
var query = from b in context.boms
where b.semana_inicio == week
select b;
return(query.ToList());
}
}
public System.Collections.IList getTipoArticulos()
{
using (dbEntities context = new dbEntities())
{
DescripcionDAO dDAO = new DescripcionDAO();
var query = from ta in context.tipo_articulo
from d in context.descripcions
where ta.descripcion_id == d.descripcion_id
select new { ta.tipo_id, d.descripcion_str };
return(query.ToList());
}
}
public void addTipoArticulo(string descripcion)
{
DescripcionDAO dDAO = new DescripcionDAO();
tipo_articulo tArt = new tipo_articulo();
tArt.descripcion_id = dDAO.addDescripcion(descripcion);
using (dbEntities context = new dbEntities())
{
context.tipo_articulo.Add(tArt);
context.SaveChanges();
}
}
public System.Collections.IList getDescripcionTAById(int id)
{
using (dbEntities context = new dbEntities())
{
DescripcionDAO dDAO = new DescripcionDAO();
var query = from ta in context.tipo_articulo
from d in context.descripcions
where ta.descripcion_id == d.descripcion_id
where ta.tipo_id == id
select d.descripcion_str;
return(query.ToList());
}
}
public void deleteBom(int id)
{
using (dbEntities context = new dbEntities())
{
RegistroDAO rDAO = new RegistroDAO();
bom bom = context.boms.First(b => b.bom_id == id);
//bom.registro_id = rDAO.addRegistro();
bom.registro_id = 1;
bom.activo = 0;
((IObjectContextAdapter)context).ObjectContext.ApplyCurrentValues("boms", bom);
context.SaveChanges();
}
}
public int addDescripcion(string descripcion)
{
using (dbEntities context = new dbEntities())
{
descripcion d = new descripcion();
d.lenguaje_id = 1;
d.descripcion_str = descripcion;
context.descripcions.Add(d);
context.SaveChanges();
return(d.descripcion_id);
}
}
public void addBom(bom bom)
{
using (dbEntities context = new dbEntities())
{
RegistroDAO rDAO = new RegistroDAO();
bom.registro_id = rDAO.addRegistro();
//bom.registro_id = 1;
bom.activo = 1;
bom.semana_inicio = WeekOfTheYear(bom.fecha_inicio);
bom.semana_fin = WeekOfTheYear(bom.fecha_fin);
context.boms.Add(bom);
context.SaveChanges();
}
}
public void addArticulo(float precioStd, string descripcion, int tipoArticulo, int um)
{
using (dbEntities context = new dbEntities())
{
articulo art = new articulo();
DescripcionDAO dDAO = new DescripcionDAO();
RegistroDAO rDAO = new RegistroDAO();
art.descripcion_id = dDAO.addDescripcion(descripcion);
art.precio_std = precioStd;
//art.codigo = codigo;
art.tipo_articulo = tipoArticulo;
art.unidad_med = um;
art.registro_id = rDAO.addRegistro();
context.articuloes.Add(art);
context.SaveChanges();
}
}
public System.Collections.IList Implosion(List <int> id)
{
using (dbEntities context = new dbEntities())
{
var idPadres = getPadres(id);
if (idPadres == id)
{
return(null);
}
else
{
var arts = from a in context.articuloes
where idPadres.Contains(a.articulo_id)
select new { a.articulo_id, a.tipo_articulo, a.descripcion_id };
return(arts.ToList());
}
}
}
//Implosion
public List <int> getPadres(List <int> idHijos)
{
using (dbEntities context = new dbEntities())
{
var idPadres = context.boms
.Where(padre => idHijos.Contains(padre.articulo_hijo))
.Select(padre => padre.articulo_padre)
.ToList();
if (idPadres.Count == 0)
{
return(idHijos);
}
else
{
return(getPadres(idPadres));
}
}
}