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