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