public void eliminar(clsPercha ctm) { using (INVENTARIOEntities te = new INVENTARIOEntities()) { var t = (from q in te.Percha where q.IdPercha == ctm.codigo select q).First(); te.DeleteObject(t); te.SaveChanges(); } }
public void eliminar(clsTipoMotor ctm) { using (INVENTARIOEntities te = new INVENTARIOEntities()) { var t = (from q in te.TipoMotor where q.IdTipoMotor == ctm.codigo select q).First(); te.DeleteObject(t); te.SaveChanges(); } }
public Boolean eliminar(clsBodega ctm) { try { using (INVENTARIOEntities ent = new INVENTARIOEntities()) { var x = (from q in ent.Bodega where q.IdBodega == ctm.IdBodega select q).First(); ent.DeleteObject(x); ent.SaveChanges(); } return true; } catch (Exception) { return false; } }
public bool ModificarTomaFisica(clsTomaFisicaCAB dato) { try { INVENTARIOEntities enti = new INVENTARIOEntities(); var sel = (from q in enti.TomaFisicaDet where q.IdEmpresa == 1 && q.NroTomaFisica==dato.NroTomaFisica select q); foreach (var item in sel) { enti.DeleteObject(item); } enti.SaveChanges(); using (INVENTARIOEntities ent = new INVENTARIOEntities()) { int linea = 1; foreach (var item in dato.detalle) { TomaFisicaDet det = new TomaFisicaDet() { IdEmpresa = 1, linea =linea, NroTomaFisica = dato.NroTomaFisica, IdArticulo = item.IdArticulo, ExistenciaSistema = item.ExistenciaSistema, ExistenciaFisica = item.ExistenciaFisica, CantidadAjustada = item.CantidadAjustada, FechaAjuste = item.FechaAjuste }; linea = linea + 1; ent.AddToTomaFisicaDet(det); ent.SaveChanges(); } } return true; } catch (Exception) { return false; } }
public void EliminarArt(clsArticulo artic) { using (INVENTARIOEntities ar = new INVENTARIOEntities()) { var a = (from q in ar.Articulo where q.IdArticulo == artic.IdArt select q).First(); ar.DeleteObject(a); ar.SaveChanges(); } }