public void Actualizar(InvTipoTransaccionDTO obj)
{
Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
DbCommand dbCommand = db.GetStoredProcCommand(C_ACTUALIZAR);
db.AddInParameter(dbCommand, "@id_tipo_transaccion", DbType.Int32, obj.IdTipoTransaccion);
db.AddInParameter(dbCommand, "@nombre_transaccion", DbType.String, obj.NombreTransaccion);
db.AddInParameter(dbCommand, "@estado", DbType.String, obj.Estado);
db.AddInParameter(dbCommand, "@clase", DbType.String, obj.Clase);
db.ExecuteNonQuery(dbCommand);
}
public List<InvTipoTransaccionDTO> Listar()
{
List<InvTipoTransaccionDTO> Lista = new List<InvTipoTransaccionDTO>();
Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR);
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
while (dr.Read())
{
InvTipoTransaccionDTO obj = new InvTipoTransaccionDTO();
if (dr["id_tipo_transaccion"] != System.DBNull.Value)
obj.IdTipoTransaccion = (int)dr["id_tipo_transaccion"];
if (dr["nombre_transaccion"] != System.DBNull.Value)
obj.NombreTransaccion = (string)dr["nombre_transaccion"];
if (dr["estado"] != System.DBNull.Value)
obj.Estado = (string)dr["estado"];
if (dr["clase"] != System.DBNull.Value)
obj.Clase = (string)dr["clase"];
Lista.Add(obj);
}
}
return Lista;
}
public InvTipoTransaccionDTO ListarPorClave(int idTransaccion)
{
List<InvTipoTransaccionDTO> Lista = new List<InvTipoTransaccionDTO>();
InvTipoTransaccionDTO obj = null;
Database db = DatabaseFactory.CreateDatabase("ApplicationConnectionString");
DbCommand dbCommand = db.GetStoredProcCommand(C_LISTAR_POR_CLAVE);
db.AddInParameter(dbCommand, "@id_tipo_transaccion", DbType.Int32, idTransaccion);
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
while (dr.Read())
{
obj = new InvTipoTransaccionDTO();
if (dr["id_tipo_transaccion"] != System.DBNull.Value)
obj.IdTipoTransaccion = (int)dr["id_tipo_transaccion"];
if (dr["nombre_transaccion"] != System.DBNull.Value)
obj.NombreTransaccion = (string)dr["nombre_transaccion"];
if (dr["estado"] != System.DBNull.Value)
obj.Estado = (string)dr["estado"];
if (dr["clase"] != System.DBNull.Value)
obj.Clase = (string)dr["clase"];
}
}
return obj;
}