public void CreateAtributoLino(AtributoLino atributoLino)
{
try
{
using (var db = new CG2019())
{
db.AtributoLino.Add(atributoLino);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteAtributoLino(int idAtributoLino)
{
try
{
using (var db = new CG2019())
{
AtributoLino atributoLino = db.AtributoLino.Where(atr => atr.idMueble == idAtributoLino).FirstOrDefault();
db.AtributoLino.Remove(atributoLino);
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public AtributoLino GetAtributoLino(int idAtributoLino)
{
AtributoLino atributoLino = null;
try
{
using (var db = new CG2019())
{
atributoLino = db.AtributoLino.Where(atr => atr.idMueble == idAtributoLino).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(atributoLino);
}
public void UpdateMueble(int idMueble, AtributoLino atributoLino)
{
try
{
using (var db = new CG2019())
{
AtributoLino actualizar = db.AtributoLino.Where(mue => mue.idMueble == idMueble).FirstOrDefault();
actualizar.alto = atributoLino.alto;
actualizar.ancho = atributoLino.ancho;
actualizar.colorBase = atributoLino.colorBase;
actualizar.colorTabla = atributoLino.colorTabla;
actualizar.entrepañosC1 = atributoLino.entrepañosC1;
actualizar.entrepañosC2 = atributoLino.entrepañosC2;
actualizar.largo = atributoLino.largo;
db.Entry(actualizar).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
