public static DataTable getTargetasTablePorUsuarioID(int usuario_id) { string command_string = string.Format("SELECT tarjeta_id, numero_de_cuenta, tipo, fecha_hora FROM Tarjetas WHERE usuario_id = {0}", usuario_id); return(DataBase.SelectCommand(command_string)); }
public static int borrarTarjetaPorID(int tarjeta_id) { string sql_commanf = string.Format("DELETE FROM Tarjetas WHERE tarjeta_id = {0}", tarjeta_id); return(DataBase.IUDCommand(sql_commanf)); }