public _TIPTRAN BuscarPrimero()
{
dbSQLConn.ConecDb_Abrir();
_TIPTRAN usr = new _TIPTRAN();
NpgsqlDataReader Dr = null;
string Sql = "SELECT " + Elementos + " FROM tiptransa ORDER BY codtra ASC LIMIT 1 ";
NpgsqlCommand cmd = new NpgsqlCommand(Sql, dbSQLConn.Cnn);
Dr = cmd.ExecuteReader();
if (Dr.HasRows)
{
Dr.Read();
usr = LLenar(Dr);
Dr.Close();
dbSQLConn.ConecDb_Close();
return(usr);
}
else
{
Dr.Close();
dbSQLConn.ConecDb_Close();
return(usr);
}
}
public _TIPTRAN BuscarTipo(string vtiptra)
{
dbSQLConn.ConecDb_Abrir();
_TIPTRAN usr = new _TIPTRAN();
NpgsqlDataReader Dr = null;
string Sql = "SELECT " + Elementos + " FROM tiptransa WHERE tiptra = @tiptra LIMIT 1";
NpgsqlCommand cmd = new NpgsqlCommand(Sql, dbSQLConn.Cnn);
cmd.Parameters.AddWithValue("@tiptra", vtiptra);
Dr = cmd.ExecuteReader();
if (Dr.HasRows)
{
Dr.Read();
usr = LLenar(Dr);
Dr.Close();
dbSQLConn.ConecDb_Close();
return(usr);
}
else
{
Dr.Close();
dbSQLConn.ConecDb_Close();
return(BuscarPrimero());
}
}
public Boolean Modificar(_TIPTRAN TTR)
{
if (Existe(TTR.tiptra))
{
dbSQLConn.ConecDb_Abrir();
string Sql = "UPDATE tiptransa SET codtra = @codtra, tiptra = @tiptra, destra = @destra, statra = @statra, codpro = @codpro WHERE codtra = @codtra";
NpgsqlCommand cmd = new NpgsqlCommand(Sql, dbSQLConn.Cnn);
cmd.Parameters.AddWithValue("@codtra", TTR.codtra);
cmd.Parameters.AddWithValue("@tiptra", TTR.tiptra);
cmd.Parameters.AddWithValue("@destra", TTR.destra);
cmd.Parameters.AddWithValue("@statra", TTR.statra);
cmd.Parameters.AddWithValue("@codpro", NpgsqlDbType.Array | NpgsqlDbType.Integer, TTR.codpro);
int retVal = cmd.ExecuteNonQuery();
dbSQLConn.ConecDb_Close();
if (retVal == 1)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public _TIPTRAN BuscarSiguiente(_TIPTRAN TTR)
{
dbSQLConn.ConecDb_Abrir();
_TIPTRAN usr = new _TIPTRAN();
NpgsqlDataReader Dr = null;
string Sql = "SELECT " + Elementos + " FROM tiptransa WHERE codtra > @codtra ORDER BY codtra ASC LIMIT 1";
NpgsqlCommand cmd = new NpgsqlCommand(Sql, dbSQLConn.Cnn);
cmd.Parameters.AddWithValue("@codtra", TTR.codtra);
Dr = cmd.ExecuteReader();
if (Dr.HasRows)
{
Dr.Read();
usr = LLenar(Dr);
Dr.Close();
dbSQLConn.ConecDb_Close();
return(usr);
}
else
{
Dr.Close();
dbSQLConn.ConecDb_Close();
return(BuscarUltimo());
}
}
public Boolean Nuevo(_TIPTRAN TTR)
{
if (!Existe(TTR.tiptra))
{
dbSQLConn.ConecDb_Abrir();
string Sql = "INSERT INTO tiptransa (codtra, tiptra, destra, statra, codpro) VALUES (@codtra, @tiptra, @destra, @statra, @codpro)";
NpgsqlCommand cmd = new NpgsqlCommand(Sql, dbSQLConn.Cnn);
cmd.Parameters.AddWithValue("@codtra", TTR.codtra);
cmd.Parameters.AddWithValue("@tiptra", TTR.tiptra);
cmd.Parameters.AddWithValue("@destra", TTR.destra);
cmd.Parameters.AddWithValue("@statra", TTR.statra);
cmd.Parameters.AddWithValue("@codpro", NpgsqlDbType.Array | NpgsqlDbType.Integer, TTR.codpro);
cmd.ExecuteNonQuery();
dbSQLConn.ConecDb_Close();
return(true);
}
else
{
return(false);
}
}
