/// <summary> /// verifica si es posible eliminar una entrada /// </summary> /// <param name="id">id de registro</param> /// <returns></returns> public bool posibleEliminar(int id) { bool exito = false; dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter(); long?res = (long)query.getNumEntradasUtilizadas(id); if (res == 0) { exito = true; } return(exito); }
public override bool add() { clear(); bool exito = false; try { dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter(); ta.add(Total, idUsuarioLog); //dar de alta salida int?idSalida = 0; //utilizado para ver ultima salida try { foreach (clsDetalleSalida de in lDetalle) { dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter(); idSalida = (int?)query.getLastIdSalida(); de.idSalida = idSalida.Value; de.add(); //asigna el detalle salida a el detalle entrada int?idDetalleSalida = query.getLastIdDetalleSalida(); dsGimnasioTableAdapters.detalleentradaTableAdapter taDE = new dsGimnasioTableAdapters.detalleentradaTableAdapter(); taDE.asignaSalida(idDetalleSalida.Value, de.idProducto); } } catch (Exception ex) { this.changeState(3, idSalida.Value); //se elimina la ultima salida error.Add(ex.Message); } exito = true; } catch (Exception ex) { error.Add(ex.Message); } return(exito); }
public override bool add() { clear(); bool exito = false; try { dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter(); ta.add(idUsuarioLog, Total); int?idEntrada = 0; //utilizada pa ultimo id insertado de entrada //dar de alta entradas try { foreach (clsDetalleEntrada de in lDetalleEmtrada) { dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter(); idEntrada = query.getLastIdEntrada(); de.idEntrada = idEntrada.Value; de.add(); } } catch (Exception ex) { this.changeState(3, idEntrada.Value); //se elimina la ultima entrada error.Add(ex.Message); } exito = true; } catch (Exception ex) { error.Add(ex.Message); } return(exito); }
public override bool add() { clear(); bool exito = false; try { dsGimnasioTableAdapters.entradaTableAdapter ta = new dsGimnasioTableAdapters.entradaTableAdapter(); ta.add(idUsuarioLog,Total); int? idEntrada=0;//utilizada pa ultimo id insertado de entrada //dar de alta entradas try { foreach (clsDetalleEntrada de in lDetalleEmtrada) { dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter(); idEntrada = query.getLastIdEntrada(); de.idEntrada = idEntrada.Value; de.add(); } } catch (Exception ex) { this.changeState(3, idEntrada.Value);//se elimina la ultima entrada error.Add(ex.Message); } exito = true; } catch (Exception ex) { error.Add(ex.Message); } return exito; }
/// <summary> /// verifica si es posible eliminar una entrada /// </summary> /// <param name="id">id de registro</param> /// <returns></returns> public bool posibleEliminar(int id) { bool exito = false; dsGimnasioTableAdapters.QueriesTableAdapter query = new dsGimnasioTableAdapters.QueriesTableAdapter(); long? res = (long)query.getNumEntradasUtilizadas(id); if (res == 0) { exito = true; } return exito; }