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); }
/// <summary> /// elimina utilizando delete /// </summary> /// <param name="id">id del registro</param> /// <returns></returns> public bool remove(int id) { clear(); bool exito = false; try { dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter(); ta.remove(id); exito = true; } catch (Exception ex) { error.Add(ex.Message); } return(exito); }
public override bool changeState(int newState, int id) { clear(); bool exito = false; try { dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter(); ta.cambiaEstado(newState, id); exito = true; } catch (Exception ex) { error.Add(ex.Message); } return(exito); }
public override bool getDatos(int id) { clear(); bool exito = false; try { dsGimnasioTableAdapters.salidaTableAdapter ta = new dsGimnasioTableAdapters.salidaTableAdapter(); dsGimnasio.salidaDataTable dt = ta.GetDataById(id); if (dt.Rows.Count > 0) { datos = (dsGimnasio.salidaRow)dt.Rows[0]; exito = true; } } catch (Exception ex) { error.Add(ex.Message); } return(exito); }